DEV Community: Devart

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

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/.

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

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

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

Meet Major Update of Devart ODBC Drivers: GUI for macOS/Linux, PostgreSQL 18 Support, and Enhanced Security

Devart — Thu, 18 Dec 2025 18:38:30 +0000

Devart, a leading provider of data connectivity solutions for various data connection technologies and frameworks, released updated ODBC Drivers.
The key feature of this release - PostgreSQL 18 and MariaDB 12 support.

The release includes the following updates:

Added a graphical interface for configuring the driver on macOS and Linux.

OAuth 2.0 authorization support on macOS and Linux for Salesforce and Dynamics 365 Drivers.

Support for Bearer Token authentication when using an HTTP tunnel in Oracle, PostgreSQL, QuestDB, Redshift, MySQL, ASE, SQL Server, SQL Azure, and SQL Synapse Drivers.

For ODBC Driver for Oracle:

Added support for REF_CURSOR parameters in stored procedures and functions to retrieve them as Result Sets.
Added support for the BOOLEAN data type in Oracle 23c and later.

The ODBC Driver for MySQL now supports:

MariaDB 12.
Vector data type.
UUID data type in MariaDB 10.7 and later.
INET4 and INET6 data types in MariaDB 10.10 and later.

The PostgreSQL Driver is now fully compatible with PostgreSQL 18.

For the Microsoft Access Driver:

Significantly improved the performance of DML operations within a transaction.
Added the CacheSize and CacheLifetime options to improve performance in the ExclusiveLock mode.

Support for the Canada and Saudi Arabia data centers in Zoho Drivers.

Improved support for the HiPerSix database format for the xBase Driver.

The NexusDB Driver offers support for NexusDB 4.75.17.

The Firebird Driver introduces support for network protocol selection.

Improved compatibility with Linked Servers in MSSMS for the MongoDB Driver.

OAuth 2.0 authorization is available in the Klaviyo Driver.

Extended the list of supported tables in HubSpot Driver.

Added support for the new extended API for Jira Service Management Driver.

To learn more about the recent release and download new products, visit:
https://blog.devart.com/devart-odbc-drivers-get-major-update-with-gui-for-macos-linux-postgresql-18-support-and-enhanced-security.html

ODBC Drivers are high-performance connectivity solutions with enterprise-level features for accessing the most popular database management systems and cloud services from ODBC-compliant reporting, analytics, BI, and ETL tools on 32-bit and 64-bit Windows, macOS, and Linux. Download a 30-day free trial of ODBC Drivers here: https://www.devart.com/products.html#odbc

About Devart

dotConnect for QuickBooks Online | Secure C# ADO.NET connection with ORM support

Devart — Fri, 28 Nov 2025 10:44:40 +0000

In this video, you will learn how to connect your C# .NET applications directly to QuickBooks Online with dotConnect for QuickBooks — a robust, high-performance data provider designed for modern financial integration.

Whether you’re building financial dashboards, automating reports, or syncing accounting data, dotConnect gives you seamless, secure access to QuickBooks Online with full Visual Studio integration and rich ORM capabilities.

Tap the link to watch in full: https://www.youtube.com/watch?v=g9YA1jtdt2Q

Download a 30-day absolutely free trial of Devart dotConnect for QuickBooks Online: https://www.devart.com/dotconnect/quickbooks/download.html

Subscribe to the Devart YouTube channel: https://www.youtube.com/user/DevartSoftware

Let’s take a look at the new page - EF Core Diagram Class Generation and DbContext Visualization

Devart — Thu, 27 Nov 2025 12:54:08 +0000

https://www.devart.com/entitydeveloper/ef-core-diagram.html

The ability to visualize these models is especially valuable. Specialized tools make it much easier for developers to build, customize, and manage EF Core models. One such tool is Devart Entity Developer – a powerful ORM designer for Entity Framework, Entity Framework Core, NHibernate, LinqConnect, Telerik Data Access, and LINQ to SQL. In this article, you will learn more about it.

Download a 30-day absolutely free trial of Entity Developer: https://www.devart.com/entitydeveloper/download.html

dotConnect Universal – Unified Database Access for .NET Apps

Devart — Tue, 25 Nov 2025 11:09:57 +0000

In this video, you’ll unlock true C# universal database connection capabilities with dotConnect Universal — a feature-rich ADO.NET provider that enables seamless data access across SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Db2, and more.

Tap the link to watch in full: https://www.youtube.com/watch?v=5mDkq-46Qmg

Download a 30-day absolutely free trial of Devart dotConnect Universal: https://www.devart.com/dotconnect/universal/download.html

Subscribe to the Devart YouTube channel: https://www.youtube.com/user/DevartSoftware