DEV Community: Devart

Meet the Release of dotConnect Providers and Entity Developer with Major Feature Updates

Devart — Wed, 27 May 2026 14:44:09 +0000

Devart released major feature updates of dotConnect Providers and Entity Developer.

Devart announced a new release of dotConnect and Entity Developer with major feature updates.

Key enhancements in this release:

Expanded connectivity for business platforms

dotConnect for BigCommerce 3.2

Added the new CustomerMetafields object
Added the new ProductImageContents object for working with binary content of product images in BigCommerce

dotConnect for FreshBooks 3.2

Added new objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, and JournalEntriesByAccountReport
Added new report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, and TrialBalanceReport

dotConnect for Mailchimp 3.2

Added new objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, and Stores

dotConnect for QuickBooks Online 3.2

Added 50 new QuickBooks report objects
Added the new TaxExemptionReasonId field to objects

dotConnect for SugarCRM 3.2

Added support for the RowsAndColumns, Summation, and SummationWithDetails reports

Modern authentication

dotConnect for Salesforce 6.2

Added support for Server-to-Server authentication
Added the ClientCredentials element to the AuthenticationType enum
Added the PreserveNames property to the SalesforceConnectionStringBuilder class to preserve the original names of custom objects and fields, including the __c suffix

Entity Developer 8.1

Added support for Server-to-Server authentication in Salesforce
Improved support for large-scale CRM operations

dotConnect for Zoho CRM 3.2

Zoho CRM API v8 is supported
Changed the behavior: The ZohoAPIVersion enum has only new Preferred (it's API v8 now, but can change in future) and Deprecated (it's API v2 now) elements.
Added the BulkRead option to the connection string. It's enables Bulk Read API of Zoho CRM for querying large data volumes

dotConnect for Zoho Books 2.2

Added the new object SalesReceipts
Added support for nested objects in the LineItems field of the Bills object
Improved selection of BankTransactions records for all available statuses
Improved record filtering by the Status field
Improved support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects

Modern .NET and Oracle Database support

dotConnect for Dynamics 365 3.2

Added .NET 6 and .NET 8 assemblies to the Devart.Data.Dynamics NuGet package

dotConnect for Oracle 11.1.100

Added support for the JSON data type in Direct mode for Oracle Database 21c, 23ai, and 26ai

To learn more about the recent release and download new products, visit: https://www.devart.com/blog/dotconnect-providers-and-entity-developer-receive-major-feature-updates.html?utm_source=devto&utm_medium=referral&utm_campaign=cc_pr_dotconnect_release_2026.1

dotConnect is a suite of high-performance ADO.NET data providers that enable direct access to major database systems and cloud services. It is a complete solution that helps develop data-related .NET applications and web sites.

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration, and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/?utm_source=devto&utm_medium=referral&utm_campaign=cc_pr_dotconnect_release_2026.1.

dbForge 2026.1 Introduces Improved AI SQL Generation and Advanced PostgreSQL Development Features

Devart — Thu, 21 May 2026 11:38:10 +0000

Devart, a developer of database management and development solutions, has announced the release of dbForge 2026.1, a major update to its AI-powered database development solutions that introduces improved AI SQL generation and augmented PostgreSQL design and development capabilities.

dbForge 2026.1 Highlights

dbForge AI Assistant now uses database index metadata to improve AI-powered SQL generation and optimization.
dbForge 2026.1 introduces visual query building and database design in PostgreSQL alongside a number of auxiliary enhancements.
The release also expands PostgreSQL schema comparison and synchronization capabilities for PostgreSQL and Amazon Redshift.

dbForge AI Assistant Enhances AI-Powered SQL Optimization

dbForge 2026.1 expands the capabilities of dbForge AI Assistant by introducing improved SQL generation and optimization across all supported database systems.

The AI Assistant can now access detailed database index metadata, including clustered, no clustered, composite, unique, and B-tree indexes, allowing it to generate more context-aware SQL queries and deliver more accurate optimization recommendations.

The AI-powered capabilities of dbForge include the following:

Conversion of natural language to SQL
Context-aware SQL query generation
Optimization of pre-written SQL queries
Detection of redundant or missing indexes
Detailed SQL explanations
Error analysis and troubleshooting
Integrated AI chat for questions related to databases and SQL

“AI-generated SQL becomes substantially more valuable when it understands the structure and performance characteristics of the underlying database,” said Victor Horlenko, Head of AI Innovations at Devart. “The goal is to help teams accelerate development while maintaining stronger query performance and optimization standards.”

dbForge 2026.1 Expands PostgreSQL Development Capabilities

dbForge 2026.1 also introduces major PostgreSQL development enhancements across dbForge Studio for PostgreSQL and dbForge Edge.

The release brings an enhanced SQL Editor, syntax highlighting within code blocks enclosed in dollar quotes, index name suggestions, document tab improvements, and new options that deliver greater flexibility in everyday database operations.

Visual PostgreSQL Query Builder That Simplifies SQL Development

dbForge Studio for PostgreSQL now includes a visual Query Builder that allows teams to create SELECT, INSERT, UPDATE, DELETE, and JOIN queries using a graphical drag-and-drop interface.

This helps developers, analysts, DBAs, and BI teams simplify PostgreSQL query development and reduce syntax errors to a minimum.

Expanded Schema Comparison and Synchronization for PostgreSQL

dbForge 2026.1 also expands PostgreSQL schema comparison and synchronization capabilities with expanded support for PostgreSQL and related servers, new options, fuller schema and table mapping, as well as comparison and synchronization of indexes on tables and materialized views. All this makes schema deployment and migration operations easier and much more flexible.

New Visual Table Editor and Workflow Improvements

The release also introduces a new visual Table Editor for PostgreSQL that delivers convenient management of columns, primary and foreign keys, unique constraints, indexes, and other table properties without writing SQL manually.

Additional usability improvements include pinned document tabs for faster access to frequently used SQL scripts, schema files, and queries during multi-tab database development sessions.

“With dbForge 2026.1, we're delivering a unified database development solution for PostgreSQL teams,” said Andrii Melnykov, Head of Product, dbForge. “By bringing visual query development, database design, and enhanced schema comparison into a familiar environment, we’re helping teams make their daily work easier and more comfortable.”

Availability

dbForge 2026.1 is available today for dbForge Edge, dbForge Studio for SQL Server, dbForge Studio for PostgreSQL, dbForge Studio for MySQL, dbForge Studio for Oracle, and other products that are part of the dbForge ecosystem.

Customers with active subscriptions can get this update immediately. New users can explore the latest features through a free trial available on Devart’s official website.

For more information about dbForge 2026.1 visit: https://www.devart.com/blog/whats-new-in-dbforge-2026-1.html

About Devart

Devart is a multi-product company and a leading developer of database management software, ALM solutions, data providers for database servers, as well as data integration and backup solutions.

The company’s dbForge product line helps teams simplify SQL development, database administration, data management, and a variety of database operations across SQL Server, MySQL, MariaDB, Oracle, PostgreSQL, and related cloud databases and services.

For additional information about Devart, please visit https://www.devart.com

A Strategic Guide to the Best Oracle ODBC Drivers

Devart — Thu, 14 May 2026 13:43:43 +0000

Navigating the landscape of Oracle connectivity requires a shift in focus from "simple access" to "policy-driven security." In a modern enterprise, an ODBC driver is the frontline for encryption, identity verification, and operational auditing. Standardizing on a commercial driver is often the most effective way to ensure that security policies are enforced consistently across diverse teams and toolsets.

Core Pillars of a Secure Selection
The best driver for your organization is the one that meets your security benchmarks without compromising the reliability of your BI, ETL, or application stacks. When evaluating candidates, prioritize these four technical requirements:

Mandatory Encryption: Look for drivers that allow you to enforce TLS/SSL protocols with no "silent fallback" to unencrypted connections. The ability to strictly validate CA certificates and check hostnames is non-negotiable for compliance.
Identity Alignment: The driver must natively support your organization's authentication model, whether that involves Oracle Wallets, Kerberos, LDAP, or integrated OS-level identity management.
Operational Transparency: Connectivity failures in production are inevitable. A secure driver provides verbose, actionable logging that clearly distinguishes between a network timeout, an expired certificate, or an authentication mismatch.
Universal Consistency: Security shouldn't break depending on the tool. The driver should behave identically whether it is being called by Power BI, Tableau, Informatica, or a custom Linux-based application.

Leading Commercial Solutions

Devart ODBC Driver for Oracle
Devart is frequently the go-to choice for organizations that need to standardize a single driver across a wide variety of client tools. Its strength lies in a robust set of configuration "knobs"— allowing administrators to fine-tune timeouts, tracing, and connection pooling. This configurability makes it easier to create a master security template that can be rolled out to BI and development teams alike, ensuring that every connection follows the same hardened protocol.

Progress DataDirect
Progress DataDirect is designed for high-concurrency, mission-critical environments where downtime has a significant financial impact. It is often treated as "connectivity infrastructure" rather than just a driver. With a focus on cross-platform uniformity and premium vendor support SLAs, it is the ideal candidate for regulated industries that require long-term stability and a formal support path for their incident response plans.

Oracle ODBC Driver
For organizations that are fully "Oracle-aligned," the official driver bundled with the Oracle Client remains the baseline. It offers the most direct compatibility with Oracle-specific features and updates. However, it can be operationally heavier to manage, as it requires maintaining the Oracle Client component versions across all workstations and servers.

Easysoft & OpenLink
Easysoft is a favored choice for "classic" ODBC stacks where straightforward deployment and stable commercial support are the primary goals. It is particularly effective for reporting tools and legacy integrations. On the other hand, OpenLink excels in complex, heterogeneous environments involving middleware or intricate data routing, providing high flexibility for architectures that go beyond simple point-to-point connectivity.

Bridging the Gap: Security in Practice
Why Diagnostics are a Security Asset
True security is proactive. If a driver only reports a generic "Connection Failed," your team may spend hours troubleshooting the network when the real issue is an expired SSL certificate or an unsupported cipher suite. Commercial drivers that offer granular tracing turn security policy enforcement into a manageable operational task rather than a source of downtime.

Authentication and Secret Management
One of the most common points of failure is the misalignment between a driver and an organization's secret-handling policy. As companies move toward automated password rotation and centralized identity, the driver must be capable of negotiating these paths without manual intervention. While the native Oracle stack handles this well, commercial alternatives like Devart and DataDirect often provide a more "client-agnostic" approach, reducing the friction involved in managing secrets across dozens of different third-party applications.

The Selection Path
To make a final decision, align your choice with your primary operational goal:
If you need a single, highly configurable driver for a mixed toolset of BI and ETL apps, prioritize Devart.

If you manage a large-scale global estate where cross-platform consistency and vendor accountability are paramount, choose Progress DataDirect.
If your procurement and compliance are strictly Oracle-centric, stick with the Oracle Native Driver.

Finally, for legacy integrations or complex middleware where flexibility outweighs raw throughput, Easysoft or OpenLink will provide the most stable foundation.

Best PostgreSQL ODBC Drivers: Choosing the Right Connectivity Tool

Devart — Wed, 13 May 2026 13:56:02 +0000

PostgreSQL is widely used for business-critical databases, but many external platforms still rely on ODBC to connect with relational databases. Reporting tools, ETL platforms, analytics suites, and older enterprise systems often require an ODBC driver to communicate with PostgreSQL.

Because of this, choosing an ODBC driver is not just a technical detail. It affects performance, deployment complexity, support requirements, and long-term maintenance costs.

This article compares open-source and commercial PostgreSQL ODBC connectivity options, focusing on architecture, operational trade-offs, and suitable use cases.

What a PostgreSQL ODBC Driver Does
An ODBC driver acts as a bridge between an application and a PostgreSQL database. The application sends database requests through the ODBC API, and the driver translates those requests into a format PostgreSQL can understand.

A reliable PostgreSQL ODBC solution should handle several core responsibilities:
SQL Compatibility
The driver must translate standard SQL calls into PostgreSQL-compatible syntax. This is especially important when applications expect SQL-92 or SQL-99 behavior but PostgreSQL uses its own extensions and conventions.

Data Type Conversion
ODBC and PostgreSQL represent some data types differently. For example, the driver may need to convert SQL_TIMESTAMP values into PostgreSQL timestamp types such as TIMESTAMPTZ.

PostgreSQL Protocol Communication
The driver must communicate with PostgreSQL using the PostgreSQL Frontend/Backend protocol, currently version 3.0.

Security and Authentication
Modern deployments often require secure authentication and encrypted traffic. A driver may need to support TLS/SSL, GSSAPI, SSPI, and related authentication mechanisms.

Open-Source PostgreSQL ODBC Options
1. psqlODBC
psqlODBC is the official community-supported PostgreSQL ODBC driver. It is maintained by the PostgreSQL community and released under the LGPL license.

Main Advantages
psqlODBC is closely aligned with PostgreSQL itself and supports the core PostgreSQL feature set well. It is also free to use, making it attractive for development teams, internal tools, and organizations with strict licensing constraints.

Main Limitations
The main drawback is operational responsibility. Performance tuning, debugging, cursor behavior, memory usage, and configuration issues usually have to be handled internally. Features such as Declare/Fetch settings may require careful tuning depending on workload.

Best Fit
psqlODBC is a strong choice for:
Development and testing environments
Internal applications with moderate performance requirements
Cost-sensitive teams with PostgreSQL expertise
Research and experimental projects

2. unixODBC with psqlODBC
On Linux and macOS systems, PostgreSQL ODBC connectivity often uses a driver manager such as unixODBC. In this setup, unixODBC manages the ODBC interface while psqlODBC handles the PostgreSQL-specific connection.

Configuration Requirements
This approach usually requires manual configuration of files such as:
odbcinst.ini
odbc.ini

It may also require careful handling of environment variables, shared libraries, and system paths.

Operational Challenges
The unixODBC stack can become difficult to manage in containerized, distributed, or multi-version environments. Library conflicts, missing dependencies, and incorrect linking can create deployment problems.

Best Fit
This option works well when teams are comfortable managing Linux-level configuration and need an open-source ODBC stack.

Commercial PostgreSQL ODBC Drivers

1. Devart ODBC Driver for PostgreSQL
Devart offers a commercial PostgreSQL ODBC driver designed for performance, simplified deployment, and compatibility with many third-party tools.

Key Strengths
One of Devart’s main advantages is Direct Mode connectivity. This allows the driver to connect to PostgreSQL directly over TCP/IP without requiring PostgreSQL client libraries such as libpq.
Devart also provides consistent behavior across Windows, Linux, and macOS, which can simplify cross-platform deployments.

Tool Compatibility
The driver is designed to work with a wide range of BI, reporting, and ETL tools, including platforms such as Power BI, Tableau, and Informatica.

Best Fit

Devart is well suited for:
Production BI environments
ETL pipelines
Cross-platform analytics deployments
Teams that want vendor support and reduced configuration overhead

2. Progress DataDirect
Progress DataDirect is an enterprise-grade ODBC solution focused on scalability, reliability, and broad platform support.

Key Strengths
DataDirect is designed for demanding enterprise environments. It offers features such as advanced connection pooling, wire-level compression, and optimizations for high-latency networks.

It also supports a wider range of operating systems than many other drivers, including legacy Unix platforms such as Solaris, AIX, and HP-UX.

Best Fit

Progress DataDirect is most appropriate for:
Large enterprise infrastructure
Regulated industries
Legacy operating system environments
High-volume or geographically distributed systems
Organizations requiring formal vendor support and auditing

The best PostgreSQL ODBC driver depends on system importance, internal expertise, performance expectations, and support requirements.

For development, experimentation, and cost-sensitive internal systems, psqlODBC is usually the most practical option. It provides solid PostgreSQL compatibility without licensing costs, but it requires internal technical knowledge.

For Linux or macOS environments where an open-source driver manager is needed, unixODBC with psqlODBC is a flexible option. However, teams should be prepared to manage configuration files, environment variables, and dependency issues.

For production analytics, BI, and ETL workflows, Devart ODBC Driver for PostgreSQL is a strong commercial choice. It reduces setup complexity, supports Direct Mode connectivity, and offers broad compatibility with third-party tools.

For large enterprises with complex infrastructure, legacy systems, or strict support requirements, Progress DataDirect is the most suitable option. Its strengths are scalability, platform coverage, and enterprise-grade support.

In short, open-source drivers are best when cost control and flexibility matter most. Commercial drivers are better when performance, support, and reduced operational risk are the main priorities.

New Release of ODBC Drivers: Expanded Compatibility, New Authentication Options, and Enhanced Data Type Support

Devart — Tue, 21 Apr 2026 13:46:21 +0000

Devart, a leading provider of data connectivity solutions for various data connection technologies and frameworks, rolled out updates of ODBC Drivers. Key enhancements for all products include improved compatibility with Attunity Qlik Replicate, with the PDO_ODBC PHP extension and with Node.js.

The product-specific updates in the release:
ODBC Driver for Oracle

Support for Oracle 26ai
Support for the JSON data type in Oracle 21c and later
Added the ability to use SSL and SSH protocols simultaneously

ODBC Driver for MySQL

Added support for MySQL 9.6
Added the ability to use SSL and SSH protocols simultaneously
Significantly improved compatibility with Linked Server in MSSMS
Improved work with the VECTOR data type
Improved work with Numeric/Decimal fields with precision > 38

ODBC Driver for PostgreSQL

Support for protocol 3.2
Support for virtual generated columns
Added support for OAUTHBEARER authentication
Added the EnablePgTimeStamp, CurrentTimeZone, ExactTimeZone connection options
Added the ability to use SSL and SSH protocols simultaneously

ODBC Driver for Firebird

Added the FloatAsSingle, WireCompression, UseReadConsistency, ConnectionConfigOverrides connection options
Improved compatibility with MS Access
Improved compatibility with Linked Server in MSSMS
Improved work with INT128 fields
Improved work with DECFLOAT16 and DECFLOAT34 fields

ODBC Driver for InterBase

Added the FloatAsSingle connection option
Improved compatibility with MS Access
Improved compatibility with Linked Server in SSMS

ODBC Driver for xBase

Added the Read Only connection mode
Fixes for index update issues

ODBC Driver for Microsoft Access: added the SharedMode and SharedTimeout options, which allow using the same database simultaneously from multiple applications.

ODBC Driver for Microsoft Excel

Support for the CREATE RANGE statement to allow referring to a range of cells as a database object
Added the ExactFieldLength option, which sets the length of a string field to an exact value depending on the data

ODBC Driver for Salesforce: added support for Server-to-Server authorization.

ODBC Driver for Freshdesk: added the UseCustomObjects option.

ODBC Driver for Shopify

Added support for API version 2
Added support for Properties for DraftOrderDetails

ODBC Driver for Podio: added support for the separator field type.

ODBC Driver for Google BigQuery: added support for Service Account Authentication using JSON.

To learn more about the recent release and download new products, visit: https://blog.devart.com/major-update-to-odbc-drivers-expanded-compatibility-new-authentication-options-and-enhanced-data-type-support.html

Devart's ODBC connectors are an optimal variant to access databases with native protocol directly without using additional client software and access cloud data sources via HTTPS.

About Devart

SecureBridge, EntityDAC, and dbExpress Drivers: New Release

Devart — Thu, 09 Apr 2026 12:04:47 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, announced the latest release of SecureBridge, EntityDAC, and dbExpress Drivers.

The list of product-specific updates in the release:

SecureBridge:

Support for RAD Studio 13 Florence Release 1.
Support for the Arm64EC target platform.
Compatibility with Lazarus 4.6.
New component with a demo: TScSymmetricEncryptor
TScOAuth2 component improvements: *Support for obtaining AccessCode without login. *Availability of SSL options for secure token exchanges.
Improved error handling.
Demo updates: *A new example in the WebRequest demo: uploading and downloading large files. *The improved WebRequest and HttpServer demos.

EntityDAC: supports RAD Studio 13 Florence Release 1 and the Arm64EC target platform.

dbExpress Drivers: the entire line supports RAD Studio 13 Florence Release 1.

dbExpress Driver for InterBase and Firebird 6.4.0
Three new driver options expand configuration flexibility:

FloatAsSingle
UseReadConsistency
ConnectionConfigOverrides

dbExpress Driver for MySQL 8.4.0

Support for MySQL 9.6 is now included.

dbExpress Driver for Oracle 8.4.0

Added support for Oracle 26ai
Support for the JSON data type in Oracle 21c and later

dbExpress Driver for PostgreSQL 5.8.0

Support for PostgreSQL 18
Support for protocol 3.2
Added support for virtual generated columns

dbExpress Driver for SQL Server 9.5.1

Added information about selecting the OLEDB versions order in ReadMe.html

To find a full list of improvements and download new products, visit: https://blog.devart.com/new-release-securebridge-entitydac-and-dbexpress-drivers-get-support-for-latest-ides-and-databases.html

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration, and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/.

Devart Delphi Data Access Components: New Release

Devart — Mon, 06 Apr 2026 16:04:58 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, provided a new release of Delphi DAC. The main updates - support for the latest IDEs, databases, and Windows Arm64EC target platform.

The list of key general enhancements:

Support for RAD Studio 13 Florence Release 1
Support for Lazarus 4.6,
Support for the Arm64EC target platform on Windows

The product-specific improvements in the release:
Oracle: updates to ODAC v15.0 and the Oracle provider in UniDAC v12.0.

Support for Oracle 26ai
Support for JSON data type in Oracle 21c and later
Faster detection of installed Oracle clients

MySQL: updates to MyDAC v14.0 and the MySQL provider in UniDAC v12.0.

Support for MySQL 9.6
Improved dump functionality:
- Support for read-only fields in INSERT statements
- Custom delimiter configuration for stored procedures and triggers

PostgreSQL: updates apply to PgDAC v10.0 and the PostgreSQL provider in UniDAC v12.0.

Support for PostgreSQL 18 and protocol 3.2
Support for:
- Virtual generated columns
- OAUTHBEARER authentication
New connection options:
- CurrentTimeZone
- ExactTimeZone
- UseSystemLocale
Improved support for:
- PostGIS
- PgArray
- PgInet

SQL Server: updates to SDAC v13.0 and the SQL Server provider in UniDAC v12.0.

Added the CommandTimeout option to TMSConnection
Added the CommandTimeout option to SQL Server-specific settings in TUniConnection

InterBase and Firebird: updates to IBDAC v11.0 and the

InterBase/Firebird providers in UniDAC v12.0.
Support for Firebird 3 functions
Support for:
- GENERATED BY DEFAULT AS IDENTITY
- Extended transaction and database parameters (TPB, DPB, SPB)
New connection options:
- FloatAsSingle
- UseReadConsistency
- ConnectionConfigOverrides
Improved performance and handling of database configuration blocks

SQLite: updates apply to LiteDAC v8.0 and the SQLite provider in UniDAC v12.0.

Support for vector extensions (sqlite-vec, sqlite-vector)
New connection limits:
- LimitLength
- LimitExprDepth

To find a full list of improvements and download new products, visit: https://blog.devart.com/new-release-of-delphi-data-access-components-adds-support-for-latest-ides-and-databases.html

Delphi Data Access Components allow developing multi-platform applications in Embarcadero RAD Studio, Delphi, C++Builder, Lazarus, and Free Pascal on Windows, Linux, macOS, iOS, and Android, for both 32-bit and 64-bit platforms. They are terrific tools that provide direct access to popular databases such as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, as well as clouds - Salesforce, FreshBooks, SugarCRM and many others. In addition to these, we offer a mature ORM framework for Delphi, making it a comprehensive solution for all your database connectivity needs.

About Devart

Explore the New Release of dotConnect and Entity Developer with EF Core 10, AI Vector Types, and Expanded Database Compatibility

Devart — Thu, 19 Mar 2026 12:28:00 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released new versions of dotConnect and Entity Developer. The new release adds support for Entity Framework Core 10, introduces AI-focused vector data types across major databases, and extends compatibility with the newest platform capabilities such as SQL Server 2025, Oracle 26ai, and Microsoft Entra authentication.

Key enhancements in this release:

Support for Entity Framework Core 10 across all dotConnect providers (except dotConnect for SQL Server and dotConnect Universal) and Entity Developer.

Added Vector data types for AI workloads:

dotConnect for Oracle 11.1: vector data types in Oracle 23ai/26ai, with support for BINARY, INT8, FLOAT32, FLOAT64 in sparse and dense formats.
dotConnect for MySQL 10.1: VECTOR data type support in MySQL.
dotConnect for PostgreSQL 9.1: pgvector types, with support for VECTOR and HALFVEC.
dotConnect for SQLite 7.1: sqlite-vec vector types, with support for BINARY, INT8, FLOAT.

Added new database data types in Oracle and MariaDB:

dotConnect for Oracle 11.1: Boolean data type support in Oracle 23ai/26ai.
dotConnect for Oracle 11.1: JSON data type support in Oracle 21c/23ai/26ai.
dotConnect for MySQL 10.1: Inet6 data type support in MariaDB.
dotConnect for MySQL 10.1: UUID data type support in MariaDB.

Support for SQL Server 2025 and Oracle 26ai:

dotConnect for SQL Server 6.1: support for SQL Server 2025.
dotConnect for Oracle 11.1: support for Oracle 26ai.

NetTopologySuite 2.6 support for spatial workloads:

dotConnect for Oracle 11.1: NetTopologySuite 2.6 support for EF6 in .NET Standard 2.0 assemblies.
dotConnect providers: NetTopologySuite 2.6 support for EF Core in spatial functionality (Oracle, MySQL, PostgreSQL, and SQLite).

Added support for Microsoft Entra authentication in the .NET Standard 2.0 assemblies of the Devart.Data.SqlServer NuGet package.

Full support for modern .NET provider builds in Entity Developer.

To learn more about the recent release and download new products, visit: https://blog.devart.com/new-dotconnect-and-entity-developer-release-ef-core-10-ai-vector-types-and-expanded-database-compatibility.html

About Devart

Meet the new version of SSIS Data Flow Components 4.0: Visual Studio 2026, SQL Server 2025, and Beyond

Devart — Tue, 03 Feb 2026 11:28:37 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released a new version of SSIS Data Flow Components.

What’s new in version 4.0

Support for Visual Studio 2026
Support for Visual Studio 2026 Insiders
Support for SQL Server Integration Services 2025 (SSIS 2025, v17.0)
Support for SQL Server 2025
Support for Oracle 26ai

To learn more about the recent release and download new products, visit:
https://blog.devart.com/ssis-data-flow-components-4-0-ready-for-visual-studio-2026-sql-server-2025-and-beyond.html

Devart SSIS Data Flow Components are powerful tools designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages, allowing users to connect cloud applications and databases through their SSIS workflows without the need to write complex code.

About Devart

dbForge 2025.3: AI Assistant in SQL Complete, Expanded Connectivity, and Smarter SQL Workflows

Devart — Thu, 22 Jan 2026 12:06:37 +0000

Devart, a leading developer of database management software, recently announced the release of dbForge 2025.3, the latest update to its unified ecosystem of professional database tools. The new version delivers expanded connectivity, full support for SSMS 22, Visual Studio 2026, MySQL 9.5, MariaDB 12.2, and Oracle Database 26i, along with UI/UX enhancements, broader SQL syntax coverage, and the introduction of dbForge AI Assistant within SQL Complete.

dbForge AI Assistant Now Available in SQL Complete for SSMS

dbForge AI Assistant is now integrated into dbForge SQL Complete, an SSMS add-in widely used for SQL Server development. By bringing intelligent assistance directly into SSMS, dbForge 2025.3 accelerates query development and helps teams minimize errors without relying on any external tools.

Key features include:

Instant conversion of natural language input to valid SQL code
Generation of queries that are relevant to the context of your databases
Optimization and troubleshooting of pre-written queries
Detailed explanations of SQL query syntax
Analysis and clarifications of query execution errors
AI chat on any issue related to databases and SQL
Built-in web search for the most up-to-date information
Integration with multiple dbForge solutions, including SQL Complete

Expanded Support for the Latest Databases and IDEs

dbForge 2025.3 ensures seamless workflows when upgrading database platforms and development environments. It provides the following updates:

Full compatibility with SSMS 22 across dbForge add-ins
SQL Complete integration with Visual Studio 2026, enabling smart code completion and AI features
Support for MySQL 9.5 and MariaDB 12.2
Support for Oracle Database 26i
Support for AWS RDS Proxy with caching_sha2_password authentication

These updates allow teams to adopt the latest updates without sacrificing tool compatibility or productivity.

Improved Performance Analysis and Database Design

The release introduces enhancements that simplify navigation and performance analysis, especially in complex environments:

Object Search in Database Diagrams, enabling instant location of tables, relationships, notes, stamps, and containers in large ER diagrams
Visual execution plan diagrams for MySQL queries, transforming EXPLAIN output into intuitive visuals that make performance bottlenecks easier to identify and optimize

Expanded SQL Syntax Support Across Platforms

dbForge 2025.3 significantly improves SQL parsing, validation, formatting, and code completion across supported databases, including:

Extended PostgreSQL and Redshift support: WITH clauses, MERGE, and advanced SELECT, INSERT, UPDATE, and DELETE statements
Full support for RETURNING expressions, cursors, and advanced conflict-handling logic
Improved MySQL syntax validation, including support for SHOW BINARY LOG STATUS
Oracle syntax check support for SQL_MACRO functions (SCALAR and TABLE) and pipelined table functions

UI and UX Enhancements for Everyday Productivity

To streamline daily development tasks, dbForge 2025.3 introduces several usability improvements, including:

Scrollbar annotations for faster navigation in large scripts
Automatic wrapping of selected text with quotes, brackets, or parentheses
Updated identifier formatting options, including camelCase, Capitalized, and PascalCase, with full backward compatibility with the existing formatting profiles

Unified Multi-Database Workflows with dbForge Edge

While dbForge 2025.3 focuses on SSMS and SQL Server enhancements, teams working across multiple database systems can explore dbForge Edge. This all-in-one multidatabase solution combines dbForge Studios for SQL Server, MySQL/MariaDB, Oracle, and PostgreSQL, helping organizations streamline database design, development, and management across projects and platforms.

Availability

dbForge 2025.3 is available today.

Users with active subscriptions can upgrade immediately, and new users can explore the release with a free trial.

For more information, visit: https://www.devart.com/dbforge/

New Release of SSIS Data Flow Components with Improved Security and Database Integration

Devart — Tue, 13 Jan 2026 12:59:15 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, rolled out a new release of SSIS Data Flow Components with significant improvements in security and database integration.

Key enhancements in this release:

PostgreSQL 18 support, which allows users to seamlessly integrate with the latest version of PostgreSQL.
Added support for MariaDB 12, enabling smoother and more efficient data operations.
Support for long passwords in Oracle 23ai, it helps Oracle database users manage longer and more secure passwords more easily.
Support for enhanced encryption and key exchange algorithms for SSH - enhances security and protects data during transmission.

To learn more about the recent release and download new products, visit: https://blog.devart.com/ssis-3-2-release.html

About Devart

Meet the New dotConnect 2025.1 Release

Devart — Tue, 23 Dec 2025 13:16:11 +0000

Devart, a recognized vendor of world-class data connectivity solutions for various data connection technologies and frameworks, released dotConnect 2025.1. With this release, developers gain higher performance thanks to batch updates, easier cloud connectivity through built-in OAuth, and a cleaner, more modern data access stack focused on current technologies.

The list of key updates:

Support for .NET 10 across all dotConnect providers and LinqConnect
Support for Visual Studio 2026 and Visual Studio 2026 Insiders in all dotConnect providers, LinqConnect, and Entity Developer
dotConnect 2025.1 significantly improves SSH support for dotConnect for Oracle (in Direct mode), dotConnect for MySQL, and dotConnect for PostgreSQL
Added built-in OAuth 2.0 support for cloud database connectivity in dotConnect for Salesforce, dotConnect for Dynamics 365, dotConnect for FreshBooks, dotConnect for Mailchimp, dotConnect for QuickBooks, dotConnect for Zoho CRM, dotConnect for Zoho Books, and dotConnect for Zoho Desk.
Now, Batch Updates is available for dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, dotConnect for SQL Server, dotConnect for DB2, and dotConnect Universal.
Added the PgSqlNumeric structure for the PostgreSQL NUMERIC data type in dotConnect for PostgreSQL

Look at the other improvements:

Added support for SQL Server Reporting Services 2017 (15), 2019 (16), and 2022 (17) in dotConnect for Oracle, MySQL, PostgreSQL, SQLite, and DB2.
Improved OracleLoader performance for LOB types in Direct mode in dotConnect for Oracle
Support for MariaDB 12 and SingleStore (formerly MemSQL) in dotCOnnect for MySQL.
Added support for PostgreSQL 18 in dotConnect for PostgreSQL.
Added support for savepoints in the SQLiteTransaction class in dotCOnnect for SQLite.
Improved the Add Connection dialog in Visual Studio Server Explorer in dotCOnnect for Salesforce MC.
A transparent and unified licensing model is available for the entire dotConnect line.
Entity Developer is now available with Professional and Standard editions. Express remains free, and all editions use key-based licensing.

To learn more about the recent release and download new products, visit:
https://blog.devart.com/dotconnect-2025-1-release.html

About Devart