CData Software - Knowledge Base
Recent Articles
-
Connect to Klipfolio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Klipfolio data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Opsgenie Replication to Oracle
Use CData Sync for automated, continuous, customizable Opsgenie replication to Oracle.
-
Connect to Azure Data Catalog in SpagoBI
Create reports featuring live Azure Data Catalog data in SpagoBI Studio. Host Azure Data Catalog reports on SpagoBI Server.
-
Automated Continuous NASA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable NASA replication to PostgreSQL.
-
How to connect Amazon QuickSight to Trello Data
Create a connection to Trello data in CData Connect AI and insert Trello data into Amazon QuickSight SPICE to build interactive dashboards.
-
Work with ClickTime Data in FoxPro
Load ClickTime data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Recurly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Recurly data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous PabblySubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to delimited files (CSV/TSV).
-
Connect to NASA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for NASA data.
-
Query Salesforce from Node.js
Execute CRUD queries to live Salesforce data in Node.js.
-
Analyze NASA Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze NASA data in Microsoft R Open.
-
Query Highrise Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Highrise data from Node.js.
-
Migrating data from Clockify to Databricks using CData SSIS Components.
Easily push Clockify data to Databricks using the CData SSIS Tasks for Clockify and Databricks.
-
How to Connect to & Open Redshift Data in Microsoft Excel
This article uses the CData ODBC driver for Redshift to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to SendPulse Data from Crystal Reports
Use CData Connect AI to connect to and report on live SendPulse data from Crystal Reports.
-
How to connect to Recurly Data with Squirrel SQL client
Connect to Recurly data and execute queries in the Squirrel SQL Client.
-
How to import Google Ad Manager Data into Apache Solr
Use the CData Software JDBC Driver for Google Ad Manager in Data Import Handler and create an automated import of Google Ad Manager data to Apache Solr Enterprise Search platform.
-
Build a Singer.io Tap for Blackbaud FE NXT With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Blackbaud FE NXT data using the CData Python Connector.
-
Connect to BenchmarkEmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BenchmarkEmail Data and connect to BenchmarkEmail data in Akorbi Digital RunMyProcess.
-
Automated Continuous BambooHR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable BambooHR replication to IBM DB2.
-
Connect to and Query eBay Data in QlikView over ODBC
Create data visualizations with eBay data in QlikView.
-
Build Apps with Live Phoenix data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Phoenix data into the Adalo platform and build custom mobile and web applications with real-time Phoenix data.
-
Access Epicor Kinetic Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Epicor Kinetic data from your Oracle system.
-
Integrating Boomi Agentstudio with ServiceNow Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ServiceNow data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Bitbucket Data from a Connection Pool in JBoss
Integrate Bitbucket data into Java servlets: Use the Management Console in JBoss to install the Bitbucket JDBC Driver.
-
Getting Started with the CData Tableau Connector for SingleStore
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SingleStore.
-
Work with Testmonitor Data in FoxPro
Load Testmonitor data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect SharePoint with SharePoint Excel Services Data through external lists
Provide SharePoint Excel Services data to SharePoint users as an external list.
-
How to Connect to MarkLogic Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MarkLogic data. Leverage the pyodbc module for ODBC in Python.
-
Access Contentful Data from MySQL in PHP
Connect to Contentful through the standard MySQL libraries in PHP.
-
Create Power BI Reports on Real-Time LightSpeedRetail Data
Use the CData ODBC Driver for LightSpeedRetail to visualize LightSpeedRetail data in Power BI Desktop.
-
How to update Couchbase from Excel
This article explains how to transfer data from Excel to Couchbase using the Excel Add-In for Couchbase.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Nethunt
Provide connectivity to Nethunt data through an SAP BusinessObjects universe.
-
How to load Invoiced data into Elasticsearch via Logstash
Introducing a simple method to load Invoiced data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Operational Reporting on Bitly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Bitly data.
-
Connect to CapsuleCRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live CapsuleCRM data from Filemaker Pro on Mac.
-
Integrate FTP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate FTP with External Services.
-
Connect to SAP Business One Data in RapidMiner
Integrate SAP Business One data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Seamlessly Import Pinecone Data into IBM SPSS Modeler
Integrate Pinecone data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Zendesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zendesk Data from Zoho Analytics and import live Zendesk data.
-
Visualize Spotify Data in TIBCO Spotfire through ADO.NET
Integrate Spotify data into dashboards in TIBCO Spotfire.
-
Query, Visualize, and Share live Workday Data in Redash
Use CData Connect AI to connect to live Workday data in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Asana Data in Microsoft Excel
This article uses the CData ODBC driver for Asana to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Gumloop with WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on WordPress data within automated workflows.
-
Automated Continuous Oracle Sales Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Amazon S3.
-
Replicate Exact Online Data to Multiple Databases
Replicate Exact Online data to disparate databases with a point-and-click configuration.
-
Automated Continuous Marketo Replication to Oracle
Use CData Sync for automated, continuous, customizable Marketo replication to Oracle.
-
How to Connect to Live PolarTeamPro Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your PolarTeamPro data for you.
-
Integrating Cursor with Cloudant 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.
-
Query Sage 300 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sage 300 data from Node.js.
-
How to Connect Flowise AI Agents to Live LinkedIn Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live LinkedIn Ads data without replication.
-
Add Kintone Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kintone with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for BigCommerce on an SSRS Report Server
Connect to BigCommerce 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.
-
Load Salesforce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce data to a database.
-
Integrating Gumroad Data in Talend Cloud Data Management Platform
Connect Gumroad Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Visualize ShipEngine 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 ShipEngine data in Python.
-
Publish Crystal Reports on WordPress Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date WordPress data.
-
Connect to Real-Time Close Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Close data in Power Apps.
-
Connecting Agentforce with Sage Cloud Accounting Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sage Cloud Accounting data for you.
-
Add Webflow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Webflow with the Informatica Enterprise Data Catalog to classify and organize data.
-
Natively Connect to SurveyMonkey Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SurveyMonkey data. Leverage the native support for ODBC in PHP.
-
Integrate Dify with Live Yelp Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Yelp data.
-
Connect to Gorgias Data in Jaspersoft Studio
Execute SQL to remote Gorgias data in Jaspersoft Studio.
-
Connect to NASA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time NASA data using standard SQL.
-
Replicate Epicor Kinetic Data in Heroku for Use in Salesforce Connect
Replicate Epicor Kinetic data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Auth0 Data in Heroku for Use in Salesforce Connect
Replicate Auth0 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Agno to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your QuickBooks Online data for you.
-
Integrating LangGraph with SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Ariba Source data within automated workflows.
-
Create SSAS Tabular Models from MYOB AccountRight Data
How to build a SQL Server Analysis Service Tabular Model from MYOB AccountRight data using CData drivers.
-
Replicate Codat Data from PowerShell
Write a quick PowerShell script to query Codat data. Use connectivity to the live data to replicate Codat data to SQL Server.
-
Connect to Factorial Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Factorial.
-
Easily Integrate Eventbrite Data in Lazarus Pascal IDE
Learn how to easily integrate live Eventbrite data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import and Visualize Optimizely Data in Power View
Create data visualizations based on Optimizely data in Excel.
-
Build a PostgreSQL Interface for SAS xpt Data using the CData JDBC Driver
Use the Remoting features of the SAS xpt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Working with SAP HANA Data in LINQPad
Execute LINQ queries to SAP HANA data in LINQPad.
-
Connect to Avro Data in JRuby
Create a simple JRuby app with access to live Avro data.
-
Establish a Live Connection with Calendly Data using Tableau Bridge
The CData ODBC Driver for Calendly enables you to integrate live Calendly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Provide OData Services of Eventbrite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Eventbrite data by developing a WCF Service Application.
-
Add Kafka Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Kafka with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Avalara AvaTax Data in Pentaho Data Integration
Build ETL pipelines based on Avalara AvaTax data in the Pentaho Data Integration tool.
-
Integrate Google's Antigravity Agent with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Tavily data using the Model Context Protocol.
-
Bidirectional Access to YouTube Analytics Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate YouTube Analytics data in Filemaker Pro for Mac or Windows.
-
Create Authorize.Net-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Authorize.Net Data from Klipfolio and build custom visualizations using live Authorize.Net data.
-
How to Work with Microsoft Entra ID Data in ETL Validator JDBC
Connect to Microsoft Entra ID from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Sage Cloud Accounting Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sage Cloud Accounting data.
-
Query Sage 200 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage 200 data from Node.js.
-
Connect to Humanity Data from PowerBuilder via ADO.NET
This article demonstrates how to access Humanity data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build MySQL Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MySQL data and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Slack in Microsoft Power Query
You can use the CData Slack ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Slack data into Microsoft Power Query.
-
Build Apps with Live Adobe Commerce data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce data into the Adalo platform and build custom mobile and web applications with real-time Adobe Commerce data.
-
Connect to and Visualize Live ADP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ADP data.
-
Access Live FTP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FTP data from your Google Sheets.
-
Use CData Connect AI to Access MailerLite Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MailerLite data in the Power Pivot business intelligence tool.
-
Connect to Stack Exchange Data in Jaspersoft Studio
Execute SQL to remote Stack Exchange data in Jaspersoft Studio.
-
Build Testmonitor-Connected Apps in Choreo
Use CData Connect AI to connect to Testmonitor Data from Choreo and build custom apps using live Testmonitor data.
-
Getting Started with the CData Python Connector for Coda
Learn to install and license the CData Python Connector and configure a connection to live Coda data.
-
Prepare, Blend, and Analyze ZohoPeople Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoPeople data for self-service data analytics.
-
Analyze Discord Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Discord data with the CData JDBC Driver for Discord.
-
How to Connect Okta Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Okta data in real time using natural language.
-
Build AI/ML Models with Live Vercel Data using Dataiku
Connect Vercel Data with Dataiku using the CData API Driver for JDBC.