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

CData Software - Knowledge Base

Recent Articles

Publish Xero-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Xero Accounting.
Integrating Dataiku with Microsoft Project via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Project.
Bidirectional Access to Sage Cloud Accounting from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Sage Business Cloud Accounting in Filemaker Pro for Mac or Windows.
Connect to and Query Google Ad Manager in QlikView over ODBC

Create data visualizations with Google Ad Manager in QlikView.
DataBind Controls to Slack in Delphi

DataBind to Slack in Delphi with standard data access components and controls.
How to Build an ETL App for Microsoft Exchange in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Exchange in Python with petl.
Use the CData SSIS Components to Insert New or Update Existing Twitter Records from SQL Server

Easily push SQL Server data to Twitter using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Twitter or update existing records with data from a SQL Server database.
Automated Continuous Shippo Replication to SQLite

Use CData Sync for automated, continuous, customizable Shippo replication to SQLite.
How to connect to SAP Netweaver Gateway from Spring Boot

Connect to SAP Netweaver Gateway in a Spring Boot Application using CData JDBC SAP Netweaver Gateway Driver
Query Phoenix using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Phoenix entities in PHP by modeling them as objects.
Feed Adobe Analytics into FineReport

How to set Adobe Analytics as a JDBC data source in FineReport.
Connect to WooCommerce from Crystal Reports

Use CData Connect AI to connect to and report on live WooCommerce from Crystal Reports.
LINQ to OData Services

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 OData Data Provider.
Connect to SAP Fieldglass in RapidMiner

Integrate SAP Fieldglass with standard components and data source configuration wizards in RapidMiner Studio.
Automated Continuous TaxJar Replication to AlloyDB

Use CData Sync for automated, continuous, customizable TaxJar replication to AlloyDB.
Automated Continuous DB2 Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable DB2 replication to Amazon Redshift.
Connect to and Query SAP BusinessObjects BI in QlikView over ODBC

Create data visualizations with SAP BusinessObjects BI in QlikView.
How to import Teradata into Apache Solr

Use the CData Software JDBC Driver for Teradata in Data Import Handler and create an automated import of Teradata to Apache Solr Enterprise Search platform.
Prepare, Blend, and Analyze SAP Ariba Procurement in Alteryx Designer (Connect AI)

Build workflows to access live SAP Ariba Procurement for self-service data analytics.
Build Semantic Layer Views for Klipfolio in APOS Live Data Gateway

Use the CData Connector for Klipfolio in APOS Live Data Gateway to build Semantic Layer Views for Klipfolio.
Import Zoho CRM Using Azure Data Factory

Use CData Connect AI to connect to Zoho CRM from Azure Data Factory and import live Zoho CRM.
Work with Power BI XMLA in FoxPro

Load Power BI XMLA into a FoxPro database. This article includes full code and a walk-through of the process.
Access Live SFTP in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate SFTP into the statistical analysis tools available in SAS JMP. This article shows how to use SFTP in the Graph Builder and Query Builder.
Integrate Klipfolio with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Klipfolio with External Services.
Analyze MYOB AccountRight in Looker

Use CData Connect AI to connect to MYOB AccountRight from Looker and build custom apps using live MYOB AccountRight.
How to work with RSS Feeds in Apache Spark using SQL

Access and process RSS Feeds in Apache Spark using the CData Software JDBC Driver.
How to Connect to Live GitHub from OpenAI Python Applications (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your GitHub through natural language.
Access Live Snapchat Ads in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate Snapchat Ads into the statistical analysis tools available in SAS JMP. This article shows how to use Snapchat Ads in the Graph Builder and Query Builder.
Create Apps from Azure Analysis Services in Qlik Sense Cloud

Use CData Connect AI to connect to Azure Analysis Services and build apps from live Azure Analysis Services in Qlik Sense Cloud.
Automated Continuous Presto Replication to SingleStore

Use CData Sync for automated, continuous, customizable Presto replication to SingleStore.
How to connect and process Gmail from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Gmail.
Excel Spreadsheet Automation on CouchDB with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.
Connect to Twitter Ads from PowerBuilder via JDBC

This article demonstrates how to access Twitter Ads from PowerBuilder using the Twitter Ads JDBC Driver.
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy Web

Connect to Adobe Target in MicroStrategy Web using the CData Software JDBC Driver for Adobe Target.
How to Connect Flowise AI Agents to Live MySQL via CData Connect AI

Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
How to Connect to & Open Excel Online in Microsoft Excel

This article uses the CData ODBC driver for Excel Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Connect to Oracle Sales in Airbyte ELT Pipelines

Use CData Connect AI to build ELT pipelines for Oracle Sales in Airbyte.
Use Dash to Build to Web Apps on Couchbase

Create Python applications that use pandas and Dash to build Couchbase-connected web apps.
Connect to DocuSign from AWS Glue

Use CData Connect AI to gain access to live DocuSign from your AWS Glue jobs.
Build AI/ML Models with Live MySQL Data using Dataiku