CData Software - Knowledge Base
Recent Articles
-
Connect to Paymo Data in HULFT Integrate
Connect to Paymo as a JDBC data source in HULFT Integrate
-
Natively Connect to Contentful Data in PHP
The CData ODBC driver for Contentful enables you to create PHP applications with connectivity to Contentful data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Productboard Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Productboard replication to Apache Cassandra.
-
Visualize Live Beeminder Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Beeminder data.
-
Connect to Trello in SpagoBI
Create reports featuring live Trello data in SpagoBI Studio. Host Trello reports on SpagoBI Server.
-
Build RabbitMQ-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live RabbitMQ data.
-
Connecting Supabase to CData Connect AI
Learn how to connect a Supabase PostgreSQL database to CData Connect AI so your AI tools and agents can query live data using natural language.
-
Analyze Gong Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gong data in Microsoft R Open.
-
Connect to Real-Time Outlook Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Outlook data in Power Apps.
-
Visualize Azure Data Catalog 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 Azure Data Catalog data into TIBCO Spotfire.
-
Integrate Live Monday.com Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Monday.com data and integrate live Monday.com data into apps built in Microsoft Power Apps.
-
How to Connect to QuickBooks Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Online data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple Azure Data Catalog Accounts via the CData Sync CLI
Replicate multiple Azure Data Catalog accounts to one or many databases.
-
How to Build an ETL App for Jira Data in Python with CData Connect AI
Extract and transform live Jira data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Keap Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Keap replication to Apache Kafka.
-
Working with Aircall Data in LINQPad
Execute LINQ queries to Aircall data in LINQPad.
-
How to Build an ETL App for Twilio Data in Python with CData
Create ETL applications and real-time data pipelines for Twilio data in Python with petl.
-
Build Agents in Relevance AI with Access to Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Okta data within intelligent agent workflows.
-
Enable the JSON JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with JSON services.
-
Integrate Live LinkedIn Ads Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LinkedIn Ads data to Blue Prism using the CData ODBC Driver for LinkedIn Ads to create automated workflows for repetitive business tasks.
-
Access Live Salesforce Data 360 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce Data 360 data from your Excel spreadsheets.
-
A PostgreSQL Interface for SAP Netweaver Gateway Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Netweaver Gateway JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Dotmailer in MicroStrategy Web
Connect to Dotmailer data in MicroStrategy Web using the CData Software ODBC Driver for Dotmailer.
-
Access Lakebase Data from MySQL in Amazon QuickSight
Connect to Lakebase and build visualizations of Lakebase data using a MySQL Connection in Amazon QuickSight.
-
Connect to and Visualize Live Quickbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quickbase data.
-
Connect to SAP Concur Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Concur to connect to SAP Concur data and execute queries in PowerBuilder.
-
Access Live Clari Data in AWS Lambda
Connect to live Clari data in AWS Lambda using the CData JDBC Driver.
-
Automate Salesforce Marketing Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce Marketing data replication to Azure Synapse.
-
Automate VWO Data Replication to Couchbase
Use CData Sync to Customize and automate VWO data replication to Couchbase.
-
Publish Reports with HelloSign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HelloSign data.
-
Validate Webflow Data with QuerySurge
Access and validate Webflow data in QuerySurge using the CData JDBC Driver.
-
Build ClickTime-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ClickTime data and build web apps with connectivity to live ClickTime data.
-
Automated Continuous Exact Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Exact Online replication to PostgreSQL.
-
View Reports on Real-Time ZohoInvoice Data in Power BI Report Server
Use the CData ODBC Driver for ZohoInvoice to visualize ZohoInvoice data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Biml to Build SSIS Tasks to Replicate Bannerbear Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bannerbear data to SQL Server.
-
Use ChatGPT to Talk to Your ZohoPeople 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 ZohoPeople data for you.
-
Automated Continuous AfterShip Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AfterShip replication to Amazon S3.
-
Connect to ZohoSubscriptions Data from HeidiSQL
Use CData Connect AI to connect to and query live ZohoSubscriptions data from HeidiSQL.
-
Connect to Quaderno Data from PowerBuilder via JDBC
This article demonstrates how to access Quaderno data from PowerBuilder using the Quaderno JDBC Driver.
-
Prepare, Blend, and Analyze QuickBooks Data in Alteryx Designer (Connect AI)
Build workflows to access live QuickBooks data for self-service data analytics.
-
How to Connect Flowise AI Agents to Live LDAP Objects via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live LDAP objects without replication.
-
Integrate Pipeline CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pipeline CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pipeline CRM data.
-
Connect to SAP Business Warehouse Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business Warehouse data from HeidiSQL.
-
Automate SharePoint Excel Services Data Replication to SAP HANA
Use CData Sync to customize and automate SharePoint Excel Services data replication to SAP HANA.
-
Integrate Lakebase Data into Power Automate Desktop using CData Connect
CData Connect for Lakebase Data enables you to integrate Lakebase data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Shippo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shippo and the SQL Gateway to access Shippo data from Google Apps Script.
-
Replicate SAP Fieldglass Data from PowerShell
Write a quick PowerShell script to query SAP Fieldglass data. Use connectivity to the live data to replicate SAP Fieldglass data to SQL Server.
-
Integrate Live XML 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 XML data from within the IDE.
-
Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy
Connect to Blackbaud FE NXT data in MicroStrategy Developer using the CData Software ODBC Driver for Blackbaud FE NXT.
-
Connect Quaderno to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Quaderno data using the CData Python MCP Server.
-
Replicate Google Calendar Data to Multiple Databases
Replicate Google Calendar data to disparate databases with a point-and-click configuration.
-
Connect Aircall to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Aircall data using the CData Python MCP Server.
-
How to integrate Cloudflare with Apache Airflow
Access and process Cloudflare data in Apache Airflow using the CData JDBC Driver.
-
Choosing the Best Method to Connect Instagram to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Instagram data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to ZohoMarketingHub Data in C++Builder
DataBind to ZohoMarketingHub data in C++Builder with standard components and controls.
-
Import and Visualize Dropbox Data in Power View
Create data visualizations based on Dropbox data in Excel.
-
Integrate with live iContact Data in Jitterbit
Use CData Connect AI to connect to and integrate live iContact data in Jitterbit.
-
Connect to Reckon Accounts Hosted Data in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon Accounts Hosted data in Google Apps Script.
-
Build Apps with Live CouchDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live CouchDB data into the Adalo platform and build custom mobile and web applications with real-time CouchDB data.
-
Configure the CData JDBC Driver for Retently in a Connection Pool in Tomcat
Connect to Retently data from a connection pool in Tomcat.
-
Replicate Xero Data from PowerShell
Write a quick PowerShell script to query Xero data. Use connectivity to the live data to replicate Xero data to SQL Server.
-
Connect to IBM Cloud Object Storage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage data and execute queries in PowerBuilder.
-
Use JayDeBeApi to access Sage Cloud Accounting Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Cloud Accounting data.
-
Build an OLAP Cube in SSAS from Power BI XMLA Data
Establish a connection to Power BI XMLA data data from SQL Server Analysis Services, and use the Power BI XMLA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Extract, Transform, and Load Greenplum Data in Informatica PowerCenter
Create a simple Workflow for Greenplum data in Informatica PowerCenter.
-
Integrate Act CRM Data in the Pentaho Report Designer
Publish reports based on Act CRM data in the Pentaho BI tool.
-
Automated Continuous Salesforce Pardot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Snowflake.
-
Deploy the ADO.NET Provider for Helpscout on an SSRS Report Server
Connect to Helpscout 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.
-
Automated Continuous ElevenLabs Replication to SingleStore
Use CData Sync for automated, continuous, customizable ElevenLabs replication to SingleStore.
-
DataBind MariaDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for MariaDB with the DevExpress Windows Forms and Web controls to provide MariaDB data to a chart.
-
Integrate Dify with Live GetResponse 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 GetResponse data.
-
Replicate Multiple CapsuleCRM Accounts via the CData Sync CLI
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Connect to MarkLogic Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MarkLogic data in the Denodo Virtual DataPort Administrator.
-
Integrate Cline with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Presto data from within your IDE.
-
Integrate GitHub Data in the Pentaho Report Designer
Publish reports based on GitHub data in the Pentaho BI tool.
-
Provide OData Services of Twilio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Twilio data by developing a WCF Service Application.
-
Automated Continuous Azure Data Lake Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Apache Cassandra.
-
Connecting Moonlit Workflow with Greenhouse 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 Greenhouse data in real time.
-
Build Data Flows from Access to SQL Server using SSIS
Easily back up Access data to SQL Server using the SSIS components for Access.
-
Integrating GitHub Copilot with SAP Business Warehouse 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.
-
Design BIRT Reports on Rootly Data
Provide current Rootly data to your embedded analytics.
-
Integrate with Live Freshteam Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Freshteam from the MuleSoft Anypoint Platform to integrate live Freshteam data into custom reports and dashboards.
-
Connect to Greenhouse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Greenhouse data.
-
Analyze ChartMogul Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ChartMogul data in Microsoft R Open.
-
Replicate HubDB Data in Heroku for Use in Salesforce Connect
Replicate HubDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Bridge Front Connectivity with Apache NiFi
Access and process Front data in Apache NiFi using the CData JDBC Driver.
-
Automate Mailgun Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mailgun data replication to Azure Data Lake.
-
How to Connect to Live PayPal 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 PayPal data for you.
-
Use Agno to Talk to Your Coda 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 Coda data for you.
-
Use Microsoft Copilot Studio to talk to your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Redis data for you.
-
Automated Continuous SAP Ariba Procurement Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Databricks.
-
Use JayDeBeApi to access Planio Data in Python
Use standard Python scripting and the development environment of your choice to access live Planio data.
-
Query MYOB AccountRight Data in ColdFusion
Write standard ColdFusion data access code to connect to MYOB AccountRight data.
-
Build an OLAP Cube in SSAS from YouTube Analytics Data
Establish a connection to YouTube Analytics data data from SQL Server Analysis Services, and use the YouTube Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to use SQLAlchemy ORM to access Amazon Marketplace Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon Marketplace data.
-
How to create BigCommerce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BigCommerce data in MySQL .
-
How to integrate CapsuleCRM with Apache Airflow
Access and process CapsuleCRM data in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Google Ads in MicroStrategy Web
Connect to Google Ads data in MicroStrategy Web using the CData Software ODBC Driver for Google Ads.
-
Connect to AgileCRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live AgileCRM data.
-
How to Create Power BI Visual Reports with Real-Time Twilio Data
Use CData Power BI Connectors to visualize Twilio data in Power BI.