CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle
Create an ODBC connection to Oracle in Informatica and browse and transfer Oracle data.
-
Integrating LangChain with Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Egnyte data within automated workflows.
-
Replicate Spotify Data to Multiple Databases via the CData Sync CLI
Replicate Spotify data to disparate databases with a single configuration.
-
Integrating Claude Code CLI with FormSite 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.
-
Integrating GitHub Copilot with SQL Server 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.
-
Natively Connect to Sybase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sybase data. Leverage the native support for ODBC in PHP.
-
Connect to Presto from a Connection Pool in WebLogic
Use the CData JDBC Driver for Presto to connect to Presto data from Web applications running on WebLogic.
-
Process & Analyze Greenplum Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Greenplum Data.
-
Import Real-Time Bright Data Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bright Data data in ColdFusion.
-
Query, Visualize, and Share live Pinterest Data in Redash
Use CData Connect AI to connect to live Pinterest data in Redash for querying, visualizing, and sharing.
-
Design BIRT Reports on SAP Concur Data
Provide current SAP Concur data to your embedded analytics.
-
Connect to Microsoft Exchange from Asprova with CData Software ODBC Driver for Microsoft Exchange
This article shows how to connect faster to Microsoft Exchange data from Asprova.
-
Integrating OpenCode with Zoho CRM 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 Semantic Layer Views for Google Forms Data in APOS Live Data Gateway
Use the CData Connector for Google Forms in APOS Live Data Gateway to build Semantic Layer Views for Google Forms data.
-
Moving Data from Adobe Target to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Target data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to XML Data from PowerBuilder via ADO.NET
This article demonstrates how to access XML data from Appeon PowerBuilder using the CData ADO.NET Provider for XML.
-
Automated Continuous Teradata Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teradata replication to delimited files (CSV/TSV).
-
Integrate Live FHIR Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live FHIR data from within the IDE.
-
Create Datasets from Shopify in Domo Workbench and Build Visualizations of Shopify Data in Domo
Use the CData Software ODBC Driver for Shopify to create datasets from Shopify data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Freshservice Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshservice data from your Excel spreadsheets.
-
Use the CData ODBC Driver for Google Calendar in Microsoft Power Query
You can use the CData Google Calendar ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Calendar data into Microsoft Power Query.
-
Integrating Claude Code CLI with IBM Informix 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 JDBC Driver for Paylocity in MicroStrategy
Connect to Paylocity data in MicroStrategy Developer using the CData Software JDBC Driver for Paylocity.
-
Connect to NASA in SpagoBI
Create reports featuring live NASA data in SpagoBI Studio. Host NASA reports on SpagoBI Server.
-
Getting Started with the CData Excel Add-In for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PhantomBuster.
-
Integrate Cline with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Ariba Source data from within your IDE.
-
Getting Started with the CData Power BI Connector for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build an OLAP Cube in SSAS from Facebook Ads Data
Establish a connection to Facebook Ads data data from SQL Server Analysis Services, and use the Facebook Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with iContact 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 iContact data into a Java-based ORM framework, Hibernate.
-
How to connect to Campaigner Data with Squirrel SQL client
Connect to Campaigner data and execute queries in the Squirrel SQL Client.
-
Build Automated Supabase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Supabase data and build automated workflows in Zapier.
-
Query Bullhorn CRM Data in DataGrip
Create a Data Source for Bullhorn CRM in DataGrip and use SQL to query live Bullhorn CRM data.
-
Working with Datetime Values Using CData Drivers
Use the API Server and React to Build Dynamic Web Apps with Live Database Data.
-
Create Reckon Accounts Hosted-Connected Dashboards in Grafana
Connect to Reckon Accounts Hosted Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Reckon Accounts Hosted data.
-
How to Build an ETL App for Elasticsearch Data in Python with CData
Create ETL applications and real-time data pipelines for Elasticsearch data in Python with petl.
-
Connect to Auth0 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Auth0 data using standard SQL.
-
Analyze Kintone Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Kintone data with the CData JDBC Driver for Kintone.
-
Connect NetSuite to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live NetSuite data using the CData Python MCP Server.
-
Use JayDeBeApi to access NetSuite Data in Python
Use standard Python scripting and the development environment of your choice to access live NetSuite data.
-
Use Agno to Talk to Your Acumatica 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 Acumatica data for you.
-
Automated Continuous Amplitude Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amplitude replication to IBM DB2.
-
Integrate with Live HBase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HBase from the MuleSoft Anypoint Platform to integrate live HBase data into custom reports and dashboards.
-
Publish IBM Informix-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live IBM Informix data.
-
How to import Exact Online Data into Apache Solr
Use the CData Software JDBC Driver for Exact Online in Data Import Handler and create an automated import of Exact Online data to Apache Solr Enterprise Search platform.
-
Build Zoho Projects Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho Projects data and build visualizations in Tableau Cloud.
-
Work with Live Microsoft Dataverse Data in Power Query
Use CData Connect AI to connect to Microsoft Dataverse data and work with live Microsoft Dataverse data in Microsoft Power Query.
-
Visualize CapsuleCRM Data in Tableau
The CData ODBC driver for CapsuleCRM enables you integrate CapsuleCRM data into Tableau dashboards.
-
Integrating Boomi Agentstudio with Sybase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sybase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect Office 365 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Office 365 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for Oracle Sales Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Sales data in Python with petl and the CData Connect AI Python SDK.
-
How to Work with Salesloft Data in AWS Glue Jobs Using JDBC
Connect to Salesloft from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Multiple Planio Accounts via the CData Sync CLI
Replicate multiple Planio accounts to one or many databases.
-
Access Live OneNote Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live OneNote data from your Google Sheets.
-
Publish Reports with Reply.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reply.io data.
-
View Reports on Real-Time Missive Data in Power BI Report Server
Use the CData ODBC Driver for Missive to visualize Missive data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Timely Data from MySQL in PHP
Connect to Timely through the standard MySQL libraries in PHP.
-
Integrate SQL Server Data into Power Automate Desktop using CData Connect
CData Connect for SQL Server Data enables you to integrate SQL Server data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho Books Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Books and the Script function in FileMaker Pro to connect to Zoho Books and work with Zoho Books data in your FileMaker application.
-
How to load Stripe data into Elasticsearch via Logstash
Introducing a simple method to load Stripe data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Supabase
Provide connectivity to Supabase data through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Mailjet Data using the CData ODBC Driver
Use the SQL Gateway and Mailjet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query AlloyDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against AlloyDB data from Node.js.
-
Automated Continuous Phoenix Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Phoenix replication to Google BigQuery.
-
Connect to and Query Phoenix Data in QlikView over ODBC
Create data visualizations with Phoenix data in QlikView.
-
Integrate ZohoPeople Data into Power Automate Desktop using CData Connect
CData Connect for ZohoPeople Data enables you to integrate ZohoPeople data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous LinkedIn Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LinkedIn replication to Apache Kafka.
-
Replicate PolarTeamPro Data in Heroku for Use in Salesforce Connect
Replicate PolarTeamPro data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Eventbrite Replication to Databricks
Use CData Sync for automated, continuous, customizable Eventbrite replication to Databricks.
-
Use Biml to Build SSIS Tasks to Replicate Snapchat Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Snapchat Ads data to SQL Server.
-
Publish Planio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Planio data.
-
Analyze Dynamics NAV Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dynamics NAV data with the CData JDBC Driver for Dynamics NAV.
-
Integrating Gumloop with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho CRM data within automated workflows.
-
Model, Search, and Visualize Live Monday.com Data in ThoughtSpot
Use CData Connect AI to connect to live Monday.com data for modeling, searching, and visualizing.
-
Connect SAP HANA XS Advanced to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP HANA XS Advanced with IBM WebSphere for seamless data integration and connectivity.
-
Query Adobe Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Adobe Analytics data from Node.js.
-
Analyze BenchmarkEmail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BenchmarkEmail data in Microsoft R Open.
-
Visualize Smartsheet Data in Sisense
Create an ElastiCube in Sisense app with access to Smartsheet data.
-
How to Access Oracle Service Cloud Data Using Entity Framework
This article shows how to access Oracle Service Cloud data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to MongoDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MongoDB and the SQL Gateway to access MongoDB data from Google Apps Script.
-
Analyze Freshdesk Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Freshdesk data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
LINQ to Office 365 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 Office 365 Data Provider.
-
Connect to Oracle Sales from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Sales data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Work with FTP Data in AWS Glue Jobs Using JDBC
Connect to FTP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to integrate Metabase with Oracle HCM Cloud Data
Use CData Connect AI to connect to live Oracle HCM Cloud data and create an interactive dashboard in Metabase from Oracle HCM Cloud data.
-
Connecting GenSpark with Avalara AvaTax Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Avalara AvaTax data without any replication or custom integration required.
-
Connect to MySQL Data from a Connection Pool in Jetty
The MySQL JDBC Driver supports connection pooling: This article shows how to connect faster to MySQL data from Web apps in Jetty.
-
Integrating LangChain with xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on xBase data within automated workflows.
-
A PostgreSQL Interface for SparkPost Data using the CData ODBC Driver
Use the SQL Gateway and SparkPost ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Coinbase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Coinbase data in ColdFusion.
-
Establish a Live Connection with Stack Exchange Data using Tableau Bridge
The CData ODBC Driver for Stack Exchange enables you to integrate live Stack Exchange data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Biml to Build SSIS Tasks to Replicate Tickspot Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tickspot data to SQL Server.
-
How to Connect to Live Mailjet Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Mailjet data for you.
-
Connect to RabbitMQ Data in DBeaver
Use the CData ODBC Driver to connect to RabbitMQ data in DBeaver.
-
Automated Continuous AlloyDB Replication to Databricks
Use CData Sync for automated, continuous, customizable AlloyDB replication to Databricks.
-
CData Sync - History Mode
Configuring History Mode replication for CData Sync.
-
Getting Started with the CData Tableau Connector for SFTP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SFTP.
-
Automated Continuous Telegram Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Telegram replication to delimited files (CSV/TSV).
-
Bridge Calendly Connectivity with Apache NiFi
Access and process Calendly data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect to MariaDB Data from Spring Boot
Connect to MariaDB in a Spring Boot Application using the CData JDBC Driver for MariaDB