CData Software - Knowledge Base
Recent Articles
-
How to update REST from Excel
This article explains how to transfer data from Excel to REST using the Excel Add-In for REST.
-
Create Datasets from Vercel in Domo Workbench and Build Visualizations of Vercel Data in Domo
Use the CData Software ODBC Driver for Vercel to create datasets from Vercel data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Zoho Recruit Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Apache Kafka.
-
Write a Simple Go Application to work with Square Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Square data.
-
Query Certinia Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Certinia entities in PHP by modeling them as objects.
-
A PostgreSQL Interface for Intercom Data (MySQL Remoting via JDBC)
Use the Remoting features of the Intercom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Azure Data Lake Storage-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Azure Data Lake Storage data without replication.
-
Create Vault CRM-Connected Applications in Appsmith
Connect to Vault CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Vault CRM data.
-
Automated Continuous DB2 for i Replication to Oracle
Use CData Sync for automated, continuous, customizable DB2 for i replication to Oracle.
-
Integrating Codex with ServiceDesk Plus 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.
-
Design BIRT Reports on Chargebee Data
Provide current Chargebee data to your embedded analytics.
-
Automated Continuous ChartMogul Replication to SQL Server
Use CData Sync for automated, continuous, customizable ChartMogul replication to SQL Server.
-
Integrate with live RSS Feeds in Jitterbit
Use CData Connect AI to connect to and integrate live RSS feeds in Jitterbit.
-
Build a PostgreSQL Interface for Tickspot Data using the CData JDBC Driver
Use the Remoting features of the Tickspot JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Teradata Data Using Entity Framework
This article shows how to access Teradata data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live SAP Fieldglass Data in Coginiti Pro
Connect to and query live SAP Fieldglass data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Sybase IQ Replication to Vertica
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Vertica.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy Desktop
Connect to Humanity data in MicroStrategy Desktop using the CData Software ODBC Driver for Humanity.
-
Create Data Visualizations in Cognos BI with Foursquare Data
Access Foursquare data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create VWO-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to VWO Data from OutSystems and build custom enterprise apps using live VWO data.
-
Integrating Kiro with ScrapingBee 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.
-
Use the CData Software ODBC Driver for Mistral AI in SAS for Real-Time Reporting and Analytics
Connect to real-time Mistral AI data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mistral AI.
-
Automated Continuous Wave Financial Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Wave Financial replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Yelp
Provide connectivity to Yelp data through an SAP BusinessObjects universe.
-
Integrate Trae with Live TaxJar Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live TaxJar data from within the AI-powered IDE.
-
Integrate Google's Antigravity Agent with Live Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Coda data using the Model Context Protocol.
-
Connect and Visualize Live Zoom Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoom data into the Databricks platform and create visualization dashboards with real-time Zoom data.
-
Process & Analyze Sage Intacct Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage Intacct Data.
-
Build Semantic Layer Views for JotForm Data in APOS Live Data Gateway
Use the CData Connector for JotForm in APOS Live Data Gateway to build Semantic Layer Views for JotForm data.
-
Natively Connect to Avalara AvaTax Data in PHP
The CData ODBC driver for Avalara AvaTax enables you to create PHP applications with connectivity to Avalara AvaTax data. Leverage the native support for ODBC in PHP.
-
Analyze Coinbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Coinbase data in Microsoft R Open.
-
Connect to Bitbucket Data from AWS Glue
Use CData Connect AI to gain access to live Bitbucket data from your AWS Glue jobs.
-
Access Live Salesforce Pardot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Pardot data into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Pardot data in the Graph Builder and Query Builder.
-
Build a Singer.io Tap for Cvent With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cvent data using the CData Python Connector.
-
Object-Relational Mapping (ORM) with Ontraport 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 Ontraport data into a Java-based ORM framework, Hibernate.
-
Build Charts with Freshservice Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshservice data in Clear Analytics.
-
Working with FTP Data in LINQPad
Execute LINQ queries to FTP data in LINQPad.
-
How to publish and share Cohere Data dashboards with Tableau Server
The CData ODBC driver for Cohere enables you integrate Cohere data into Tableau dashboards.
-
Build Charts with Apify Data in Clear Analytics
Create dynamic charts and perform analytics based on Apify data in Clear Analytics.
-
Connect HDFS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HDFS with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Yelp
Provide connectivity to Yelp data through an SAP BusinessObjects universe.
-
Build Dashboards with SpaceX Data in DBxtra
Create dynamic dashboards and perform analytics based on SpaceX data in DBxtra.
-
Replicate Multiple Auth0 Accounts
Replicate multiple Auth0 accounts to one or many databases.
-
How to Work with SurveyMonkey Data in AWS Glue Jobs Using JDBC
Connect to SurveyMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Microsoft Copilot Studio to talk to your Smartsheet 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 Smartsheet data for you.
-
Model Paylocity Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Paylocity, enabling the direct import of real-time Paylocity data.
-
Integrate Sage 300 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage 300 with External Services.
-
Integrating Claude Code CLI with SAP SuccessFactors 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.
-
Build Box-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Box Data and create custom apps in Mendix.
-
Connect to ShipEngine Data from HeidiSQL
Use CData Connect AI to connect to and query live ShipEngine data from HeidiSQL.
-
Build Charts with Scrapfly Data in Clear Analytics
Create dynamic charts and perform analytics based on Scrapfly data in Clear Analytics.
-
Rapidly Develop WooCommerce-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 WooCommerce.
-
How to connect to FreeAgent Data from Spring Boot
Connect to FreeAgent in a Spring Boot Application using the CData API Driver for JDBC
-
How to Work with Dropbox Data in ETL Validator JDBC
Connect to Dropbox from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Devin with Live Facebook Ads 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 Facebook Ads data.
-
Getting Started with the CData ODBC Driver for Omnisend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Omnisend.
-
Connect to Redis Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Redis Data and connect to Redis data in Akorbi Digital RunMyProcess.
-
Connect to GitLab Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GitLab Data and connect to GitLab data in Akorbi Digital RunMyProcess.
-
Automated Continuous Coinbase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Coinbase replication to delimited files (CSV/TSV).
-
Load Datadog Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Datadog data to a database.
-
Build Semantic Layer Views for Oracle Eloqua Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Eloqua data.
-
Connect to Amazon Marketplace Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon Marketplace data using standard SQL.
-
Query Google Calendar Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Calendar data from Node.js.
-
Use Dash to Build to Web Apps on Optimizely Data
Create Python applications that use pandas and Dash to build Optimizely-connected web apps.
-
Connect to Zoom Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoom data in Airbyte.
-
Connect to Sage Cloud Accounting Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Cloud Accounting data.
-
Connect to Slack Data in RazorSQL
Connect to Slack from wizards and query Slack data from the GUI in the RazorSQL database management tool.
-
Build Charts with Pinecone Data in Clear Analytics
Create dynamic charts and perform analytics based on Pinecone data in Clear Analytics.
-
Automated Continuous Google Ad Manager Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Google Cloud SQL.
-
DataBind Controls to Campaigner Data in Delphi
DataBind to Campaigner data in Delphi with standard data access components and controls.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Commerce Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Commerce data.
-
How to create PDFMonkey federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PDFMonkey data in MySQL .
-
Publish Reports with LinkedIn Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LinkedIn Ads data.
-
Build Dashboards with Ontraport Data in Dundas BI
Create dynamic dashboards and perform analytics based on Ontraport data in Dundas BI.
-
Access Lakebase Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Lakebase data.
-
Automated Continuous xBase Replication to Oracle
Use CData Sync for automated, continuous, customizable xBase replication to Oracle.
-
Integrate OpenCode with Live Tally Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Tally data from within your AI coding agent.
-
Integrating Gumloop with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Guru data within automated workflows.
-
Visualize Live Dropbox Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Dropbox data.
-
How to Connect to Live LDAP Objects from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your LDAP objects for you.
-
Easily Integrate QuickBooks Time Data in Lazarus Pascal IDE
Learn how to easily integrate live QuickBooks Time data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Easily Integrate FreshBooks Data in Lazarus Pascal IDE
Learn how to easily integrate live FreshBooks data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Live Twilio Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Twilio from the MuleSoft Anypoint Platform to integrate live Twilio data into custom reports and dashboards.
-
Use JayDeBeApi to access Superchat Data in Python
Use standard Python scripting and the development environment of your choice to access live Superchat data.
-
Connect to SAP Business One Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business One data in Google Apps Script.
-
ETL Bright Data in Oracle Data Integrator
This article shows how to transfer Bright Data data into a data warehouse using Oracle Data Integrator.
-
Publish Reports with Coinbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Coinbase data.
-
Import SAP SuccessFactors LMS Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP SuccessFactors LMS Data and provide access to live SAP SuccessFactors LMS data for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To an ODBC Data Source for Email
Create an ODBC connection to Email in Informatica and browse and transfer Email data.
-
Integrate Shortcut with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Shortcut with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Shortcut data.
-
Visualize xBase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to xBase data.
-
Connect to Zoom Data in Ruby
Connect to Zoom data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Snapchat Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Snapchat Ads data.
-
Natively Connect to Foursquare Data in PHP
The CData ODBC driver for Foursquare enables you to create PHP applications with connectivity to Foursquare data. Leverage the native support for ODBC in PHP.
-
Access Live HCL Domino Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HCL Domino data into the statistical analysis tools available in SAS JMP. This article shows how to use HCL Domino data in the Graph Builder and Query Builder.
-
Provide OData Services of ConvertAPI Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ConvertAPI data by developing a WCF Service Application.
-
How to Connect DBeaver to Adobe Commerce via a JDBC Driver
Manage Adobe Commerce data with visual tools in DBeaver like the query browser.
-
Connect to Slack Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Slack data in the Denodo Virtual DataPort Administrator.
-
Access Live Sage Cloud Accounting Data in TIBCO Data Virtualization
Use the Sage Cloud Accounting Tibco DV Adapter to create a Sage Cloud Accounting data data source in TIBCO Data Virtualization Studio and gain access to live Sage Cloud Accounting data from your TDV Server.
-
How to Connect to Live NetSuite 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 NetSuite data for you.