CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in Azure Data Catalog Data with Power Map
Create data visualizations with Azure Data Catalog data in Power Map.
-
Create SSAS Tabular Models from Aweber Data
How to build a SQL Server Analysis Service Tabular Model from Aweber data using CData drivers.
-
Build Google Ad Manager-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Ad Manager Data and create custom apps in Mendix.
-
How to Connect to Live Paymo 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 Paymo data for you.
-
Connect to Microsoft Planner Data in CloverDX (formerly CloverETL)
Transfer Microsoft Planner data using the visual workflow in the CloverDX data integration tool.
-
Validate BigCommerce Data with QuerySurge
Access and validate BigCommerce data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Dotmailer Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dotmailer replication to SQL Server.
-
Automate Hubstaff Data Replication to Azure Synapse
Use CData Sync to customize and automate Hubstaff data replication to Azure Synapse.
-
Query Invoiced Data in DataGrip
Create a Data Source for Invoiced in DataGrip and use SQL to query live Invoiced data.
-
Deploy the ADO.NET Provider for SAP BusinessObjects BI on an SSRS Report Server
Connect to SAP BusinessObjects BI 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.
-
Connect to Google Campaign Manager 360 Data in Aqua Data Studio
Access Google Campaign Manager 360 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live WordPress 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 WordPress data for you.
-
Connect to NASA Data from a Connection Pool in JBoss
Integrate NASA data into Java servlets: Use the Management Console in JBoss to install the NASA JDBC Driver.
-
Model Zuora Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zuora, enabling the direct import of real-time Zuora data.
-
Configure the CData JDBC Driver for SAP Ariba Procurement in a Connection Pool in Tomcat
Connect to SAP Ariba Procurement data from a connection pool in Tomcat.
-
Connect ConvertAPI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ConvertAPI with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ConvertKit Data in DBArtisan
Use wizards in DBArtisan to configure ConvertKit data as a data source.
-
How to create Access federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Access data in MySQL .
-
How to load Salesforce Data 360 data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Data 360 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Reckon Data in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon data in Google Apps Script.
-
Build MVC Applications with Connectivity to GetResponse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GetResponse from an ASP.NET MVC application.
-
Automated Continuous Clockify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Clockify replication to MongoDB.
-
DataBind Charts to DB2 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to DB2 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.
-
Access ElevenLabs Data from MySQL in PHP
Connect to ElevenLabs through the standard MySQL libraries in PHP.
-
How to Visualize Microsoft Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Ads data in Python.
-
Create Dashboards and Visualize Live Redshift Data in Geckoboard
Use CData Connect AI to connect to live Redshift data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous ActiveCampaign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to delimited files (CSV/TSV).
-
How to Connect to Live Salesforce Data 360 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 Salesforce Data 360 data for you.
-
Build Retently-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Retently data.
-
Feed Cassandra Data into FineReport
How to set Cassandra data as a JDBC data source in FineReport.
-
Creating Mailjet-Connected Applications in Unqork
You can use CData Connect AI to feed Mailjet data to Unqork and build custom business apps.
-
Integrating Codex with Testmonitor 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 Claude to Talk to Your Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Sugar CRM data for you.
-
Integrating Boomi Agentstudio with OData Services via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to OData services, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import HubSpot Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to HubSpot Data and provide access to live HubSpot data for custom reports in the Power BI Service.
-
Analyze Twitter Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twitter Ads data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Visualize ZohoSubscriptions Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ZohoSubscriptions data in Python.
-
Build Grafana-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Grafana data and build web apps with connectivity to live Grafana data.
-
Integrating LangChain with Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Teradata data within automated workflows.
-
Access Spark Data from MySQL in PHP
Connect to Spark through the standard MySQL libraries in PHP.
-
Analyze Gorgias Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gorgias from Power Pivot. You will use the Table Import Wizard to load Gorgias data. You can visually build the import query or use any SQL supported by the driver.
-
Build AI Agents with Salesforce Data 360 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 Salesforce Data 360 data through CData Connect AI.
-
How to connect and process Sugar CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sugar CRM data.
-
How to connect and process Amazon Athena data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon Athena data.
-
Build SAP HANA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA data.
-
Integrating Codex 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.
-
Integrate Dify with Live Toggl Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Toggl data.
-
Integrating Antigravity CLI with IBM Informix data via CData CLI
Connect IBM Informix data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live XML Data Using the Low-Code Development Platform of Mendix
Connect XML data with Mendix to build apps using the CData JDBC Driver for XML.
-
Model Sage Intacct Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sage Intacct, enabling the direct import of real-time Sage Intacct data.
-
Add Facebook Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Facebook Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting data through an SAP BusinessObjects universe.
-
Access Ontraport Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Ontraport data from your Oracle system.
-
Integrate Google's Antigravity Agent with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Data Catalog data using the Model Context Protocol.
-
Connect to and Visualize Live Perigon Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Perigon data.
-
How to Connect to Live ServiceNow 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 ServiceNow data for you.
-
Import FreshBooks Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to FreshBooks Data and provide access to live FreshBooks data for custom reports in the Power BI Service.
-
Connect and Visualize Live Oracle Service Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud data into the Databricks platform and create visualization dashboards with real-time Oracle Service Cloud data.
-
Integrating GitHub Copilot with Gorgias 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 Close Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Close data to a JSON file on disk.
-
Access Live Twitter Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads data from your Google Sheets.
-
ETL Power BI XMLA in Oracle Data Integrator
This article shows how to transfer Power BI XMLA data into a data warehouse using Oracle Data Integrator.
-
Operational Reporting on SpaceX Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SpaceX data.
-
Create Freshteam-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Freshteam Data from OutSystems and build custom enterprise apps using live Freshteam data.
-
Automated Continuous Amazon DynamoDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Amazon DynamoDB data replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open Redis Data in Microsoft Excel
This article uses the CData ODBC driver for Redis to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Freshservice Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshservice data.
-
Connect to Vimeo Data in RazorSQL
Connect to Vimeo from wizards and query Vimeo data from the GUI in the RazorSQL database management tool.
-
Build Supabase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Supabase data.
-
ETL Salesforce Pardot in Oracle Data Integrator
This article shows how to transfer Salesforce Pardot data into a data warehouse using Oracle Data Integrator.
-
Integrate ZendeskSell with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZendeskSell with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZendeskSell data.
-
Connect to Acumatica Data in NetBeans
Connect to Acumatica data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Freshsales in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshsales data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshsales.
-
Build Apps with Live Jira Data Using the Low-Code Development Platform of Mendix
Connect Jira data with Mendix to build apps using the CData JDBC Driver for Jira.
-
Automated Continuous API Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable API replication to Google BigQuery.
-
How to publish and share GraphQL Data dashboards with Tableau Server
The CData ODBC driver for GraphQL enables you integrate GraphQL data into Tableau dashboards.
-
How to Seamlessly Import Anaplan Data into IBM SPSS Modeler
Integrate Anaplan data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Semantic Layer Views for Couchbase Data in APOS Live Data Gateway
Use the CData Connector for Couchbase in APOS Live Data Gateway to build Semantic Layer Views for Couchbase data.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy Web
Connect to Zoom data in MicroStrategy Web using the CData Software JDBC Driver for Zoom.
-
Access Chargebee Data from MySQL in Amazon QuickSight
Connect to Chargebee and build visualizations of Chargebee data using a MySQL Connection in Amazon QuickSight.
-
Model, Search, and Visualize Live Basecamp Data in ThoughtSpot
Use CData Connect AI to connect to live Basecamp data for modeling, searching, and visualizing.
-
Seamlessly Bring Microsoft Planner Data into Retool Using CData Connect AI
Integrate Microsoft Planner data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Trigger SuiteCRM IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SuiteCRM with standard wizards in Logic Apps.
-
Automated Continuous DocuSign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable DocuSign replication to IBM DB2.
-
Integrate Cursor with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Discord data from within the editor.
-
Use the CData ODBC Driver for SAP HANA XS Advanced in Microsoft Power Query
You can use the CData SAP HANA XS Advanced ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP HANA XS Advanced data into Microsoft Power Query.
-
Integrate Cursor with Live Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Optimizely data from within the editor.
-
How to connect and process SAP Ariba Source data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Source data.
-
Work with Live Cosmos DB Data in Power Query
Use CData Connect AI to connect to Cosmos DB data and work with live Cosmos DB data in Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Spark Data
Use CData Power BI Connectors to visualize Spark data in Power BI.
-
Validate Reckon Accounts Hosted Data with QuerySurge
Access and validate Reckon Accounts Hosted data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous CapsuleCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to IBM DB2.
-
Operational Reporting on Workday Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Workday data.
-
Use Azure AI Foundry to Talk to Your Exact Online 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 Exact Online data for you.
-
Query Nethunt Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Nethunt data from Node.js.
-
Create Twilio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Twilio from PowerBI.com to create Power BI Dataflows with real-time data.
-
Add Webex Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Webex with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Live Eventbrite Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Eventbrite data data in natural language using Python.
-
Natively Connect to Exa Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Exa data. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Oracle Service Cloud Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Service Cloud data in Birst.