CData Software - Knowledge Base
Recent Articles
-
Visualize CSV Data in Sisense
Create an ElastiCube in Sisense app with access to CSV data.
-
Use ChatGPT to Talk to Your EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your EnterpriseDB data for you.
-
Query Attio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Attio data from Node.js.
-
How to Connect to Live ZohoInvoice Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoInvoice data without replication.
-
Automated Continuous SharePoint Excel Services Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon Redshift.
-
Getting Started with the CData JDBC Driver for ServiceNow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ServiceNow.
-
Connect to CSV Data in Jaspersoft Studio
Execute SQL to remote CSV data in Jaspersoft Studio.
-
Build MailChimp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MailChimp data.
-
Connect to Adobe Commerce Data in Google Apps Script via Connect AI
Use CData Connect AI to access Adobe Commerce data in Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for CSV
Create an ODBC connection to CSV in Informatica and browse and transfer CSV data.
-
Connect to Superchat Data from PowerBuilder via ADO.NET
This article demonstrates how to access Superchat data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Klipfolio in Microsoft Power Query
You can use the CData Klipfolio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klipfolio data into Microsoft Power Query.
-
Build Dashboards with Opsgenie Data in Dundas BI
Create dynamic dashboards and perform analytics based on Opsgenie data in Dundas BI.
-
Automated Continuous Azure DevOps Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure DevOps replication to IBM DB2.
-
Create Datasets from Samanage in Domo Workbench and Build Visualizations of Samanage Data in Domo
Use the CData Software ODBC Driver for Samanage to create datasets from Samanage data in Domo Workbench and then build visualizations in the Domo service.
-
Workable Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Workable facts in real time.
-
How to connect to Perplexity Data in DBVisualizer
Integrate Perplexity data with visual data analysis tools and data connection wizards in DBVisualizer
-
Design BIRT Reports on SFTP Data
Provide current SFTP data to your embedded analytics.
-
Search External BenchmarkEmail Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of BenchmarkEmail data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BenchmarkEmail Data objects that you can access from apps and the dashboard.
-
Viewing GitLab Data in RAD Studio Data Explorer
How to view GitLab data in RAD Studio Data Explorer using the CData ODBC Driver for GitLab.
-
Access YouTube Analytics 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 YouTube Analytics data.
-
Create Informatica Mappings From/To a JDBC Data Source for Bright Data
Create Bright Data data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Data Flows from BigCommerce to SQL Server using SSIS
Easily back up BigCommerce data to SQL Server using the SSIS components for BigCommerce.
-
Use Databricks Agent Bricks to Talk to Your Zuora Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zuora data for you.
-
How to Connect to Live Email Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Email data for you.
-
How to Connect to Live DocuSign Data 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 DocuSign data for you.
-
Automated Pipeline CRM Data Replication to Teradata
Use CData Sync to Customize and automate Pipeline CRM data replication to Teradata.
-
How to Connect to Live Twitter Ads 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 Twitter Ads data for you.
-
Integrating Claude Code with Certinia Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Certinia data within assisted coding and automated development workflows.
-
Integrate MarkLogic Data in the Pentaho Report Designer
Publish reports based on MarkLogic data in the Pentaho BI tool.
-
Visualize Live Smartsheet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Smartsheet data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Guru-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Guru data and build web apps with connectivity to live Guru data.
-
Access SAP Hybris C4C Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Hybris C4C data from HeidiSQL.
-
Create Reports with ZohoMarketingHub Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoMarketingHub data.
-
Access Float 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 Float data.
-
Viewing Monday.com Data in RAD Studio Data Explorer
How to view Monday.com data in RAD Studio Data Explorer using the CData ODBC Driver for Monday.com.
-
ADO.NET Provider Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData ADO.NET Provider
-
How to Build an ETL App for Typeform Data in Python with CData
Create ETL applications and real-time data pipelines for Typeform data in Python with petl.
-
Enable the Office 365 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Office 365 data.
-
Create Apps from SingleStore Data in Qlik Sense Cloud
Use CData Connect AI to connect to SingleStore Data and build apps from live SingleStore data in Qlik Sense Cloud.
-
Use Microsoft Copilot Studio to talk to your WooCommerce 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 WooCommerce data for you.
-
How to Connect to Live SAP SuccessFactors LMS Data 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 SAP SuccessFactors LMS data for you.
-
Build a Singer.io Tap for Campaigner With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Campaigner data using the CData Python Connector.
-
Work with Live XML Data in Power Query
Use CData Connect AI to connect to XML data and work with live XML data in Microsoft Power Query.
-
Create EnterpriseDB-Connected Applications in Appsmith
Connect to EnterpriseDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to EnterpriseDB data.
-
Integrate with Airtable Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Airtable data to a JSON file on disk.
-
How to use SQLAlchemy ORM to access Salesloft Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesloft data.
-
How to integrate Snowflake with Apache Airflow
Access and process Snowflake data in Apache Airflow using the CData JDBC Driver.
-
Connect to RSS Feeds Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for RSS and the Script function in FileMaker Pro to connect to RSS and work with RSS feeds in your FileMaker application.
-
A PostgreSQL Interface for FTP Data (MySQL Remoting via JDBC)
Use the Remoting features of the FTP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of Oracle Eloqua Reporting Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Eloqua Reporting data in Birst.
-
Getting Started with the CData JDBC Driver for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SurveyMonkey.
-
Integrate Live Adobe Experience Manager Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Experience Manager from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Experience Manager data.
-
Integrate Live Xero 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 Xero data from within the IDE.
-
Build an OLAP Cube in SSAS from Avro Data
Establish a connection to Avro data data from SQL Server Analysis Services, and use the Avro Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Testmonitor Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Testmonitor data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Impala Data from a Connection Pool in Jetty
The Impala JDBC Driver supports connection pooling: This article shows how to connect faster to Impala data from Web apps in Jetty.
-
Getting Started with the CData ODBC Driver for Customer.io
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Customer.io.
-
How to Connect to Live Azure DevOps Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Azure DevOps data for you.
-
Integrating Codex with Instantly 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.
-
Connect to Mistral AI Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mistral AI data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access ZohoInvoice Data from MySQL in Amazon QuickSight
Connect to ZohoInvoice and build visualizations of ZohoInvoice data using a MySQL Connection in Amazon QuickSight.
-
How to integrate Zuora with Apache Airflow
Access and process Zuora data in Apache Airflow using the CData JDBC Driver.
-
Edit and Search External Adobe Commerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Adobe Commerce data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Adobe Commerce Data objects that you can access from apps and the dashboard.
-
Build a Singer.io Tap for Autopilot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Autopilot data using the CData Python Connector.
-
Automate Square Data Replication to Azure Data Lake
Use CData Sync to customize and automate Square data replication to Azure Data Lake.
-
Build Strava-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Strava data and build web apps with connectivity to live Strava data.
-
Import and Visualize RabbitMQ Data in Power View
Create data visualizations based on RabbitMQ data in Excel.
-
Access Bitly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bitly data from HeidiSQL.
-
Build Visualizations of Close Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Close data in Birst.
-
Build TaxJar-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for TaxJar Data and create custom apps in Bubble.
-
Connect to SharePoint Excel Services Data in Ruby
Connect to SharePoint Excel Services data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Microsoft Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to MySQL.
-
Connect to Microsoft Teams Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Teams as an External Source in Dremio.
-
Create Toggl-Connected Dashboards in Grafana
Connect to Toggl Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Toggl data.
-
Automated Continuous Grafana Replication to MongoDB
Use CData Sync for automated, continuous, customizable Grafana replication to MongoDB.
-
Using the CData Software ODBC Driver for AfterShip in PyCharm
Connect to AfterShip as an ODBC data source in PyCharm using the CData Software ODBC Driver for AfterShip.
-
Provide OData Services of XML Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for XML data by developing a WCF Service Application.
-
Viewing Xero Data in RAD Studio Data Explorer
How to view Xero data in RAD Studio Data Explorer using the CData ODBC Driver for Xero.
-
Use the CData ODBC Driver for Smartsheet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Smartsheet to connect to Smartsheet data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Smartsheet data in Excel.
-
Integrate Live Toggl Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Toggl from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Toggl data.
-
Build Data Flows from BambooHR to SQL Server using SSIS
Easily back up BambooHR data to SQL Server using the SSIS components for BambooHR.
-
Publish Moosend-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Moosend data.
-
Object-Relational Mapping (ORM) with Paymo 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 Paymo data into a Java-based ORM framework, Hibernate.
-
How to Build an ETL App for QuickBooks Time Data in Python with CData Connect AI
Extract and transform live QuickBooks Time data in Python with petl and the CData Connect AI Python SDK.
-
Build NASA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NASA data and build web apps with connectivity to live NASA data.
-
Automated Continuous FHIR Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FHIR replication to Azure SQL Database.
-
Automate ADP Data Replication to Azure Data Lake
Use CData Sync to customize and automate ADP data replication to Azure Data Lake.
-
Integrate with Retently Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Retently data to a JSON file on disk.
-
Build XML-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live XML data.
-
Natively Connect to Vault CRM Data in PHP
The CData ODBC driver for Vault CRM enables you to create PHP applications with connectivity to Vault CRM data. Leverage the native support for ODBC in PHP.
-
Connect and Query Live GitLab Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitLab data into Databricks and enable direct, live querying and analysis without replication.
-
How to import Mixpanel Data into Apache Solr
Use the CData Software JDBC Driver for Mixpanel in Data Import Handler and create an automated import of Mixpanel data to Apache Solr Enterprise Search platform.
-
Integrate with MYOB AccountRight Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MYOB AccountRight data in SnapLogic.
-
Connect to LaunchDarkly in SpagoBI
Create reports featuring live LaunchDarkly data in SpagoBI Studio. Host LaunchDarkly reports on SpagoBI Server.
-
Connect to BenchmarkEmail Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BenchmarkEmail data from Filemaker Pro on Mac.
-
Access Live Eventbrite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Eventbrite data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Real-Time Act CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Act CRM and Dataflow to import and use Act CRM data in Power Apps.
-
How to Connect Azure DevOps Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure DevOps data in real time using natural language.
-
Integrate LinkedIn Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LinkedIn Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LinkedIn Ads data.