CData Software - Knowledge Base
Recent Articles
-
Analyze Databricks Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Databricks data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to PagerDuty Data in Ruby
Connect to PagerDuty data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to Snowflake Data in PHP
The CData ODBC driver for Snowflake enables you to create PHP applications with connectivity to Snowflake data. Leverage the native support for ODBC in PHP.
-
Connect to Attio Data in Google Apps Script via Connect AI
Use CData Connect AI to access Attio data in Google Apps Script.
-
Integrating OpenCode with PingOne 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 Hacker News to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hacker News data using the CData Python MCP Server.
-
How to Connect to & Open Presto Data in Microsoft Excel
This article uses the CData ODBC driver for Presto to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Seamlessly Import Excel Data into IBM SPSS Modeler
Integrate Excel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous MongoDB Replication to Databricks
Use CData Sync for automated, continuous, customizable MongoDB replication to Databricks.
-
Replicate Multiple Epicor Kinetic Accounts via the CData Sync CLI
Replicate multiple Epicor Kinetic accounts to one or many databases.
-
Work with Microsoft Ads Data in FoxPro
Load Microsoft Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Google Search Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Search results and build visualizations in Tableau.
-
Create Data Visualizations in Cognos BI with ServiceNow Data
Access ServiceNow data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Klipfolio Data in Google Apps Script via Connect AI
Use CData Connect AI to access Klipfolio data in Google Apps Script.
-
Visualize Sugar CRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sugar CRM data.
-
Use the CData Software JDBC Driver for Email in MicroStrategy
Connect to Email data in MicroStrategy Developer using the CData Software JDBC Driver for Email.
-
Integrate with Splunk Data in JReport Designer
Create charts and reports based on Splunk data in JReport Designer.
-
Use ChatGPT to Talk to Your MariaDB 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 MariaDB data for you.
-
Create Power BI Reports on Real-Time Google Translate Data
Use the CData ODBC Driver for Google Translate to visualize Google Translate data in Power BI Desktop.
-
Build Dashboards with Reckon Accounts Hosted Data in DBxtra
Create dynamic dashboards and perform analytics based on Reckon Accounts Hosted data in DBxtra.
-
Trigger Zoho Creator IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zoho Creator with standard wizards in Logic Apps.
-
Import Real-Time Figshare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Figshare data in ColdFusion.
-
Connect to Wistia Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Wistia data from Filemaker Pro on Mac.
-
Connect to OData Services in JRuby
Create a simple JRuby app with access to live OData services.
-
Integrate Theia IDE with Live Supabase 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 Supabase data from within the development environment.
-
A PostgreSQL Interface for LeadDesk Data using the CData ODBC Driver
Use the SQL Gateway and LeadDesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Klaviyo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Klaviyo replication to IBM DB2.
-
Create Dynamic Discord Grids Using the Infragistics XamDataGrid
Learn how you can connect Discord to Infragistics XamDataGrid to build dynamic grids.
-
Query Facebook Data as a MySQL Database in Node.js
Execute MySQL queries against Facebook data from Node.js.
-
Connect to CSV Data in ACL Analytics
Connect to CSV data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to CSV data.
-
Build Instagram Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Instagram data and build visualizations in Tableau.
-
Query Live Confluence 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 Confluence data through a conversational interface.
-
Build SAP SuccessFactors-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP SuccessFactors Data and create custom apps in Mendix.
-
Analyze Live Microsoft Ads Data in SAS Viya
Use CData Connect AI to connect to Microsoft Ads data from SAS Viya and deploy self-service analytics using live Microsoft Ads data.
-
Automated Continuous Aweber Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aweber replication to Apache Cassandra.
-
Build Google Ads-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Ads data without replication.
-
Automated Continuous ConvertKit Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ConvertKit replication to AlloyDB.
-
Integrating Kiro with Dotmailer 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.
-
Build Dashboards with Paymo Data in DBxtra
Create dynamic dashboards and perform analytics based on Paymo data in DBxtra.
-
Integrate Theia IDE with Live Klaviyo 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 Klaviyo data from within the development environment.
-
Connect to Guru Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Guru data in Airbyte.
-
Validate Kafka Data with QuerySurge
Access and validate Kafka data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data for you.
-
Integrate Live Confluence Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Confluence data to Blue Prism using the CData ODBC Driver for Confluence to create automated workflows for repetitive business tasks.
-
Query Live SAP HANA XS Advanced Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP HANA XS Advanced data directly from the development environment.
-
Deploy the ADO.NET Provider for Oracle on an SSRS Report Server
Connect to Oracle 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 Kiro with Strava 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.
-
How to publish and share REST Data dashboards with Tableau Server
The CData ODBC driver for REST enables you integrate REST data into Tableau dashboards.
-
Access Live Azure Data Lake Storage Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Data Lake Storage data through MCP integration.
-
Automated Continuous MailerLite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailerLite replication to Apache Cassandra.
-
Getting Started with the CData ODBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Office 365.
-
Integrate Devin with Live Azure Synapse 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 Azure Synapse data.
-
Publish Calendly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Calendly data.
-
Integrate Dify with Live ShipStation 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 ShipStation data.
-
Access Live Gmail Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Gmail data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Instagram Replication to MySQL
Use CData Sync for automated, continuous, customizable Instagram replication to MySQL.
-
How to Easily Query GitLab Data in OpenOffice Base
Connect to GitLab data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connecting GenSpark with Marketo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Marketo data without any replication or custom integration required.
-
Migrating data from LinkedIn to Databricks using CData SSIS Components.
Easily push LinkedIn data to Databricks using the CData SSIS Tasks for LinkedIn and Databricks.
-
Integrate Live Dynamics 365 Business Central Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Dynamics 365 Business Central data and integrate live Dynamics 365 Business Central data into apps built in Microsoft Power Apps.
-
How to Connect to Live Salesforce CRM Analytics Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Salesforce CRM Analytics data through natural language.
-
Use ChatGPT to Talk to Your Microsoft Exchange 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 Microsoft Exchange data for you.
-
Deploy the ADO.NET Provider for SageHR on an SSRS Report Server
Connect to SageHR 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.
-
Access Float Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Float data from your Oracle system.
-
DataBind Controls to Sage 300 Data in C++Builder
DataBind to Sage 300 data in C++Builder with standard components and controls.
-
Connect to Demio Data in RapidMiner
Integrate Demio data with standard components and data source configuration wizards in RapidMiner Studio.
-
Write a Simple Go Application to work with Amplitude Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amplitude data.
-
Build Node.js Apps on Your Business Data with the New CData CLI
Learn how the CData CLI and cdata-cli-odbc skill ground AI coding agents in your real schema so they can build production-ready Node.js apps connected to Salesforce and hundreds of other sources through the CData ODBC Driver.
-
Create SSAS Tabular Models from Azure Data Lake Storage Data
How to build a SQL Server Analysis Service Tabular Model from Azure Data Lake Storage data using CData drivers.
-
Automated Continuous Harvest Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Harvest replication to Google Cloud SQL.
-
Automated Continuous Redis Replication to Vertica
Use CData Sync for automated, continuous, customizable Redis replication to Vertica.
-
Build MVC Applications with Connectivity to Klaviyo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klaviyo from an ASP.NET MVC application.
-
Use the CData SSIS Components to Insert New or Update Existing Salesloft Records from SQL Server
Easily push SQL Server data to Salesloft using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesloft or update existing records with data from a SQL Server database.
-
Build AI Agents with WordPress 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 WordPress data through CData Connect AI.
-
Query Live Wistia 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 Wistia data through a conversational interface.
-
How to connect PolyBase to OpenWeatherMap
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OpenWeatherMap data.
-
Build Agents in Relevance AI with Access to Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on FreshBooks data within intelligent agent workflows.
-
Stream AfterShip Data into Apache Kafka Topics
Access and stream AfterShip data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Model, Search, and Visualize Live ZohoPeople Data in ThoughtSpot
Use CData Connect AI to connect to live ZohoPeople data for modeling, searching, and visualizing.
-
Integrating Claude Code with Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Exchange data within assisted coding and automated development workflows.
-
Connect to Pipedrive Data in NetBeans
Connect to Pipedrive data in NetBeans with the data source configuration wizard.
-
Access Live ServiceNow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ServiceNow data into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceNow data in the Graph Builder and Query Builder.
-
Replicate Multiple Zoho Inventory Accounts
Replicate multiple Zoho Inventory accounts to one or many databases.
-
Import Real-Time Short.io Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Short.io data in ColdFusion.
-
Create Power BI Reports on Real-Time MYOB AccountRight Data
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight data in Power BI Desktop.
-
Visualize Greenhouse Data in Tableau
The CData ODBC driver for Greenhouse enables you integrate Greenhouse data into Tableau dashboards.
-
Integrate with Dynamics 365 Data in JReport Designer
Create charts and reports based on Dynamics 365 data in JReport Designer.
-
How to connect PolyBase to Sendwithus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sendwithus data.
-
Feed Keap Data into FineReport
How to set Keap data as a JDBC data source in FineReport.
-
Connect to and Query Adobe Target Data in QlikView over ODBC
Create data visualizations with Adobe Target data in QlikView.
-
Connect to REST Data in RapidMiner
Integrate REST data with standard components and data source configuration wizards in RapidMiner Studio.
-
Trigger Lakebase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Lakebase with standard wizards in Logic Apps.
-
Access Live Procore Data in Excel 365 Online (Excel for the web)
Connect to Procore data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to SAS xpt Data in DBArtisan
Use wizards in DBArtisan to configure SAS xpt data as a data source.
-
How to use SQLAlchemy ORM to access Phoenix Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Phoenix data.
-
Create Apps from Marketo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Marketo Data and build apps from live Marketo data in Qlik Sense Cloud.
-
Automated Continuous LightSpeedRetail Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Amazon S3.
-
Operational Reporting on Cohere Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cohere data.
-
Build Pipelines with Live Attio Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Attio from Google Cloud Data Fusion, enabling the integration of live Attio data into the building and management of effective data pipelines.
-
Connect to Wistia Data in ACL Analytics
Connect to Wistia data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Wistia data.