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

CData Software - Knowledge Base

Recent Articles

How to import SAP Concur into Apache Solr

Use the CData Software JDBC Driver for SAP Concur in Data Import Handler and create an automated import of SAP Concur to Apache Solr Enterprise Search platform.
Connect to Zoho Creator in Google Apps Script via SQL Gateway

Use the ODBC Driver for Zoho Creator and the SQL Gateway to access Zoho Creator from Google Apps Script.
Use the CData Software ODBC Driver for Slack in MicroStrategy

Connect to Slack in MicroStrategy Developer using the CData Software ODBC Driver for Slack.
Migrating data from Confluence to Google BigQuery using CData SSIS Components.

Easily push Atlassian Confluence to Google BigQuery using the CData SSIS Tasks for Confluence and Google BigQuery.
Use Manus AI to Talk to Your ServiceNow via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ServiceNow.
How to Connect to & Open Hive in Microsoft Excel

This article uses the CData ODBC driver for Hive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Query Xero through ODBC in Node.js

Use node-odbc to execute SQL queries against Xero Accounting from Node.js.
Migrating data from Redshift to Snowflake using CData SSIS Components.

Easily push Amazon Redshift to Snowflake using the CData SSIS Tasks for Redshift and Snowflake.
Deploy the ADO.NET Provider for ActiveCampaign on an SSRS Report Server

Connect to ActiveCampaign from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
Provide OData Services of SAP Business One from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for SAP Business One by developing a WCF Service Application.
Create Dynamic Access Grids Using the Infragistics XamDataGrid

Learn how you can connect Access to Infragistics XamDataGrid to build dynamic grids.
How to Build an ETL App for BambooHR in Python with CData

Create ETL applications and real-time data pipelines for BambooHR in Python with petl.
Replicate Cosmos DB in Heroku for Use in Salesforce Connect

Replicate Azure Cosmos DB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
How to Build an ETL App for HBase in Python with CData

Create ETL applications and real-time data pipelines for Apache HBase in Python with petl.
Query Parquet in ColdFusion

Write standard ColdFusion data access code to connect to Apache Parquet.
Visualize SAP Hybris C4C in Tableau

The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.
Access Live QuickBooks Time in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate QuickBooks Time into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Time in the Graph Builder and Query Builder.
Analyze Gmail in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Gmail and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
Access Drift from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Drift from HeidiSQL.
How to create Freshdesk federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshdesk in MySQL .
Query Live Impala in Zed Editor via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Apache Impala directly from the development environment.
How to Query PayPal in MySQL Workbench

Execute MySQL queries against live PayPal from MySQL Workbench.
How to Connect to Live Gmail in n8n Workflows and Agents (via CData Connect AI)

Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Gmail for you.
Using the CData Software ODBC Driver for Phoenix in PyCharm

Connect to Phoenix as an ODBC data source in PyCharm using the CData Software ODBC Driver for Phoenix.
Automate Spark Replication to Azure Data Lake

Use CData Sync to customize and automate Apache Spark SQL replication to Azure Data Lake.
Create Basecamp Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
Use Grok to Talk to Your Spark via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Spark SQL for you.
Work with Zoho Inventory in FoxPro

Load Zoho Inventory into a FoxPro database. This article includes full code and a walk-through of the process.
Create Dashboards and Visualize Live SurveyMonkey in Geckoboard

Use CData Connect AI to connect to live SurveyMonkey and create dashboards for real-time monitoring and visualization in Geckoboard.
Access Live Adobe Analytics in Google Sheets through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Adobe Analytics from your Google Sheets.
How to use SQLAlchemy ORM to access SAP in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP ERP/NetWeaver.
Connect to SQL Analysis Services in RazorSQL

Connect to SQL Analysis Services from wizards and query SQL Analysis Services from the GUI in the RazorSQL database management tool.
Access Live Smartsheet Data in Tableau with CData API Server

With CData API Server, easily create OData endpoints for live Smartsheet data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
Bind Live Power BI XMLA Data in Wijmo FlexGrid with CData API Server

With CData API Server, easily create OData endpoints for live Power BI XMLA data
Integrate Live SingleStore into Custom Business Apps Built in Power Apps

Use CData Connect AI to connect to SingleStore and integrate live SingleStore into apps built in Microsoft Power Apps.
Access Live Coinbase in AWS Lambda

Connect to live Coinbase in AWS Lambda using the CData JDBC Driver.
Create Dashboards and Visualize Live Oracle Service Cloud in Geckoboard

Use CData Connect AI to connect to live Oracle Service Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.
Natively Connect to Sybase in PHP

The CData ODBC driver for Sybase enables you to create PHP applications with connectivity to Sybase. Leverage the native support for ODBC in PHP.
Integrate Live Confluence into Amazon SageMaker Canvas with RDS

Use CData Connect AI to connect to Confluence from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Atlassian Confluence.
Integrating LangChain with GitHub via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitHub within automated workflows.
How to Connect DBeaver to Azure Synapse via a JDBC Driver

Manage Azure Synapse with visual tools in DBeaver like the query browser.
Build Freshdesk-Connected Visualizations in datapine

Use CData Connect AI and datapine to build visualizations and dashboards with access to live Freshdesk.
Automated Continuous Spark Replication to Databricks

Use CData Sync for automated, continuous, customizable Spark replication to Databricks.
DataBind Charts to Google Ads

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Ads from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
Access Amazon Marketplace in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Amazon Marketplace.
Use Microsoft Copilot Studio to talk to your Google Search Results via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Search for you.
Build Dashboards with SQL Analysis Services in DBxtra

Create dynamic dashboards and perform analytics based on SQL Analysis Services in DBxtra.
Connect to Bing Ads from Crystal Reports

Use CData Connect AI to connect to and report on live Bing Ads from Crystal Reports.
Connect to Klipfolio in Ruby

Connect to Klipfolio in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
How to Connect to Live Amazon Marketplace Data from Sourcegraph Amp (via CData Connect AI)

Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon Marketplace securely in real time.
Connect to Azure Data Catalog in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
DataBind Controls to SAP in C++Builder

DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.
Integrate Live Workday into Blue Prism for Intelligent Robotic Process Automation (RPA)

CData is the data layer that makes AI work in production—live connectivity and replication across hundreds of the most critical enterprise sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.