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

CData Software - Knowledge Base

Recent Articles

Connect to Box in DBeaver

Use the CData ODBC Driver to connect to Box in DBeaver.
How to connect and process Tally from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Tally
Replicate Multiple Acumatica Accounts via the CData Sync CLI

Replicate multiple Acumatica accounts to one or many databases.
Replicate QuickBooks Online to Multiple Databases via the CData Sync CLI

Replicate QuickBooks Online to disparate databases with a single configuration.
Use the CData SSIS Components to Insert New or Update Existing Certinia Records from SQL Server

Easily push SQL Server data to Certinia using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Certinia or update existing records with data from a SQL Server database.
How to publish and share SAP dashboards with Tableau Server

The CData ODBC driver for SAP enables you integrate SAP ERP/NetWeaver into Tableau dashboards.
Import Printify into FileMaker Pro

Create reports that integrate Printify in Filemaker Pro.
Create Data Visualizations in Cognos BI with GitHub

Access GitHub as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
Create Apps from API in Qlik Sense Cloud

Use CData Connect Cloud to connect to API and build apps from live API in Qlik Sense Cloud.
Model SAP HANA Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and SAP HANA, enabling the direct import of real-time SAP HANA.
Integrate SAS Data Sets in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS Data Sets from Informatica Cloud.
Analyze Asana with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana. You can visually build the import query or use any SQL supported by the driver.
Query Unbounce in ColdFusion

Write standard ColdFusion data access code to connect to Unbounce.
How to load IBM Cloud Object Storage data into Elasticsearch via Logstash

Introducing a simple method to load IBM Cloud Object Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Query Bitbucket in DataGrip

Create a Data Source for Bitbucket in DataGrip and use SQL to query live Bitbucket.
Configure the CData JDBC Driver for Amazon Marketplace in a Connection Pool in Tomcat

Connect to Amazon Marketplace from a connection pool in Tomcat.
Natively Connect to ServiceNow in PHP

The CData ODBC driver for ServiceNow enables you to create PHP applications with connectivity to ServiceNow. Leverage the native support for ODBC in PHP.
Creating Azure Analysis Services-Connected Applications in Unqork

You can use CData Connect Cloud to feed Azure Analysis Services to Unqork and build custom business apps.
Automated Continuous Coinbase Replication to Oracle

Use CData Sync for automated, continuous, customizable Coinbase replication to Oracle.
Integrate with SQL Analysis Services in JReport Designer

Create charts and reports based on SQL Analysis Services in JReport Designer.
Build Automated Workflows with Live MySQL in Workato

Use CData Connect Cloud to connect to live MySQL and build automated workflows in Workato.
Automated Continuous Zuora Replication to Oracle

Use CData Sync for automated, continuous, customizable Zuora replication to Oracle.
Connect to Zoho Projects in JRuby

Create a simple JRuby app with access to live Zoho Projects.
How to Use a Microsoft Access Database to Update Slack in Real Time

Update Slack data by creating a linked table in Microsoft Access with the CData Slack ODBC Driver.
Automated Continuous Act CRM Replication to SQLite

Use CData Sync for automated, continuous, customizable Act CRM replication to SQLite.
Connect to Shopify as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Shopify.
How to Build Dynamic React Apps with Azure Data Catalog

Use the CData Connect and React to Build Dynamic Web Apps with Live Azure Data Catalog .
Act-On Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Act-On facts in real time.
Integrate Real-Time Access to QuickBooks Time in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Time in real time.
LINQ to PingOne

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the PingOne Data Provider.
Publish Epicor Kinetic-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Epicor Kinetic.
Prepare, Blend, and Analyze Oracle Service Cloud in Alteryx Designer (ODBC)

Build workflows to access live Oracle Service Cloud for self-service data analytics.
Replicate AlloyDB for Use in Salesforce Connect

Replicate Google AlloyDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Easily Integrate Invoiced in Lazarus Pascal IDE

Learn how to easily integrate live Invoiced in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
Operational Reporting on Epicor Kinetic from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Epicor Kinetic.
Model OneNote Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and OneNote, enabling the direct import of real-time Microsoft OneNote.
Automated Continuous JSON Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable JSON replication to Apache Kafka.
Publish Crystal Reports on xBase

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date xBase.
DataBind Controls to Hive in Delphi

DataBind to Apache Hive in Delphi with standard data access components and controls.
Publish Reports with Amazon Athena in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Amazon Athena.
Create Reports from Azure Synapse in Looker Studio

Use CData Connect Cloud to gain access to live Azure Synapse and create custom reports in Looker Studio.
Use Dash to Build to Web Apps on Printful

Create Python applications that use pandas and Dash to build Printful-connected web apps.
How to connect to Dynamics 365 Business Central from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Dynamics 365 Business Central and work with Dynamics 365 Business Central in Microsoft Excel on Mac OS X.
Add Azure Data Lake Storage to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Azure Data Lake Storage with the Informatica Enterprise Data Catalog to classify and organize data.
How to work with Zoho CRM in Apache Spark using SQL

Access and process Zoho CRM in Apache Spark using the CData Software JDBC Driver.
Bidirectional Access to Oracle Financials Cloud from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Financials Cloud in Filemaker Pro for Mac or Windows.
Use the CData Software ODBC Driver for Oracle Eloqua in MicroStrategy Web

Connect to Oracle Eloqua in MicroStrategy Web using the CData Software ODBC Driver for Oracle Eloqua.
How to update IBM Informix from Excel

This article explains how to transfer data from Excel to IBM Informix using the Excel Add-In for IBM Informix.
Connect to Twitter in Google Apps Script via SQL Gateway

Use the ODBC Driver for Twitter and the SQL Gateway to access Twitter from Google Apps Script.
Integrate Live DocuSign into Blue Prism for Intelligent Robotic Process Automation (RPA)