CData Software - Knowledge Base
Recent Articles
-
Connect to Dynamics NAV with the CData OData Provider
This article uses the CData ADO.NET OData provider to retrieve data from Dynamics NAV. The process described will also work for other CData OData providers (JDBC, ODBC, SSIS, etc.).
-
Connecting Moonlit Workflow with Presto Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Presto data in real time.
-
Automated Continuous Microsoft Planner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse data in MicroStrategy Desktop using the CData Software JDBC Driver for Greenhouse.
-
Access Live Cohere Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cohere data into the statistical analysis tools available in SAS JMP. This article shows how to use Cohere data in the Graph Builder and Query Builder.
-
Connect to Paddle Data in DBeaver
Use the CData ODBC Driver to connect to Paddle data in DBeaver.
-
Use JayDeBeApi to access GraphQL Data in Python
Use standard Python scripting and the development environment of your choice to access live GraphQL data.
-
Automated Continuous FreshBooks Replication to SingleStore
Use CData Sync for automated, continuous, customizable FreshBooks replication to SingleStore.
-
How to connect and process SingleStore data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SingleStore data.
-
Analyze Zoho Projects Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho Projects data and visualize Zoho Projects data in SAP Analytics Cloud.
-
Back Up Helpscout data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Helpscout data data.
-
Query Live Yelp Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Yelp data through a conversational interface.
-
Use Claude to Talk to Your Oracle 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 Oracle data for you.
-
Analyze Sage 200 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage 200 from Power Pivot. You will use the Table Import Wizard to load Sage 200 data. You can visually build the import query or use any SQL supported by the driver.
-
Build Dashboards with Webflow Data in Dundas BI
Create dynamic dashboards and perform analytics based on Webflow data in Dundas BI.
-
Integrate Codat Data in the Pentaho Report Designer
Publish reports based on Codat data in the Pentaho BI tool.
-
Automated Continuous MessageBird Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MessageBird replication to Azure SQL Database.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads data for you.
-
Build Semantic Layer Views for WordPress Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WordPress data.
-
Integrate Epicor Kinetic with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Epicor Kinetic with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Epicor Kinetic data.
-
Connect to Hive Data from a Connection Pool in JBoss
Integrate Hive data into Java servlets: Use the Management Console in JBoss to install the Hive JDBC Driver.
-
Access Live Azure DevOps Data in Coginiti Pro
Connect to and query live Azure DevOps data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate OnePageCrm Data in Pentaho Data Integration
Build ETL pipelines based on OnePageCrm data in the Pentaho Data Integration tool.
-
Building Dynamic Web Pages with Bullhorn CRM Data Using AngularJS
Create single-page applications with live connectivity to Bullhorn CRM using the CData API Server.
-
Build Coinbase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Coinbase data.
-
Work with Brex Data in FoxPro
Load Brex data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for ConstantContact
Create an ODBC connection to ConstantContact in Informatica and browse and transfer ConstantContact data.
-
Deploy the ADO.NET Provider for MailerLite on an SSRS Report Server
Connect to MailerLite 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.
-
Operational Reporting on Oracle Eloqua Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Eloqua data.
-
Configure the CData JDBC Driver for Facebook Ads in a Connection Pool in Tomcat
Connect to Facebook Ads data from a connection pool in Tomcat.
-
Easily Integrate Jira Data in Lazarus Pascal IDE
Learn how to easily integrate live Jira data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
View Reports on Real-Time OData Services in Power BI Report Server
Use the CData ODBC Driver for OData to visualize OData services in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Agno to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Getting Started with the CData Power BI Connector for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Elasticsearch.
-
Use Dash to Build to Web Apps on Klipfolio Data
Create Python applications that use pandas and Dash to build Klipfolio-connected web apps.
-
Create Informatica Mappings From/To an ODBC Data Source for TaxJar
Create an ODBC connection to TaxJar in Informatica and browse and transfer TaxJar data.
-
Visualize Float Data in Tableau
The CData ODBC driver for Float enables you integrate Float data into Tableau dashboards.
-
Integrating Cursor with Impala 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 Semantic Layer Views for Rebilly Data in APOS Live Data Gateway
Use the CData Connector for Rebilly in APOS Live Data Gateway to build Semantic Layer Views for Rebilly data.
-
Replicate Highrise Data to Multiple Databases
Replicate Highrise data to disparate databases with a point-and-click configuration.
-
Automated Continuous Bannerbear Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bannerbear replication to AlloyDB.
-
Connect to QuickBooks Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks data in DBeaver.
-
How to Build an ETL App for Adobe Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Analytics data in Python with petl.
-
Integrate Cursor with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Stripe data from within the editor.
-
How to publish and share SFTP Data dashboards with Tableau Server
The CData ODBC driver for SFTP enables you integrate SFTP data into Tableau dashboards.
-
Connect to Smartsheet Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Smartsheet data.
-
Import Asana Data Using Azure Data Factory
Use CData Connect AI to connect to Asana Data from Azure Data Factory and import live Asana data.
-
Integrate Live Dynamics 365 Business Central Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dynamics 365 Business Central data to Blue Prism using the CData ODBC Driver for Dynamics 365 Business Central to create automated workflows for repetitive business tasks.
-
How to Connect to Live Google Cloud Storage Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Cloud Storage data through natural language.
-
Create Google Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Google Analytics Data from Nintex Workflow Cloud and build custom workflows using live Google Analytics data.
-
Prepare, Blend, and Analyze Discourse Data in Alteryx Designer (ODBC)
Build workflows to access live Discourse data for self-service data analytics.
-
Access Live Airtable Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Airtable data into the statistical analysis tools available in SAS JMP. This article shows how to use Airtable data in the Graph Builder and Query Builder.
-
Build Zoho Creator-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Creator Data from Choreo and build custom apps using live Zoho Creator data.
-
Connect to Live Cosmos DB Data in MicroStrategy through CData Connect AI
Create a live connection to Cosmos DB Data in CData Connect AI and connect to your Cosmos DB data from MicroStrategy.
-
Automated Continuous Email Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Email replication to delimited files (CSV/TSV).
-
Integrating Boomi Agentstudio with Azure Synapse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Synapse data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Chargebee from Asprova with CData Software ODBC Driver for Chargebee
This article shows how to connect faster to Chargebee data from Asprova.
-
How to work with Drip Data in Apache Spark using SQL
Access and process Drip Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous CockroachDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CockroachDB replication to Azure SQL Database.
-
Build Google Calendar-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Calendar Data and create custom apps in Mendix.
-
Connect to SFTP Data in Jaspersoft Studio
Execute SQL to remote SFTP data in Jaspersoft Studio.
-
Connect to Discourse Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Discourse and work with Discourse data in your FileMaker applications.
-
Use ChatGPT to Talk to Your Procore 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 Procore data for you.
-
Use ChatGPT to Talk to Your Salesforce Data 360 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 Salesforce Data 360 data for you.
-
Query Wistia Data in DataGrip
Create a Data Source for Wistia in DataGrip and use SQL to query live Wistia data.
-
Integrating OpenCode with Zuora 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 SSAS Tabular Models from BigQuery Data
How to build a SQL Server Analysis Service Tabular Model from BigQuery data using CData drivers.
-
Connect to Salesloft Data from AWS Glue
Use CData Connect AI to gain access to live Salesloft data from your AWS Glue jobs.
-
Automated Hubstaff Data Replication to Teradata
Use CData Sync to Customize and automate Hubstaff data replication to Teradata.
-
Build Voice Agents in ElevenLabs with access to Live WordPress Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live WordPress data.
-
Sugar CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sugar CRM facts in real time.
-
Integrate Oracle Financials Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Financials Cloud data in the Pentaho Data Integration tool.
-
Query Freshteam Data in ColdFusion
Write standard ColdFusion data access code to connect to Freshteam data.
-
Visualize Keap Data in Sisense
Create an ElastiCube in Sisense app with access to Keap data.
-
Getting Started with the CData ODBC Driver for Planio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Planio.
-
Access Printful Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Printful data.
-
Automated Continuous Outlook Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Outlook replication to delimited files (CSV/TSV).
-
Getting Started with the CData Python Connector for Tally
Learn to install and license the CData Python Connector and configure a connection to live Tally data.
-
Build Apps with Live Invoiced Data Using the Low-Code Development Platform of Mendix
Connect Invoiced data with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze Freshdesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshdesk data and visualize Freshdesk data in SAP Analytics Cloud.
-
Build Visualizations of Printify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Printify data in Birst.
-
How to Connect to & Open MariaDB Data in Microsoft Excel
This article uses the CData ODBC driver for MariaDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SSAS Tabular Models from Highrise Data
How to build a SQL Server Analysis Service Tabular Model from Highrise data using CData drivers.
-
How to use SQLAlchemy ORM to access Azure DevOps Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure DevOps data.
-
Integrate Cline with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Entra ID data from within your IDE.
-
Integrate ShipStation Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ShipStation data and integrate live ShipStation data into your Power Automate tasks.
-
Access Live Teamgate Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Teamgate data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Zoho Recruit Data in the Pentaho Report Designer
Publish reports based on Zoho Recruit data in the Pentaho BI tool.
-
Visualize Quickbase Data in TIBCO Spotfire through OData
Integrate Quickbase data into dashboards in TIBCO Spotfire.
-
Visualize Live OData Services in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live OData services into custom reports in Power BI.
-
Connect and Visualize Live Hive Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Hive data into the Databricks platform and create visualization dashboards with real-time Hive data.
-
Integrate Live Procore Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Procore data from within the IDE.
-
Build Dashboards with Redis Data in Dundas BI
Create dynamic dashboards and perform analytics based on Redis data in Dundas BI.
-
Use Dash to Build to Web Apps on Microsoft Ads Data
Create Python applications that use pandas and Dash to build Microsoft Ads-connected web apps.
-
Connect to Todoist Data in JRuby
Create a simple JRuby app with access to live Todoist data.
-
Automated Continuous Greenplum Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Greenplum replication to Google BigQuery.
-
Create Greenhouse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Greenhouse Data from Klipfolio and build custom visualizations using live Greenhouse data.
-
Back Up Recurly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Recurly data data.
-
DataBind Controls to Calendly Data in C++Builder
DataBind to Calendly data in C++Builder with standard components and controls.
-
Connecting Pipedream with Mailgun Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Mailgun data in real time.