CData Software - Knowledge Base
Recent Articles
-
Access Live CockroachDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live CockroachDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build AI Agents with Elasticsearch Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Connect to Oracle in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Database in Google Apps Script.
-
Getting Started with the CData Excel Add-In for Hive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hive.
-
Work with Sage Cloud Accounting in FoxPro
Load Sage Business Cloud Accounting into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Procore Replication to MySQL
Use CData Sync for automated, continuous, customizable Procore replication to MySQL.
-
How to connect to REST from Spring Boot
Connect to REST in a Spring Boot Application using CData JDBC REST Driver
-
Replicate Zoho Inventory to Multiple Databases via the CData Sync CLI
Replicate Zoho Inventory to disparate databases with a single configuration.
-
Bidirectional Access to Kafka from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache Kafka in Filemaker Pro for Mac or Windows.
-
Bidirectional Access to PayPal from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PayPal in Filemaker Pro for Mac or Windows.
-
Build a PostgreSQL Interface for Zoho Creator using the CData JDBC Driver
Use the Remoting features of the Zoho Creator JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for HCL Domino in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
Connect Kintone to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Kintone using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Google Search Results in CloverDX (formerly CloverETL)
Transfer Google Search using the visual workflow in the CloverDX data integration tool.
-
How to Build an ETL App for Sage Cloud Accounting in Python with CData
Create ETL applications and real-time data pipelines for Sage Business Cloud Accounting in Python with petl.
-
Work with Redshift in FoxPro
Load Amazon Redshift into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connecting Moonlit Workflow with Presto via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Presto in real time.
-
Use the CData API Server to Access SQL Analysis Services in Microsoft PowerPivot
Use the CData API Server to connect to live SQL Analysis Services in the Power Pivot business intelligence tool.
-
Analyze Klipfolio with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Klipfolio from Power Pivot. You will use the Table Import Wizard to load Klipfolio. You can visually build the import query or use any SQL supported by the driver.
-
Build Automated Workflows with Live SAP Concur in Workato
Use CData Connect AI to connect to live SAP Concur and build automated workflows in Workato.
-
Create ServiceNow-Connected Business Apps in AppSheet
Connect to ServiceNow via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ServiceNow.
-
Build a Singer.io Tap for Twilio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Twilio data using
-
Write a Simple Go Application to work with Calendly on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Calendly.
-
Build CockroachDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CockroachDB and create custom apps in Bubble.
-
Build Semantic Layer Views for eBay in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for eBay.
-
How to work with JotForm in Apache Spark using SQL
Access and process JotForm in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangChain with Shopify via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shopify within automated workflows.
-
How to Connect to Live Twitter Ads from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Twitter Ads for you.
-
Getting Started with the CData Python Connector for Invoiced
Learn to install and license the CData Python Connector
-
Connect to and Visualize Live Xero in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Xero Accounting.
-
Visualize Zoom in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zoom into TIBCO Spotfire.
-
Automate JotForm Replication to Azure Data Lake
Use CData Sync to customize and automate JotForm replication to Azure Data Lake.
-
Integrate Live Reckon into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Reckon from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Reckon.
-
Visualize Google Analytics in TIBCO Spotfire through OData
Integrate Google Analytics into dashboards in TIBCO Spotfire.
-
Process & Analyze Sage Intacct in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage Intacct .
-
Access Live Amazon Marketplace in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Amazon Marketplace through MCP integration.
-
Visualize Microsoft Teams in TIBCO Spotfire through OData
Integrate Microsoft Teams into dashboards in TIBCO Spotfire.
-
Manage Twilio in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twilio.
-
A PostgreSQL Interface for Basecamp using the CData ODBC Driver
Use the SQL Gateway and Basecamp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Klaviyo via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Klaviyo in ColdFusion.
-
Use the CData SSIS Components to Insert New or Update Existing TaxJar Records from SQL Server
Easily push SQL Server data to TaxJar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into TaxJar or update existing records with data from a SQL Server database.
-
Create WooCommerce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WooCommerce data access from reports, embedded analytics, and more.
-
Integrate Live ActiveCampaign into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ActiveCampaign and integrate live ActiveCampaign into apps built in Microsoft Power Apps.
-
Connect to Freshdesk in Aqua Data Studio
Access Freshdesk from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Extract, Transform, and Load Aha! in Informatica PowerCenter
Create a simple Workflow for Aha! in Informatica PowerCenter.
-
How to Connect to Live eBay 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 eBay for you.
-
Import Couchbase into the Power BI Service for Visualizations
Use CData Connect AI to connect to Couchbase and provide access to live Couchbase for custom reports in the Power BI Service.
-
Visualize MariaDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to MariaDB.
-
Establish a Live Connection with SendGrid using Tableau Bridge
The CData ODBC Driver for SendGrid enables you to integrate live SendGrid into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Oracle from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle Database for you.
-
Integrating Claude Code with Redshift via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon Redshift within assisted coding and automated development workflows.
-
Automated Continuous DB2 Replication to Vertica
Use CData Sync for automated, continuous, customizable DB2 replication to Vertica.
-
Integrate Live Kintone into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Kintone and integrate live Kintone into apps built in Microsoft Power Apps.
-
Access Live MailChimp in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MailChimp into the statistical analysis tools available in SAS JMP. This article shows how to use MailChimp in the Graph Builder and Query Builder.
-
Connect to DocuSign as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for DocuSign.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Splunk
Provide connectivity to Splunk through an SAP BusinessObjects universe.
-
Connect to MYOB AccountRight in Google Apps Script via SQL Gateway
Use the ODBC Driver for MYOB AccountRight and the SQL Gateway to access MYOB AccountRight from Google Apps Script.
-
How to Access Live SurveyMonkey in Visual Studio Code via Cline
-