by Eric Madariaga | April 16, 2019

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.

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 (Betrieve), Evernote, FedEx, Greenplum, Google Spanner, IBM Cloud SQL, Oracle, Sybase, Snowflake, Teradata, and Veeva

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

New Drivers & Releases

Act-On

Act-On

Acumatica

Acumatica

Amazon Marketplace

Amazon Marketplace

BlackBaud FE NXT

BlackBaud FE NXT

Couchbase

Couchbase

DataRobot

DataRobot

Dropbox

Dropbox

Instagram

Instagram

MariaDB

MariaDB

Odoo

Odoo

SFTP

SFTP

Pervasive (Btrieve)

Pervasive (Btrieve)

Evernote

Evernote

FedEx

FedEx

Greenplum

Greenplum

Google Spanner

Google Spanner

IBM Cloud SQL Query

IBM Cloud SQL Query

Oracle Database

Oracle Database

SAP Sybase

SAP Sybase

Snowflake

Snowflake

Teradata

Teradata

Veevaa Vault

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.