CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import Intercom Data into IBM SPSS Modeler
Integrate Intercom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Quaderno Data in Informatica PowerCenter
Create a simple Workflow for Quaderno data in Informatica PowerCenter.
-
Connecting Mastra with Box 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 Box data, no replication required.
-
Analyze Okta Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Okta data and visualize Okta data in SAP Analytics Cloud.
-
Use Databricks Agent Bricks to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SQL Analysis Services data for you.
-
Integrating Avro Data in Talend Cloud Data Management Platform
Connect Avro Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avro.
-
Build Azure Data Lake Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Data Lake Storage data.
-
Create Power BI Reports on Real-Time Blackbaud FE NXT Data
Use the CData ODBC Driver for Blackbaud FE NXT to visualize Blackbaud FE NXT data in Power BI Desktop.
-
Integrate Google's Antigravity Agent with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PingOne data using the Model Context Protocol.
-
Query Invoiced Data in ColdFusion
Write standard ColdFusion data access code to connect to Invoiced data.
-
Automate Klipfolio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Klipfolio data from PowerShell? This article demonstrates how to utilize the Klipfolio Cmdlets for tasks like connecting to Klipfolio data, automating operations, downloading data, and more.
-
Build Dashboards with OpenWeatherMap Data in Dundas BI
Create dynamic dashboards and perform analytics based on OpenWeatherMap data in Dundas BI.
-
How to create Power BI XMLA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Power BI XMLA data in MySQL .
-
Validate Email Data with QuerySurge
Access and validate Email data in QuerySurge using the CData JDBC Driver.
-
Build Cvent-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cvent data and build Cvent-connected web apps with Axios.
-
Visualize Live Discord Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Discord data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bright Data Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bright Data facts in real time.
-
Integrating Codex with SAS xpt 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 Grok to Talk to Your SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SuiteCRM data for you.
-
Create Act-On Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Act-On data access from reports, embedded analytics, and more.
-
How to Build an ETL App for Anaplan Data in Python with CData Connect AI
Extract and transform live Anaplan data in Python with petl and the CData Connect AI Python SDK.
-
Access SpaceX Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SpaceX data from HeidiSQL.
-
Integrating Boomi Agentstudio with Mailgun Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Mailgun data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating Jira Assets Data in Talend Cloud Data Management Platform
Connect Jira Assets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Jira Assets.
-
Create Dynamic FTP Grids Using the Infragistics XamDataGrid
Learn how you can connect FTP to Infragistics XamDataGrid to build dynamic grids.
-
Create DB2 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time DB2 data access from reports, embedded analytics, and more.
-
Visualize Salesloft Data in TIBCO Spotfire through ADO.NET
Integrate Salesloft data into dashboards in TIBCO Spotfire.
-
Connect Databricks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Databricks data using the CData Python MCP Server.
-
A PostgreSQL Interface for NetSuite Data using the CData ODBC Driver
Use the SQL Gateway and NetSuite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Search External Jira Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Jira data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jira Data objects that you can access from apps and the dashboard.
-
Access Live BenchmarkEmail Data in AWS Lambda
Connect to live BenchmarkEmail data in AWS Lambda using the CData JDBC Driver.
-
Build Visualizations of JobNimbus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JobNimbus data in Birst.
-
Automated Continuous Contentful Replication to Snowflake
Use CData Sync for automated, continuous, customizable Contentful replication to Snowflake.
-
Natively Connect to XML Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to XML data. Leverage the native support for ODBC in PHP.
-
Access Live Cvent 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 Cvent data through MCP integration.
-
Build Visualizations of Teamgate Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teamgate data in Birst.
-
Publish Reports with MailerSend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerSend data.
-
Import Real-Time Keap Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Keap data in ColdFusion.
-
Use Claude to Talk to Your Freshteam 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 Freshteam data for you.
-
Feed FreshBooks Data into FineReport
How to set FreshBooks data as a JDBC data source in FineReport.
-
Integrate Live Dynamics 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics 365 data.
-
Connect to and Query Active Directory Data in QlikView over ODBC
Create data visualizations with Active Directory data in QlikView.
-
How to Connect DBeaver to Sendwithus via a JDBC Driver
Manage Sendwithus data with visual tools in DBeaver like the query browser.
-
Integrate Snapchat Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Snapchat Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Snapchat Ads data.
-
Query Freshsales Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshsales data from Node.js.
-
Visualize Amazon DynamoDB Data in Tableau
The CData ODBC driver for Amazon DynamoDB enables you integrate Amazon DynamoDB data into Tableau dashboards.
-
Integrating Claude Code CLI with Google Analytics 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.
-
Automated Continuous Webflow Replication to Vertica
Use CData Sync for automated, continuous, customizable Webflow replication to Vertica.
-
Connect to and Query ZohoSubscriptions Data in QlikView over ODBC
Create data visualizations with ZohoSubscriptions data in QlikView.
-
How to Build an ETL App for IBM Cloud Object Storage Data in Python with CData
Create ETL applications and real-time data pipelines for IBM Cloud Object Storage data in Python with petl.
-
How to create Yelp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Yelp data in MySQL .
-
Build Stripe-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 Stripe data without replication.
-
Integrate Open WebUI with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Dynamics CRM data from within the chat interface.
-
Connect to Gumroad Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gumroad to connect to Gumroad data and execute queries in PowerBuilder.
-
Object-Relational Mapping (ORM) with Microsoft Entra ID 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 Microsoft Entra ID data into a Java-based ORM framework, Hibernate.
-
Build AlloyDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AlloyDB Data from Zoho Analytics and import live AlloyDB data.
-
Visualize Productboard Data in Tableau
The CData ODBC driver for Productboard enables you integrate Productboard data into Tableau dashboards.
-
How to Connect DBeaver to FTP via a JDBC Driver
Manage FTP data with visual tools in DBeaver like the query browser.
-
Access LightSpeedRetail Data from MySQL in PHP
Connect to LightSpeedRetail through the standard MySQL libraries in PHP.
-
Visualize Live Kintone Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Kintone data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Search External FreshBooks Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of FreshBooks data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FreshBooks Data objects that you can access from apps and the dashboard.
-
Automated Continuous Auth0 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Auth0 data replication to OneLake in Microsoft Fabric.
-
Connect to Amazon S3 Data in RazorSQL
Connect to Amazon S3 from wizards and query Amazon S3 data from the GUI in the RazorSQL database management tool.
-
DataBind Controls to Paymo Data in Delphi
DataBind to Paymo data in Delphi with standard data access components and controls.
-
Visualize Pipedrive Data in TIBCO Spotfire through ADO.NET
Integrate Pipedrive data into dashboards in TIBCO Spotfire.
-
Integrate Sentry with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sentry with External Services.
-
Getting Started with the CData ODBC Driver for Jira
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jira.
-
DataBind Google Sheets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets data to a chart.
-
Create Dynamic Apify Grids Using the Infragistics XamDataGrid
Learn how you can connect Apify to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your HBase 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 HBase data for you.
-
Integrate Devin with Live iContact 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 iContact data.
-
Visualize MailerLite Data in TIBCO Spotfire through ADO.NET
Integrate MailerLite data into dashboards in TIBCO Spotfire.
-
How to load ZeroBounce data into Elasticsearch via Logstash
Introducing a simple method to load ZeroBounce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Autopilot Replication to SQLite
Use CData Sync for automated, continuous, customizable Autopilot replication to SQLite.
-
Replicate Telegram Data to Multiple Databases
Replicate Telegram data to disparate databases with a point-and-click configuration.
-
Work with Unbounce Data in FoxPro
Load Unbounce data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Facebook Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Azure SQL Database.
-
Access Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data through MCP integration.
-
Work with Live Instagram Data in Power Query
Use CData Connect AI to connect to Instagram data and work with live Instagram data in Microsoft Power Query.
-
Work with Spotify Data in FoxPro
Load Spotify data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Cursor with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Figshare data from within the editor.
-
How to Easily Query Egnyte Data in OpenOffice Base
Connect to Egnyte data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Qualaroo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Qualaroo data from your Oracle system.
-
Integrate LibreChat with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Highrise data from within the chat interface.
-
How to Work with Quaderno Data in ETL Validator JDBC
Connect to Quaderno from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to ServiceDesk Plus Data from Spring Boot
Connect to ServiceDesk Plus in a Spring Boot Application using the CData API Driver for JDBC
-
Establish a Live Connection with Apollo Data using Tableau Bridge
The CData ODBC Driver for Apollo enables you to integrate live Apollo data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Nethunt Data in Talend Cloud Data Management Platform
Connect Nethunt Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Cline with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snapchat Ads data from within your IDE.
-
Use the CData Software ODBC Driver for Google Spanner in MicroStrategy Web
Connect to Google Spanner data in MicroStrategy Web using the CData Software ODBC Driver for Google Spanner.
-
How to Visualize PostgreSQL Data in Python with pandas
Use pandas and other modules to analyze and visualize live PostgreSQL data in Python.
-
Visualize Live Airtable Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Airtable data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Automated Workflows with Live Zoho Projects Data in Workato
Use CData Connect AI to connect to live Zoho Projects data and build automated workflows in Workato.
-
Create Dashboards and Visualize Live SAP Business Warehouse Data in Geckoboard
Use CData Connect AI to connect to live SAP Business Warehouse data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Desktop
Connect to Presto data in MicroStrategy Desktop using the CData Software ODBC Driver for Presto.
-
Provide OData Services of Cvent Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cvent data by developing a WCF Service Application.
-
Automated Continuous Harvest Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Harvest replication to Apache Kafka.
-
Access Live Tanda Data in Coginiti Pro
Connect to and query live Tanda data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Google's Vertex AI Agent with Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data within intelligent workflows.
-
Build Voice Agents in ElevenLabs with access to Live FreshBooks Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FreshBooks data.