CData Software - Knowledge Base
Recent Articles
-
Bind Live xBase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live xBase data
-
Use the CData Software JDBC Driver for Bullhorn CRM in MicroStrategy Web
Connect to Bullhorn CRM in MicroStrategy Web using the CData Software JDBC Driver for Bullhorn CRM.
-
Analyze Zuora Data in Looker
Use CData Connect AI to connect to Zuora Data from Looker and build custom apps using live Zuora.
-
How to publish and share Salesloft Data dashboards with Tableau Server
The CData ODBC driver for Salesloft enables you integrate Salesloft into Tableau dashboards.
-
Build an OLAP Cube in SSAS from Power BI XMLA Data
Establish a connection to Power BI XMLA data from SQL Server Analysis Services, and use the Power BI XMLA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Microsoft OneDrive Data in JRuby
Create a simple JRuby app with access to live Microsoft OneDrive.
-
How to Access Live MYOB AccountRight Data in Visual Studio Code via Cline
Run CData MCP Server for MYOB AccountRight on Windows Subsytem for Linux (WSL) and connect to live MYOB AccountRight from the Cline extension in Visual Studio Code.
-
Connect to Auth0 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate Multiple MailChimp Accounts
Replicate multiple MailChimp accounts to one or many databases.
-
Integrating Kiro CLI with TigerGraph 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 xBase Data in RapidMiner
Integrate xBase with standard components and data source configuration wizards in RapidMiner Studio.
-
Process & Analyze eBay Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live eBay Analytics Data.
-
Integrate Cline with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Search from within your IDE.
-
Create Elasticsearch-Connected Nintex Workflows
Use CData Connect AI to connect to Elasticsearch Data from Nintex Workflow Cloud and build custom workflows using live Elasticsearch.
-
Create Reports with Pipeline CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeline CRM.
-
Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.
-
Query Amazon S3 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon S3 from Node.js.
-
Build Dynamics NAV-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics NAV.
-
Create Informatica Mappings From/To an ODBC Data Source for Superchat
Create an ODBC connection to Superchat in Informatica and browse and transfer Superchat.
-
Connect to Live Impala Data in MicroStrategy through CData Connect AI
Create a live connection to Impala Data in CData Connect AI and connect to your Apache Impala from MicroStrategy.
-
Build Dashboards with Simplesat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Simplesat in Dundas BI.
-
Integrating Dataiku with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Fieldglass.
-
Build Data Flows from Access to SQL Server using SSIS
Easily back up Microsoft Access to SQL Server using the SSIS components for Access.
-
Connect to Clio from Asprova with CData Software ODBC Driver for Clio
This article shows how to connect faster to Clio data from Asprova.
-
Connect to Testmonitor Data in DBeaver
Use the CData ODBC Driver to connect to Testmonitor in DBeaver.
-
Connect to Salesforce Marketing Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Marketing Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Explore Geographical Relationships in Zoho CRM Data with Power Map
Create data visualizations with Zoho CRM in Power Map.
-
How to connect PolyBase to Calendly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Calendly.
-
Automated Continuous Freshteam Replication to Vertica
Use CData Sync for automated, continuous, customizable Freshteam replication to Vertica.
-
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.
-
Build AI/ML Models with Live Billsby Data using Dataiku
Connect Billsby Data with Dataiku using the CData API Driver for JDBC.
-
Access Live GitHub Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitHub from your Excel spreadsheets.
-
Getting Started with the CData Python Connector for Trello
Learn to install and license the CData Python Connector
-
Replicate Impala Data to Multiple Databases
Replicate Apache Impala to disparate databases with a point-and-click configuration.
-
How to Create Power BI Visual Reports with Real-Time Twilio Data
Use CData Power BI Connectors to visualize Twilio in Power BI.
-
Visualize Oracle Eloqua Reporting Data in TIBCO Spotfire through ADO.NET
Integrate Oracle Eloqua Reporting into dashboards in TIBCO Spotfire.
-
How to create HubSpot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HubSpot in MySQL .
-
Automated Continuous AfterShip Replication to SQLite
Use CData Sync for automated, continuous, customizable AfterShip replication to SQLite.
-
How to Connect to & Open Hubstaff Data in Microsoft Excel
This article uses the CData ODBC driver for Hubstaff to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Agno to Talk to Your WordPress 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 WordPress for you.
-
Configure the CData JDBC Driver for PingOne in a Connection Pool in Tomcat
Connect to PingOne from a connection pool in Tomcat.
-
Use the CData Software JDBC Driver for Delighted in MicroStrategy Desktop
Connect to Delighted in MicroStrategy Desktop using the CData Software JDBC Driver for Delighted.
-
Connect to JDBC-ODBC Bridge in SpagoBI
Create reports featuring live JDBC-ODBC Bridge in SpagoBI Studio. Host JDBC-ODBC Bridge reports on SpagoBI Server.
-
Integrating OpenCode Terminal with Qualaroo 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 AI Agents with Power BI XMLA 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 Power BI XMLA through CData Connect AI.
-
Build ServiceNow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ServiceNow.
-
Visualize Live Excel Online Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Excel Online into custom reports in Power BI.
-
Build Email-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Email Data and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest in MicroStrategy Desktop using the CData Software JDBC Driver for Harvest.
-
Integrating Claude Code with Google Search Results via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Search within assisted coding and automated development workflows.
-
Oracle Eloqua Reporting Reporting in OBIEE with the Oracle Eloqua Reporting JDBC Driver
Deploy the Oracle Eloqua Reporting JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Metabase with Adobe Analytics Data
Use CData Connect AI to connect to live Adobe Analytics and create an interactive dashboard in Metabase from Adobe Analytics.
-
Connect to Tally Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tally ERP using standard SQL.
-
How to integrate eBay Analytics with Apache Airflow
Access and process eBay Analytics in Apache Airflow using the CData JDBC Driver.
-
Integrating OpenCode Terminal with Shippo 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.
-
Import Real-Time Adobe Experience Manager Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Experience Manager in ColdFusion.
-
Connect to Teamgate Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Teamgate and the SQL Gateway to access Teamgate from Google Apps Script.
-
Automate Typeform Data Replication to Couchbase
Use CData Sync to Customize and automate Typeform replication to Couchbase.
-
Object-Relational Mapping (ORM) with Workday 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 Workday into a Java-based ORM framework, Hibernate.
-
Integrate with Live EnterpriseDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to EnterpriseDB from the MuleSoft Anypoint Platform to integrate live EnterpriseDB into custom reports and dashboards.
-
Connect to Hacker News Data in RapidMiner
Integrate Hacker News with standard components and data source configuration wizards in RapidMiner Studio.
-
Process & Analyze Auth0 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Auth0 Data.
-
Connect to and Visualize Live Gong Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gong.
-
Establish a Live Connection with Attio Data using Tableau Bridge
The CData ODBC Driver for Attio enables you to integrate live Attio into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Grok to Talk to Your Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Spanner for you.
-
Access Cloudflare Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cloudflare from your Oracle system.
-
Connect to Brex Data from a Connection Pool in Jetty
The Brex JDBC Driver supports connection pooling: This article shows how to connect faster to Brex from Web apps in Jetty.
-
Build Voice Agents in ElevenLabs with access to Live Google Analytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Analytics.
-
Rapidly Develop Samanage-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 Samanage.
-
Integrate Open WebUI with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Monday.com from within the chat interface.
-
Analyze Microsoft Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Ads from Power Pivot. You will use the Table Import Wizard to load Microsoft Ads. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for HelloSign
Provide connectivity to HelloSign through an SAP BusinessObjects universe.
-
Integrate with Klipfolio Data in JReport Designer
Create charts and reports based on Klipfolio in JReport Designer.
-
Visualize Live Power BI XMLA Data in the Power BI Service
Use CData Connect AI to connect to live Power BI XMLA and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Bitly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate Gong Data from PowerShell
Write a quick PowerShell script to query Gong. Use connectivity to the live data to replicate Gong to SQL Server.
-
Bidirectional Access to Mode Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mode in Filemaker Pro for Mac or Windows.
-
Connect to Instagram Data from Crystal Reports
Use CData Connect AI to connect to and report on live Instagram from Crystal Reports.
-
How to Query Live RabbitMQ Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live RabbitMQ data in natural language using Python.
-
How to Create Power BI Visual Reports with Real-Time Discord Data
Use CData Power BI Connectors to visualize Discord in Power BI.
-
Jodoo Reporting in OBIEE with the Jodoo JDBC Driver
Deploy the Jodoo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData API Server to Access Raisers Edge NXT Data in Microsoft PowerPivot
Use the CData API Server to connect to live Raisers Edge NXT in the Power Pivot business intelligence tool.
-
Replicate Microsoft Dataverse Data to Multiple Databases
Replicate Microsoft Dataverse (CDS) to disparate databases with a point-and-click configuration.
-
Use Azure AI Foundry to Talk to Your Google Search Results 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 Google Search for you.
-
Integrate Cursor with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Hive from within the editor.
-
Integrate Customer.io Data in Pentaho Data Integration
Build ETL pipelines based on Customer.io in the Pentaho Data Integration tool.
-
Migrating data from Delighted to Snowflake using CData SSIS Components.
Easily push Delighted to Snowflake using the CData SSIS Tasks for Delighted and Snowflake.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM for you.
-
Consume IBM Cloud Object Storage OData Feeds in PowerBuilder
This article demonstrates how to consume IBM Cloud Object Storage as OData feeds from PowerBuilder using the API Server.
-
Analyze SAP Concur Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Concur from Power Pivot. You will use the Table Import Wizard to load SAP Concur. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData SSIS Components for XML
Complete guide to installing, licensing, and connecting with the CData SSIS Components for XML.
-
Configuring Oracle Autonomous Database as a CData Sync Destination
A basic guide to configuring Oracle Autonomous Database as a destination for enterprise replication in CData Sync.
-
Access Snapchat Ads Data from MySQL in PHP
Connect to Snapchat Ads through the standard MySQL libraries in PHP.
-
Access Live SendInBlue Data in Coginiti Pro
Connect to and query live SendInBlue from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Deploy the ADO.NET Provider for Odoo on an SSRS Report Server
Connect to Odoo ERP 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.
-
Connect to Intercom Data from PowerBuilder via ADO.NET
This article demonstrates how to access Intercom from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Hacker News Data in HULFT Integrate
Connect to Hacker News as a JDBC data source in HULFT Integrate
-
Access Live Redshift Data in Excel 365 Online (Excel for the web)
Connect to Amazon Redshift from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache Avro using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Desktop
Connect to Pipedrive in MicroStrategy Desktop using the CData Software ODBC Driver for Pipedrive.