CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Zoho Recruit Data Using the Low-Code Development Platform of Mendix
Connect Zoho Recruit data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Zoho Books Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Books data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Nuclia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Nuclia data using the CData Python MCP Server.
-
How to Connect to Live Amazon Athena Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Amazon Athena data for you.
-
Automated Continuous MailChimp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon S3.
-
Integrating Codex with Klipfolio 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.
-
Create Reports from Mode Data in Looker Studio
Use CData Connect AI to gain access to live Mode data and create custom reports in Looker Studio.
-
Build Charts with Sybase Data in Clear Analytics
Create dynamic charts and perform analytics based on Sybase data in Clear Analytics.
-
Connect to GetResponse Data in Aqua Data Studio
Access GetResponse data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Perform Batch Operations with Bullhorn CRM Data in Apache NiFi
Connect to Bullhorn CRM data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Short.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Short.io and the SQL Gateway to access Short.io data from Google Apps Script.
-
How to Work with SAP Ariba Source Data in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Source from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Retently Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Retently data using standard SQL.
-
Microsoft Entra ID Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Entra ID facts in real time.
-
Integrate SAP Ariba Procurement Data in the Pentaho Report Designer
Publish reports based on SAP Ariba Procurement data in the Pentaho BI tool.
-
Automated Continuous Guru Replication to Databricks
Use CData Sync for automated, continuous, customizable Guru replication to Databricks.
-
Integrate Epicor Kinetic Data in Pentaho Data Integration
Build ETL pipelines based on Epicor Kinetic data in the Pentaho Data Integration tool.
-
Integrate Live Snowflake Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Snowflake from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Snowflake data.
-
View Reports on Real-Time Microsoft Ads Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Ads to visualize Microsoft Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Typeform Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Typeform data.
-
How to connect to Aweber Data from Spring Boot
Connect to Aweber in a Spring Boot Application using the CData API Driver for JDBC
-
Build Dynamics CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics CRM Data and create custom apps in Mendix.
-
Analyze YouTube Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze YouTube Analytics data in Microsoft R Open.
-
Connect to Dynamics 365 Business Central Data in RazorSQL
Connect to Dynamics 365 Business Central from wizards and query Dynamics 365 Business Central data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Python Connector for Perigon
Learn to install and license the CData Python Connector and configure a connection to live Perigon data.
-
How to connect to Grafana Data in DBVisualizer
Integrate Grafana data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Cloud Accounting
Create Sage Cloud Accounting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating GitHub Copilot with ShipStation 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 LlamaIndex with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce data in real time.
-
How to Connect to Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data without replication.
-
Integrating LangChain with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MySQL data within automated workflows.
-
Integrating LangChain with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on EnterpriseDB data within automated workflows.
-
How to Connect to Eventbrite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Eventbrite data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Live Pipedrive Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Pipedrive from the MuleSoft Anypoint Platform to integrate live Pipedrive data into custom reports and dashboards.
-
Integrating LangChain with Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Optimizely data within automated workflows.
-
Search External ZohoInvoice Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoInvoice data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoInvoice Data objects that you can access from apps and the dashboard.
-
Use the CData SSIS Components to Insert New or Update Existing WordPress Records from SQL Server
Easily push SQL Server data to WordPress using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WordPress or update existing records with data from a SQL Server database.
-
Getting Started with the CData Power BI Connector for Supabase
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous PagerDuty Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable PagerDuty replication to Amazon Redshift.
-
Integrating Square Data in Talend Cloud Data Management Platform
Connect Square Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Square.
-
Connecting Mastra with Certinia 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 Certinia data, no replication required.
-
How to load Google Sheets data into Elasticsearch via Logstash
Introducing a simple method to load Google Sheets data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Act CRM Data in Coginiti Pro
Connect to and query live Act CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create ActiveCampaign-Connected Nintex Workflows
Use CData Connect AI to connect to ActiveCampaign Data from Nintex Workflow Cloud and build custom workflows using live ActiveCampaign data.
-
Stream Power BI XMLA Data into Apache Kafka Topics
Access and stream Power BI XMLA data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate TigerGraph Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live TigerGraph data from Informatica Cloud.
-
Bridge TaxJar Connectivity with Apache NiFi
Access and process TaxJar data in Apache NiFi using the CData JDBC Driver.
-
Integrating LangChain with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SurveyMonkey data within automated workflows.
-
Build a Singer.io Tap for Cloudflare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudflare data using the CData Python Connector.
-
Demio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Demio facts in real time.
-
Access Yelp Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Yelp data from your Oracle system.
-
Connect to Real-Time Pinterest Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Pinterest and Dataflow to import and use Pinterest data in Power Apps.
-
Visualize ActiveCampaign Data in TIBCO Spotfire through ADO.NET
Integrate ActiveCampaign data into dashboards in TIBCO Spotfire.
-
Access Live xBase 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 xBase data through MCP integration.
-
Automate Mailgun Data Replication to Couchbase
Use CData Sync to Customize and automate Mailgun data replication to Couchbase.
-
Use the CData Software JDBC Driver for Cloudflare in MicroStrategy Desktop
Connect to Cloudflare data in MicroStrategy Desktop using the CData Software JDBC Driver for Cloudflare.
-
Connect to Power BI XMLA Data in Google Apps Script via Connect AI
Use CData Connect AI to access Power BI XMLA data in Google Apps Script.
-
Connect to Brex Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Brex.
-
How to connect and process Sage 200 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage 200 data.
-
Integrating Kiro with CircleCI 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 Auth0 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Auth0 with External Services.
-
Automated Continuous Salesloft Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesloft replication to Apache Cassandra.
-
Automated Continuous Zoho Books Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Books replication to Oracle.
-
Automated Continuous Mailgun Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mailgun replication to Google Cloud SQL.
-
How to connect to FormSite Data from Spring Boot
Connect to FormSite in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to ElevenLabs Data in Jaspersoft Studio
Execute SQL to remote ElevenLabs data in Jaspersoft Studio.
-
Integrating GitHub Copilot with iContact 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.
-
Getting Started with the CData Excel Add-In for HelloSign
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HelloSign.
-
Enable the ChartMogul JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ChartMogul data.
-
Create SSAS Tabular Models from Anaplan Data
How to build a SQL Server Analysis Service Tabular Model from Anaplan data using CData drivers.
-
Replicate OData Services from PowerShell
Write a quick PowerShell script to query OData services. Use connectivity to the live data to replicate OData services to SQL Server.
-
Create Paylocity-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paylocity Data from OutSystems and build custom enterprise apps using live Paylocity data.
-
How to Connect the Power BI Service to Workday: Complete Guide
Connect to the CData Software Power BI Connector for Workday from PowerBI.com to provide real-time Workday data across the organization.
-
Use the CData ODBC Driver for Autopilot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Autopilot to connect to Autopilot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Autopilot data in Excel.
-
How to Access Live SAP Ariba Procurement Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate SAP Ariba Procurement data into workflows built using Microsoft Power Automate Desktop.
-
Create Reports with Azure Data Catalog Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Catalog data.
-
Validate LeadDesk Data with QuerySurge
Access and validate LeadDesk data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Excel Online Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Excel Online data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Greenhouse Replication to MySQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to MySQL.
-
Build Dashboards with Active Directory Data in DBxtra
Create dynamic dashboards and perform analytics based on Active Directory data in DBxtra.
-
Use Azure AI Foundry to Talk to Your Yelp 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 Yelp data for you.
-
Connect to ZohoDesk Data from a Connection Pool in JBoss
Integrate ZohoDesk data into Java servlets: Use the Management Console in JBoss to install the ZohoDesk JDBC Driver.
-
Import Real-Time Outlook Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Outlook data in ColdFusion.
-
Connect to Guru Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Guru data.
-
How to Build an ETL App for Quickbase Data in Python with CData
Create ETL applications and real-time data pipelines for Quickbase data in Python with petl.
-
Visualize SAP SuccessFactors Data in TIBCO Spotfire through ADO.NET
Integrate SAP SuccessFactors data into dashboards in TIBCO Spotfire.
-
Build Visualizations of Pipedrive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pipedrive data in Birst.
-
Use the CData ODBC Driver for ShipEngine in Microsoft Power Query
You can use the CData ShipEngine ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ShipEngine data into Microsoft Power Query.
-
Access Live Microsoft OneDrive Data in TIBCO Data Virtualization
Use the Microsoft OneDrive Tibco DV Adapter to create a Microsoft OneDrive data data source in TIBCO Data Virtualization Studio and gain access to live Microsoft OneDrive data from your TDV Server.
-
Connect to AdRoll Data in DBArtisan
Use wizards in DBArtisan to configure AdRoll data as a data source.
-
Visualize SAP Business Warehouse Data in Tableau
The CData ODBC driver for SAP Business Warehouse enables you integrate SAP Business Warehouse data into Tableau dashboards.
-
Automated Continuous Telegram Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Telegram replication to Apache Cassandra.
-
Access Live Greenhouse Data in Excel 365 Online (Excel for the web)
Connect to Greenhouse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to publish and share Redshift Data dashboards with Tableau Server
The CData ODBC driver for Redshift enables you integrate Redshift data into Tableau dashboards.
-
Query Microsoft OneDrive Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft OneDrive data from Node.js.
-
Access Live HubSpot Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to HubSpot data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Figshare-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Figshare Data and create custom apps in Bubble.
-
Build Dashboards with NASA Data in DBxtra
Create dynamic dashboards and perform analytics based on NASA data in DBxtra.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Web
Connect to SAP Ariba Source data in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Source.
-
Getting Started with the CData ADO.NET Provider for Cvent
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cvent.