CData Software - Knowledge Base
Recent Articles
-
Connect to Opsgenie Data in NetBeans
Connect to Opsgenie data in NetBeans with the data source configuration wizard.
-
Extract, Transform, and Load Acumatica Data in Informatica PowerCenter
Create a simple Workflow for Acumatica data in Informatica PowerCenter.
-
Analyze PingOne Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PingOne data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to FHIR Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FHIR Data and connect to FHIR data in Akorbi Digital RunMyProcess.
-
Replicate Multiple Parallel Accounts via the CData Sync CLI
Replicate multiple Parallel accounts to one or many databases.
-
Automated SAP Hybris C4C Data Replication to Teradata
Use CData Sync to Customize and automate SAP Hybris C4C data replication to Teradata.
-
Visualize Gumroad Data in Sisense
Create an ElastiCube in Sisense app with access to Gumroad data.
-
Automated Continuous Oracle Financials Cloud Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Amazon S3.
-
How to load Placid data into Elasticsearch via Logstash
Introducing a simple method to load Placid data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build AI/ML Models with Live Google Sheets Data using Dataiku
Connect Google Sheets Data with Dataiku using the CData JDBC Driver for Google Sheets.
-
Connect to BigQuery Data from AWS Glue
Use CData Connect AI to gain access to live BigQuery data from your AWS Glue jobs.
-
Build Freshservice-Connected Apps in Choreo
Use CData Connect AI to connect to Freshservice Data from Choreo and build custom apps using live Freshservice data.
-
Build Epicor Kinetic-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Epicor Kinetic Data from Zoho Analytics and import live Epicor Kinetic data.
-
How to create Blackbaud FE NXT federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Blackbaud FE NXT data in MySQL .
-
Integrate Devin with Live MongoDB 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 MongoDB data.
-
Replicate OpenWeatherMap Data to Multiple Databases
Replicate OpenWeatherMap data to disparate databases with a point-and-click configuration.
-
Provide OData Services of Sage 200 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage 200 data by developing a WCF Service Application.
-
Build Apps with Live Bugsnag Data Using the Low-Code Development Platform of Mendix
Connect Bugsnag data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Bugsnag Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bugsnag replication to Amazon S3.
-
Access Microsoft Planner Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Planner data from HeidiSQL.
-
Connect and Query Live Vault CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Vault CRM data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating GitHub Copilot 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.
-
Integrate with SQL Server Data in JReport Designer
Create charts and reports based on SQL Server data in JReport Designer.
-
Build Pipelines with Live ZohoDesk Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ZohoDesk from Google Cloud Data Fusion, enabling the integration of live ZohoDesk data into the building and management of effective data pipelines.
-
Consume Gmail OData Feeds in PowerBuilder
This article demonstrates how to consume Gmail data as OData feeds from PowerBuilder using the API Server.
-
Build AI Agents with Smartsheet Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Smartsheet data through CData Connect AI.
-
Integrate LibreChat with Live VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live VWO data from within the chat interface.
-
Create Jira-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Jira Data from Klipfolio and build custom visualizations using live Jira data.
-
Connect Invoiced to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Invoiced data using the CData Python MCP Server.
-
Getting Started with the CData ADO.NET Provider for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Business Warehouse.
-
Moving Data from ZohoSubscriptions to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZohoSubscriptions data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Live SAS Data Sets Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SAS Data Sets data through a conversational interface.
-
Connect to Kafka Data in JRuby
Create a simple JRuby app with access to live Kafka data.
-
SendGrid Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SendGrid data through CData Connect AI using different applications and tools.
-
Connect to Kintone Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Kintone Data and connect to Kintone data in Akorbi Digital RunMyProcess.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy Desktop
Connect to ZohoPeople data in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoPeople.
-
Access Marketo Data from MySQL in Amazon QuickSight
Connect to Marketo and build visualizations of Marketo data using a MySQL Connection in Amazon QuickSight.
-
Access Live Typeform Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Typeform data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for Instagram in MicroStrategy
Connect to Instagram data in MicroStrategy Developer using the CData Software JDBC Driver for Instagram.
-
Extract, Transform, and Load Close Data in Informatica PowerCenter
Create a simple Workflow for Close data in Informatica PowerCenter.
-
How to Access Adobe Commerce Data Using Entity Framework
This article shows how to access Adobe Commerce data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy Web
Connect to GetResponse data in MicroStrategy Web using the CData Software JDBC Driver for GetResponse.
-
DataBind Controls to Customer.io Data in Delphi
DataBind to Customer.io data in Delphi with standard data access components and controls.
-
Excel Spreadsheet Automation on Google Ads Data with the QUERY Formula
Pull data from Google Ads, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Stripe Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Stripe data to a JSON file on disk.
-
How to work with Clio Data in Apache Spark using SQL
Access and process Clio Data in Apache Spark using the CData Software JDBC Driver.
-
How to create an RPA flow for Monday.com Data in UiPath Studio
Use the Monday.com ODBC Driver to create workflows that access real-time Monday.com data without any coding.
-
How to Build an ETL App for Nethunt Data in Python with CData
Create ETL applications and real-time data pipelines for Nethunt data in Python with petl.
-
Build an OLAP Cube in SSAS from Optimizely Data
Establish a connection to Optimizely data data from SQL Server Analysis Services, and use the Optimizely Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Egnyte Data to Multiple Databases
Replicate Egnyte data to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for HubSpot in SAS for Real-Time Reporting and Analytics
Connect to real-time HubSpot data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HubSpot.
-
Visualize GraphQL Data in TIBCO Spotfire through ADO.NET
Integrate GraphQL data into dashboards in TIBCO Spotfire.
-
Access Live SAP HANA Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA data from your Excel spreadsheets.
-
Integrating Claude Code with Outreach.io Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Outreach.io data within assisted coding and automated development workflows.
-
Integrate Live WordPress Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live WordPress data to Blue Prism using the CData ODBC Driver for WordPress to create automated workflows for repetitive business tasks.
-
Migrating data from Brex to Databricks using CData SSIS Components.
Easily push Brex data to Databricks using the CData SSIS Tasks for Brex and Databricks.
-
Visualize xBase Data in Sisense
Create an ElastiCube in Sisense app with access to xBase data.
-
CapsuleCRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to CapsuleCRM data through CData Connect AI using different applications and tools.
-
Access Live Cvent Data in Coginiti Pro
Connect to and query live Cvent data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Flowlu
Create an ODBC connection to Flowlu in Informatica and browse and transfer Flowlu data.
-
Getting Started with the CData Power BI Connector for Tally
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Tally.
-
How to use SQLAlchemy ORM to access MYOB AccountRight Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MYOB AccountRight data.
-
How to Connect to Live Anaplan 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 Anaplan data for you.
-
Build Visualizations of Optimizely Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Optimizely data in Birst.
-
Automated Continuous Pipedrive Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipedrive replication to SQL Server.
-
Getting Started with the CData ADO.NET Provider for Excel Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Excel Online.
-
Connect to Productboard Data in DBArtisan
Use wizards in DBArtisan to configure Productboard data as a data source.
-
Manage Aweber Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aweber.
-
Integrating Claude Code CLI with Gong 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.
-
Query Live EnterpriseDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live EnterpriseDB data through a conversational interface.
-
Connect to Klaviyo Data in Jaspersoft Studio
Execute SQL to remote Klaviyo data in Jaspersoft Studio.
-
Getting Started with the CData Connect AI Python SDK for Salesforce Pardot
Install the CData Connect AI Python SDK to read and write live Salesforce Pardot data with standard DB-API 2.0 Python code.
-
Publish Crystal Reports on PagerDuty Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PagerDuty data.
-
Easily Integrate MariaDB Data in Lazarus Pascal IDE
Learn how to easily integrate live MariaDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Elorus Data from MySQL in PHP
Connect to Elorus through the standard MySQL libraries in PHP.
-
Connect to Microsoft Exchange Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Exchange data from your AWS Glue jobs.
-
How to connect and process Certinia data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Certinia data.
-
Connect to HCL Domino Data in Claris FileMaker Pro
Use the CData ODBC Driver for HCL Domino in FileMaker Pro to connect to HCL Domino and work with HCL Domino data in your FileMaker applications.
-
Automated Continuous HubDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HubDB replication to delimited files (CSV/TSV).
-
Integrating Codex with GraphQL 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.
-
Integrate Live Pinterest Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Pinterest from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Pinterest data.
-
DataBind Dotmailer Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Dotmailer data to a chart.
-
Visualize Live Monday.com Data in the Power BI Service
Use CData Connect AI to connect to live Monday.com data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access ConvertKit Data from MySQL in PHP
Connect to ConvertKit through the standard MySQL libraries in PHP.
-
Use Microsoft Copilot Studio to talk to your Airtable 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 Airtable data for you.
-
Build ADP-Connected Apps in Choreo
Use CData Connect AI to connect to ADP Data from Choreo and build custom apps using live ADP data.
-
Use Azure AI Foundry to Talk to Your GetResponse 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 GetResponse data for you.
-
Process & Analyze Twitter Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twitter Ads Data.
-
Automated Continuous Flowlu Replication to Oracle
Use CData Sync for automated, continuous, customizable Flowlu replication to Oracle.
-
How to Connect to & Open Cosmos DB Data in Microsoft Excel
This article uses the CData ODBC driver for Cosmos DB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Claude Code with CSV Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on CSV data within assisted coding and automated development workflows.
-
Access Live AfterShip Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live AfterShip data from your Google Sheets.
-
How to Easily Query HCL Domino Data in OpenOffice Base
Connect to HCL Domino data in OpenOffice Base using the CData ODBC Driver for HCL Domino and generate reports with live data insights.
-
Automated Continuous ZohoExpense Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Apache Kafka.
-
Integrate with live Avalara AvaTax Data in Jitterbit
Use CData Connect AI to connect to and integrate live Avalara AvaTax data in Jitterbit.
-
Connect to AfterShip Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to AfterShip and work with AfterShip data in your FileMaker applications.
-
How to connect to Humanity Data from Spring Boot
Connect to Humanity in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Sybase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sybase data from Crystal Reports.
-
Access Live Azure Data Catalog Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Catalog data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Enable the MailChimp JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MailChimp data.