CData Software - Knowledge Base
Recent Articles
-
Load Microsoft Exchange Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Exchange data to a database.
-
Integrate with live SparkPost Data in Jitterbit
Use CData Connect AI to connect to and integrate live SparkPost data in Jitterbit.
-
Connecting GenSpark with Teradata Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Teradata data without any replication or custom integration required.
-
Integrate Cursor with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Basecamp data from within the editor.
-
CSV Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CSV facts in real time.
-
Build a PostgreSQL Interface for SurveyMonkey Data using the CData JDBC Driver
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Rootly Data from PowerBuilder via JDBC
This article demonstrates how to access Rootly data from PowerBuilder using the Rootly JDBC Driver.
-
Create Data Visualizations in Cognos BI with Eventbrite Data
Access Eventbrite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Okta 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 Okta data without replication.
-
Connect to Deel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Deel data.
-
Rapidly Develop Azure Data Lake Storage-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 Azure Data Lake Storage.
-
Replicate Trello Data to Multiple Databases
Replicate Trello data to disparate databases with a point-and-click configuration.
-
Create Greenhouse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenhouse data access from reports, embedded analytics, and more.
-
Connect to OneNote Data in ACL Analytics
Connect to OneNote data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to OneNote data.
-
Model, Search, and Visualize Live MailChimp Data in ThoughtSpot
Use CData Connect AI to connect to live MailChimp data for modeling, searching, and visualizing.
-
Automate Zuora Data Replication to Couchbase
Use CData Sync to Customize and automate Zuora data replication to Couchbase.
-
Zuora Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zuora data through CData Connect AI using different applications and tools.
-
Integrate Goose with Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ServiceDesk Plus data from within the local AI agent.
-
Integrate with BigQuery Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy BigQuery data to a JSON file on disk.
-
Connect to Salesforce Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce data from PowerBuilder using the Salesforce JDBC Driver.
-
Automated Continuous SAP Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP data replication to OneLake in Microsoft Fabric.
-
Build Dashboards with Reply.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Reply.io data in Dundas BI.
-
Connect to WooCommerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for WooCommerce to connect to WooCommerce data from Web applications running on WebLogic.
-
Getting Started with the CData Python Connector for Amazon DynamoDB
Learn to install and license the CData Python Connector and configure a connection to live Amazon DynamoDB data.
-
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy Desktop
Connect to Adobe Target data in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Target.
-
Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy Desktop
Connect to SAP BusinessObjects BI data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP BusinessObjects BI.
-
Use Grok to Talk to Your Mailjet 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 Mailjet data for you.
-
Visualize Live Oracle Sales Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Sales data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Airtable Data in Jaspersoft Studio
Execute SQL to remote Airtable data in Jaspersoft Studio.
-
How to connect and process Microsoft Exchange data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Exchange data.
-
Integrating Antigravity CLI with Sage Intacct data via CData CLI
Connect Sage Intacct data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to load Sage Cloud Accounting data into Elasticsearch via Logstash
Introducing a simple method to load Sage Cloud Accounting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect Salesforce Marketing to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Marketing data using the CData Python MCP Server.
-
Build a PostgreSQL Interface for Retently Data using the CData JDBC Driver
Use the Remoting features of the Retently JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Email Replication to MongoDB
Use CData Sync for automated, continuous, customizable Email replication to MongoDB.
-
Use Grok to Talk to Your Testmonitor 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 Testmonitor data for you.
-
Provide OData Services of Trello Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Trello data by developing a WCF Service Application.
-
How to create MessageBird federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MessageBird data in MySQL .
-
Visualize SendPulse Data in Tableau
The CData ODBC driver for SendPulse enables you integrate SendPulse data into Tableau dashboards.
-
Build AI/ML Models with Live Workday Data using Dataiku
Connect Workday Data with Dataiku using the CData JDBC Driver for Workday.
-
Integrate Live Aweber Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Aweber data and integrate live Aweber data into apps built in Microsoft Power Apps.
-
How to create Visio diagrams from Salesforce Pardot Data
Automatically update Salesforce Pardot data with the changes you make to Visio master shapes.
-
Integrate Theia IDE with Live ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ServiceDesk Plus data from within the development environment.
-
Connect to Stripe from Asprova with CData Software ODBC Driver for Stripe
This article shows how to connect faster to Stripe data from Asprova.
-
Build Visualizations of ADP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ADP data in Birst.
-
Build Webflow-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Webflow data and build web apps with connectivity to live Webflow data.
-
Connect to ADP Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ADP data in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Highrise Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Highrise replication to delimited files (CSV/TSV).
-
How to update Zoho Projects from Excel
This article explains how to transfer data from Excel to Zoho Projects using the Excel Add-In for Zoho Projects.
-
Connecting Pipedream with Reckon Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Reckon data in real time.
-
Build Charts with Redis Data in Clear Analytics
Create dynamic charts and perform analytics based on Redis data in Clear Analytics.
-
How to create Azure Data Catalog federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Catalog data in MySQL .
-
Natively Connect to SAP Hybris C4C Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP Hybris C4C data. Leverage the native support for ODBC in PHP.
-
Visualize AgileCRM Data in TIBCO Spotfire through ADO.NET
Integrate AgileCRM data into dashboards in TIBCO Spotfire.
-
Provide OData Services of Aweber Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Aweber data by developing a WCF Service Application.
-
How to use SQLAlchemy ORM to access Jodoo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jodoo data.
-
Connect to SAP Business Warehouse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP Business Warehouse.
-
Connect to Humanity Data in RazorSQL
Connect to Humanity from wizards and query Humanity data from the GUI in the RazorSQL database management tool.
-
Build Voice Agents in ElevenLabs with access to Live FTP Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FTP data.
-
Connect to ShipEngine Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipEngine to connect to ShipEngine data and execute queries in PowerBuilder.
-
Integrating OpenCode with CSV 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.
-
Access Live Dynamics NAV Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Dynamics NAV data from your Google Sheets.
-
How to Connect to Live Google Cloud Storage 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 Google Cloud Storage data for you.
-
Integrate Cursor with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Pipedrive data from within the editor.
-
Connect to Google Translate Data from a Connection Pool in Jetty
The Google Translate JDBC Driver supports connection pooling: This article shows how to connect faster to Google Translate data from Web apps in Jetty.
-
Create a Data Access Object for Invoiced Data using JDBI
A brief overview of creating a SQL Object API for Invoiced data in JDBI.
-
How to Connect Google Search Results to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Search data in real time using natural language.
-
Connect to Act CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Act CRM data from HeidiSQL.
-
Connect to MariaDB Data in NetBeans
Connect to MariaDB data in NetBeans with the data source configuration wizard.
-
Integrating LlamaIndex with Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Service Cloud data in real time.
-
Integrate with Live GraphQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from the MuleSoft Anypoint Platform to integrate live GraphQL data into custom reports and dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for PDFMonkey
Create an ODBC connection to PDFMonkey in Informatica and browse and transfer PDFMonkey data.
-
Work with Live Snapchat Ads Data in Power Query
Use CData Connect AI to connect to Snapchat Ads data and work with live Snapchat Ads data in Microsoft Power Query.
-
Query, Visualize, and Share live Paymo Data in Redash
Use CData Connect AI to connect to live Paymo data in Redash for querying, visualizing, and sharing.
-
Access Live Outlook Data in Coginiti Pro
Connect to and query live Outlook data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Elasticsearch Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Elasticsearch replication to AlloyDB.
-
Use Azure AI Foundry to Talk to Your MarkLogic 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 MarkLogic data for you.
-
Query Zoho Projects Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Projects entities in PHP by modeling them as objects.
-
Consume Oracle Financials Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Financials Cloud data as OData feeds from PowerBuilder using the API Server.
-
Build a Simple VCL Application for Adobe Experience Manager Data
How to build a simple VCL Application to view Adobe Experience Manager data in RAD Studio using the CData ODBC Driver for Adobe Experience Manager.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Web
Connect to eBay data in MicroStrategy Web using the CData Software JDBC Driver for eBay.
-
Analyze Quickbase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Quickbase data with the CData JDBC Driver for Quickbase.
-
Replicate Mistral AI Data to Multiple Databases
Replicate Mistral AI data to disparate databases with a point-and-click configuration.
-
How to connect SharePoint with Klaviyo Data through external lists
Provide Klaviyo data to SharePoint users as an external list.
-
Enable the Hugging Face JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hugging Face data.
-
Connect to Tickspot Data in DBArtisan
Use wizards in DBArtisan to configure Tickspot data as a data source.
-
Connect to Onfleet Data in Jaspersoft Studio
Execute SQL to remote Onfleet data in Jaspersoft Studio.
-
Import Databricks Data Using Azure Data Factory
Use CData Connect AI to connect to Databricks Data from Azure Data Factory and import live Databricks data.
-
Analyze Live ShipStation Data in SAS Viya
Use CData Connect AI to connect to ShipStation data from SAS Viya and deploy self-service analytics using live ShipStation data.
-
How to Work with Box Data in AWS Glue Jobs Using JDBC
Connect to Box from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Power BI Reports on Real-Time AgileCRM Data
Use the CData ODBC Driver for AgileCRM to visualize AgileCRM data in Power BI Desktop.
-
Access ServiceDesk Plus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ServiceDesk Plus data from HeidiSQL.
-
Integrating Claude Code with DocuSign Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on DocuSign data within assisted coding and automated development workflows.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Planner Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Planner data to SQL Server.
-
Visualize Live SAP Fieldglass Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Fieldglass data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Zoho Books Data Using the Low-Code Development Platform of Mendix
Connect Zoho Books data with Mendix to build apps using the CData JDBC Driver for Zoho Books.
-
Use ChatGPT to Talk to Your BambooHR 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 BambooHR data for you.
-
Automated Continuous Paylocity Replication to Vertica
Use CData Sync for automated, continuous, customizable Paylocity replication to Vertica.
-
How to load Exact Online data into Elasticsearch via Logstash
Introducing a simple method to load Exact Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Extract, Transform, and Load Invoiced Data in Informatica PowerCenter
Create a simple Workflow for Invoiced data in Informatica PowerCenter.