CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Superchat Data in Informatica PowerCenter
Create a simple Workflow for Superchat in Informatica PowerCenter.
-
Access Live Shopify Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Shopify through MCP integration.
-
How to connect Amazon QuickSight to QuickBooks Online Data
Create a connection to QuickBooks Online in CData Connect AI and insert QuickBooks Online into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software JDBC Driver for Dotmailer in MicroStrategy Web
Connect to Dotmailer in MicroStrategy Web using the CData Software JDBC Driver for Dotmailer.
-
Automated Continuous MailChimp Replication to SingleStore
Use CData Sync for automated, continuous, customizable MailChimp replication to SingleStore.
-
Build MVC Applications with Connectivity to ConvertKit Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ConvertKit from an ASP.NET MVC application.
-
Connecting Mastra with Adobe Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Adobe Analytics, no replication required.
-
Connect to XML Data in JRuby
Create a simple JRuby app with access to live XML Files.
-
Build Semantic Layer Views for Invoiced Data in APOS Live Data Gateway
Use the CData Connector for Invoiced in APOS Live Data Gateway to build Semantic Layer Views for Invoiced.
-
Integrate with SAP SuccessFactors LMS Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP SuccessFactors LMS in SnapLogic.
-
Provide OData Services of Pinecone Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Pinecone by developing a WCF Service Application.
-
Publish Box-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Box.
-
Create Cohere Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cohere data access from reports, embedded analytics, and more.
-
Build MongoDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MongoDB and build MongoDB-connected web apps with Axios.
-
How to work with Salesforce Data 360 Data in Apache Spark using SQL
Access and process Salesforce Data 360 Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for CouchDB in MicroStrategy Web
Connect to Apache CouchDB in MicroStrategy Web using the CData Software ODBC Driver for CouchDB.
-
Connect to RabbitMQ Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to RabbitMQ and work with RabbitMQ in your FileMaker applications.
-
A PostgreSQL Interface for Asana Data (MySQL Remoting via JDBC)
Use the Remoting features of the Asana JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with CouchDB Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache CouchDB in DBxtra.
-
How to connect to Power BI XMLA Data in DBVisualizer
Integrate Power BI XMLA with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Query Live Azure DevOps Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure DevOps data in natural language using Python.
-
Connect to Contentful Data in DBeaver
Use the CData ODBC Driver to connect to Contentful in DBeaver.
-
Process & Analyze Webex Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Webex Data.
-
Connect to Couchbase Data in Aqua Data Studio
Access Couchbase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce Pardot for you.
-
Natively Connect to Foursquare Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Foursquare. Leverage the native support for ODBC in PHP.
-
Query Salesforce Data 360 Data as a MySQL Database in Node.js
Execute MySQL queries against Salesforce Data 360 from Node.js.
-
DataBind Charts to Oracle Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Database 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.
-
Stream SAP ByDesign Data into Apache Kafka Topics
Access and stream SAP Business ByDesign in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous ZohoDesk Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoDesk replication to SingleStore.
-
Create Datasets from AlloyDB in Domo Workbench and Build Visualizations of AlloyDB Data in Domo
Use the CData Software ODBC Driver for AlloyDB to create datasets from Google AlloyDB in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Cursor CLI with Jumpseller 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.
-
Bidirectional Access to Google Ad Manager Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Ad Manager in Filemaker Pro for Mac or Windows.
-
Operational Reporting on PagerDuty Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PagerDuty.
-
Build MVC Applications with Connectivity to Helpscout Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Helpscout from an ASP.NET MVC application.
-
Migrating data from SAS Data Sets to Databricks using CData SSIS Components.
Easily push SAS Data Sets to Databricks using the CData SSIS Tasks for SAS Data Sets and Databricks.
-
How to Access Live Raisers Edge NXT Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Raisers Edge NXT enables you to integrate Raisers Edge NXT into workflows built using Microsoft Power Automate Desktop.
-
Connect to Timely Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Timely and work with Timely in your FileMaker applications.
-
Build Asana-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Asana to explore live Asana Data in Cursor to assist with building Asana-powered applications.
-
Work with Microsoft OneDrive Data in FoxPro
Load Microsoft OneDrive into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to work with Microsoft Entra ID Data in Apache Spark using SQL
Access and process Microsoft Entra ID Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to BambooHR Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BambooHR from Filemaker Pro on Mac.
-
Build MVC Applications with Connectivity to ServiceDesk Plus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ServiceDesk Plus from an ASP.NET MVC application.
-
How to Create Power BI Visual Reports with Real-Time Dynamics CRM Data
Use CData Power BI Connectors to visualize Microsoft Dynamics CRM in Power BI.
-
Build Dashboards with ServiceDesk Plus Data in DBxtra
Create dynamic dashboards and perform analytics based on ServiceDesk Plus in DBxtra.
-
Use the CData Software JDBC Driver for Retently in MicroStrategy Web
Connect to Retently in MicroStrategy Web using the CData Software JDBC Driver for Retently.
-
Build a PostgreSQL Interface for Guru Data using the CData JDBC Driver
Use the Remoting features of the Guru JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Office 365 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Office 365 replication to PostgreSQL.
-
Getting Started with the CData JDBC Driver for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Business Warehouse.
-
Use Microsoft Copilot Studio to talk to your YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your YouTube Analytics for you.
-
Build LinkedIn-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for LinkedIn to explore live LinkedIn Data in Claude Code to assist with building LinkedIn-powered applications.
-
How to Seamlessly Import Landbot Data into IBM SPSS Modeler
Integrate Landbot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Acumatica Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Excel spreadsheets.
-
Enable the Superchat JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Superchat.
-
Create Reports from Gmail Data in Looker Studio
Use CData Connect AI to gain access to live Gmail and create custom reports in Looker Studio.
-
Process & Analyze SQL Analysis Services Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SQL Analysis Services Data.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoInvoice
Create an ODBC connection to ZohoInvoice in Informatica and browse and transfer ZohoInvoice.
-
Integrate Elasticsearch with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Elasticsearch with External Services.
-
Connecting Agentforce with Paylocity Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Paylocity for you.
-
How to load Instagram data into Elasticsearch via Logstash
Introducing a simple method to load Instagram data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData SSIS Components for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Hybris C4C.
-
How to Easily Query IBM Cloud Object Storage Data in OpenOffice Base
Connect to IBM Cloud Object Storage data in OpenOffice Base using the CData ODBC Driver for IBM Cloud Object Storage and generate reports with live data insights.
-
Migrating data from PostgreSQL to Google BigQuery using CData SSIS Components.
Easily push PostgreSQL to Google BigQuery using the CData SSIS Tasks for PostgreSQL and Google BigQuery.
-
How to Work with ConvertKit Data in ETL Validator JDBC
Connect to ConvertKit from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Import Data from Active Directory into Google Sheets
Import Active Directory into a Google spreadsheet that is automatically refreshed.
-
Creating Microsoft Teams-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Teams to Unqork and build custom business apps.
-
Connect to SAS Data Sets Data in RazorSQL
Connect to SAS Data Sets from wizards and query SAS Data Sets from the GUI in the RazorSQL database management tool.
-
Use Microsoft Copilot Studio to talk to your Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Dataverse (CDS) for you.
-
Integrating Cursor CLI with SingleStore 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.
-
Replicate Zendesk Data from PowerShell
Write a quick PowerShell script to query Zendesk. Use connectivity to the live data to replicate Zendesk to SQL Server.
-
Integrate with Live Box Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Box from the MuleSoft Anypoint Platform to integrate live Box into custom reports and dashboards.
-
Connect to LightSpeedRetail Data from a Connection Pool in Jetty
The LightSpeedRetail JDBC Driver supports connection pooling: This article shows how to connect faster to LightSpeedRetail from Web apps in Jetty.
-
How to Work with SFTP Data in ETL Validator JDBC
Connect to SFTP from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Parallel Data in ColdFusion
Write standard ColdFusion data access code to connect to Parallel.
-
Connect to Coda Data from a Connection Pool in JBoss
Integrate Coda into Java servlets: Use the Management Console in JBoss to install the Coda JDBC Driver.
-
Connect to AdRoll Data in Jaspersoft Studio
Execute SQL to remote AdRoll in Jaspersoft Studio.
-
How to use SQLAlchemy ORM to access xBase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of xBase.
-
Query Sentry Data in ColdFusion
Write standard ColdFusion data access code to connect to Sentry.
-
Connect Access to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Access using the CData Python MCP Server.
-
Connect to MarkLogic Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Live Box Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Visualize Sage Cloud Accounting Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Business Cloud Accounting.
-
Create Datasets from Access in Domo Workbench and Build Visualizations of Access Data in Domo
Use the CData Software ODBC Driver for Access to create datasets from Microsoft Access in Domo Workbench and then build visualizations in the Domo service.
-
Use CData Connect AI to Access YouTube Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live YouTube Analytics in the Power Pivot business intelligence tool.
-
How to import Cvent Data into Apache Solr
Use the CData Software JDBC Driver for Cvent in Data Import Handler and create an automated import of Cvent to Apache Solr Enterprise Search platform.
-
Create a Data Access Object for Blackbaud FE NXT Data using JDBI
A brief overview of creating a SQL Object API for Blackbaud FE NXT in JDBI.
-
Work with Oracle Eloqua Reporting Data in FoxPro
Load Oracle Eloqua Reporting into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Samanage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Samanage replication to PostgreSQL.
-
Use Grok to Talk to Your HCL Domino 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 HCL Domino for you.
-
How to Work with ChartMogul Data in AWS Glue Jobs Using JDBC
Connect to ChartMogul from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating GitHub Copilot CLI with MariaDB 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.
-
Visualize ActiveCampaign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ActiveCampaign.
-
Access Live Gong Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Gong through MCP integration.
-
Query Bitbucket Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bitbucket from Node.js.
-
Enable the Basecamp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Basecamp.
-
Build Voice Agents in ElevenLabs with access to Live eBay Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live eBay.
-
Integrating GitHub Copilot CLI with eBay 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 Build an ETL App for Tally Data in Python with CData
Create ETL applications and real-time data pipelines for Tally ERP in Python with petl.
-
Connect to Freshteam Data in Jaspersoft Studio
Execute SQL to remote Freshteam in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Outlook
Provide connectivity to Outlook through an SAP BusinessObjects universe.