CData Software - Knowledge Base

Show articles by: Integration Technology | Driver Technology | Recent Articles

Recent Articles

A Comparison of Database Drivers for MySQL

A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)
A Comparison of Database Drivers for SQL Server

A performance comparison of the CData JDBC Driver for SQL Server and the native JDBC Driver for SQL Server (updated May 2020)
Connect to MySQL through SSH Using the Built-In Client

A detailed overview of the SQL Gateway, its function, and its features.
Configuring the CData Query Federation Driver

A guide on configuring the CData Query Federation Driver, a connectivity solution that allows for cross-source querying of SaaS, Big Data, and NoSQL sources.
Configure the CData Cloud Hub Connector for Google Data Studio

Use the CData Cloud Hub Connector to connect to your Cloud Hub instance from Google Data Studio.
Easily Integrate with Any RESTful API Using the CData API Driver

Configure the CData API Driver to enable codeless API connectivity between apps and APIs.
Creating API Driver API Profiles

Create a new API Profiles to enable SQL access to a new API.
Editing API Driver API Profiles

Edit existing API Profiles to enable more SQL access to APIs.
Host CData Sync on Azure

Host CData Sync in Microsoft Windows Azure to host your data replication processes in the cloud.
Use SQL with the CData JDBC Driver for Twitter to Search for Users

Use the CData JDBC Driver for Twitter to Discover Users who have not followed your account but have Tweeted about a particular topic.
Analyze Live Salesforce Data in Infragistics Reveal by Connecting through CData Cloud Hub or CData API Server

Use the CData Cloud Hub or CData API Server to create an OData API on top of Salesforce data and visualize live Salesforce data in Ingragistics Reveal.
A Comparison of JDBC Drivers for BigQuery

A performance comparison of the CData JDBC Driver for Google BigQuery and the Google JDBC Driver for Google BigQuery (updated September 2019)
A Comparison of Drivers for Elasticsearch

In this article, we compare the read performance and resource usage of the CData Software JDBC Driver for Elasticsearch with the native JDBC Driver.
A Comparison of Drivers for Amazon DynamoDB

An article comparing the read performance, client-side resource usage, and read capacity consumption of different JDBC drivers for Amazon DynamoDB.
A Comparison of Drivers for Azure Cosmos DB

An article comparing the read performance and resources usage of the CData Software ODBC Driver for CosmosDB with the native ODBC Driver.
A Performance Comparison of Drivers for MongoDB

An article comparing the read performance of CData Software Drivers for MongoDB.
Use the CData SSIS Components to Insert New or Update Existing Salesforce Records from SQL Server

Easily push SQL Server data to Salesforce using the CData SSIS Components for Salesforce. This example uses an SSIS workflow to either insert new records into Salesforce or update existing records with data from a SQL Server database.
Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

A walkthrough of using CData SSIS Components to query for new HubSpot contacts and add them to an existing MailChimp list.
Perform API Operations Using the CData SharePoint Task

The CData SharePoint Task allows you to easily call stored procedures to perform SharePoint API operations.
Perform API Operations Using Stored Procedures in CData SSIS Components

The CData SSIS Data Flow components allow you to easily import and export data from various data sources. However, in some cases, the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS Data Flow.