CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Templated Data Using the Low-Code Development Platform of Mendix
Connect Templated with Mendix to build apps using the CData API Driver for JDBC.
-
Query Superchat Data in ColdFusion
Write standard ColdFusion data access code to connect to Superchat.
-
Connect to Live Facebook Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Facebook Ads in CData Connect AI and connect to your Facebook Ads from PostgreSQL.
-
How to create an RPA flow for Pipedrive Data in UiPath Studio
Use the Pipedrive ODBC Driver to create workflows that access real-time Pipedrive without any coding.
-
Automate Clockify Data Replication to Azure Synapse
Use CData Sync to customize and automate Clockify replication to Azure Synapse.
-
Getting Started with the CData ADO.NET Provider for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for QuickBooks Online.
-
How to Query Live Stack Exchange Data in Perplexity MacOS Desktop
Connect to and query live Stack Exchange Data in Perplexity Desktop using CData MCP Server.
-
Build a Singer.io Tap for XML With the CData Python Connector
Learn how to easily build a Singer.io Tap for live XML data using
-
Visualize WordPress Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to WordPress.
-
Feed Highrise Data into FineReport
How to set Highrise CRM as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur in MicroStrategy Developer using the CData Software ODBC Driver for SAP Concur.
-
Migrating data from Epicor Kinetic to Google BigQuery using CData SSIS Components.
Easily push Epicor Kinetic to Google BigQuery using the CData SSIS Tasks for Epicor Kinetic and Google BigQuery.
-
Replicate Microsoft OneLake Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft OneLake to disparate databases with a single configuration.
-
Migrating data from EnterpriseDB to Google BigQuery using CData SSIS Components.
Easily push EnterpriseDB to Google BigQuery using the CData SSIS Tasks for EnterpriseDB and Google BigQuery.
-
Connect to Google Directory in SpagoBI
Create reports featuring live Google Directory in SpagoBI Studio. Host Google Directory reports on SpagoBI Server.
-
Build SAP BusinessObjects BI-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Bubble.
-
Build MVC Applications with Connectivity to SAP Business Warehouse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business Warehouse from an ASP.NET MVC application.
-
Create Datasets from Google Ad Manager in Domo Workbench and Build Visualizations of Google Ad Manager Data in Domo
Use the CData Software ODBC Driver for Google Ad Manager to create datasets from Google Ad Manager in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to MessageBird Data with Squirrel SQL client
Connect to MessageBird and execute queries in the Squirrel SQL Client.
-
Automate Datadog Data Replication to Azure Synapse
Use CData Sync to customize and automate Datadog replication to Azure Synapse.
-
Design BIRT Reports on CapsuleCRM Data
Provide current CapsuleCRM to your embedded analytics.
-
Connect Azure Analysis Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Analysis Services using the CData Python MCP Server.
-
Work with Quaderno Data in FoxPro
Load Quaderno into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Voice Agents in ElevenLabs with access to Live HCL Domino Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live HCL Domino.
-
Build Visualizations of SharePoint Excel Services Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SharePoint Excel Services in Birst.
-
Build Dashboards with Teamgate Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamgate in Dundas BI.
-
How to connect to Zoho Books Data with Squirrel SQL client
Connect to Zoho Books and execute queries in the Squirrel SQL Client.
-
Connect to Teamwork from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teamwork to connect to Teamwork from Web applications running on WebLogic.
-
Migrating data from Gmail to Databricks using CData SSIS Components.
Easily push Gmail to Databricks using the CData SSIS Tasks for Gmail and Databricks.
-
How to Create Power BI Visual Reports with Real-Time Vimeo Data
Use CData Power BI Connectors to visualize Vimeo in Power BI.
-
Write a Simple Go Application to work with Teamwork Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamwork.
-
DataBind Controls to ZohoPeople Data in Delphi
DataBind to ZohoPeople in Delphi with standard data access components and controls.
-
Access Live Freshservice Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshservice from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access ConstantContact Data Using Entity Framework
This article shows how to access ConstantContact using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Feed GetResponse Data into FineReport
How to set GetResponse as a JDBC data source in FineReport.
-
Analyze GitLab Data in Cognos Analytics
Use CData Connect AI to connect to GitLab Data from Cognos Analytics and analyze live GitLab.
-
Configure the CData JDBC Driver for Google Tasks in a Connection Pool in Tomcat
Connect to Google Tasks from a connection pool in Tomcat.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Entra ID within intelligent workflows.
-
Integrating LangGraph with NetSuite Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on NetSuite CRM & ERP within automated workflows.
-
Build MVC Applications with Connectivity to Dynamics 365 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics 365 from an ASP.NET MVC application.
-
Build Data Flows from SQL Server to Redshift through SSIS
Easily push SQL Server data to Redshift using the CData SSIS Tasks for Redshift.
-
Connect Adobe Commerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Commerce with IBM WebSphere for seamless data integration and connectivity.
-
Prepare, Blend, and Analyze SharePoint Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft SharePoint for self-service data analytics.
-
Integrate LibreChat with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live NetSuite CRM & ERP from within the chat interface.
-
Connect to Billsby in SpagoBI
Create reports featuring live Billsby in SpagoBI Studio. Host Billsby reports on SpagoBI Server.
-
How to integrate Metabase with Google Analytics Data
Use CData Connect AI to connect to live Google Analytics and create an interactive dashboard in Metabase from Google Analytics.
-
Visualize Parallel Data in TIBCO Spotfire through OData
Integrate Parallel into dashboards in TIBCO Spotfire.
-
Connect to LightSpeedRetail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LightSpeedRetail and the SQL Gateway to access LightSpeedRetail from Google Apps Script.
-
Consume BambooHR OData Feeds in PowerBuilder
This article demonstrates how to consume BambooHR as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Foursquare Data
Create Python applications that use pandas and Dash to build Foursquare-connected web apps.
-
Connect to Amazon Marketplace Data from AWS Glue
Use CData Connect AI to gain access to live Amazon Marketplace from your AWS Glue jobs.
-
Connect to Mode Data in Aqua Data Studio
Access Mode from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Voice Agents in ElevenLabs with access to Live Marketo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Marketo.
-
Visualize Live eBay Data in the Power BI Service
Use CData Connect AI to connect to live eBay and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live PingOne Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PingOne into the statistical analysis tools available in SAS JMP. This article shows how to use PingOne in the Graph Builder and Query Builder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ShipEngine to Power BI dashboards. Simply drag and drop ShipEngine into data visuals on the Power BI canvas.
-
Integrating Gumloop with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Greenhouse within automated workflows.
-
Create Reports with Marketo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Marketo.
-
Load Postmark Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Postmark to a database.
-
How to Create Power BI Visual Reports with Real-Time Salesforce CRM Analytics Data
Use CData Power BI Connectors to visualize Salesforce CRM Analytics in Power BI.
-
Connect to FreshBooks Data in DBeaver
Use the CData ODBC Driver to connect to FreshBooks in DBeaver.
-
Bidirectional Access to Vercel Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vercel in Filemaker Pro for Mac or Windows.
-
Migrating data from Oracle HCM Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle HCM Cloud to Google BigQuery using the CData SSIS Tasks for Oracle HCM Cloud and Google BigQuery.
-
Create Twilio-Connected Business Apps in AppSheet
Connect to Twilio Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Twilio.
-
Automated Continuous QuickBooks Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to MongoDB.
-
Visualize Zoom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoom.
-
Automated Continuous Planio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Planio replication to SingleStore.
-
Integrating Codex CLI with WooCommerce 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.
-
Build an OLAP Cube in SSAS from Epicor Kinetic Data
Establish a connection to Epicor Kinetic data from SQL Server Analysis Services, and use the Epicor Kinetic Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to Autopilot Data in C++Builder
DataBind to Autopilot in C++Builder with standard components and controls.
-
Feed Elorus Data into FineReport
How to set Elorus as a JDBC data source in FineReport.
-
Build a Singer.io Tap for Cloudant With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudant data using
-
Access Workable Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Workable from HeidiSQL.
-
Integrate ConvertAPI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ConvertAPI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ConvertAPI.
-
Connect to TigerGraph Data from PowerBuilder via JDBC
This article demonstrates how to access TigerGraph from PowerBuilder using the TigerGraph JDBC Driver.
-
Build Reckon Accounts Hosted-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Zoho Analytics and import live Reckon Accounts Hosted.
-
Connect to Gumroad Data in NetBeans
Connect to Gumroad in NetBeans with the data source configuration wizard.
-
Build a Singer.io Tap for PayPal With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PayPal data using
-
Add Oracle HCM Cloud Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle HCM Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live Snapchat Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snapchat Ads securely in real time.
-
Getting Started with the CData Tableau Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect Access Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Access using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Google Translate 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 Google Translate into TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for VWO
Complete guide to installing, licensing, and connecting with the CData SSIS Components for VWO.
-
Connect to and Visualize Live CouchDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache CouchDB.
-
Access Wrike Data from MySQL in PHP
Connect to Wrike through the standard MySQL libraries in PHP.
-
Integrating OpenCode Terminal with Highrise 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.
-
Analyze SAP Hybris C4C Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Hybris C4C and visualize live SAP Hybris C4C in Infragistics Reveal.
-
Build Agents in Relevance AI with Access to Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zendesk within intelligent agent workflows.
-
Replicate Sage 200 Data from PowerShell
Write a quick PowerShell script to query Sage 200. Use connectivity to the live data to replicate Sage 200 to SQL Server.
-
Visualize Missive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Missive.
-
Integrating Twilio Data in Talend Cloud Data Management Platform
Connect Twilio Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twilio.
-
Access Excel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Excel from HeidiSQL.
-
Integrating BigCommerce Data in Talend Cloud Data Management Platform
Connect BigCommerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for BigCommerce.
-
How to connect to MongoDB Data in DBVisualizer
Integrate MongoDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Anaplan Data in APOS Live Data Gateway
Use the CData Connector for Anaplan in APOS Live Data Gateway to build Semantic Layer Views for Anaplan.
-
Build a Simple VCL Application for Splunk Data
How to build a simple VCL Application to view Splunk in RAD Studio using the CData ODBC Driver for Splunk.
-
Build GraphQL-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for GraphQL to explore live GraphQL Data in Cursor to assist with building GraphQL-powered applications.
-
DataBind Controls to IBM Cloud Object Storage Data in Delphi
DataBind to IBM Cloud Object Storage in Delphi with standard data access components and controls.
-
Integrate TigerGraph Data in Pentaho Data Integration
Build ETL pipelines based on TigerGraph in the Pentaho Data Integration tool.