CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy
Connect to Freshservice data in MicroStrategy Developer using the CData Software ODBC Driver for Freshservice.
-
Object-Relational Mapping (ORM) with SAP Fieldglass 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 SAP Fieldglass data into a Java-based ORM framework, Hibernate.
-
Publish Reports with Customer.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Customer.io data.
-
Integrating Kiro with BambooHR 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 Jumpseller in MicroStrategy
Connect to Jumpseller data in MicroStrategy Developer using the CData Software ODBC Driver for Jumpseller.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Synapse
Create Azure Synapse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Live Timely Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Timely enables you to integrate Timely data into workflows built using Microsoft Power Automate Desktop.
-
Object-Relational Mapping (ORM) with Mailjet 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 Mailjet data into a Java-based ORM framework, Hibernate.
-
Create Vertica-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Vertica Data from Klipfolio and build custom visualizations using live Vertica data.
-
Build MVC Applications with Connectivity to Typeform Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Typeform from an ASP.NET MVC application.
-
How to Connect to BigCommerce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to BigCommerce data. Leverage the pyodbc module for ODBC in Python.
-
Build Google Ad Manager Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Ad Manager data and build visualizations in Tableau.
-
Bridge Discord Connectivity with Apache NiFi
Access and process Discord data in Apache NiFi using the CData JDBC Driver.
-
Integrate Goose with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Kintone data from within the local AI agent.
-
Connect to Amazon S3 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon S3 to connect to Amazon S3 data and execute queries in PowerBuilder.
-
How to Work with Microsoft Planner Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Planner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Microsoft Copilot Studio to talk to your ZohoMarketingHub 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 ZohoMarketingHub data for you.
-
How to Query Dropbox Data in MySQL Workbench
Execute MySQL queries against live Dropbox data from MySQL Workbench.
-
How to Connect to Live Sage Intacct Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sage Intacct data securely in real time.
-
Integrate GitLab Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to GitLab data and integrate live GitLab data into your Power Automate tasks.
-
Connect and Query Live Wistia Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Wistia data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Real-Time Guru Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Guru data in Power Apps.
-
Integrate Vercel Data in the Pentaho Report Designer
Publish reports based on Vercel data in the Pentaho BI tool.
-
Automated Continuous Sybase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sybase replication to Apache Cassandra.
-
Build MVC Applications with Connectivity to FreshBooks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FreshBooks from an ASP.NET MVC application.
-
Connect to Aircall Data in DBArtisan
Use wizards in DBArtisan to configure Aircall data as a data source.
-
Build Automated Workflows with Live Power BI XMLA Data in Workato
Use CData Connect AI to connect to live Power BI XMLA data and build automated workflows in Workato.
-
Connect to Wave Financial Data in ACL Analytics
Connect to Wave Financial data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Wave Financial data.
-
Create Bright Data-Connected Business Apps in AppSheet
Connect to Bright Data Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Bright Data data.
-
Build Data Flows from Instagram to SQL Server using SSIS
Easily back up Instagram data to SQL Server using the SSIS components for Instagram.
-
Getting Started with the CData Excel Add-In for Rootly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Rootly.
-
Amazon DynamoDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon DynamoDB facts in real time.
-
Create Reports with eBay Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay data.
-
Create Informatica Mappings From/To a JDBC Data Source for Reply.io
Create Reply.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Jira Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jira replication to delimited files (CSV/TSV).
-
Connect to Live Gmail Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Gmail in CData Connect AI and connect to your Gmail data from PostgreSQL.
-
Integrate Live GitLab 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 GitLab data from within the IDE.
-
Build AI Agents with SQL Server 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 SQL Server data through CData Connect AI.
-
Automate ServiceNow Data Replication to Azure Data Lake
Use CData Sync to customize and automate ServiceNow data replication to Azure Data Lake.
-
Automate Pipeliner CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Pipeliner CRM data replication to Azure Synapse.
-
Integrate Open WebUI with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Epicor Kinetic data from within the chat interface.
-
Query Gorgias Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Gorgias data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Landbot
Provide connectivity to Landbot data through an SAP BusinessObjects universe.
-
Connect to ShipEngine Data from a Connection Pool in Jetty
The ShipEngine JDBC Driver supports connection pooling: This article shows how to connect faster to ShipEngine data from Web apps in Jetty.
-
Automated Continuous SAP Concur Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Concur replication to Google Cloud SQL.
-
Automate Amazon DynamoDB Data Replication to SAP HANA
Use CData Sync to customize and automate Amazon DynamoDB data replication to SAP HANA.
-
Integrate Supabase Data into Power Automate Desktop using CData Connect
CData Connect for Supabase Data enables you to integrate Supabase data into workflows built using Microsoft Power Automate Desktop.
-
Connect to AfterShip Data in Ruby
Connect to AfterShip data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google's Vertex AI Agent with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Ad Manager data within intelligent workflows.
-
Connect to Retently 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 Retently and work with Retently data in your FileMaker application.
-
Use the CData Software ODBC Driver for Teradata in SAS for Real-Time Reporting and Analytics
Connect to real-time Teradata data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Teradata.
-
DataBind Charts to ZarMoney Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZarMoney data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate REST with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate REST with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to REST data.
-
Create Reports with Cosmos DB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cosmos DB data.
-
Build Semantic Layer Views for PhantomBuster Data in APOS Live Data Gateway
Use the CData Connector for PhantomBuster in APOS Live Data Gateway to build Semantic Layer Views for PhantomBuster data.
-
Use Azure AI Foundry to Talk to Your Twitter Ads 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 Twitter Ads data for you.
-
How to Easily Query Stack Exchange Data in OpenOffice Base
Connect to Stack Exchange data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Dash to Build Web Apps on Mailgun Data via CData Connect AI
Build interactive Dash web apps on live Mailgun data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy Desktop
Connect to Figshare data in MicroStrategy Desktop using the CData Software JDBC Driver for Figshare.
-
Integrate Live SAS xpt Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAS xpt data to Blue Prism using the CData ODBC Driver for SAS xpt to create automated workflows for repetitive business tasks.
-
Connect to SendGrid Data in JRuby
Create a simple JRuby app with access to live SendGrid data.
-
Create SSAS Tabular Models from Dotmailer Data
How to build a SQL Server Analysis Service Tabular Model from Dotmailer data using CData drivers.
-
Automate Exact Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Exact Online data from PowerShell? This article demonstrates how to utilize the Exact Online Cmdlets for tasks like connecting to Exact Online data, automating operations, downloading data, and more.
-
Integrate Open WebUI with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live CSV data from within the chat interface.
-
Integrate Theia IDE with Live Sage 200 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 Sage 200 data from within the development environment.
-
DataBind Microsoft Planner Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Planner with the DevExpress Windows Forms and Web controls to provide Microsoft Planner data to a chart.
-
Integrating Dataiku with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Redis data.
-
How to Query Klipfolio Data in MySQL Workbench
Execute MySQL queries against live Klipfolio data from MySQL Workbench.
-
Integrating OpenCode with Authorize.Net 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.
-
Stream Hugging Face Data into Apache Kafka Topics
Access and stream Hugging Face data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Datadog 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 Datadog data.
-
Integrating Antigravity CLI with Supabase data via CData CLI
Connect Supabase data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software ODBC Driver for Azure Table in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Table data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Table.
-
Automate Stack Exchange Data Replication to Azure Data Lake
Use CData Sync to customize and automate Stack Exchange data replication to Azure Data Lake.
-
Create Reports with QuickBooks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks data.
-
Access Act CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act CRM data from your Oracle system.
-
Query SendPulse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SendPulse data from Node.js.
-
How to update EnterpriseDB from Excel
This article explains how to transfer data from Excel to EnterpriseDB using the Excel Add-In for EnterpriseDB.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB data in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon DynamoDB.
-
Connect Hive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Hive data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Gmail Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Gmail facts in real time.
-
Use the CData Software JDBC Driver for Oracle Eloqua Reporting in MicroStrategy
Connect to Oracle Eloqua Reporting data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Eloqua Reporting.
-
Google Cloud Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Cloud Storage facts in real time.
-
Viewing Parallel Data in RAD Studio Data Explorer
How to view Parallel data in RAD Studio Data Explorer using the CData ODBC Driver for Parallel.
-
Natively Connect to Hugging Face Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Hugging Face data. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for ZohoSubscriptions on an SSRS Report Server
Connect to ZohoSubscriptions data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Greenplum Data in Talend Cloud Data Management Platform
Connect Greenplum Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Greenplum.
-
Access Oracle Financials Cloud 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 Oracle Financials Cloud data.
-
Automated Continuous Perplexity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Perplexity replication to Snowflake.
-
Using the CData Software ODBC Driver for Sendwithus in PyCharm
Connect to Sendwithus as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sendwithus.
-
Use Dash to Build Web Apps on XML Data via CData Connect AI
Build interactive Dash web apps on live XML data using pandas and the CData Connect AI Python SDK.
-
Query Excel Online Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Excel Online data from Node.js.
-
Query Greenhouse Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Greenhouse entities in PHP by modeling them as objects.
-
Create Data Visualizations in Cognos BI with Twitter Ads Data
Access Twitter Ads data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Object-Relational Mapping (ORM) with Discourse 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 Discourse data into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData Tableau Connector for Office 365
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Office 365.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy Desktop
Connect to Reckon Accounts Hosted data in MicroStrategy Desktop using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Object-Relational Mapping (ORM) with Zoom 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 Zoom data into a Java-based ORM framework, Hibernate.
-
Connect MailChimp Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MailChimp data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Factorial Replication to SQL Server
Use CData Sync for automated, continuous, customizable Factorial replication to SQL Server.