CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple Apify Accounts via the CData Sync CLI
Replicate multiple Apify accounts to one or many databases.
-
Create Mailgun-Connected Business Apps in AppSheet
Connect to Mailgun Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Mailgun data.
-
Integrating GitHub Copilot with xBase data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Model, Search, and Visualize Live SAS Data Sets Data in ThoughtSpot
Use CData Connect AI to connect to live SAS Data Sets data for modeling, searching, and visualizing.
-
Process & Analyze CampaignMonitor Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CampaignMonitor Data.
-
Publish Missive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Missive data.
-
Automated Continuous IBM Informix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon Redshift.
-
Automated Continuous Jodoo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jodoo replication to delimited files (CSV/TSV).
-
Build an OLAP Cube in SSAS from Freshdesk Data
Establish a connection to Freshdesk data data from SQL Server Analysis Services, and use the Freshdesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use JayDeBeApi to access DB2 Data in Python
Use standard Python scripting and the development environment of your choice to access live DB2 data.
-
Deploy the ADO.NET Provider for Testmonitor on an SSRS Report Server
Connect to Testmonitor data 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 CouchDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for CouchDB data by developing a WCF Service Application.
-
Visualize Live Notion Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Notion data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use JayDeBeApi to access Toggl Data in Python
Use standard Python scripting and the development environment of your choice to access live Toggl data.
-
Access Live Teradata Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Teradata data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build ShipStation-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ShipStation data.
-
Connect to Snapchat Ads Data in Aqua Data Studio
Access Snapchat Ads data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData ODBC Driver for Beeminder from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Beeminder to connect to Beeminder data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Beeminder data in Excel.
-
Access Live iContact Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to iContact data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Invoiced Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Invoiced from Power Pivot. You will use the Table Import Wizard to load Invoiced data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Unbounce Data Replication to Teradata
Use CData Sync to Customize and automate Unbounce data replication to Teradata.
-
Use the CData ODBC Driver for Discord in Microsoft Power Query
You can use the CData Discord ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Discord data into Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData SSIS Components for Qualaroo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Qualaroo.
-
Publish Adobe Commerce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Adobe Commerce data.
-
Access Live Avro Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Avro data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Dashboards with Snapchat Ads Data in DBxtra
Create dynamic dashboards and perform analytics based on Snapchat Ads data in DBxtra.
-
Integrate with Cloudflare Data in JReport Designer
Create charts and reports based on Cloudflare data in JReport Designer.
-
Connect and Query Live Zoom Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoom data into Databricks and enable direct, live querying and analysis without replication.
-
Perform Batch Operations with Zoho Inventory Data in Apache NiFi
Connect to Zoho Inventory data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create a Data Access Object for Quickbase Data using JDBI
A brief overview of creating a SQL Object API for Quickbase data in JDBI.
-
DataBind Controls to ClickTime Data in Delphi
DataBind to ClickTime data in Delphi with standard data access components and controls.
-
Visualize Live SAP Ariba Source Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Ariba Source data.
-
Access Live Freshservice Data 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 Freshservice data through MCP integration.
-
Design BIRT Reports on Timely Data
Provide current Timely data to your embedded analytics.
-
Visualize ClickUp Data in Tableau
The CData ODBC driver for ClickUp enables you integrate ClickUp data into Tableau dashboards.
-
Automated Continuous Greenhouse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to Google Cloud SQL.
-
Connect to Webflow Data in JRuby
Create a simple JRuby app with access to live Webflow data.
-
Build Semantic Layer Views for Bugsnag Data in APOS Live Data Gateway
Use the CData Connector for Bugsnag in APOS Live Data Gateway to build Semantic Layer Views for Bugsnag data.
-
Use the CData Software JDBC Driver for Microsoft Planner in MicroStrategy
Connect to Microsoft Planner data in MicroStrategy Developer using the CData Software JDBC Driver for Microsoft Planner.
-
Use Claude to Talk to Your Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Act CRM data for you.
-
Paylocity Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Paylocity facts in real time.
-
Integrating Antigravity CLI with Azure Table data via CData CLI
Connect Azure Table data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Informatica Mappings From/To an ODBC Data Source for SageHR
Create an ODBC connection to SageHR in Informatica and browse and transfer SageHR data.
-
Deploy the ADO.NET Provider for Google Translate on an SSRS Report Server
Connect to Google Translate data 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.
-
Integrate Live HelloSign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HelloSign data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Figshare Data in Coginiti Pro
Connect to and query live Figshare data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use ChatGPT to Talk to Your Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Sendwithus data for you.
-
How to Query Live Chargebee Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Chargebee data data in natural language using Python.
-
Design BIRT Reports on Cohere Data
Provide current Cohere data to your embedded analytics.
-
How to Seamlessly Import Mixpanel Data into IBM SPSS Modeler
Integrate Mixpanel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Notion Replication to SQL Server
Use CData Sync for automated, continuous, customizable Notion replication to SQL Server.
-
How to Query Aircall Data in MySQL Workbench
Execute MySQL queries against live Aircall data from MySQL Workbench.
-
Use the CData ODBC Driver for PagerDuty in Microsoft Power Query
You can use the CData PagerDuty ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PagerDuty data into Microsoft Power Query.
-
Integrating Boomi Agentstudio with Facebook Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook Ads data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Flowlu Data to Multiple Databases via the CData Sync CLI
Replicate Flowlu data to disparate databases with a single configuration.
-
Integrate Coda with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Coda with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Coda data.
-
Import Real-Time SpaceX Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SpaceX data in ColdFusion.
-
Process & Analyze Amazon Marketplace Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amazon Marketplace Data.
-
How to Visualize eBay Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live eBay data in Python.
-
Use JayDeBeApi to access Cassandra Data in Python
Use standard Python scripting and the development environment of your choice to access live Cassandra data.
-
Connect to Jira Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Jira data.
-
Connect Salesforce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce data using the CData Python MCP Server.
-
Publish Hugging Face-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hugging Face data.
-
Build Automated Workflows with Live MYOB AccountRight Data in Workato
Use CData Connect AI to connect to live MYOB AccountRight data and build automated workflows in Workato.
-
Work with MongoDB Data in FoxPro
Load MongoDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live HCL Domino Data in Coginiti Pro
Connect to and query live HCL Domino data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Gumloop with Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Azure Analysis Services data within automated workflows.
-
Connect to Everhour Data from a Connection Pool in JBoss
Integrate Everhour data into Java servlets: Use the Management Console in JBoss to install the Everhour JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Zendesk
Install the CData Connect AI Python SDK to read and write live Zendesk data with standard DB-API 2.0 Python code.
-
Easily Integrate Flowlu Data in Lazarus Pascal IDE
Learn how to easily integrate live Flowlu data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
ETL Spotify in Oracle Data Integrator
This article shows how to transfer Spotify data into a data warehouse using Oracle Data Integrator.
-
Analyze Google Drive Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Drive data with the CData JDBC Driver for Google Drive.
-
Connect to Lakebase Data in NetBeans
Connect to Lakebase data in NetBeans with the data source configuration wizard.
-
Create Reports from Email Data in Looker Studio
Use CData Connect AI to gain access to live Email data and create custom reports in Looker Studio.
-
How to Connect to & Open Adobe Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for Adobe Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Semantic Layer Views for Perplexity Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Perplexity data.
-
Connect to Confluence Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Confluence to connect to Confluence data and execute queries in PowerBuilder.
-
View Reports on Real-Time Clockify Data in Power BI Report Server
Use the CData ODBC Driver for Clockify to visualize Clockify data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live BenchmarkEmail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BenchmarkEmail data into the statistical analysis tools available in SAS JMP. This article shows how to use BenchmarkEmail data in the Graph Builder and Query Builder.
-
Automated Continuous LightSpeedRetail Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to delimited files (CSV/TSV).
-
Use Microsoft Copilot Studio to talk to your ShipEngine Data 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 ShipEngine data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LinkedIn
Provide connectivity to LinkedIn data through an SAP BusinessObjects universe.
-
Integrate OpenCode with Live Sage 200 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sage 200 data from within your AI coding agent.
-
Automated Continuous Perigon Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Perigon replication to Apache Kafka.
-
Visualize HDFS Data in TIBCO Spotfire through ADO.NET
Integrate HDFS data into dashboards in TIBCO Spotfire.
-
Access GraphQL Data from MySQL in PHP
Connect to GraphQL through the standard MySQL libraries in PHP.
-
Connect to MYOB AccountRight Data in CloverDX (formerly CloverETL)
Transfer MYOB AccountRight data using the visual workflow in the CloverDX data integration tool.
-
Build Visualizations of SFTP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SFTP data in Birst.
-
Edit and Search External Hive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Hive data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Hive Data objects that you can access from apps and the dashboard.
-
How to Connect to Live Google Analytics Data 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 Google Analytics data for you.
-
Getting Started with the CData ODBC Driver for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA XS Advanced.
-
How to import SAP Ariba Source Data into Apache Solr
Use the CData Software JDBC Driver for SAP Ariba Source in Data Import Handler and create an automated import of SAP Ariba Source data to Apache Solr Enterprise Search platform.
-
Integrate Teradata Data in Pentaho Data Integration
Build ETL pipelines based on Teradata data in the Pentaho Data Integration tool.
-
Create Power BI Reports on Real-Time SAP ByDesign Data
Use the CData ODBC Driver for SAP ByDesign to visualize SAP ByDesign data in Power BI Desktop.
-
Easily Integrate Hubstaff Data in Lazarus Pascal IDE
Learn how to easily integrate live Hubstaff data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to load Apify data into Elasticsearch via Logstash
Introducing a simple method to load Apify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Bridge Smartsheet Connectivity with Apache NiFi
Access and process Smartsheet data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Desktop
Connect to Klaviyo data in MicroStrategy Desktop using the CData Software JDBC Driver for Klaviyo.
-
Automate Qualaroo Data Replication to Couchbase
Use CData Sync to Customize and automate Qualaroo data replication to Couchbase.