CData Software - Knowledge Base
Recent Articles
-
Add Oracle Financials Cloud Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Financials Cloud with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Guru Data in JReport Designer
Create charts and reports based on Guru data in JReport Designer.
-
How to Connect to Presto Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Presto data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Zuora Replication to Vertica
Use CData Sync for automated, continuous, customizable Zuora replication to Vertica.
-
Use JayDeBeApi to access SQL Server Data in Python
Use standard Python scripting and the development environment of your choice to access live SQL Server data.
-
Integrating Claude Code CLI with HBase 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.
-
Build an OLAP Cube in SSAS from Google Search Results
Establish a connection to Google Search results data from SQL Server Analysis Services, and use the Google Search Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Landbot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Landbot replication to Google Cloud SQL.
-
How to Create Power BI Visual Reports with Real-Time Sage Cloud Accounting Data
Use CData Power BI Connectors to visualize Sage Cloud Accounting data in Power BI.
-
Connect to Aweber Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Aweber to connect to Aweber data and execute queries in PowerBuilder.
-
Automated Continuous MailerLite Replication to SingleStore
Use CData Sync for automated, continuous, customizable MailerLite replication to SingleStore.
-
How to Visualize Bitly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bitly data in Python.
-
How to Connect to Live RSS Feeds 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 RSS feeds without replication.
-
Getting Started with the CData Excel Add-In for ZarMoney
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZarMoney.
-
Integrating Claude Code CLI with Teamgate 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.
-
Integrate Cline with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Analytics data from within your IDE.
-
Build Semantic Layer Views for Aweber Data in APOS Live Data Gateway
Use the CData Connector for Aweber in APOS Live Data Gateway to build Semantic Layer Views for Aweber data.
-
Build Dashboards with HelloSign Data in DBxtra
Create dynamic dashboards and perform analytics based on HelloSign data in DBxtra.
-
Create Datasets from Google Forms in Domo Workbench and Build Visualizations of Google Forms Data in Domo
Use the CData Software ODBC Driver for Google Forms to create datasets from Google Forms data in Domo Workbench and then build visualizations in the Domo service.
-
How to Build an ETL App for Act CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Act CRM data in Python with petl.
-
Create PayPal Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PayPal from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Apps from Dynamics NAV Data in Qlik Sense Cloud
Use CData Connect AI to connect to Dynamics NAV Data and build apps from live Dynamics NAV data in Qlik Sense Cloud.
-
Configure the CData JDBC Driver for Amazon S3 in a Connection Pool in Tomcat
Connect to Amazon S3 data from a connection pool in Tomcat.
-
How to Connect to Live Shortcut Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Shortcut data securely in real time.
-
Connect to Insightly Data in NetBeans
Connect to Insightly data in NetBeans with the data source configuration wizard.
-
Integrating LangChain with Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Odoo data within automated workflows.
-
Access Live Act-On Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act-On data into the statistical analysis tools available in SAS JMP. This article shows how to use Act-On data in the Graph Builder and Query Builder.
-
Connect to ClickTime in SpagoBI
Create reports featuring live ClickTime data in SpagoBI Studio. Host ClickTime reports on SpagoBI Server.
-
Connect to Gumroad Data in HULFT Integrate
Connect to Gumroad as a JDBC data source in HULFT Integrate
-
Query Zoho CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho CRM data from Node.js.
-
Excel Spreadsheet Automation on Perplexity Data with the QUERY Formula
Pull data from Perplexity, automate spreadsheets, and more with the QUERY formula.
-
LINQ to Pipeline CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Pipeline CRM Data Provider.
-
Adobe Experience Manager Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Experience Manager data through CData Connect AI using different applications and tools.
-
Connect to Avaza Data in NetBeans
Connect to Avaza data in NetBeans with the data source configuration wizard.
-
Rapidly Develop Oracle Eloqua Reporting-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 Oracle Eloqua Reporting.
-
Load Instagram Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Instagram data to a database.
-
Analyze ConstantContact Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ConstantContact data and visualize live ConstantContact data in Infragistics Reveal.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connector for Trello in APOS Live Data Gateway to build Semantic Layer Views for Trello data.
-
Getting Started with the CData SSIS Components for CSV
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CSV.
-
Load Certinia Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Certinia data to a database.
-
How to Connect Tally Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Tally data in real time using natural language.
-
Automate eBay Data Replication to Couchbase
Use CData Sync to Customize and automate eBay data replication to Couchbase.
-
Automated Continuous Apollo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Apollo replication to Amazon S3.
-
Integrating Power BI XMLA Data in Talend Cloud Data Management Platform
Connect Power BI XMLA Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Power BI XMLA.
-
Import Real-Time Eventbrite Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Eventbrite data in ColdFusion.
-
Analyze RabbitMQ Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for RabbitMQ from Power Pivot. You will use the Table Import Wizard to load RabbitMQ data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous LinkedIn Replication to Vertica
Use CData Sync for automated, continuous, customizable LinkedIn replication to Vertica.
-
How to Create Power BI Visual Reports with Real-Time DocuSign Data
Use CData Power BI Connectors to visualize DocuSign data in Power BI.
-
Connect to LinkedIn Ads Data from a Connection Pool in JBoss
Integrate LinkedIn Ads data into Java servlets: Use the Management Console in JBoss to install the LinkedIn Ads JDBC Driver.
-
Connect to Live Salesforce Data 360 Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce Data 360 Data in CData Connect AI and connect to your Salesforce Data 360 data from MicroStrategy.
-
Build Semantic Layer Views for ShipStation Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ShipStation data.
-
Process & Analyze Teradata Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Teradata Data.
-
Connect and Visualize Live Amazon DynamoDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon DynamoDB data into the Databricks platform and create visualization dashboards with real-time Amazon DynamoDB data.
-
Build Visualizations of Dynamics NAV Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics NAV data in Birst.
-
Getting Started with the CData JDBC Driver for Adobe Target
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Target.
-
Build Visualizations of ZohoDesk Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoDesk data in Birst.
-
Use the CData Software JDBC Driver for REST in MicroStrategy Web
Connect to REST data in MicroStrategy Web using the CData Software JDBC Driver for REST.
-
Migrating data from QuickBooks to Databricks using CData SSIS Components.
Easily push QuickBooks data to Databricks using the CData SSIS Tasks for QuickBooks and Databricks.
-
Integrate Open WebUI with Live Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Pinterest data from within the chat interface.
-
Connect to Pipedrive Data from a Connection Pool in Jetty
The Pipedrive JDBC Driver supports connection pooling: This article shows how to connect faster to Pipedrive data from Web apps in Jetty.
-
Analyze Kintone Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Kintone data and visualize Kintone data in SAP Analytics Cloud.
-
Build Apps with Live Reply.io Data Using the Low-Code Development Platform of Mendix
Connect Reply.io data with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze SAP SuccessFactors LMS Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP SuccessFactors LMS data and visualize live SAP SuccessFactors LMS data in Infragistics Reveal.
-
Connect to Adobe Analytics Data from a Connection Pool in Jetty
The Adobe Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Analytics data from Web apps in Jetty.
-
Integrating Gumloop with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on OData services within automated workflows.
-
Connect to ZeroBounce Data in JRuby
Create a simple JRuby app with access to live ZeroBounce data.
-
Connect to Real-Time Flowlu Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Flowlu data in Power Apps.
-
Extract, Transform, and Load CouchDB Data in Informatica PowerCenter
Create a simple Workflow for CouchDB data in Informatica PowerCenter.
-
How to connect Amazon QuickSight to SAP SuccessFactors Data
Create a connection to SAP SuccessFactors data in CData Connect AI and insert SAP SuccessFactors data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple MarkLogic Accounts
Replicate multiple MarkLogic accounts to one or many databases.
-
How to Query Zoom Data in MySQL Workbench
Execute MySQL queries against live Zoom data from MySQL Workbench.
-
Visualize ZeroBounce 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 ZeroBounce data into TIBCO Spotfire.
-
Integrate Live Airtable Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Airtable data to Blue Prism using the CData ODBC Driver for Airtable to create automated workflows for repetitive business tasks.
-
Integrating OpenCode with ZohoSubscriptions 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.
-
Integrating LangGraph with Azure Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Analysis Services data within automated workflows.
-
Replicate Cvent Data to Multiple Databases
Replicate Cvent data to disparate databases with a point-and-click configuration.
-
Import WooCommerce Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to WooCommerce Data and provide access to live WooCommerce data for custom reports in the Power BI Service.
-
How to Connect to Live Discord 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 Discord data without replication.
-
Use JayDeBeApi to access Couchbase Data in Python
Use standard Python scripting and the development environment of your choice to access live Couchbase data.
-
Visualize SpaceX Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SpaceX data.
-
Build Bullhorn CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Bullhorn CRM data and build visualizations in Tableau Cloud.
-
Connect to Oracle Eloqua Data from a Connection Pool in JBoss
Integrate Oracle Eloqua data into Java servlets: Use the Management Console in JBoss to install the Oracle Eloqua JDBC Driver.
-
Automate Gong Data Replication to SAP HANA
Use CData Sync to customize and automate Gong data replication to SAP HANA.
-
Publish Clari-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clari data.
-
Automated Continuous Pipeline CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Google BigQuery.
-
Connect to SingleStore Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SingleStore data in the Denodo Virtual DataPort Administrator.
-
Integrate HubSpot Data in the Pentaho Report Designer
Publish reports based on HubSpot data in the Pentaho BI tool.
-
Replicate Acumatica Data in Heroku for Use in Salesforce Connect
Replicate Acumatica data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Google Campaign Manager 360 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Campaign Manager 360 data from Filemaker Pro on Mac.
-
Access Live Smartsheet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Smartsheet data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Validate Amazon S3 Data with QuerySurge
Access and validate Amazon S3 data in QuerySurge using the CData JDBC Driver.
-
Connect to PolarTeamPro Data in RapidMiner
Integrate PolarTeamPro data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Oracle Service Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Service Cloud and the Script function in FileMaker Pro to connect to Oracle Service Cloud and work with Oracle Service Cloud data in your FileMaker application.
-
Connect to Live ZohoExpense Data in MicroStrategy through CData Connect AI
Create a live connection to ZohoExpense Data in CData Connect AI and connect to your ZohoExpense data from MicroStrategy.
-
Use CData Connect AI to Access Act-On Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Act-On data in the Power Pivot business intelligence tool.
-
How to Query Suadeo Data in MySQL Workbench
Execute MySQL queries against live Suadeo data from MySQL Workbench.
-
Integrating OpenCode with Google Contacts 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.
-
Integrating OpenCode with Gorgias 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 Stack Exchange Data in NetBeans
Connect to Stack Exchange data in NetBeans with the data source configuration wizard.
-
Connect to Dotmailer Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dotmailer to connect to Dotmailer data and execute queries in PowerBuilder.