CData Software - Knowledge Base
Recent Articles
-
How to create Visio diagrams from FTP Data
Automatically update FTP Servers with the changes you make to Visio master shapes.
-
Query QuickBooks Time Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Time.
-
Migrating data from Neo4J to Snowflake using CData SSIS Components.
Easily push Neo4J to Snowflake using the CData SSIS Tasks for Neo4J and Snowflake.
-
How to Query Live Printful Data in Claude Desktop
Connect to and query live Printful Data in Claude Desktop using CData MCP Server.
-
Consume Eventbrite OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Eventbrite feeds that reflect any changes in SAP Lumira.
-
Seamlessly Bring Workday Data into Retool Using CData Connect AI
Integrate Workday data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Publish Reports with Printful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printful.
-
Query Short.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Short.io from Node.js.
-
Integrating GitHub Copilot CLI with Zendesk 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.
-
Connect MySQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MySQL using the CData Python MCP Server.
-
Visualize Paddle Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Paddle into TIBCO Spotfire.
-
Connect to Lakebase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Lakebase Data and connect to Lakebase in Akorbi Digital RunMyProcess.
-
Analyze Oracle Eloqua Reporting Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Eloqua Reporting in Microsoft R Open.
-
How to connect to Gorgias Data in DBVisualizer
Integrate Gorgias with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Microsoft Teams Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Teams.
-
Automate CircleCI Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live CircleCI and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Printful Data in DBArtisan
Use wizards in DBArtisan to configure Printful as a data source.
-
Integrating Claude Code with FreshBooks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FreshBooks within assisted coding and automated development workflows.
-
Publish Reckon Accounts Hosted-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon Accounts Hosted.
-
Access Live Certinia Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Certinia through MCP integration.
-
Replicate QuickBooks Time Data to Multiple Databases
Replicate QuickBooks Time to disparate databases with a point-and-click configuration.
-
Connect to Deel Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Deel and work with Deel in your FileMaker application.
-
Integrating OpenCode Terminal with Deel 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.
-
Getting Started with the CData Python Connector for Gong
Learn to install and license the CData Python Connector
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Phoenix
Provide connectivity to Apache Phoenix through an SAP BusinessObjects universe.
-
Build ZohoMarketingHub-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live ZohoMarketingHub Data in GitHub Copilot to assist with building ZohoMarketingHub-powered applications.
-
Build Dashboards with Google Drive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Drive in Dundas BI.
-
How to Query LaunchDarkly Data in MySQL Workbench
Execute MySQL queries against live LaunchDarkly from MySQL Workbench.
-
Add ClickUp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ClickUp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Greenhouse
Provide connectivity to Greenhouse through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on Google Cloud Storage Data with the QUERY Formula
Pull data from Google Cloud Storage, automate spreadsheets, and more with the QUERY formula.
-
Connect to Avro from Asprova with CData Software ODBC Driver for Avro
This article shows how to connect faster to Avro data from Asprova.
-
Access Short.io Data from MySQL in Amazon QuickSight
Connect to Short.io and build visualizations of Short.io using a MySQL Connection in Amazon QuickSight.
-
Integrate Live Microsoft OneDrive Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft OneDrive to Blue Prism using the CData ODBC Driver for Microsoft OneDrive to create automated workflows for repetitive business tasks.
-
Operational Reporting on SingleStore Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SingleStore.
-
Connect to CockroachDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with CockroachDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData API Server to Access SAP Fieldglass Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Fieldglass in the Power Pivot business intelligence tool.
-
Create SSAS Tabular Models from Marketo Data
How to build a SQL Server Analysis Service Tabular Model from Marketo using CData drivers.
-
DataBind Charts to Paymo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paymo 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.
-
Connect to Flowlu Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Flowlu in the Denodo Virtual DataPort Administrator.
-
Build Oracle-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Database.
-
Integrating LangChain with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Workday within automated workflows.
-
Connect to Vimeo Data in CloverDX (formerly CloverETL)
Transfer Vimeo using the visual workflow in the CloverDX data integration tool.
-
How to Query Tanda Data in MySQL Workbench
Execute MySQL queries against live Tanda from MySQL Workbench.
-
Analyze Microsoft Teams Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Teams and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Simple VCL Application for Placid Data
How to build a simple VCL Application to view Placid in RAD Studio using the CData ODBC Driver for Placid.
-
Integrate Paylocity Data in the Pentaho Report Designer
Publish reports based on Paylocity in the Pentaho BI tool.
-
Use Biml to Build SSIS Tasks to Replicate Salesforce Pardot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Salesforce Pardot to SQL Server.
-
Build Zendesk-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zendesk to explore live Zendesk Data in GitHub Copilot to assist with building Zendesk-powered applications.
-
Integrate Real-Time Access to Azure Table in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Table Storage in real time.
-
Build Dashboards with xBase Data in DBxtra
Create dynamic dashboards and perform analytics based on xBase in DBxtra.
-
Use the CData ODBC Driver for Webflow in Microsoft Power Query
You can use the CData Webflow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Webflow into Microsoft Power Query.
-
Visualize Live Azure DevOps Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure DevOps.
-
How to connect and process QuickBooks Time from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Time.
-
Integrate Redshift Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Redshift from Informatica Cloud.
-
Working with Typeform Data in LINQPad
Execute LINQ queries to Typeform in LINQPad.
-
Extract, Transform, and Load Anaplan Data in Informatica PowerCenter
Create a simple Workflow for Anaplan in Informatica PowerCenter.
-
Create Power BI Reports on Real-Time Square Data
Use the CData ODBC Driver for Square to visualize Square in Power BI Desktop.
-
Integrating Claude Code CLI with CouchDB 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tickspot
Provide connectivity to Tickspot through an SAP BusinessObjects universe.
-
Integrate Quickbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Quickbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Quickbase.
-
Query SparkPost Data as a MySQL Database in Node.js
Execute MySQL queries against SparkPost from Node.js.
-
Build a PostgreSQL Interface for Slack Data using the CData JDBC Driver
Use the Remoting features of the Slack JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build MVC Applications with Connectivity to Clio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clio from an ASP.NET MVC application.
-
Integrate with Twitter Ads Data in JReport Designer
Create charts and reports based on Twitter Ads in JReport Designer.
-
Build Semantic Layer Views for Perplexity Data in APOS Live Data Gateway
Use the CData Connector for Perplexity in APOS Live Data Gateway to build Semantic Layer Views for Perplexity.
-
View Reports on Real-Time Elorus Data in Power BI Report Server
Use the CData ODBC Driver for Elorus to visualize Elorus in Power BI Desktop and then publish them to Power BI Report Server.
-
Write a Simple Go Application to work with Procore Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Procore.
-
Automated Continuous DB2 Replication to Snowflake
Use CData Sync for automated, continuous, customizable DB2 replication to Snowflake.
-
How to connect and process Basecamp from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Basecamp.
-
Build Pipelines with Live SAP Hybris C4C Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Hybris C4C from Google Cloud Data Fusion, enabling the integration of live SAP Hybris C4C into the building and management of effective data pipelines.
-
Migrating data from Chargebee to Snowflake using CData SSIS Components.
Easily push Chargebee to Snowflake using the CData SSIS Tasks for Chargebee and Snowflake.
-
Configure the CData JDBC Driver for ZohoExpense in a Connection Pool in Tomcat
Connect to ZohoExpense from a connection pool in Tomcat.
-
Migrating data from Vault CRM to Snowflake using CData SSIS Components.
Easily push Veeva Vault & Vault CRM to Snowflake using the CData SSIS Tasks for Vault CRM and Snowflake.
-
Building Dynamic Web Pages with Google Directory Data Using AngularJS
Create single-page applications with live connectivity to Google Directory using the CData API Server.
-
Connect to Suadeo Data in DBArtisan
Use wizards in DBArtisan to configure Suadeo as a data source.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy Desktop
Connect to Google Tasks in MicroStrategy Desktop using the CData Software JDBC Driver for Google Tasks.
-
Enable the PhantomBuster JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PhantomBuster.
-
Integrate Cursor with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Box from within the editor.
-
Connect to Mixpanel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mixpanel and the SQL Gateway to access Mixpanel from Google Apps Script.
-
Build Dashboards with Google Spanner Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Spanner in DBxtra.
-
Connect Gmail to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gmail using the CData Python MCP Server.
-
Connect to Cosmos DB from Asprova with CData Software ODBC Driver for Cosmos DB
This article shows how to connect faster to Cosmos DB data from Asprova.
-
How to Work with Everhour Data in ETL Validator JDBC
Connect to Everhour from ETL Validator jobs using the CData Software JDBC Driver.
-
Natively Connect to SendPulse Data in PHP
The CData ODBC driver for SendPulse enables you to create PHP applications with connectivity to SendPulse. Leverage the native support for ODBC in PHP.
-
Access CouchDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache CouchDB from your Oracle system.
-
Build Dashboards with Jira Assets Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jira Assets in Dundas BI.
-
Connect to FormSite Data in CloverDX (formerly CloverETL)
Transfer FormSite using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous LinkedIn Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to MySQL.
-
How to Query Live Teamgate Data in Perplexity MacOS Desktop
Connect to and query live Teamgate Data in Perplexity Desktop using CData MCP Server.
-
Connect to and Query Reckon Accounts Hosted Data in QlikView over ODBC
Create data visualizations with Reckon Accounts Hosted in QlikView.
-
Connect to JobNimbus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for JobNimbus.
-
How to create Visio diagrams from Google Spanner Data
Automatically update Google Spanner with the changes you make to Visio master shapes.
-
Load Bitbucket Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bitbucket to a database.
-
Build Humanity-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Humanity Data in GitHub Copilot to assist with building Humanity-powered applications.
-
Visualize Drip Data in Tableau
The CData ODBC driver for Drip enables you integrate Drip into Tableau dashboards.
-
DataBind Controls to Jira Assets Data in Delphi
DataBind to Jira Assets in Delphi with standard data access components and controls.
-
Configure the CData JDBC Driver for Google Campaign Manager 360 in a Connection Pool in Tomcat
Connect to Google Campaign Manager 360 from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy Desktop
Connect to IBM Cloud Object Storage in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Connect to Greenhouse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Greenhouse.