CData Software - Knowledge Base
Recent Articles
-
Integrate Theia IDE with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Explore Geographical Relationships in Clari Data with Power Map
Create data visualizations with Clari in Power Map.
-
Connect to Notion Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Notion and work with Notion in your FileMaker applications.
-
Query ZohoDesk Data in DataGrip
Create a Data Source for ZohoDesk in DataGrip and use SQL to query live ZohoDesk.
-
Migrating data from JobNimbus to Google BigQuery using CData SSIS Components.
Easily push JobNimbus to Google BigQuery using the CData SSIS Tasks for JobNimbus and Google BigQuery.
-
Build Google Sheets-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Sheets to explore live Google Sheets Data in Gemini Code Assist to assist with building Google Sheets-powered applications.
-
Build Data Flows from HelloSign to SQL Server using SSIS
Easily back up HelloSign to SQL Server using the SSIS components for HelloSign.
-
Import Azure Analysis Services Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Analysis Services Data from Azure Data Factory and import live Azure Analysis Services.
-
Connect to Factorial Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Factorial in the Denodo Virtual DataPort Administrator.
-
Connect to Google Ad Manager Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Ad Manager.
-
How to work with SageHR Data in Apache Spark using SQL
Access and process SageHR Data in Apache Spark using the CData Software JDBC Driver.
-
Use Manus AI to Talk to Your Google Analytics 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 Google Analytics.
-
Integrating Dataiku with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MYOB AccountRight.
-
Connect to DocuSign Data in Ruby
Connect to DocuSign in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live Couchbase Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Couchbase securely in real time.
-
Natively Connect to Impala Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Impala. Leverage the native support for ODBC in PHP.
-
Build Tally-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Tally to explore live Tally Data in Claude Code to assist with building Tally-powered applications.
-
LINQ to ZohoDesk Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the ZohoDesk Data Provider.
-
How to create an RPA flow for LeadDesk Data in UiPath Studio
Use the LeadDesk ODBC Driver to create workflows that access real-time LeadDesk without any coding.
-
Viewing Google Forms Data in RAD Studio Data Explorer
How to view Google Forms in RAD Studio Data Explorer using the CData ODBC Driver for Google Forms.
-
Visualize PagerDuty Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PagerDuty into TIBCO Spotfire.
-
ODBC Driver Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData ODBC Driver
-
Publish Xero-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Xero Accounting.
-
Integrating Claude Code CLI with Salesforce Marketing 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 use SQLAlchemy ORM to access Oracle Eloqua Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua.
-
Integrating Hacker News Data in Talend Cloud Data Management Platform
Connect Hacker News Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Freshsales Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Freshsales replication to Google Cloud SQL.
-
Automate Cloudant Data Replication to Couchbase
Use CData Sync to Customize and automate IBM Cloudant replication to Couchbase.
-
Integrating Codex CLI with REST 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.
-
Create Dynamics 365 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics 365 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Dashboards and Visualize Live Microsoft Teams Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Teams and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live Adobe Target Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Adobe Target enables you to integrate Adobe Target into workflows built using Microsoft Power Automate Desktop.
-
Connect SharePoint Excel Services to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SharePoint Excel Services with IBM WebSphere for seamless data integration and connectivity.
-
Create Dashboards and Visualize Live SAP Hybris C4C Data in Geckoboard
Use CData Connect AI to connect to live SAP Hybris C4C and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Airtable Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Airtable replication to AlloyDB.
-
How to Easily Query Sybase IQ Data in OpenOffice Base
Connect to Sybase IQ data in OpenOffice Base using the CData ODBC Driver for Sybase IQ and generate reports with live data insights.
-
Connect to Tanda Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to PivotalTracker Data in RazorSQL
Connect to PivotalTracker from wizards and query PivotalTracker from the GUI in the RazorSQL database management tool.
-
Integrate with PayPal Data in SnapLogic
Use CData Connect AI to connect to and integrate with live PayPal in SnapLogic.
-
Integrate Recurly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Recurly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Recurly.
-
Query SparkPost Data in DataGrip
Create a Data Source for SparkPost in DataGrip and use SQL to query live SparkPost.
-
Automate LinkedIn Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live LinkedIn Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting Mastra with Cosmos DB 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 Azure Cosmos DB, no replication required.
-
Connect MYOB AccountRight to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MYOB AccountRight using the CData Python MCP Server.
-
Build AI/ML Models with Live CouchDB Data using Dataiku
Connect CouchDB Data with Dataiku using the CData JDBC Driver for CouchDB.
-
Connect to Scrapfly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Outlook Data in the Pentaho Report Designer
Publish reports based on Outlook in the Pentaho BI tool.
-
Connect to SAP HANA Data in RapidMiner
Integrate SAP HANA with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to AfterShip Data from PowerBuilder via ADO.NET
This article demonstrates how to access AfterShip from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Extract, Transform, and Load ChargeOver Data in Informatica PowerCenter
Create a simple Workflow for ChargeOver in Informatica PowerCenter.
-
Use the CData SSIS Components to Insert New or Update Existing Hive Records from SQL Server
Easily push SQL Server data to Hive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Hive or update existing records with data from a SQL Server database.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Ad Manager
Provide connectivity to Google Ad Manager through an SAP BusinessObjects universe.
-
How to load DB2 data into Elasticsearch via Logstash
Introducing a simple method to load DB2 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating GitHub Copilot CLI with Microsoft Planner 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 Facebook Ads-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Facebook Ads to explore live Facebook Ads Data in Claude Code to assist with building Facebook Ads-powered applications.
-
Connect to Amazon Marketplace Data in Ruby
Connect to Amazon Marketplace in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy Desktop
Connect to FHIR in MicroStrategy Desktop using the CData Software ODBC Driver for FHIR.
-
Build Dashboards with PingOne Data in DBxtra
Create dynamic dashboards and perform analytics based on PingOne in DBxtra.
-
Connect and Visualize Live FHIR Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FHIR into the Databricks platform and create visualization dashboards with real-time FHIR.
-
Perform Batch Operations with Smartsheet Data in Apache NiFi
Connect to Smartsheet and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Reckon Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon from your Oracle system.
-
How to Create Power BI Visual Reports with Real-Time Close Data
Use CData Power BI Connectors to visualize Close in Power BI.
-
Automated Continuous Neo4J Replication to SingleStore
Use CData Sync for automated, continuous, customizable Neo4J replication to SingleStore.
-
Object-Relational Mapping (ORM) with Blackbaud FE NXT 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 Blackbaud FE NXT into a Java-based ORM framework, Hibernate.
-
Access Live FreshBooks Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FreshBooks from your Excel spreadsheets.
-
How to Build an ETL App for Dynamics 365 Business Central Data in Python with CData
Create ETL applications and real-time data pipelines for Dynamics 365 Business Central in Python with petl.
-
Integrating Claude Code with SendGrid Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SendGrid within assisted coding and automated development workflows.
-
Build a PostgreSQL Interface for ClickTime Data using the CData JDBC Driver
Use the Remoting features of the ClickTime JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sybase in real time.
-
Edit and Search Salesforce Pardot External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Salesforce Pardot to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Salesforce Pardot objects that you can access from apps and the dashboard.
-
Build a Singer.io Tap for OpenWeatherMap With the CData Python Connector
Learn how to easily build a Singer.io Tap for live OpenWeatherMap data using
-
Integrate Bitbucket Data in the Pentaho Report Designer
Publish reports based on Bitbucket in the Pentaho BI tool.
-
Replicate Multiple Workday Accounts
Replicate multiple Workday accounts to one or many databases.
-
Connect to VWO Data in HULFT Integrate
Connect to VWO as a JDBC data source in HULFT Integrate
-
Integrating LangGraph with Gmail Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Gmail within automated workflows.
-
How to Connect to & Open Outlook Data in Microsoft Excel
This article uses the CData ODBC driver for Outlook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time TigerGraph Data
Use the CData ODBC Driver for TigerGraph to visualize TigerGraph in Power BI Desktop.
-
Import Real-Time Aha! Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aha! in ColdFusion.
-
Build Salesforce Marketing Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce Marketing Cloud and build visualizations in Tableau Cloud.
-
Connect to Todoist Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Todoist and work with Todoist in your FileMaker application.
-
Automate EnterpriseDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live EnterpriseDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze Odoo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Odoo ERP in Microsoft R Open.
-
Connecting GenSpark with Email Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Email without any replication or custom integration required.
-
Bridge Ontraport Connectivity with Apache NiFi
Access and process Ontraport in Apache NiFi using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Gong Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Gong, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Live SAP SuccessFactors Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP SuccessFactors through natural language.
-
Build a Singer.io Tap for Microsoft Entra ID With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Entra ID data using
-
Use the CData API Server to Access Sage Cloud Accounting Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage Business Cloud Accounting in the Power Pivot business intelligence tool.
-
Integrate HubSpot Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HubSpot and integrate live HubSpot into your Power Automate tasks.
-
Connecting Pipedream with Asana 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 Asana data in real time.
-
Automate WordPress Data Replication to Azure Data Lake
Use CData Sync to customize and automate WordPress replication to Azure Data Lake.
-
Build a Simple VCL Application for Dotmailer Data
How to build a simple VCL Application to view Dotmailer in RAD Studio using the CData ODBC Driver for Dotmailer.
-
Getting Started with the CData Python Connector for Microsoft Ads
Learn to install and license the CData Python Connector
-
Build Agents in Relevance AI with Access to Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Dataverse (CDS) within intelligent agent workflows.
-
Build Automated Workflows with Live Gong Data in Workato
Use CData Connect AI to connect to live Gong and build automated workflows in Workato.
-
Connecting Mastra with Impala 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 Apache Impala, no replication required.
-
Connect and Visualize Live QuickBooks Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online into the Databricks platform and create visualization dashboards with real-time QuickBooks Online.
-
How to load Google Cloud Storage data into Elasticsearch via Logstash
Introducing a simple method to load Google Cloud Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Salesforce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Salesforce to explore live Salesforce Data in GitHub Copilot to assist with building Salesforce-powered applications.
-
Visualize Live SendPulse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendPulse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.