CData Software - Knowledge Base
Recent Articles
-
Create Power BI Reports on Real-Time Perplexity Data
Use the CData ODBC Driver for Perplexity to visualize Perplexity data in Power BI Desktop.
-
How to integrate Sybase IQ with Apache Airflow
Access and process Sybase IQ data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Elasticsearch 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 Elasticsearch data for you.
-
Automated Continuous Authorize.Net Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google BigQuery.
-
Integrate LibreChat with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zoho CRM data from within the chat interface.
-
Prepare, Blend, and Analyze WordPress Data in Alteryx Designer (ODBC)
Build workflows to access live WordPress data for self-service data analytics.
-
Working with ZendeskSell Data in LINQPad
Execute LINQ queries to ZendeskSell data in LINQPad.
-
Connect to Miro Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Miro and the SQL Gateway to access Miro data from Google Apps Script.
-
Visualize Live Sage 200 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage 200 data into custom reports in Power BI.
-
Access Timely 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 Timely data.
-
Connect to Kintone Data in Jaspersoft Studio
Execute SQL to remote Kintone data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailerSend
Provide connectivity to MailerSend data through an SAP BusinessObjects universe.
-
How to Visualize ClickUp Data in Python with pandas
Use pandas and other modules to analyze and visualize live ClickUp data in Python.
-
Integrate Open WebUI with Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live eBay Analytics data from within the chat interface.
-
Build AI/ML Models with Live Asana Data using Dataiku
Connect Asana Data with Dataiku using the CData JDBC Driver for Asana.
-
Connect to Paylocity Data from HeidiSQL
Use CData Connect AI to connect to and query live Paylocity data from HeidiSQL.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy
Connect to Demio data in MicroStrategy Developer using the CData Software JDBC Driver for Demio.
-
Automated Continuous SAP Netweaver Gateway Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to SQL Server.
-
Automated Continuous PDFMonkey Replication to Databricks
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Databricks.
-
Automated Continuous Printful Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Printful replication to PostgreSQL.
-
How to connect to Shortcut Data from Spring Boot
Connect to Shortcut in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Oracle HCM Cloud Data into Power Automate Desktop using CData Connect
CData Connect for Oracle HCM Cloud Data enables you to integrate Oracle HCM Cloud data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Flowlu Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Flowlu replication to Google Cloud SQL.
-
Analyze Google Analytics Data in Looker
Use CData Connect AI to connect to Google Analytics Data from Looker and build custom apps using live Google Analytics data.
-
Connect to Superchat Data from a Connection Pool in Jetty
The Superchat JDBC Driver supports connection pooling: This article shows how to connect faster to Superchat data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Scrapfly in MicroStrategy Web
Connect to Scrapfly data in MicroStrategy Web using the CData Software ODBC Driver for Scrapfly.
-
Connect to Mailgun Data in RazorSQL
Connect to Mailgun from wizards and query Mailgun data from the GUI in the RazorSQL database management tool.
-
Connect to Act CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Act CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData Connect AI Python SDK for Adobe Target
Install the CData Connect AI Python SDK to read live Adobe Target data with standard DB-API 2.0 Python code.
-
Connect to Xero from a Connection Pool in WebLogic
Use the CData JDBC Driver for Xero to connect to Xero data from Web applications running on WebLogic.
-
Access Live Grafana Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Grafana data from your Excel spreadsheets.
-
Connect to Highrise Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Highrise.
-
How to Connect to & Open Amazon Athena Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon Athena to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Sage 200 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage 200 data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Factorial Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Factorial replication to IBM DB2.
-
Create Dynamic GetResponse Grids Using the Infragistics XamDataGrid
Learn how you can connect GetResponse to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Postmark Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Postmark data in ColdFusion.
-
Connect to CockroachDB Data in RazorSQL
Connect to CockroachDB from wizards and query CockroachDB data from the GUI in the RazorSQL database management tool.
-
Query Live Twilio Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Twilio data directly from the development environment.
-
Getting Started with the CData ADO.NET Provider for AlloyDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for AlloyDB.
-
Use CData Connect AI to Access RSS Feeds in Microsoft Power Pivot
Use CData Connect AI to connect to live RSS feeds in the Power Pivot business intelligence tool.
-
Connect to Facebook Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Facebook Ads data in the Denodo Virtual DataPort Administrator.
-
Replicate DocuSign Data in Heroku for Use in Salesforce Connect
Replicate DocuSign data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Everhour Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Everhour data with the CData JDBC Driver for Everhour.
-
Automated Continuous SurveyMonkey Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Azure SQL Database.
-
Connect to Highrise Data in ACL Analytics
Connect to Highrise data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Highrise data.
-
How to Seamlessly Import IBM Cloud Object Storage Data into IBM SPSS Modeler
Integrate IBM Cloud Object Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Claude to Talk to Your Adobe Target 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 Adobe Target data for you.
-
Integrate Dify with Live Bitly 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 Bitly data.
-
How to integrate Metabase with SAP BusinessObjects BI Data
Use CData Connect AI to connect to live SAP BusinessObjects BI data and create an interactive dashboard in Metabase from SAP BusinessObjects BI data.
-
Automated Continuous DocuSign Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable DocuSign replication to PostgreSQL.
-
Automated Continuous Templated Replication to SQL Server
Use CData Sync for automated, continuous, customizable Templated replication to SQL Server.
-
Object-Relational Mapping (ORM) with Google Spanner 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 Google Spanner data into a Java-based ORM framework, Hibernate.
-
Access Live Bullhorn CRM Data in Coginiti Pro
Connect to and query live Bullhorn CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Front 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 Front data into TIBCO Spotfire.
-
How to Create Power BI Visual Reports with Real-Time Printful Data
Use CData Power BI Connectors to visualize Printful data in Power BI.
-
Getting Started with the CData Power BI Connector for Sage Intacct
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Intacct.
-
Rapidly Develop Mocean-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Mocean.
-
Use Dash to Build Web Apps on Azure Synapse Data via CData Connect AI
Build interactive Dash web apps on live Azure Synapse data using pandas and the CData Connect AI Python SDK.
-
Connect to Airtable Data from HeidiSQL
Use CData Connect AI to connect to and query live Airtable data from HeidiSQL.
-
How to Visualize AlloyDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live AlloyDB data in Python.
-
Use Agno to Talk to Your Dropbox 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 Dropbox data for you.
-
Connect to Microsoft Ads in SpagoBI
Create reports featuring live Microsoft Ads data in SpagoBI Studio. Host Microsoft Ads reports on SpagoBI Server.
-
Automated Continuous LightSpeedRetail Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Amazon Redshift.
-
Build AI Agents with Notion Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Notion data through CData Connect AI.
-
Query IBM Informix Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Informix data from Node.js.
-
How to connect PolyBase to Marketo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Marketo data.
-
Integrating Cursor with Google 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 JayDeBeApi to access AfterShip Data in Python
Use standard Python scripting and the development environment of your choice to access live AfterShip data.
-
Connect to BigCommerce Data in RazorSQL
Connect to BigCommerce from wizards and query BigCommerce data from the GUI in the RazorSQL database management tool.
-
How to integrate Dynamics 365 with Apache Airflow
Access and process Dynamics 365 data in Apache Airflow using the CData JDBC Driver.
-
Integrate Stripe Data into Power Automate Desktop using CData Connect
CData Connect for Stripe Data enables you to integrate Stripe data into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize Freshteam Data in Power View
Create data visualizations based on Freshteam data in Excel.
-
Integrating Dataiku with Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Vault CRM data.
-
Automated Continuous Act-On Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Act-On replication to Apache Cassandra.
-
Build AI Agents with MarkLogic Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live MarkLogic data through CData Connect AI.
-
Integrate with live Gong Data in Jitterbit
Use CData Connect AI to connect to and integrate live Gong data in Jitterbit.
-
Use JayDeBeApi to access Neo4J Data in Python
Use standard Python scripting and the development environment of your choice to access live Neo4J data.
-
Query Spark Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Spark data from Node.js.
-
Moving Data from SageHR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SageHR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream Zoom Data into Apache Kafka Topics
Access and stream Zoom data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData ODBC Driver for Simplesat
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Simplesat.
-
Visualize Live HubDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HubDB data into custom reports in Power BI.
-
Replicate Airtable Data from PowerShell
Write a quick PowerShell script to query Airtable data. Use connectivity to the live data to replicate Airtable data to SQL Server.
-
Access Live Amazon Marketplace Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon Marketplace data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Chargebee Data in Coginiti Pro
Connect to and query live Chargebee data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Chargebee Reporting in OBIEE with the Chargebee JDBC Driver
Deploy the Chargebee JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zoho Projects Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Projects data in Google Apps Script.
-
Integrating OpenCode with Coda 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 Sage 300 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to Google Cloud SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Dropbox
Create an ODBC connection to Dropbox in Informatica and browse and transfer Dropbox data.
-
Integrating Azure Data Lake Storage Data in Talend Cloud Data Management Platform
Connect Azure Data Lake Storage Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Data Lake Storage.
-
Connect to Freshdesk from Asprova with CData Software ODBC Driver for Freshdesk
This article shows how to connect faster to Freshdesk data from Asprova.
-
Connect to Live Teradata Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Teradata in CData Connect AI and connect to your Teradata data from PostgreSQL.
-
DataBind Front Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Front data to a chart.
-
How to work with Mocean Data in Apache Spark using SQL
Access and process Mocean Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Sage 300 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sage 300 data with the CData JDBC Driver for Sage 300.
-
Access SAP Ariba Procurement Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Procurement data from HeidiSQL.
-
Visualize Live Power BI XMLA Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Power BI XMLA data into custom reports in Power BI.
-
How to create an RPA flow for ZohoExpense Data in UiPath Studio
Use the ZohoExpense ODBC Driver to create workflows that access real-time ZohoExpense data without any coding.