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 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
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 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.
New Drivers & Releases
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.
