CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Couchbase in Domo Workbench and Build Visualizations of Couchbase Data in Domo
Use the CData Software ODBC Driver for Couchbase to create datasets from Couchbase data in Domo Workbench and then build visualizations in the Domo service.
-
Apollo Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apollo data through CData Connect AI using different applications and tools.
-
Model, Search, and Visualize Live SAP BusinessObjects BI Data in ThoughtSpot
Use CData Connect AI to connect to live SAP BusinessObjects BI data for modeling, searching, and visualizing.
-
Access Live Printful Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Printful data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to load SAP Business One data into Elasticsearch via Logstash
Introducing a simple method to load SAP Business One data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to CockroachDB Data in DBVisualizer
Integrate CockroachDB data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to work with MongoDB Data in Apache Spark using SQL
Access and process MongoDB Data in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Neo4J Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Neo4J data.
-
Create Reports with Oracle Sales Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Sales data.
-
Replicate Dynamics 365 Business Central Data in Heroku for Use in Salesforce Connect
Replicate Dynamics 365 Business Central data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dynamic Shippo Grids Using the Infragistics XamDataGrid
Learn how you can connect Shippo to Infragistics XamDataGrid to build dynamic grids.
-
Use Dash to Build Web Apps on Google Sheets Data via CData Connect AI
Build interactive Dash web apps on live Google Sheets data using pandas and the CData Connect AI Python SDK.
-
Access Live Cosmos DB Data in TIBCO Data Virtualization
Use the Cosmos DB Tibco DV Adapter to create a Cosmos DB data data source in TIBCO Data Virtualization Studio and gain access to live Cosmos DB data from your TDV Server.
-
Using the CData Software ODBC Driver for Azure DevOps in PyCharm
Connect to Azure DevOps as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure DevOps.
-
Query Office 365 Data as a MySQL Database in Node.js
Execute MySQL queries against Office 365 data from Node.js.
-
Analyze LinkedIn Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of LinkedIn Ads data and visualize LinkedIn Ads data in SAP Analytics Cloud.
-
Connect to Cvent Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cvent Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Cursor with ZohoPeople 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 Guru Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Guru data using standard SQL.
-
Extract, Transform, and Load ServiceDesk Plus Data in Informatica PowerCenter
Create a simple Workflow for ServiceDesk Plus data in Informatica PowerCenter.
-
Visualize Live Redshift Data in the Power BI Service
Use CData Connect AI to connect to live Redshift data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Singer.io Tap for SendPulse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendPulse data using the CData Python Connector.
-
Integrate with Teamwork Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Teamwork data to a JSON file on disk.
-
Automated Continuous Sentry Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sentry replication to IBM DB2.
-
Integrating Gumloop with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on CouchDB data within automated workflows.
-
Replicate Oracle Service Cloud Data to Multiple Databases
Replicate Oracle Service Cloud data to disparate databases with a point-and-click configuration.
-
Moving Data from SparkPost to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SparkPost data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Build an ETL App for Instagram Data in Python with CData Connect AI
Build ETL pipelines that read and write live Instagram data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to Live ZohoExpense Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your ZohoExpense data for you.
-
Analyze Email Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Email data and visualize live Email data in Infragistics Reveal.
-
Use Manus AI to Talk to Your Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Teradata data.
-
Use Agno to Talk to Your Oracle Sales 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 Oracle Sales data for you.
-
Integrate Devin with Live SAP SuccessFactors Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP SuccessFactors data.
-
Access LinkedIn Data from MySQL in PHP
Connect to LinkedIn through the standard MySQL libraries in PHP.
-
Migrating data from ScrapingBee to Snowflake using CData SSIS Components.
Easily push ScrapingBee data to Snowflake using the CData SSIS Tasks for ScrapingBee and Snowflake.
-
Getting Started with the CData SSIS Components for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OpenWeatherMap.
-
Connect to SAP Fieldglass Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Fieldglass data from Filemaker Pro on Mac.
-
Build SFTP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SFTP Data from Zoho Analytics and import live SFTP data.
-
How to connect PolyBase to NASA
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live NASA data.
-
Connect to QuickBooks Data in RapidMiner
Integrate QuickBooks data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate OpenCode with Live Azure DevOps Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Azure DevOps data from within your AI coding agent.
-
Connect to Databricks Data in Jaspersoft Studio
Execute SQL to remote Databricks data in Jaspersoft Studio.
-
How to Work with Zoho CRM Data in AWS Glue Jobs Using JDBC
Connect to Zoho CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Add ConvertKit Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConvertKit with the Informatica Enterprise Data Catalog to classify and organize data.
-
A PostgreSQL Interface for Cloudflare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudflare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Retently Data
Use the CData ODBC Driver for Retently to visualize Retently data in Power BI Desktop.
-
Integrate Live Tanda Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tanda data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Zoho Books-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Books Data from Nintex Workflow Cloud and build custom workflows using live Zoho Books data.
-
Create SSAS Tabular Models from Microsoft Dataverse Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Dataverse data using CData drivers.
-
Automated Continuous Bright Data Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bright Data replication to SingleStore.
-
Automated Continuous SAP SuccessFactors Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Databricks.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Data
Use CData Power BI Connectors to visualize Salesforce data in Power BI.
-
Automated Continuous Box Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Box replication to Apache Kafka.
-
ETL Dynamics CRM in Oracle Data Integrator
This article shows how to transfer Dynamics CRM data into a data warehouse using Oracle Data Integrator.
-
Build Microsoft Dataverse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Dataverse Data and create custom apps in Bubble.
-
ETL EmailOctopus in Oracle Data Integrator
This article shows how to transfer EmailOctopus data into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to Google Contacts Data in Delphi
DataBind to Google Contacts data in Delphi with standard data access components and controls.
-
Automated Continuous Datadog Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Datadog replication to Amazon S3.
-
Integrating Pingdom Data in Talend Cloud Data Management Platform
Connect Pingdom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Salesforce Marketing Data from MySQL in Amazon QuickSight
Connect to Salesforce Marketing and build visualizations of Salesforce Marketing data using a MySQL Connection in Amazon QuickSight.
-
Query ActiveCampaign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ActiveCampaign data from Node.js.
-
Automated Continuous ZendeskSell Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZendeskSell data replication to OneLake in Microsoft Fabric.
-
Connect to MessageBird Data from a Connection Pool in Jetty
The MessageBird JDBC Driver supports connection pooling: This article shows how to connect faster to MessageBird data from Web apps in Jetty.
-
Add MYOB AccountRight Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MYOB AccountRight with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting GenSpark with SingleStore Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SingleStore data without any replication or custom integration required.
-
Use the CData ODBC Driver for SurveyMonkey from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SurveyMonkey to connect to SurveyMonkey data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SurveyMonkey data in Excel.
-
Use ChatGPT to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Amazon Marketplace data for you.
-
Connect to Discord Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Discord data.
-
MarkLogic Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MarkLogic facts in real time.
-
Visualize Live API Data in the Power BI Service
Use CData Connect AI to connect to live API data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ZohoInvoice Data in HULFT Integrate
Connect to ZohoInvoice as a JDBC data source in HULFT Integrate
-
How to connect to SparkPost Data from Spring Boot
Connect to SparkPost in a Spring Boot Application using the CData API Driver for JDBC
-
Creating ServiceNow-Connected Applications in Unqork
You can use CData Connect AI to feed ServiceNow data to Unqork and build custom business apps.
-
Access Live ElevenLabs Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ElevenLabs data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live Zuora Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zuora data data in natural language using Python.
-
DataBind Apollo Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Apollo data to a chart.
-
Connect to Klipfolio Data in JRuby
Create a simple JRuby app with access to live Klipfolio data.
-
Connect to Reckon Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Reckon data in Airbyte.
-
Integrate Trae with Live CapsuleCRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CapsuleCRM data from within the AI-powered IDE.
-
Stream Tanda Data into Apache Kafka Topics
Access and stream Tanda data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with iContact Data in SnapLogic
Use CData Connect AI to connect to and integrate with live iContact data in SnapLogic.
-
How to Work with ChargeOver Data in ETL Validator JDBC
Connect to ChargeOver from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query CSV Data in MySQL Workbench
Execute MySQL queries against live CSV data from MySQL Workbench.
-
Import SparkPost Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SparkPost Data and provide access to live SparkPost data for custom reports in the Power BI Service.
-
Establish a Live Connection with Egnyte Data using Tableau Bridge
The CData ODBC Driver for Egnyte enables you to integrate live Egnyte data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live SageHR 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 SageHR data through MCP integration.
-
Explore Geographical Relationships in Tickspot Data with Power Map
Create data visualizations with Tickspot data in Power Map.
-
Replicate SharePoint Excel Services Data to Multiple Databases via the CData Sync CLI
Replicate SharePoint Excel Services data to disparate databases with a single configuration.
-
Load GitLab Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GitLab data to a database.
-
Connect to AlloyDB Data in JRuby
Create a simple JRuby app with access to live AlloyDB data.
-
Work with Oracle HCM Cloud Data in FoxPro
Load Oracle HCM Cloud data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to SingleStore in SpagoBI
Create reports featuring live SingleStore data in SpagoBI Studio. Host SingleStore reports on SpagoBI Server.
-
Connect to Coda Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coda data.
-
Replicate Email Data to Multiple Databases via the CData Sync CLI
Replicate Email data to disparate databases with a single configuration.
-
Excel Spreadsheet Automation on OData Services with the QUERY Formula
Pull data from OData, automate spreadsheets, and more with the QUERY formula.
-
Build Aweber-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Aweber data and build Aweber-connected web apps with Axios.
-
Connect to Sendwithus Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sendwithus data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Grok to Talk to Your Mailgun 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 Mailgun data for you.
-
Use ChatGPT to Talk to Your xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your xBase data for you.
-
Bidirectional Access to Salesforce Pardot Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Pardot data in Filemaker Pro for Mac or Windows.