CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live DocuSign Data in Geckoboard
Use CData Connect AI to connect to live DocuSign data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Pingdom Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pingdom and the SQL Gateway to access Pingdom data from Google Apps Script.
-
Integrate OpenCode with Live Zoho Creator Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoho Creator data from within your AI coding agent.
-
Excel Spreadsheet Automation on RSS Feeds with the QUERY Formula
Pull data from RSS, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Planner
Create an ODBC connection to Microsoft Planner in Informatica and browse and transfer Microsoft Planner data.
-
Connect to Salesforce Data 360 Data from a Connection Pool in Jetty
The Salesforce Data 360 JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Data 360 data from Web apps in Jetty.
-
Connect to Mailgun Data from Crystal Reports
Use CData Connect AI to connect to and report on live Mailgun data from Crystal Reports.
-
Automated Continuous Neo4J Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Neo4J replication to Azure SQL Database.
-
Connect to Bullhorn CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Bullhorn CRM data in Google Apps Script.
-
Build Microsoft OneDrive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft OneDrive Data and create custom apps in Mendix.
-
How to connect to Mixpanel Data in DBVisualizer
Integrate Mixpanel data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Salesforce CRM Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce CRM Analytics data from Informatica Cloud.
-
Automated Continuous Zuora Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zuora replication to MongoDB.
-
Analyze Google Calendar Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Calendar from Power Pivot. You will use the Table Import Wizard to load Google Calendar data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze SendInBlue Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SendInBlue data with the CData JDBC Driver for SendInBlue.
-
Connect to Google Contacts Data in CloverDX (formerly CloverETL)
Transfer Google Contacts data using the visual workflow in the CloverDX data integration tool.
-
Connect to Live Gong Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Gong in CData Connect AI and connect to your Gong data from PostgreSQL.
-
Integrate OData Services into Automated Tasks with Power Automate
Use CData Connect AI to connect to OData services and integrate live OData services into your Power Automate tasks.
-
Integrate Google Drive Data into Power Automate Desktop using CData Connect
CData Connect for Google Drive Data enables you to integrate Google Drive data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Google Spanner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Spanner data from Informatica Cloud.
-
Connect to IBM Informix Data in DBeaver
Use the CData ODBC Driver to connect to IBM Informix data in DBeaver.
-
Query ChartMogul Data in ColdFusion
Write standard ColdFusion data access code to connect to ChartMogul data.
-
Integrating OpenCode with Suadeo 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 ServiceDesk Plus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ServiceDesk Plus data with the CData JDBC Driver for ServiceDesk Plus.
-
Connect Azure Data Lake Storage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Data Lake Storage data using the CData Python MCP Server.
-
Automated Procore Data Replication to Teradata
Use CData Sync to Customize and automate Procore data replication to Teradata.
-
Connect to DB2 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for DB2 to connect to DB2 data and execute queries in PowerBuilder.
-
Natively Connect to Presto Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Presto data. Leverage the native support for ODBC in PHP.
-
Integrate Google's Antigravity Agent with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Odoo data using the Model Context Protocol.
-
Create ZohoSubscriptions Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoSubscriptions data access from reports, embedded analytics, and more.
-
Query Tally Data as a SQL Server Database in Node.js
Execute SQL Server queries against Tally data from Node.js.
-
Automated Continuous WordPress Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable WordPress replication to Amazon Redshift.
-
Integrating LangChain with Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shippo data within automated workflows.
-
Automated Continuous Tickspot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Tickspot replication to delimited files (CSV/TSV).
-
Use JayDeBeApi to access FTP Data in Python
Use standard Python scripting and the development environment of your choice to access live FTP data.
-
How to Connect to Power BI XMLA Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Power BI XMLA data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live JSON Services in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JSON services.
-
Connect to Oracle Financials Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Financials Cloud data.
-
Connect to PayPal Data in CloverDX (formerly CloverETL)
Transfer PayPal data using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from Zoho Inventory to SQL Server using SSIS
Easily back up Zoho Inventory data to SQL Server using the SSIS components for Zoho Inventory.
-
Automated Continuous Optimizely Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Optimizely replication to Apache Cassandra.
-
Connect to Certinia Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Certinia and the SQL Gateway to access Certinia data from Google Apps Script.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy Desktop
Connect to Trello data in MicroStrategy Desktop using the CData Software JDBC Driver for Trello.
-
Integrate ClickTime with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickTime with External Services.
-
Build ServiceNow-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ServiceNow Data and create custom apps in Bubble.
-
Access Live Microsoft Entra ID Data in Coginiti Pro
Connect to and query live Microsoft Entra ID data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Adobe Analytics 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 Adobe Analytics data through MCP integration.
-
Automated Continuous Sage Intacct Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage Intacct data replication to OneLake in Microsoft Fabric.
-
Link Asana with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Asana data in Filemaker Pro for Mac or Windows.
-
How to use SQLAlchemy ORM to access Zoho Creator Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Creator data.
-
Bridge Oracle SCM Connectivity with Apache NiFi
Access and process Oracle SCM data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Grafana Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Grafana replication to delimited files (CSV/TSV).
-
Automated Continuous Productboard Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Productboard replication to Apache Kafka.
-
Connecting GenSpark with SAP Business Warehouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business Warehouse data without any replication or custom integration required.
-
Integrating Notion Data in Talend Cloud Data Management Platform
Connect Notion Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to create Visio diagrams from Dynamics CRM Data
Automatically update Dynamics CRM data with the changes you make to Visio master shapes.
-
Integrating GitHub Copilot with Databricks 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.
-
Automated Continuous iContact Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable iContact replication to PostgreSQL.
-
Work with ElevenLabs Data in FoxPro
Load ElevenLabs data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Bitly Data in DBArtisan
Use wizards in DBArtisan to configure Bitly data as a data source.
-
Automated Continuous RabbitMQ Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Google Cloud SQL.
-
Access Live Jira Assets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Jira Assets data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BambooHR
Provide connectivity to BambooHR data through an SAP BusinessObjects universe.
-
Automated Continuous Supabase Replication to MySQL
Use CData Sync for automated, continuous, customizable Supabase replication to MySQL.
-
How to Create Power BI Visual Reports with Real-Time Klaviyo Data
Use CData Power BI Connectors to visualize Klaviyo data in Power BI.
-
How to Access Live SAP Netweaver Gateway Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Netweaver Gateway enables you to integrate SAP Netweaver Gateway data into workflows built using Microsoft Power Automate Desktop.
-
Access SendPulse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SendPulse data from HeidiSQL.
-
Integrating Cursor with Zoho Creator 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 Real-Time ZohoSubscriptions Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoSubscriptions data in Power Apps.
-
Analyze Salesforce Data in Looker
Use CData Connect AI to connect to Salesforce Data from Looker and build custom apps using live Salesforce data.
-
Publish Reports with Vault CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vault CRM data.
-
Connect to ZohoMarketingHub Data in Jaspersoft Studio
Execute SQL to remote ZohoMarketingHub data in Jaspersoft Studio.
-
Build a Singer.io Tap for SAP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP data using the CData Python Connector.
-
Automated Apify Data Replication to Teradata
Use CData Sync to Customize and automate Apify data replication to Teradata.
-
Access Missive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Missive data from your Oracle system.
-
Trigger Instagram IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Instagram with standard wizards in Logic Apps.
-
Connect to Parallel 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 Parallel and work with Parallel data in your FileMaker application.
-
How to Access Live Freshsales Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshsales enables you to integrate Freshsales data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Microsoft Entra ID Data in ACL Analytics
Connect to Microsoft Entra ID data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Entra ID data.
-
Build Automated Workflows with Live Acumatica Data in Workato
Use CData Connect AI to connect to live Acumatica data and build automated workflows in Workato.
-
Build a Singer.io Tap for Short.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Short.io data using the CData Python Connector.
-
Integrating LangChain with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Marketing data within automated workflows.
-
Automated Continuous Facebook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Facebook replication to Amazon Redshift.
-
How to Work with HelloSign Data in AWS Glue Jobs Using JDBC
Connect to HelloSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Link Google Ads with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Ads data in Filemaker Pro for Mac or Windows.
-
Access Live Gumroad Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gumroad data into the statistical analysis tools available in SAS JMP. This article shows how to use Gumroad data in the Graph Builder and Query Builder.
-
Automated Continuous Xero Replication to SQLite
Use CData Sync for automated, continuous, customizable Xero replication to SQLite.
-
Connect to SFTP Data in DBeaver
Use the CData ODBC Driver to connect to SFTP data in DBeaver.
-
Connect to Pipeliner CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipeliner CRM to connect to Pipeliner CRM data from Web applications running on WebLogic.
-
Integrate LibreChat with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesloft data from within the chat interface.
-
Query Adobe Target Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Target entities in PHP by modeling them as objects.
-
Automated Continuous XML Replication to Amazon S3
Use CData Sync for automated, continuous, customizable XML replication to Amazon S3.
-
Integrating GitHub Copilot with Adobe 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.
-
Use CData Connect AI to Access Adobe Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Adobe Analytics data in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy Desktop
Connect to Mouseflow data in MicroStrategy Desktop using the CData Software JDBC Driver for Mouseflow.
-
ETL DocuSign in Oracle Data Integrator
This article shows how to transfer DocuSign data into a data warehouse using Oracle Data Integrator.
-
Access Adobe Experience Manager 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 Adobe Experience Manager data.
-
How to Visualize Mouseflow Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mouseflow data in Python.
-
Integrating Gumloop with Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Presto data within automated workflows.
-
How to Access Microsoft Dataverse Data Using Entity Framework
This article shows how to access Microsoft Dataverse data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.