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

CData Software - Knowledge Base

Recent Articles

Stream Google Calendar into Apache Kafka Topics

Access and stream Google Calendar in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Use the CData Software ODBC Driver for Dynamics 365 in SAS for Real-Time Reporting and Analytics

Connect to real-time Microsoft Dynamics 365 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics 365.
Visualize Live Zoho Creator in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Creator.
Build Airtable-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Airtable and build Airtable-connected web apps with Axios.
DataBind Controls to QuickBooks in Delphi

DataBind to QuickBooks Desktop in Delphi with standard data access components and controls.
Add SingleStore to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for SingleStore with the Informatica Enterprise Data Catalog to classify and organize data.
Analyze Teradata in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Teradata and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
LINQ to MailChimp

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 MailChimp Data Provider.
Provide OData Services of Sage 50 UK from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Sage 50 UK by developing a WCF Service Application.
LINQ to HCL Domino

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 HCL Domino Data Provider.
Use the CData API Server to Access Google Sheets in Microsoft PowerPivot

Use the CData API Server to connect to live Google Sheets in the Power Pivot business intelligence tool.
Import Real-Time Adobe Commerce via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Adobe Commerce in ColdFusion.
Configure the CData JDBC Driver for Neo4J in a Connection Pool in Tomcat

Connect to Neo4J from a connection pool in Tomcat.
Automated Continuous QuickBooks Replication to AlloyDB

Use CData Sync for automated, continuous, customizable QuickBooks replication to AlloyDB.
Automated Continuous Sage 50 UK Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Amazon Redshift.
How to Seamlessly Import SAP SuccessFactors Data into IBM SPSS Modeler

Integrate SAP SuccessFactors data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
A PostgreSQL Interface for Impala using the CData ODBC Driver

Use the SQL Gateway and Impala ODBC Driver to create a PostgreSQL entry-point for data access.
Explore Geographical Relationships in Aha with Power Map

Create data visualizations with Aha! in Power Map.
Edit and Search QuickBooks Time External Objects

Use the API Server to securely provide OData feeds of QuickBooks Time to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create QuickBooks Time objects that you can access from apps and the dashboard.
How to Build an ETL App for Sage Intacct in Python with CData

Create ETL applications and real-time data pipelines for Sage Intacct in Python with petl.
Migrating data from Calendly to Snowflake using CData SSIS Components.

Easily push Calendly to Snowflake using the CData SSIS Tasks for Calendly and Snowflake.
Bidirectional Access to DocuSign from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate DocuSign in Filemaker Pro for Mac or Windows.
Using CData JDBC Drivers in ColdFusion

This article will demonstrate how to use the CData JDBC Drivers with ColdFusion. Included are steps for adding the CData JDBC Driver as a data source, as well as basic ColdFusion code to query the data source and display results.
Use Dash to Build to Web Apps on Typeform

Create Python applications that use pandas and Dash to build Typeform-connected web apps.
Using the CData Software ODBC Driver for Sage Intacct in PyCharm

Connect to Sage Intacct as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Intacct.
Create Data Visualizations Based On Google Spanner in Mode

Use CData Connect Cloud to connect to Google Spanner from Mode and build visualizations using live
Create Google Analytics-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Google Analytics from OutSystems and build custom enterprise apps using live Google Analytics.
Edit and Search Exact Online External Objects

Use the API Server to securely provide OData feeds of Exact Online to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Exact Online objects that you can access from apps and the dashboard.
How to Build an ETL App for Google Spanner in Python with CData

Create ETL applications and real-time data pipelines for Google Spanner in Python with petl.
How to update Google Contacts from Excel

This article explains how to transfer data from Excel to Google Contacts using the Excel Add-In for Google Contacts.
Publish Monday.com-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Monday.com.
Connect to Oracle HCM Cloud as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Oracle HCM Cloud.
Create SSAS Tabular Models from IBM Cloud Object Storage

How to build a SQL Server Analysis Service Tabular Model from IBM Cloud Object Storage using CData drivers.
Work with Confluence in FoxPro

Load Atlassian Confluence into a FoxPro database. This article includes full code and a walk-through of the process.
Trigger Zoho Inventory IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
How to create Visio diagrams from Salesloft

Automatically update Salesloft with the changes you make to Visio master shapes.
How to connect to Sage 50 UK from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Sage 50 UK and work with Sage 50 UK in Microsoft Excel on Mac OS X.
Prepare, Blend, and Analyze Salesloft in Alteryx Designer (ODBC)

Build workflows to access live Salesloft for self-service data analytics.
Access Live Klipfolio in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Klipfolio to create a Klipfolio source in TIBCO Data Virtualization Studio and gain access to live Klipfolio from your TDV Server.
Analyze Oracle Service Cloud in Infragistics Reveal

Use the CData API Server to create an OData API on top of Oracle Service Cloud and visualize live Oracle Service Cloud in Ingragistics Reveal.
Access Active Directory from MySQL in Amazon QuickSight

Connect to Active Directory and build visualizations of Active Directory using a MySQL Connection in Amazon QuickSight.
Validate Azure Data Catalog with QuerySurge

Access and validate Azure Data Catalog in QuerySurge using the CData JDBC Driver.
How to update Quickbase from Excel

This article explains how to transfer data from Excel to Quickbase using the Excel Add-In for Quickbase.
Build Semantic Layer Views for Dynamics CRM in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dynamics CRM.
Access Zoom from MySQL in PHP

Connect to Zoom through the standard MySQL libraries in PHP.
Create a Data Access Object for Couchbase using JDBI

A brief overview of creating a SQL Object API for Couchbase in JDBI.
Prepare, Blend, and Analyze Salesforce Pardot in Alteryx Designer (ODBC)

Build workflows to access live Salesforce Pardot for self-service data analytics.
Replicate Multiple Bing Search Accounts via the CData Sync CLI

Replicate multiple Bing Search accounts to one or many databases.
Edit and Search External Microsoft Dataverse Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Microsoft Dataverse (CDS) to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Dataverse objects that you can access from apps and the dashboard.
Automated Continuous Google Analytics Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Google Analytics replication to OneLake in Microsoft Fabric.
Build Bing Search-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Bing Search and build Bing Search-connected web apps with Axios.
Access Pipedrive from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Pipedrive from HeidiSQL.
Integrate Greenhouse in Pentaho Data Integration

Build ETL pipelines based on Greenhouse in the Pentaho Data Integration tool.
Query MailChimp as a SQL Server Database in Node.js

Execute SQL Server queries against MailChimp from Node.js.
Automated Continuous TaxJar Replication to SQL Server

Use CData Sync for automated, continuous, customizable TaxJar replication to SQL Server.
Build Freshdesk-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Freshdesk.
Connect to Elasticsearch Using the Script Function in Claris FileMaker Pro