CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Webflow.
-
Getting Started with the CData Python Connector for Slack
Learn to install and license the CData Python Connector and configure a connection to live Slack data.
-
Automated Continuous Tanda Replication to SQL Server
Use CData Sync for automated, continuous, customizable Tanda replication to SQL Server.
-
Work with Kintone Data in FoxPro
Load Kintone data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Live Jumpseller 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 Jumpseller data from within the IDE.
-
Build Voice Agents in ElevenLabs with access to Live Stripe Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Stripe data.
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Integrate Dify with Live Mailjet 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 Mailjet data.
-
Automated Continuous Lakebase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Lakebase replication to Amazon S3.
-
Integrate Goose with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Cvent data from within the local AI agent.
-
Connect to Grafana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Grafana data in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Outreach.io 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 Outreach.io data for you.
-
Visualize Live Bright Data Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bright Data data.
-
Prepare, Blend, and Analyze Xero Data in Alteryx Designer (Connect AI)
Build workflows to access live Xero data for self-service data analytics.
-
Integrate Devin with Live ZohoInvoice Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ZohoInvoice data.
-
Automated Continuous Microsoft Dataverse Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Databricks.
-
Getting Started with the CData SSIS Components for HubDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HubDB.
-
Automated Continuous Spark Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Spark replication to Amazon S3.
-
How to Visualize SAP Hybris C4C 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 SAP Hybris C4C data in Python.
-
Access Live SQL Analysis Services Data in AWS Lambda
Connect to live SQL Analysis Services data in AWS Lambda using the CData JDBC Driver.
-
Connect HubDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with live Slack Data in Jitterbit
Use CData Connect AI to connect to and integrate live Slack data in Jitterbit.
-
Connect to Amazon Athena Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon Athena data from PowerBuilder using the Amazon Athena JDBC Driver.
-
How to Query Live Google Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Analytics data data in natural language using Python.
-
Natively Connect to JotForm Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JotForm data. Leverage the native support for ODBC in PHP.
-
Integrate Parquet Data in the Pentaho Report Designer
Publish reports based on Parquet data in the Pentaho BI tool.
-
Validate SAS Data Sets Data with QuerySurge
Access and validate SAS Data Sets data in QuerySurge using the CData JDBC Driver.
-
Manage Templated Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Templated.
-
Integrate Goose with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Active Directory data from within the local AI agent.
-
Build Dashboards with Odoo Data in DBxtra
Create dynamic dashboards and perform analytics based on Odoo data in DBxtra.
-
Access Live Monday.com Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Monday.com data into the statistical analysis tools available in SAS JMP. This article shows how to use Monday.com data in the Graph Builder and Query Builder.
-
How to Query ChartMogul Data in MySQL Workbench
Execute MySQL queries against live ChartMogul data from MySQL Workbench.
-
View Reports on Real-Time Cohere Data in Power BI Report Server
Use the CData ODBC Driver for Cohere to visualize Cohere data in Power BI Desktop and then publish them to Power BI Report Server.
-
Excel Spreadsheet Automation on Highrise Data with the QUERY Formula
Pull data from Highrise, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Epicor Kinetic Data in ETL Validator JDBC
Connect to Epicor Kinetic from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data through natural language.
-
Create Datasets from Stack Exchange in Domo Workbench and Build Visualizations of Stack Exchange Data in Domo
Use the CData Software ODBC Driver for Stack Exchange to create datasets from Stack Exchange data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Zoho CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho CRM data.
-
Viewing Snowflake Data in RAD Studio Data Explorer
How to view Snowflake data in RAD Studio Data Explorer using the CData ODBC Driver for Snowflake.
-
Create Data Visualizations in Cognos BI with Hacker News Data
Access Hacker News data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with Tanda Data in ETL Validator JDBC
Connect to Tanda from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live PolarTeamPro 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 PolarTeamPro data through MCP integration.
-
Build Semantic Layer Views for Optimizely Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Optimizely data.
-
How to Visualize Elorus Data in Python with pandas
Use pandas and other modules to analyze and visualize live Elorus data in Python.
-
Integrate Facebook Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Facebook Ads data and integrate live Facebook Ads data into your Power Automate tasks.
-
Build Apps with Live BambooHR data in Adalo using CData Connect AI
Use CData Connect AI to integrate live BambooHR data into the Adalo platform and build custom mobile and web applications with real-time BambooHR data.
-
Query Apollo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apollo data from Node.js.
-
Getting Started with the CData ODBC Driver for SendInBlue
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SendInBlue.
-
Access Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data through MCP integration.
-
Excel Spreadsheet Automation on Oracle SCM Data with the QUERY Formula
Pull data from Oracle SCM, automate spreadsheets, and more with the QUERY formula.
-
Connect to Clockify Data in Jaspersoft Studio
Execute SQL to remote Clockify data in Jaspersoft Studio.
-
Access Live AgileCRM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live AgileCRM data from your Google Sheets.
-
Connect Spreadsheets Getting Started Guide
A basic guide to setting up and connecting to data through Connect Spreadsheets by CData
-
Integrating Gumloop with Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle HCM Cloud data within automated workflows.
-
Automated Continuous AgileCRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AgileCRM replication to Amazon Redshift.
-
Object-Relational Mapping (ORM) with MYOB AccountRight Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MYOB AccountRight data into a Java-based ORM framework, Hibernate.
-
Build Tavily-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Tavily data without replication.
-
Connect to Auth0 Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Auth0 and work with Auth0 data in your FileMaker applications.
-
How to integrate Mocean with Apache Airflow
Access and process Mocean data in Apache Airflow using the CData JDBC Driver.
-
Connect to Mocean Data in DBeaver
Use the CData ODBC Driver to connect to Mocean data in DBeaver.
-
Automated Continuous MailerSend Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MailerSend data replication to OneLake in Microsoft Fabric.
-
Build Couchbase-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Couchbase data without replication.
-
Visualize Live FHIR Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FHIR data into custom reports in Power BI.
-
How to Connect to & Open BigCommerce Data in Microsoft Excel
This article uses the CData ODBC driver for BigCommerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Tanda Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tanda data from PowerShell? This article demonstrates how to utilize the Tanda Cmdlets for tasks like connecting to Tanda data, automating operations, downloading data, and more.
-
Integrate with PhantomBuster Data in JReport Designer
Create charts and reports based on PhantomBuster data in JReport Designer.
-
Validate JDBC-ODBC Bridge Data with QuerySurge
Access and validate JDBC-ODBC Bridge data in QuerySurge using the CData JDBC Driver.
-
How to integrate xBase with Apache Airflow
Access and process xBase data in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Twilio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio data.
-
How to Seamlessly Import Mailjet Data into IBM SPSS Modeler
Integrate Mailjet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Placid Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Placid data data in natural language using Python.
-
Create Office 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Office 365 data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Sybase via a JDBC Driver
Manage Sybase data with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect Outlook to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Outlook data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live Yelp Data in the Power BI Service
Use CData Connect AI to connect to live Yelp data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Boomi Agentstudio with SendGrid Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SendGrid data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
DataBind Wistia Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Wistia data to a chart.
-
Use the CData ODBC Driver for Zoho Projects in Microsoft Power Query
You can use the CData Zoho Projects ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Projects data into Microsoft Power Query.
-
Replicate Multiple Harvest Accounts via the CData Sync CLI
Replicate multiple Harvest accounts to one or many databases.
-
Connect to Stripe Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Stripe data.
-
How to publish and share Todoist Data dashboards with Tableau Server
The CData ODBC driver for Todoist enables you integrate Todoist data into Tableau dashboards.
-
Integrate Live GraphQL Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to GraphQL data and integrate live GraphQL data into apps built in Microsoft Power Apps.
-
Analyze BambooHR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BambooHR data and visualize live BambooHR data in Infragistics Reveal.
-
Connect to NASA Data in HULFT Integrate
Connect to NASA as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Asana
Provide connectivity to Asana data through an SAP BusinessObjects universe.
-
Working with REST Data in LINQPad
Execute LINQ queries to REST data in LINQPad.
-
Integrate HBase Data in the Pentaho Report Designer
Publish reports based on HBase data in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy
Connect to Apify data in MicroStrategy Developer using the CData Software JDBC Driver for Apify.
-
Visualize LightSpeedRetail Data in TIBCO Spotfire through ADO.NET
Integrate LightSpeedRetail data into dashboards in TIBCO Spotfire.
-
Build Office 365 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Office 365 data and build visualizations in Tableau.
-
Connect to HelloSign Data from PowerBuilder via ADO.NET
This article demonstrates how to access HelloSign data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Live Google Directory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Directory data and integrate live Google Directory data into apps built in Microsoft Power Apps.
-
Analyze Jumpseller Data in Looker
Use CData Connect AI to connect to Jumpseller Data from Looker and build custom apps using live Jumpseller data.
-
Connect to Live LinkedIn Data in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn Data in CData Connect AI and connect to your LinkedIn data from MicroStrategy.
-
Create Paddle Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Paddle data access from reports, embedded analytics, and more.
-
Using the CData Software ODBC Driver for SAS Data Sets in PyCharm
Connect to SAS Data Sets as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAS Data Sets.
-
Automated Continuous Adobe Commerce Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MySQL.
-
Connect to Avalara AvaTax Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Avalara AvaTax and the SQL Gateway to access Avalara AvaTax data from Google Apps Script.
-
Work with NetSuite Data in FoxPro
Load NetSuite data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating OpenCode with Paymo 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.