CData Software - Knowledge Base
Recent Articles
-
Integrating Antigravity CLI with Google Tasks via CData CLI
Connect Google Tasks to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code CLI with ShipStation 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.
-
Build Voice Agents in ElevenLabs with access to Live Cosmos DB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure Cosmos DB.
-
Connecting Agentforce with Adobe Analytics 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 Adobe Analytics for you.
-
Getting Started with the CData Tableau Connector for Sage 200
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage 200.
-
Replicate Microsoft Exchange Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Exchange to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Real-Time LionDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LionDesk in ColdFusion.
-
Rapidly Develop Moosend-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Moosend.
-
Connect to Elasticsearch Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Elasticsearch and the SQL Gateway to access Elasticsearch from Google Apps Script.
-
How to Access Live Salesloft Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesloft enables you to integrate Salesloft into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Python Connector for Demio
Learn to install and license the CData Python Connector
-
Integrate Reply.io Data in the Pentaho Report Designer
Publish reports based on Reply.io in the Pentaho BI tool.
-
How to Create Power BI Visual Reports with Real-Time SAS Data Sets Data
Use CData Power BI Connectors to visualize SAS Data Sets in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Coinbase
Create an ODBC connection to Coinbase in Informatica and browse and transfer Coinbase.
-
Connect to Google Forms in SpagoBI
Create reports featuring live Google Forms in SpagoBI Studio. Host Google Forms reports on SpagoBI Server.
-
Connect PagerDuty Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PagerDuty using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build an OLAP Cube in SSAS from Adobe Commerce Data
Establish a connection to Adobe Commerce data from SQL Server Analysis Services, and use the Adobe Commerce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Discourse Data in JRuby
Create a simple JRuby app with access to live Discourse.
-
How to work with Google Search Results in Apache Spark using SQL
Access and process Google Search Results in Apache Spark using the CData Software JDBC Driver.
-
Create a Data Access Object for EmailOctopus Data using JDBI
A brief overview of creating a SQL Object API for EmailOctopus in JDBI.
-
Build SendPulse-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live SendPulse Data in GitHub Copilot to assist with building SendPulse-powered applications.
-
Access Live Zoho Creator Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Creator data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Recurly Data from a Connection Pool in JBoss
Integrate Recurly into Java servlets: Use the Management Console in JBoss to install the Recurly JDBC Driver.
-
Replicate Email Data in Heroku for Use in Salesforce Connect
Replicate Email to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Easily Integrate Miro Data in Lazarus Pascal IDE
Learn how to easily integrate live Miro in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Instagram Data in DBArtisan
Use wizards in DBArtisan to configure Instagram as a data source.
-
Build OpenWeatherMap-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live OpenWeatherMap Data in Claude Code to assist with building OpenWeatherMap-powered applications.
-
Getting Started with the CData Excel Add-In for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Analytics.
-
Connect to and Visualize Live Planio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Planio.
-
Build Agents in Relevance AI with Access to Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SQL Analysis Services within intelligent agent workflows.
-
Replicate Multiple Unbounce Accounts
Replicate multiple Unbounce accounts to one or many databases.
-
DataBind PolarTeamPro Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PolarTeamPro to a chart.
-
How to connect and process Tally ERP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tally ERP.
-
Stream Freshdesk Data into Apache Kafka Topics
Access and stream Freshdesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Dashboards with Wistia Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wistia in Dundas BI.
-
Moving Data from Dropbox to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dropbox data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build PayPal-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PayPal and build web apps with connectivity to live PayPal.
-
Access Live Authorize.Net 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 Authorize.Net through MCP integration.
-
How to integrate PagerDuty with Apache Airflow
Access and process PagerDuty in Apache Airflow using the CData JDBC Driver.
-
Connect to Bitbucket Data from PowerBuilder via JDBC
This article demonstrates how to access Bitbucket from PowerBuilder using the Bitbucket JDBC Driver.
-
Building Dynamic Web Pages with Outreach.io Data Using AngularJS
Create single-page applications with live connectivity to Outreach.io using the CData API Server.
-
Build Charts with Factorial Data in Clear Analytics
Create dynamic charts and perform analytics based on Factorial in Clear Analytics.
-
Publish SingleStore-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SingleStore.
-
Replicate Cohere Data from PowerShell
Write a quick PowerShell script to query Cohere. Use connectivity to the live data to replicate Cohere to SQL Server.
-
Access Live SAP Business One Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business One in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Spark Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Spark SQL replication to OneLake in Microsoft Fabric.
-
Query Productboard Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Productboard entities in PHP by modeling them as objects.
-
Getting Started with the CData Power BI Connector for Kintone
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Kintone.
-
How to Query Live Tally Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tally ERP data in natural language using Python.
-
Visualize Live Workable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Workable.
-
Model LinkedIn Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LinkedIn Ads, enabling the direct import of real-time LinkedIn Ads.
-
Access Live Freshdesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshdesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Process & Analyze Todoist Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist Data.
-
How to Connect DBeaver to ZendeskSell via a JDBC Driver
Manage ZendeskSell with visual tools in DBeaver like the query browser.
-
Feed Klipfolio Data into FineReport
How to set Klipfolio as a JDBC data source in FineReport.
-
Build LeadDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LeadDesk.
-
How to connect PolyBase to CircleCI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CircleCI.
-
Integrating Claude Code CLI with LinkedIn Ads 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.
-
Connect to Dynamics 365 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Dynamics 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365.
-
Build Redshift Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon Redshift and build visualizations in Tableau Cloud.
-
Natively Connect to Amazon DynamoDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon DynamoDB. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Helpscout 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 Helpscout into TIBCO Spotfire.
-
Integrating OpenCode Terminal with Jumpseller 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 Redshift Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Amazon Redshift and visualize live Amazon Redshift in Infragistics Reveal.
-
Write a Simple Go Application to work with Salesforce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce & Force.com.
-
Publish BigCommerce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BigCommerce.
-
Visualize Live Microsoft Teams Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Teams and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic Databricks Grids Using the Infragistics XamDataGrid
Learn how you can connect Databricks to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop PolarTeamPro-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PolarTeamPro.
-
Integrate Live Gumroad Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gumroad to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build MVC Applications with Connectivity to ZendeskSell Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZendeskSell from an ASP.NET MVC application.
-
Automate CapsuleCRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate CapsuleCRM replication to Azure Data Lake.
-
Create Dynamic SAS Data Sets Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS Data Sets to Infragistics XamDataGrid to build dynamic grids.
-
A PostgreSQL Interface for Gong Data using the CData ODBC Driver
Use the SQL Gateway and Gong ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Search Results in RazorSQL
Connect to Google Search from wizards and query Google Search from the GUI in the RazorSQL database management tool.
-
Easily Integrate Google Contacts Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Contacts in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Live Google Directory Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Directory from the MuleSoft Anypoint Platform to integrate live Google Directory into custom reports and dashboards.
-
DataBind Charts to Pinterest Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Pinterest 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.
-
How to Connect Zoho Projects 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 Zoho Projects data in real time using natural language.
-
Build Semantic Layer Views for Highrise Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Highrise CRM.
-
Integrate Drift Data in the Pentaho Report Designer
Publish reports based on Drift in the Pentaho BI tool.
-
Integrate Supabase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Supabase from Informatica Cloud.
-
Build Data Flows from Greenplum to SQL Server using SSIS
Easily back up Pivotal GreenPlum to SQL Server using the SSIS components for Greenplum.
-
Import Real-Time Gong Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gong in ColdFusion.
-
How to Connect to Live SAP SuccessFactors Data 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 SAP SuccessFactors for you.
-
Automated Continuous LaunchDarkly Replication to MySQL
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to MySQL.
-
How to import Mouseflow Data into Apache Solr
Use the CData Software JDBC Driver for Mouseflow in Data Import Handler and create an automated import of Mouseflow to Apache Solr Enterprise Search platform.
-
A PostgreSQL Interface for Optimizely Data using the CData ODBC Driver
Use the SQL Gateway and Optimizely ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Suadeo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Suadeo from Power Pivot. You will use the Table Import Wizard to load Suadeo. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy Desktop
Connect to CapsuleCRM in MicroStrategy Desktop using the CData Software JDBC Driver for CapsuleCRM.
-
Connect to Google Search Results from Crystal Reports
Use CData Connect AI to connect to and report on live Google Search from Crystal Reports.
-
Integrating Codex CLI with Apify 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 Dashboards with Hive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Hive in Dundas BI.
-
Integrate Cursor with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Vertica from within the editor.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook to SQL Server.
-
How to Access Live Quaderno Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Quaderno enables you to integrate Quaderno into workflows built using Microsoft Power Automate Desktop.
-
How to Connect Flowise AI Agents to Live Azure Data Lake Storage 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 Azure Data Lake Storage without replication.
-
Bridge Google Forms Connectivity with Apache NiFi
Access and process Google Forms in Apache NiFi using the CData JDBC Driver.
-
Publish Drip-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Drip.