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 200+ Enterprise data sources from BI, ETL, & custom apps.

The latest release includes significant platform upgrades and across-the-board driver enhancements, including:

• SQL SSIS Components - New Lookup components and Execute tasks.
• JDBC Drivers - New Connection Builder & performance updates.
• ADO.NET Data Providers - Visual Studio 2019, EF core, and .NET Standard.
• New Drivers - Act-On, Acumatica, Amazon Marketplace, BlackBaud, Couchbase, DataRobot, Dropbox, Instagram, MariaDB, Odoo, SFTP, Pervasive (Btrieve), Evernote, FedEx, Greenplum, Google Spanner, IBM Cloud SQL, Oracle, Sybase, Snowflake, Teradata, and Veeva

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.

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.

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

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
• Azure Cosmos DB - Superior performance & comprehensive platform coverage.
• LinkedIn - Enhanced support for LinkedIn Ads integration and extensive company page data access.
• JIRA - New support for Projects and Filters.
• Salesforce Einstein Analytics - Upsert, Delete, BulkUpsert, BulkDelete now supported.
• Google BigQuery - Support for custom schema definitions.
• Snowflake - Asynchronous query support.

Act-On

Acumatica

Amazon Marketplace

BlackBaud FE NXT

Couchbase

DataRobot

Dropbox

Instagram

MariaDB

Odoo

SFTP

Pervasive (Btrieve)

Evernote

FedEx

Greenplum

Google Spanner

IBM Cloud SQL Query

Oracle Database

SAP Sybase

Snowflake

Teradata

Veeva Vault

Public Beta

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.