DEV Community: Devart

Devart Celebrates 29 Years With 20% Off Database Management, Data Connectivity and Productivity Tools

Devart — Wed, 19 Aug 2026 14:26:40 +0000

Devart, a global provider of database management, data connectivity and developer productivity solutions, is marking its 29th anniversary with a 20% discount across its product portfolio through Aug. 31.

Founded in 1997, Devart has spent nearly three decades building software for developers, database administrators and data professionals as data technologies have continued to change. Today, more than 500,000 users rely on Devart products, including customers in 65% of Fortune 100 companies, across a portfolio of more than 140 products.

Over the years, Devart has focused on helping technical teams simplify complex data tasks, reduce manual work and connect applications and systems across different data environments. The company has grown from a database tools provider into a broader technology ecosystem covering database management, data connectivity and developer productivity. Its main product lines include dbForge database development and management tools, ODBC Drivers, ADO.NET Data Providers, MCP Servers and other data solutions.

Recent product development reflects this direction. Devart introduced its MCP Server product line to help AI assistants and agents work with databases and cloud data sources. The company also continued to expand dbForge as an AI-powered ecosystem for the entire database lifecycle, adding new AI capabilities and stronger PostgreSQL functionality.

"For 29 years, Devart has been built on an engineering mindset: solve real problems, build things that last, and never stop improving. Technologies change, but that mindset doesn’t. Today, AI is opening a new chapter in software development, and we approach it the same way: understand where it can add real value and build tools people can rely on," said Oleksii Honcharov, Head of Engineering at Devart.

Devart’s recent innovations earned industry recognition, including a Silver Globee Awards for Artificial Intelligence and five honors in the 2026 Database Trends and Applications Readers’ Choice Awards.

To mark its 29th anniversary, Devart is offering 20% off its product portfolio through Aug. 31, 2026, one of the company’s most significant promotional offers of the year.

Explore the anniversary offer and full product list on Devart’s anniversary page: https://www.devart.com/happy-birthday.html

Devart Earns Five 2026 DBTA Readers’ Choice Awards

Devart — Wed, 12 Aug 2026 15:07:35 +0000

Devart has earned five honors in the 2026 DBTA Readers’ Choice Awards, selected by the readers of Database Trends and Applications. These awards recognize the tools and solutions used by database professionals to develop, manage, optimize, model, and safeguard databases.

Devart has received recognition in the following categories:

– Gold – Best DBA Solution: dbForge SQL Complete

– Silver – Best Database Performance Solution: dbForge Studio

– Silver – Best Data Modeling Solution: dbForge Studio

– Bronze – Best Database Development Platform: dbForge

– Bronze – Best Data Security Solution: SecureBridge

“We are proud to see Devart honored across five categories in the 2026 DBTA Readers’ Choice Awards,” said Oleksii Honcharov, Head of Engineering at Devart. “This recognition from database professionals who rely on our solutions every day confirms that our focus on productivity, performance, security, and integrated workflows is delivering real value throughout the entire database lifecycle.”

The Gold-winning dbForge SQL Complete accelerates SQL development in SQL Server Management Studio and Visual Studio with intelligent code completion, syntax validation, formatting, refactoring, and debugging capabilities.

dbForge Studio has received silver awards in both the Best Database Performance Solution and Best Data Modeling Solution categories. Users highlighted its capabilities in database development, administration, schema design, performance optimization, and data analysis.

dbForge offers four Studios: for SQL Server, MySQL, Oracle, and PostgreSQL. Besides the primary system, each Studio is compatible with a wide range of related databases and cloud services. All four Studios are available in a comprehensive multidatabase solution called dbForge Edge.

The Bronze recognition for dbForge highlights Devart’s unified ecosystem of database solutions, further powered by the integrated dbForge AI Assistant. This ecosystem gives teams the tools they need to develop, manage, optimize, and automate database workflows.

Devart is also expanding the capabilities of dbForge for PostgreSQL. Notably, the release of dbForge 2026.1 introduced a visual Query Builder that enables users to build complex PostgreSQL queries through an intuitive drag-and-drop interface.

SecureBridge, which has been awarded Bronze for Best Data Security Solution, provides connectivity components that help developers protect data transmitted between applications and remote services through secure protocols and encrypted connections.

“A modern information architecture is essential to support cloud for data and analytics, data warehouse modernization, and the integration of AI-driven insights,” said Tom Hogan, Group Publisher, Database Trends and Applications. “To help companies progress along their data-driven journeys, each year, DBTA presents the Readers’ Choice Awards, offering the opportunity to recognize the best of the best companies whose products have been selected by you—our readers!”

The recognition marks another step in Devart’s continued efforts to deliver practical, forward-looking solutions for modern database teams.

About Devart

Devart is a global leader in data management, connectivity, and integration solutions. Our mission is simple: to enable customers to manage data easily and effectively at an affordable cost. Over the past 29 years, we’ve built a rich ecosystem of database solutions. Today, more than 500,000 users, including 65% of Fortune 100 companies, rely on our products.

For more information, visit www.devart.com.

Devart Earns a Silver Globee Award for AI-Powered Data Management Innovation

Devart — Wed, 03 Jun 2026 09:51:02 +0000

Devart, a global developer of data management solutions, has recently announced that its product dbForge AI Assistant has been named a Silver Globee Winner and recognized as Best of Category in the “Best AI-based Data Management Solution” category at the 2026 Globee® Awards for Artificial Intelligence.

San Madan, President of the Globee Awards, commented:

“Congratulations to the 2026 winners for their achievements in artificial intelligence across industries and organizational roles. Your accomplishments reflect innovation, measurable impact, and the growing role of AI in shaping business and technology.”

The recognition highlights Devart’s innovation in AI-powered database development through dbForge AI Assistant, a SQL-specialized AI solution designed to help database professionals develop and optimize SQL code faster, smarter, and with greater accuracy across the dbForge ecosystem.

dbForge AI Assistant is fully integrated into key dbForge products, including the free Express editions, making advanced AI capabilities accessible to developers, analysts, and DBAs of all experience levels. The assistant requires no external setup, API keys, or additional configuration, enabling users to start working with AI-powered SQL assistance immediately.

The solution combines conversion of natural language to SQL, context-aware query generation, optimization, explanations, and troubleshooting. It also delivers an AI chat focused on database- and product-specific issues.

“This award validates our vision of making AI practical and truly useful for database professionals,” says Victor Horlenko, Head of AI Innovations at Devart. “dbForge AI Assistant was designed as more than just a productivity feature. It acts as a database-aware AI partner that helps users simplify complex SQL tasks, accelerate development, and confidently work with data regardless of their experience level.”

This recognition follows the recent release of dbForge 2026.1, which significantly expands the capabilities of dbForge AI Assistant. The update introduces enhanced SQL generation and optimization through access to database index metadata, including clustered, non-clustered, composite, unique, and B-tree indexes. This enables deeper context for SQL generation, improved query optimization recommendations, and better understanding of database performance characteristics.

For more than 27 years, Devart has developed solutions that help organizations simplify database development, administration, and connectivity. Today, more than 500,000 users worldwide, including 65% of Fortune 100 companies, rely on Devart products to support business-critical database operations.

About Devart

Devart is a multi-product company and a leading developer of database management software, AI-powered solutions, AI and ALM tools, MCP-based data connectivity solutions, data providers for database servers, and 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

About the Globee® Awards

The Globee® Awards are organizers of merit-based, data-driven business awards programs with worldwide participation. Across 10 awards programs, the Globee® Awards recognize achievements across industries, organizations, and professional roles. These programs focus on areas including Achievement, Artificial Intelligence, Business, Cybersecurity, Leadership, Innovation, Impact, Excellence, Technology, and Pioneers.

To learn more about the Globee® Awards, visit: https://globeeawards.com

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.

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