Blog

2019 Driver Update

We are proud to announce the 2019 major version update for our drivers. With this release
customers can now unlock the full potential of SQL Server SSIS, take advantage of new ADO.NET
and Java features, and easily connect with more than 150+ Enterprise data sources from BI,
ETL, & custom apps.

SQL SSIS Integration Components

The CData SSIS Integration Suite has undergone a significant transformation with the latest 2019 release.
In addition to a long list of new data flow sources and destinations, our SSIS Components have
been enhanced with powerful new Lookup components and Execute tasks.

Lookup Components — The SSIS Lookup components allow users to execute a lookup against any data source to map the matched and unmatched rows to different outputs in a Data Flow task, dramatically simplifying data flows. Multiple caching options are available to allow performance tuning based on use case.

Execute Tasks — Execute stored procedures and SQL queries at the Control Flow level. Stored
procedures and DDL statements are convenient for performing operations that don't fit in a data flow
(downloading files, sending emails, etc.) or preparing the database before the data flow begins
(such as truncating the table data). The Execute tasks provide easy-to-use components for these functions.

These updates represent a significant upgrade for developers using SSIS for ETL/data integration and offer unprecedented connectivity for SSIS packages deployed on-premise, or in the cloud via Azure Data Factory.

JDBC Drivers

In addition to ongoing performance optimizations, the 2019 JDBC Drivers have been
updated with significant usability enhancements. Each driver now includes embedded source-specific
"Connection String Builder" wizards that assist users in the setup and configuration of data connectivity
from any client application.

ADO.NET Data Providers

As a Microsoft Sim-ship partner, our latest ADO.NET Data Provider release has been
updated to support integration with the newest version of Microsoft Visual Studio 2019. Also, we have added
additional support for Entity Framework Core 2.0 and 2.1, which are included in each data provider as separate
.NET Standard Assembies.

Source Specific Updates

In addition to the performance and data coverage enhancements, this update includes expanded capabilities across
almost every available data source. A few noteworthy updates include:

Couchbase — Up to 20x performance over other connectivity options. Broader support for N1QL and SQL++ and improved metadata handling

Get Started Today

The new 2019 Drivers are available for download. Current subscription customers can freely upgrade to the latest 2019 releases. Download a free 30-day trial of any of our drivers to see for yourself how easy it is to connect your BI, analytics, ETL, reporting, and custom apps to live data.