CData Software - Knowledge Base
Recent Articles
-
Integrating Codex with Raisers Edge NXT 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.
-
How to Connect to CouchDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CouchDB data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Discord Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Discord data using standard SQL.
-
Integrating Kiro with Drip 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 Antigravity CLI with Redshift data via CData CLI
Connect Redshift data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Design BIRT Reports on FTP Data
Provide current FTP data to your embedded analytics.
-
Create Datasets from Blackbaud FE NXT in Domo Workbench and Build Visualizations of Blackbaud FE NXT Data in Domo
Use the CData Software ODBC Driver for Blackbaud FE NXT to create datasets from Blackbaud FE NXT data in Domo Workbench and then build visualizations in the Domo service.
-
Enable the ZohoMarketingHub JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoMarketingHub data.
-
Query Zuora Data in DataGrip
Create a Data Source for Zuora in DataGrip and use SQL to query live Zuora data.
-
Integrate Live Gong 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 Gong data from within the IDE.
-
ETL PDFMonkey in Oracle Data Integrator
This article shows how to transfer PDFMonkey data into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Blackbaud FE NXT Data in QlikView over ODBC
Create data visualizations with Blackbaud FE NXT data in QlikView.
-
Migrating data from Salesforce Pardot to Databricks using CData SSIS Components.
Easily push Salesforce Pardot data to Databricks using the CData SSIS Tasks for Salesforce Pardot and Databricks.
-
Create Microsoft OneDrive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft OneDrive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Gumloop with QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on QuickBooks Online data within automated workflows.
-
Import and Visualize Excel Online Data in Power View
Create data visualizations based on Excel Online data in Excel.
-
Use the CData ODBC Driver for Avro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avro to connect to Avro data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Avro data in Excel.
-
Replicate Multiple SAS xpt Accounts
Replicate multiple SAS xpt accounts to one or many databases.
-
DataBind Controls to MarkLogic Data in Delphi
DataBind to MarkLogic data in Delphi with standard data access components and controls.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for eBay
Provide connectivity to eBay data through an SAP BusinessObjects universe.
-
How to Use a Microsoft Access Database to Update Kintone Data in Real Time
Update Kintone data by creating a linked table in Microsoft Access with the CData Kintone ODBC Driver.
-
Add Harvest Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Harvest with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with MongoDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MongoDB data to a JSON file on disk.
-
How to integrate Metabase with SendGrid Data
Use CData Connect AI to connect to live SendGrid data and create an interactive dashboard in Metabase from SendGrid data.
-
How to Query Drip Data in MySQL Workbench
Execute MySQL queries against live Drip data from MySQL Workbench.
-
Connect to Aha! Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aha! as an External Source in Dremio.
-
Analyze Spark Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Spark from Power Pivot. You will use the Table Import Wizard to load Spark data. You can visually build the import query or use any SQL supported by the driver.
-
Extract, Transform, and Load Elorus Data in Informatica PowerCenter
Create a simple Workflow for Elorus data in Informatica PowerCenter.
-
Integrate Cursor with Live ClickUp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ClickUp data from within the editor.
-
Access Live Freshteam Data in Excel 365 Online (Excel for the web)
Connect to Freshteam data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Configure the CData JDBC Driver for Factorial in a Connection Pool in Tomcat
Connect to Factorial data from a connection pool in Tomcat.
-
Connect to Real-Time Amazon Marketplace Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon Marketplace and Dataflow to import and use Amazon Marketplace data in Power Apps.
-
Build OData-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to OData Services from Zoho Analytics and import live OData services.
-
Prepare, Blend, and Analyze Paymo Data in Alteryx Designer (Connect AI)
Build workflows to access live Paymo data for self-service data analytics.
-
Excel Spreadsheet Automation on ShipStation Data with the QUERY Formula
Pull data from ShipStation, automate spreadsheets, and more with the QUERY formula.
-
How to Easily Query Timely Data in OpenOffice Base
Connect to Timely data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Moving Data from Tanda to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Tanda data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Google Calendar Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Calendar data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData ADO.NET Provider for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Elasticsearch Data in TIBCO Spotfire through ADO.NET
Integrate Elasticsearch data into dashboards in TIBCO Spotfire.
-
Build FTP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FTP data and build web apps with connectivity to live FTP data.
-
Build Apps with Live Sage 300 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage 300 data into the Adalo platform and build custom mobile and web applications with real-time Sage 300 data.
-
Use the CData Software JDBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks data in MicroStrategy Web using the CData Software JDBC Driver for Google Tasks.
-
Create SSAS Tabular Models from Mailjet Data
How to build a SQL Server Analysis Service Tabular Model from Mailjet data using CData drivers.
-
Access Live Google Ad Manager Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Ad Manager data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated Workday-Connected Workflows in Zapier
Use CData Connect AI to connect to live Workday data and build automated workflows in Zapier.
-
Automated Continuous Customer.io Replication to MongoDB
Use CData Sync for automated, continuous, customizable Customer.io replication to MongoDB.
-
How to import CSV Data into Apache Solr
Use the CData Software JDBC Driver for CSV in Data Import Handler and create an automated import of CSV data to Apache Solr Enterprise Search platform.
-
Bind Live Tally Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Tally data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect to Live API Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live API data securely in real time.
-
Build Dashboards with Google Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Analytics data in DBxtra.
-
Use the CData Software JDBC Driver for HBase in MicroStrategy
Connect to HBase data in MicroStrategy Developer using the CData Software JDBC Driver for HBase.
-
Integrating LlamaIndex with VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on VWO data in real time.
-
Migrating data from Flowlu to Snowflake using CData SSIS Components.
Easily push Flowlu data to Snowflake using the CData SSIS Tasks for Flowlu and Snowflake.
-
Use Dash to Build to Web Apps on Basecamp Data
Create Python applications that use pandas and Dash to build Basecamp-connected web apps.
-
Visualize SendGrid Data in Sisense
Create an ElastiCube in Sisense app with access to SendGrid data.
-
Feed CouchDB Data into FineReport
How to set CouchDB data as a JDBC data source in FineReport.
-
Build eBay-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for eBay Data and create custom apps in Bubble.
-
Connect to Live Sage 300 Data in MicroStrategy through CData Connect AI
Create a live connection to Sage 300 Data in CData Connect AI and connect to your Sage 300 data from MicroStrategy.
-
Automated Continuous Exa Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Exa replication to PostgreSQL.
-
Design BIRT Reports on Microsoft Dataverse Data
Provide current Microsoft Dataverse data to your embedded analytics.
-
How to import Google Directory Data into Apache Solr
Use the CData Software JDBC Driver for Google Directory in Data Import Handler and create an automated import of Google Directory data to Apache Solr Enterprise Search platform.
-
DataBind Charts to TaxJar Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to TaxJar data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Goose with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Slack data from within the local AI agent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for xBase
Provide connectivity to xBase data through an SAP BusinessObjects universe.
-
Configure the CData JDBC Driver for XML in a Connection Pool in Tomcat
Connect to XML data from a connection pool in Tomcat.
-
Integrate OpenCode with Live ShipStation Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ShipStation data from within your AI coding agent.
-
Automated Continuous Amazon DynamoDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to AlloyDB.
-
Integrating Kiro with TaxJar 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.
-
How to Access FreshBooks Data Using Entity Framework
This article shows how to access FreshBooks data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access MailChimp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MailChimp data from HeidiSQL.
-
Build Samanage Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Samanage data and build visualizations in Tableau.
-
Integrate LibreChat with Live Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Jumpseller data from within the chat interface.
-
How to publish and share RabbitMQ Data dashboards with Tableau Server
The CData ODBC driver for RabbitMQ enables you integrate RabbitMQ data into Tableau dashboards.
-
Query SAP SuccessFactors Data as a MySQL Database in Node.js
Execute MySQL queries against SAP SuccessFactors data from Node.js.
-
Connect to YouTube Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to YouTube Analytics.
-
Integrate with Sendwithus Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sendwithus data in SnapLogic.
-
Enable the Klaviyo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Klaviyo data.
-
Getting Started with the CData Excel Add-In for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics NAV.
-
Oracle SCM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle SCM facts in real time.
-
Connect to Excel Online Data in RapidMiner
Integrate Excel Online data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Pingdom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pingdom to connect to Pingdom data and execute queries in PowerBuilder.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite SuiteAnalytics data replication to Azure Data Lake.
-
Visualize Live SAP BusinessObjects BI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP BusinessObjects BI data.
-
Build Voice Agents in ElevenLabs with access to Live Klipfolio Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Klipfolio data.
-
How to Connect to Live SAP Business One 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 SAP Business One data without replication.
-
Build Charts with Instagram Data in Clear Analytics
Create dynamic charts and perform analytics based on Instagram data in Clear Analytics.
-
Visualize Zendesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zendesk data.
-
Access Live ZohoSubscriptions 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 ZohoSubscriptions data through MCP integration.
-
Connect MailChimp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailChimp data using the CData Python MCP Server.
-
Connect to GitLab Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to GitLab.
-
Use Azure AI Foundry to Talk to Your eBay Data 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 eBay data for you.
-
Access Coinbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coinbase data from HeidiSQL.
-
Connect to FreshBooks Data in Ruby
Connect to FreshBooks data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Teamwork Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Teamwork replication to PostgreSQL.
-
Viewing Onfleet Data in RAD Studio Data Explorer
How to view Onfleet data in RAD Studio Data Explorer using the CData ODBC Driver for Onfleet.
-
Connect to HubSpot in SpagoBI
Create reports featuring live HubSpot data in SpagoBI Studio. Host HubSpot reports on SpagoBI Server.
-
Connect to Qualaroo Data in DBArtisan
Use wizards in DBArtisan to configure Qualaroo data as a data source.
-
How to Query JSON Services in MySQL Workbench
Execute MySQL queries against live JSON services from MySQL Workbench.
-
Automated Continuous Adobe Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Azure SQL Database.