CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ODBC Driver for Monday.com
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Monday.com.
-
Integrating Codex with YouTube Analytics 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.
-
How to Build an ETL App for Cohere Data in Python with CData
Create ETL applications and real-time data pipelines for Cohere data in Python with petl.
-
Connect to VWO Data in CloverDX (formerly CloverETL)
Transfer VWO data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Clio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Clio replication to SQL Server.
-
Create Datasets from Email in Domo Workbench and Build Visualizations of Email Data in Domo
Use the CData Software ODBC Driver for Email to create datasets from Email data in Domo Workbench and then build visualizations in the Domo service.
-
Publish Reports with Microsoft Planner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Planner data.
-
Build a PostgreSQL Interface for Smartsheet Data using the CData JDBC Driver
Use the Remoting features of the Smartsheet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Fieldglass Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Google Cloud SQL.
-
How to create an RPA flow for NetSuite Data in UiPath Studio
Use the NetSuite ODBC Driver to create workflows that access real-time NetSuite data without any coding.
-
Create Data Visualizations in Cognos BI with Phoenix Data
Access Phoenix data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ODBC Driver for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Avalara AvaTax.
-
Integrate Microsoft Entra ID Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Entra ID data and integrate live Microsoft Entra ID data into your Power Automate tasks.
-
DataBind Recurly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Recurly data to a chart.
-
Integrate with Recurly Data in JReport Designer
Create charts and reports based on Recurly data in JReport Designer.
-
How to Connect to Live Dynamics NAV Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Dynamics NAV data without replication.
-
Access Sage 200 Data from MySQL in Amazon QuickSight
Connect to Sage 200 and build visualizations of Sage 200 data using a MySQL Connection in Amazon QuickSight.
-
Integrate Placid with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Placid with External Services.
-
Create Informatica Mappings From/To an ODBC Data Source for Harvest
Create an ODBC connection to Harvest in Informatica and browse and transfer Harvest data.
-
DataBind Controls to SuiteCRM Data in Delphi
DataBind to SuiteCRM data in Delphi with standard data access components and controls.
-
How to Seamlessly Import Hugging Face Data into IBM SPSS Modeler
Integrate Hugging Face data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to MailChimp Data in PHP
The CData ODBC driver for MailChimp enables you to create PHP applications with connectivity to MailChimp data. Leverage the native support for ODBC in PHP.
-
Automate Oracle Eloqua Reporting Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Eloqua Reporting data replication to SAP HANA.
-
Automate Zoho Creator Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho Creator data replication to SAP HANA.
-
Explore Geographical Relationships in SAP HANA XS Advanced Data with Power Map
Create data visualizations with SAP HANA XS Advanced data in Power Map.
-
Automated Continuous Amazon Marketplace Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon Marketplace data replication to OneLake in Microsoft Fabric.
-
Excel Spreadsheet Automation on SendGrid Data with the QUERY Formula
Pull data from SendGrid, automate spreadsheets, and more with the QUERY formula.
-
Connect to Exact Online Data from a Connection Pool in Jetty
The Exact Online JDBC Driver supports connection pooling: This article shows how to connect faster to Exact Online data from Web apps in Jetty.
-
Integrate Chargebee with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Chargebee with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Chargebee data.
-
Connect to Optimizely 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 Optimizely and work with Optimizely data in your FileMaker application.
-
Consume Bitbucket OData Feeds in PowerBuilder
This article demonstrates how to consume Bitbucket data as OData feeds from PowerBuilder using the API Server.
-
Access Live Mode 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 Mode data through MCP integration.
-
Easily Integrate JobNimbus Data in Lazarus Pascal IDE
Learn how to easily integrate live JobNimbus data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Oracle Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle replication to PostgreSQL.
-
Viewing Exact Online Data in RAD Studio Data Explorer
How to view Exact Online data in RAD Studio Data Explorer using the CData ODBC Driver for Exact Online.
-
Connect to GitLab Data in DBeaver
Use the CData ODBC Driver to connect to GitLab data in DBeaver.
-
Access Live ADP Data in AWS Lambda
Connect to live ADP data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Todoist Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Todoist data replication to OneLake in Microsoft Fabric.
-
How to Access Live QuickBooks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for QuickBooks enables you to integrate QuickBooks data into workflows built using Microsoft Power Automate Desktop.
-
Connect PagerDuty to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PagerDuty with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Sage 300 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage 300 data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Twilio 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 Twilio data into TIBCO Spotfire.
-
Use CData Connect AI to Access OneNote Data in Microsoft Power Pivot
Use CData Connect AI to connect to live OneNote data in the Power Pivot business intelligence tool.
-
Search External Zuora Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zuora data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zuora Data objects that you can access from apps and the dashboard.
-
Build Testmonitor-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Testmonitor data.
-
Connect to Deel Data from a Connection Pool in Jetty
The Deel JDBC Driver supports connection pooling: This article shows how to connect faster to Deel data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Codat in MicroStrategy
Connect to Codat data in MicroStrategy Developer using the CData Software ODBC Driver for Codat.
-
Import Real-Time Active Directory Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Active Directory data in ColdFusion.
-
Connect to QuickBooks Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live QuickBooks data from Filemaker Pro on Mac.
-
Connect to Sugar CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sugar CRM data from Filemaker Pro on Mac.
-
Build Zendesk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zendesk data and build Zendesk-connected web apps with Axios.
-
Connect to Discourse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Discourse data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Informatica Mappings From/To an ODBC Data Source for Anaplan
Create an ODBC connection to Anaplan in Informatica and browse and transfer Anaplan data.
-
Getting Started with the CData Power BI Connector for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon Athena.
-
Back Up BenchmarkEmail 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 BenchmarkEmail data data.
-
Replicate Freshsales Data to Multiple Databases via the CData Sync CLI
Replicate Freshsales data to disparate databases with a single configuration.
-
Integrating Claude Code with XML Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on XML data within assisted coding and automated development workflows.
-
Getting Started with the CData Python Connector for GitLab
Learn to install and license the CData Python Connector and configure a connection to live GitLab data.
-
Build AI/ML Models with Live Act-On Data using Dataiku
Connect Act-On Data with Dataiku using the CData JDBC Driver for Act-On.
-
DataBind Google Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Analytics with the DevExpress Windows Forms and Web controls to provide Google Analytics data to a chart.
-
Build Zoho CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho CRM Data and create custom apps in Mendix.
-
Create Informatica Mappings From/To an ODBC Data Source for CloudConvert
Create an ODBC connection to CloudConvert in Informatica and browse and transfer CloudConvert data.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy
Connect to Oracle data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle.
-
Visualize Zoho Projects Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Projects data into dashboards in TIBCO Spotfire.
-
Connect to QuickBooks Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks Online to connect to QuickBooks Online data from Web applications running on WebLogic.
-
Build an OLAP Cube in SSAS from Sage 300 Data
Establish a connection to Sage 300 data data from SQL Server Analysis Services, and use the Sage 300 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Choosing the Best Method to Connect Brex to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Brex data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Google Drive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Drive data and build visualizations in Tableau.
-
Automated Continuous FormSite Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FormSite replication to Google Cloud SQL.
-
Connect to Live Timely Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Timely in CData Connect AI and connect to your Timely data from PostgreSQL.
-
Use Azure AI Foundry to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Oracle HCM Cloud data for you.
-
Create a Data Access Object for Asana Data using JDBI
A brief overview of creating a SQL Object API for Asana data in JDBI.
-
Connect Freshdesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Freshdesk data using the CData Python MCP Server.
-
Greenhouse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Greenhouse facts in real time.
-
Build Data Flows from Tanda to SQL Server using SSIS
Easily back up Tanda data to SQL Server using the SSIS components for Tanda.
-
A PostgreSQL Interface for OData Services using the CData ODBC Driver
Use the SQL Gateway and OData ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Microsoft Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Ads data replication to Azure Synapse.
-
Visualize Chargebee Data in Sisense
Create an ElastiCube in Sisense app with access to Chargebee data.
-
How to Connect the Power BI Service to Jumpseller: Complete Guide
Connect to the CData Software Power BI Connector for Jumpseller from PowerBI.com to provide real-time Jumpseller data across the organization.
-
Automated Continuous Guru Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Guru replication to Google Cloud SQL.
-
Access Live QuickBooks Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks data from your Excel spreadsheets.
-
Integrating LangGraph with WooCommerce Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on WooCommerce data within automated workflows.
-
Create Reports with Reckon Accounts Hosted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reckon Accounts Hosted data.
-
Build Data Flows from SQL Server to Exact Online through SSIS
Easily push SQL Server data to Exact Online using the CData SSIS Tasks for Exact Online.
-
Connect to Teamgate Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Teamgate data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Autopilot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Autopilot replication to Amazon S3.
-
Build a Singer.io Tap for Perigon With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Perigon data using the CData Python Connector.
-
Natively Connect to Vimeo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Vimeo data. Leverage the native support for ODBC in PHP.
-
Build Agents in Relevance AI with Access to Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on WordPress data within intelligent agent workflows.
-
Load SFTP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SFTP data to a database.
-
Use CData Connect AI to Access BambooHR Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BambooHR data in the Power Pivot business intelligence tool.
-
Visualize HubDB Data in TIBCO Spotfire through OData
Integrate HubDB data into dashboards in TIBCO Spotfire.
-
Connect to Monday.com Data from Crystal Reports
Use CData Connect AI to connect to and report on live Monday.com data from Crystal Reports.
-
Getting Started with the CData JDBC Driver for Billsby
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Billsby.
-
Connect to Demio Data in CloverDX (formerly CloverETL)
Transfer Demio data using the visual workflow in the CloverDX data integration tool.
-
Visualize Live PabblySubscriptions Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PabblySubscriptions data.
-
Build CloudConvert-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CloudConvert data.
-
Integrate Cursor with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live PingOne data from within the editor.
-
Build Apps with Live Dynamics NAV Data Using the Low-Code Development Platform of Mendix
Connect Dynamics NAV data with Mendix to build apps using the CData JDBC Driver for Dynamics NAV.
-
Replicate SparkPost Data from PowerShell
Write a quick PowerShell script to query SparkPost data. Use connectivity to the live data to replicate SparkPost data to SQL Server.