CData Software - Knowledge Base
Recent Articles
-
Build Cloudant-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Cloudant data and build Cloudant-connected web apps with Axios.
-
Integrate HelloSign Data in the Pentaho Report Designer
Publish reports based on HelloSign data in the Pentaho BI tool.
-
Replicate Accelo Data to Multiple Databases
Replicate Accelo data to disparate databases with a point-and-click configuration.
-
Query Live Cosmos DB 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 Cosmos DB data through a conversational interface.
-
Bridge OnePageCrm Connectivity with Apache NiFi
Access and process OnePageCrm data in Apache NiFi using the CData JDBC Driver.
-
Access BambooHR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BambooHR data from HeidiSQL.
-
How to Connect to Live iContact 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 iContact data for you.
-
Use the CData Software JDBC Driver for Perplexity in MicroStrategy Desktop
Connect to Perplexity data in MicroStrategy Desktop using the CData Software JDBC Driver for Perplexity.
-
Analyze Epicor Kinetic Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Epicor Kinetic data with the CData JDBC Driver for Epicor Kinetic.
-
Access Live Google Directory Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Directory data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Theia IDE with Live HDFS 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 HDFS data from within the development environment.
-
Stream Instantly Data into Apache Kafka Topics
Access and stream Instantly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Theia IDE with Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data from within the development environment.
-
How to Connect to Live Bright Data 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 Bright Data data through natural language.
-
Import Real-Time MySQL Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MySQL data in ColdFusion.
-
Build Semantic Layer Views for Foursquare Data in APOS Live Data Gateway
Use the CData Connector for Foursquare in APOS Live Data Gateway to build Semantic Layer Views for Foursquare data.
-
How to Build an ETL App for GraphQL Data in Python with CData Connect AI
Extract and transform live GraphQL data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Dify with Live Microsoft OneDrive 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 Microsoft OneDrive data.
-
Connect to SAP SuccessFactors LMS Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP SuccessFactors LMS data from Filemaker Pro on Mac.
-
Analyze Bright Data Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Bright Data data and visualize live Bright Data data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for SAP HANA XS Advanced in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP HANA XS Advanced data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP HANA XS Advanced.
-
Connect to and Query Live Salesforce Data in QlikView (vina ODBC)
Create data visualizations with Salesforce data in QlikView.
-
Connect to Microsoft OneDrive Data in ACL Analytics
Connect to Microsoft OneDrive data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft OneDrive data.
-
Query Egnyte Data in DataGrip
Create a Data Source for Egnyte in DataGrip and use SQL to query live Egnyte data.
-
Visualize SAP Concur Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Concur data.
-
Connect to eBay Analytics Data in DBArtisan
Use wizards in DBArtisan to configure eBay Analytics data as a data source.
-
Integrate PagerDuty Data in Pentaho Data Integration
Build ETL pipelines based on PagerDuty data in the Pentaho Data Integration tool.
-
How to create an RPA flow for Procore Data in UiPath Studio
Use the Procore ODBC Driver to create workflows that access real-time Procore data without any coding.
-
Enable the Pipedrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipedrive data.
-
Operational Reporting on Blackbaud FE NXT Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Blackbaud FE NXT data.
-
Integrate Goose with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Teams data from within the local AI agent.
-
Connecting Pipedream with GraphQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GraphQL data in real time.
-
Import Confluence Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Confluence Data and provide access to live Confluence data for custom reports in the Power BI Service.
-
How to connect PolyBase to Dynamics CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics CRM data.
-
Add Highrise Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Highrise with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Google Search Results in ColdFusion
Write standard ColdFusion data access code to connect to Google Search results.
-
DataBind Controls to SAP Data in Delphi
DataBind to SAP data in Delphi with standard data access components and controls.
-
DataBind Controls to Reply.io Data in Delphi
DataBind to Reply.io data in Delphi with standard data access components and controls.
-
Getting Started with the CData ODBC Driver for Paddle
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paddle.
-
How to Visualize Twitter Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Twitter Ads data in Python.
-
Create HCL Domino Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HCL Domino data access from reports, embedded analytics, and more.
-
Integrating Dataiku with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Ad Manager data.
-
Integrate Couchbase Data into Power Automate Desktop using CData Connect
CData Connect for Couchbase Data enables you to integrate Couchbase data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Mode Data in Ruby
Connect to Mode data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Deploy the ADO.NET Provider for SpaceX on an SSRS Report Server
Connect to SpaceX 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.
-
Automated Continuous Google Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Analytics replication to Vertica.
-
Import Quickbase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Quickbase Data and provide access to live Quickbase data for custom reports in the Power BI Service.
-
Automated Continuous Scrapfly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Scrapfly replication to Azure SQL Database.
-
Automated Continuous Tickspot Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Tickspot replication to Apache Kafka.
-
Integrating Boomi Agentstudio with Zendesk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zendesk data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Easily Query Adobe Target Data in OpenOffice Base
Connect to Adobe Target data in OpenOffice Base using the CData ODBC Driver for Adobe Target and generate reports with live data insights.
-
Create a Data Access Object for Google Search Results using JDBI
A brief overview of creating a SQL Object API for Google Search results in JDBI.
-
Getting Started with the CData Tableau Connector for Foursquare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to PostgreSQL Data from PowerBuilder via JDBC
This article demonstrates how to access PostgreSQL data from PowerBuilder using the PostgreSQL JDBC Driver.
-
Integrate NetSuite Data in Pentaho Data Integration
Build ETL pipelines based on NetSuite data in the Pentaho Data Integration tool.
-
Integrate Google's Antigravity Agent with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Sheets data using the Model Context Protocol.
-
How to Query Apollo Data in MySQL Workbench
Execute MySQL queries against live Apollo data from MySQL Workbench.
-
Create Parallel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Parallel data access from reports, embedded analytics, and more.
-
Create Salesloft Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesloft data access from reports, embedded analytics, and more.
-
How to Connect to Live Zoom 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 Zoom data for you.
-
Connect to Brex Data in DBeaver
Use the CData ODBC Driver to connect to Brex data in DBeaver.
-
Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avalara AvaTax data to SQL Server.
-
Connect to Suadeo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Suadeo and the SQL Gateway to access Suadeo data from Google Apps Script.
-
Analyze Hacker News Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hacker News data in Microsoft R Open.
-
Integrate Cline with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAS xpt data from within your IDE.
-
Getting Started with the CData ADO.NET Provider for GetResponse
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Import Supabase Data Using Azure Data Factory
Use CData Connect AI to connect to Supabase Data from Azure Data Factory and import live Supabase data.
-
Connect to Cohere Data in RazorSQL
Connect to Cohere from wizards and query Cohere data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Power BI Connector for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Blackbaud FE NXT.
-
How to Seamlessly Import Nethunt Data into IBM SPSS Modeler
Integrate Nethunt data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect Flowise AI Agents to Live Optimizely Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Optimizely data without replication.
-
Integrating OpenCode with Wrike 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 Helpscout Replication to Vertica
Use CData Sync for automated, continuous, customizable Helpscout replication to Vertica.
-
Create Printify-Connected Dashboards in Grafana
Connect to Printify Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Printify data.
-
Integrating Codex with eBay 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.
-
Integrating Antigravity CLI with Teamgate data via CData CLI
Connect Teamgate data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Process & Analyze RabbitMQ Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live RabbitMQ Data.
-
Getting Started with the CData SSIS Components for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ScrapingBee.
-
Access Live Smartsheet 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 Smartsheet data through MCP integration.
-
Connect to Ontraport Data in Jaspersoft Studio
Execute SQL to remote Ontraport data in Jaspersoft Studio.
-
Query Live ClickUp 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 ClickUp data through a conversational interface.
-
Natively Connect to Webflow Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Webflow data. Leverage the native support for ODBC in PHP.
-
PDFMonkey Reporting in OBIEE with the PDFMonkey JDBC Driver
Deploy the PDFMonkey JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Reports with Gmail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gmail data.
-
Build Charts with MYOB AccountRight Data in Clear Analytics
Create dynamic charts and perform analytics based on MYOB AccountRight data in Clear Analytics.
-
Connect to Okta Data in Google Apps Script via Connect AI
Use CData Connect AI to access Okta data in Google Apps Script.
-
Build Charts with Sybase IQ Data in Clear Analytics
Create dynamic charts and perform analytics based on Sybase IQ data in Clear Analytics.
-
Connect to MongoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MongoDB and the Script function in FileMaker Pro to connect to MongoDB and work with MongoDB data in your FileMaker application.
-
Build Dashboards with Sage Cloud Accounting Data in DBxtra
Create dynamic dashboards and perform analytics based on Sage Cloud Accounting data in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for AdRoll
Create an ODBC connection to AdRoll in Informatica and browse and transfer AdRoll data.
-
Connect to AdRoll Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AdRoll data.
-
Connect Front to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Front data using the CData Python MCP Server.
-
Visualize Live SAP Ariba Source Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Ariba Source data into custom reports in Power BI.
-
Analyze Live Square Data in SAS Viya
Use CData Connect AI to connect to Square data from SAS Viya and deploy self-service analytics using live Square data.
-
Integrate BambooHR Data into Power Automate Desktop using CData Connect
CData Connect for BambooHR Data enables you to integrate BambooHR data into workflows built using Microsoft Power Automate Desktop.
-
Work with Marketo Data in FoxPro
Load Marketo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Establish a Live Connection with ZendeskSell Data using Tableau Bridge
The CData ODBC Driver for ZendeskSell enables you to integrate live ZendeskSell data into Tableau Cloud dashboards using the Tableau Bridge.
-
Bind Live HubDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HubDB data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Recurly Data Replication to Couchbase
Use CData Sync to Customize and automate Recurly data replication to Couchbase.
-
Work with FTP Data in FoxPro
Load FTP data into a FoxPro database. This article includes full code and a walk-through of the process.