CData Software - Knowledge Base
Recent Articles
-
Create Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly data.
-
Use Agno to Talk to Your ZohoInvoice 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 ZohoInvoice data for you.
-
DataBind Charts to Oracle Sales Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Sales 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.
-
Create Reports from MailChimp Data in Looker Studio
Use CData Connect AI to gain access to live MailChimp data and create custom reports in Looker Studio.
-
Extract, Transform, and Load EnterpriseDB Data in Informatica PowerCenter
Create a simple Workflow for EnterpriseDB data in Informatica PowerCenter.
-
Access Live Sugar CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sugar CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Foursquare Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Foursquare replication to Apache Kafka.
-
Rapidly Develop Everhour-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 Everhour.
-
Use Dash to Build Web Apps on Timely Data via CData Connect AI
Build interactive Dash web apps on live Timely data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Pipedrive Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pipedrive replication to AlloyDB.
-
Visualize Live iContact Data in the Power BI Service
Use CData Connect AI to connect to live iContact data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Edit and Search External Xero Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Xero data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero Data objects that you can access from apps and the dashboard.
-
How to Connect to Live XML 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 XML data without replication.
-
Automated Continuous Aha! Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Aha! replication to Amazon Redshift.
-
Write a Simple Go Application to work with ConvertKit Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ConvertKit data.
-
Publish Crystal Reports on Reckon Accounts Hosted Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Reckon Accounts Hosted data.
-
Integrating Claude Code CLI with Postmark 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 ConvertAPI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConvertAPI and work with ConvertAPI data in your FileMaker applications.
-
Use JayDeBeApi to access Microsoft Planner Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Planner data.
-
Easily Integrate Auth0 Data in Lazarus Pascal IDE
Learn how to easily integrate live Auth0 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Add EmailOctopus Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for EmailOctopus with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bridge MailerLite Connectivity with Apache NiFi
Access and process MailerLite data in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Outreach.io
Provide connectivity to Outreach.io data through an SAP BusinessObjects universe.
-
Integrate Trae with Live LDAP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live LDAP objects from within the AI-powered IDE.
-
Integrating LangGraph with Supabase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Supabase data within automated workflows.
-
Prepare, Blend, and Analyze XML Data in Alteryx Designer (ODBC)
Build workflows to access live XML data for self-service data analytics.
-
How to Access SpaceX Data Using Entity Framework
This article shows how to access SpaceX data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate VWO Data to Multiple Databases via the CData Sync CLI
Replicate VWO data to disparate databases with a single configuration.
-
Publish Reports with GitLab Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GitLab data.
-
Import Real-Time Pushbullet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pushbullet data in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Drive data for you.
-
Automate Impala Data Replication to Couchbase
Use CData Sync to Customize and automate Impala data replication to Couchbase.
-
Connect to Impala Data from a Connection Pool in JBoss
Integrate Impala data into Java servlets: Use the Management Console in JBoss to install the Impala JDBC Driver.
-
Automated Continuous IBM Informix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon S3.
-
Analyze Discourse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Discourse data with the CData JDBC Driver for Discourse.
-
Connecting GenSpark with Bannerbear Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Bannerbear data without any replication or custom integration required.
-
Connect to PabblySubscriptions Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PabblySubscriptions and work with PabblySubscriptions data in your FileMaker applications.
-
Getting Started with the CData JDBC Driver for Accelo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Accelo.
-
Connecting Mastra with Coda Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Coda data, no replication required.
-
Connect to xBase Data in CloverDX (formerly CloverETL)
Transfer xBase data using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Chargebee to Google BigQuery using CData SSIS Components.
Easily push Chargebee data to Google BigQuery using the CData SSIS Tasks for Chargebee and Google BigQuery.
-
Working with Jodoo Data in LINQPad
Execute LINQ queries to Jodoo data in LINQPad.
-
Access Live Exact Online Data in AWS Lambda
Connect to live Exact Online data in AWS Lambda using the CData JDBC Driver.
-
Connect to Missive Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Missive and work with Missive data in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Campaign Manager 360 data within intelligent agent workflows.
-
Connect to Qualaroo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Qualaroo and work with Qualaroo data in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate Simplesat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Simplesat data to SQL Server.
-
Integrate Google's Antigravity Agent with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Grafana data using the Model Context Protocol.
-
Query Xero Data as a SQL Server Database in Node.js
Execute SQL Server queries against Xero data from Node.js.
-
Use ChatGPT to Talk to Your Freshservice 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 Freshservice data for you.
-
How to integrate Metabase with Yelp Data
Use CData Connect AI to connect to live Yelp data and create an interactive dashboard in Metabase from Yelp data.
-
Build CircleCI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CircleCI data and build web apps with connectivity to live CircleCI data.
-
Connect to Pipeliner CRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Pipeliner CRM data.
-
Build Automated SQL Server-Connected Workflows in Zapier
Use CData Connect AI to connect to live SQL Server data and build automated workflows in Zapier.
-
Getting Started with the CData Excel Add-In for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cosmos DB.
-
Query Blackbaud FE NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Blackbaud FE NXT data from Node.js.
-
Visualize Email Data in TIBCO Spotfire through ADO.NET
Integrate Email data into dashboards in TIBCO Spotfire.
-
Connect to Salesforce Marketing Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce Marketing data.
-
Replicate Sybase Data to Multiple Databases via the CData Sync CLI
Replicate Sybase data to disparate databases with a single configuration.
-
Create SharePoint Excel Services Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SharePoint Excel Services from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bridge Keap Connectivity with Apache NiFi
Access and process Keap data in Apache NiFi using the CData JDBC Driver.
-
How to integrate Metabase with GitLab Data
Use CData Connect AI to connect to live GitLab data and create an interactive dashboard in Metabase from GitLab data.
-
Integrate Google Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Ads data from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Lake Storage
Provide connectivity to Azure Data Lake Storage data through an SAP BusinessObjects universe.
-
Integrate Live Customer.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Customer.io data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating Antigravity CLI with Kintone data via CData CLI
Connect Kintone data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to integrate Metabase with Shippo Data
Use CData Connect AI to connect to live Shippo data and create an interactive dashboard in Metabase from Shippo data.
-
Connect to Microsoft Teams Data in Aqua Data Studio
Access Microsoft Teams data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Crystal Reports on CouchDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CouchDB data.
-
Connect to Jira Data in NetBeans
Connect to Jira data in NetBeans with the data source configuration wizard.
-
Build MVC Applications with Connectivity to LDAP Objects
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LDAP from an ASP.NET MVC application.
-
Operational Reporting on Grafana Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Grafana data.
-
How to Create Power BI Visual Reports with Real-Time ChartMogul Data
Use CData Power BI Connectors to visualize ChartMogul data in Power BI.
-
Integrate Live Google Contacts Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Contacts data to Blue Prism using the CData ODBC Driver for Google Contacts to create automated workflows for repetitive business tasks.
-
DataBind YouTube Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for YouTube Analytics with the DevExpress Windows Forms and Web controls to provide YouTube Analytics data to a chart.
-
Integrate Devin with Live Zoho CRM 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 Zoho CRM data.
-
How to Create Power BI Visual Reports with Real-Time Billsby Data
Use CData Power BI Connectors to visualize Billsby data in Power BI.
-
Connect to Adobe Commerce Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Commerce data from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Commerce.
-
Connect to Live HDFS Data in MicroStrategy through CData Connect AI
Create a live connection to HDFS Data in CData Connect AI and connect to your HDFS data from MicroStrategy.
-
How to Connect DBeaver to Avaza via a JDBC Driver
Manage Avaza data with visual tools in DBeaver like the query browser.
-
Import Real-Time Google Tasks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Tasks data in ColdFusion.
-
Visualize Drip Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Drip data into TIBCO Spotfire.
-
LINQ to Accelo 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 Accelo Data Provider.
-
Analyze ClickUp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ClickUp from Power Pivot. You will use the Table Import Wizard to load ClickUp data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Telegram Data in Tableau
The CData ODBC driver for Telegram enables you integrate Telegram data into Tableau dashboards.
-
Use JayDeBeApi to access Close Data in Python
Use standard Python scripting and the development environment of your choice to access live Close data.
-
Visualize Office 365 Data in TIBCO Spotfire through OData
Integrate Office 365 data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Excel Add-In for REST
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for REST.
-
How to Access Live SparkPost Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SparkPost enables you to integrate SparkPost data into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic Accelo Grids Using the Infragistics XamDataGrid
Learn how you can connect Accelo to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time IBM Cloud Object Storage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use IBM Cloud Object Storage data in ColdFusion.
-
How to create Oracle HCM Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle HCM Cloud data in MySQL .
-
How to Query Live Google Translate Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Translate data data in natural language using Python.
-
Connect to Apify Data from HeidiSQL
Use CData Connect AI to connect to and query live Apify data from HeidiSQL.
-
How to Work with Planio Data in AWS Glue Jobs Using JDBC
Connect to Planio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Oracle Data in Coginiti Pro
Connect to and query live Oracle data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
Natively Connect to SAP BusinessObjects BI Data in PHP
The CData ODBC driver for SAP BusinessObjects BI enables you to create PHP applications with connectivity to SAP BusinessObjects BI data. Leverage the native support for ODBC in PHP.
-
Build Google Analytics-Connected Apps in Choreo
Use CData Connect AI to connect to Google Analytics Data from Choreo and build custom apps using live Google Analytics data.
-
Access Live ZohoMarketingHub Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live ZohoMarketingHub data through MCP integration.