CData Software - Knowledge Base
Recent Articles
-
Work with Sage Cloud Accounting Data in FoxPro
Load Sage Cloud Accounting data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Redshift Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Redshift enables you to integrate Redshift data into workflows built using Microsoft Power Automate Desktop.
-
Create Hive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hive data access from reports, embedded analytics, and more.
-
How to use SQLAlchemy ORM to access Gumroad Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gumroad data.
-
Connect to and Query Printify Data in QlikView over ODBC
Create data visualizations with Printify data in QlikView.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy Desktop
Connect to Zuora data in MicroStrategy Desktop using the CData Software JDBC Driver for Zuora.
-
Connecting Pipedream with Printify 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 Printify data in real time.
-
Use Microsoft Copilot Studio to talk to your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your ActiveCampaign data for you.
-
Connecting Pipedream with Suadeo 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 Suadeo data in real time.
-
Connecting Mastra with VWO 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 VWO data, no replication required.
-
Publish Crystal Reports on PhantomBuster Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PhantomBuster data.
-
Stream MarkLogic Data into Apache Kafka Topics
Access and stream MarkLogic data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Impala Data in ColdFusion
Write standard ColdFusion data access code to connect to Impala data.
-
Analyze Exact Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Exact Online data with the CData JDBC Driver for Exact Online.
-
Analyze Google Campaign Manager 360 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Campaign Manager 360 from Power Pivot. You will use the Table Import Wizard to load Google Campaign Manager 360 data. You can visually build the import query or use any SQL supported by the driver.
-
Query Sybase Data as a MySQL Database in Node.js
Execute MySQL queries against Sybase data from Node.js.
-
How to connect to Paylocity Data from Spring Boot
Connect to Paylocity in a Spring Boot Application using the CData JDBC Driver for Paylocity
-
Create Reports with Simplesat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Simplesat data.
-
Connect to Autopilot Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Autopilot and work with Autopilot data in your FileMaker application.
-
Build Charts with Keap Data in Clear Analytics
Create dynamic charts and perform analytics based on Keap data in Clear Analytics.
-
Connect to Azure Data Catalog Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Data Catalog and the Script function in FileMaker Pro to connect to Azure Data Catalog and work with Azure Data Catalog data in your FileMaker application.
-
Connect to Discord Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Discord and the SQL Gateway to access Discord data from Google Apps Script.
-
Connect to Aircall Data from PowerBuilder via JDBC
This article demonstrates how to access Aircall data from PowerBuilder using the Aircall JDBC Driver.
-
Connect to JobNimbus Data in Aqua Data Studio
Access JobNimbus data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SharePoint
Provide connectivity to SharePoint data through an SAP BusinessObjects universe.
-
Work with Live Redshift Data in Power Query
Use CData Connect AI to connect to Redshift data and work with live Redshift data in Microsoft Power Query.
-
Access Workable Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Workable data from your Oracle system.
-
Connect to Teradata Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Teradata data from Filemaker Pro on Mac.
-
Use Biml to Build SSIS Tasks to Replicate Samanage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Samanage data to SQL Server.
-
Getting Started with the CData SSIS Components for Shippo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shippo.
-
Access BigCommerce Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BigCommerce data from your Oracle system.
-
Import Real-Time ClickTime Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ClickTime data in ColdFusion.
-
How to connect to Dynamics CRM Data from IntelliJ
Integrate connectivity to Dynamics CRM data with wizards in IntelliJ.
-
Viewing Zoho Books Data in RAD Studio Data Explorer
How to view Zoho Books data in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Books.
-
Automate ZohoSubscriptions Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoSubscriptions data replication to Azure Synapse.
-
Connect to ZohoPeople Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ZohoPeople Data and connect to ZohoPeople data in Akorbi Digital RunMyProcess.
-
Connecting Pipedream with Basecamp 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 Basecamp data in real time.
-
Automated Continuous Slack Replication to SQLite
Use CData Sync for automated, continuous, customizable Slack replication to SQLite.
-
How to Create Power BI Visual Reports with Real-Time Pipeline CRM Data
Use CData Power BI Connectors to visualize Pipeline CRM data in Power BI.
-
How to publish and share SpaceX Data dashboards with Tableau Server
The CData ODBC driver for SpaceX enables you integrate SpaceX data into Tableau dashboards.
-
Connect to NASA Data in CloverDX (formerly CloverETL)
Transfer NASA data using the visual workflow in the CloverDX data integration tool.
-
Use JayDeBeApi to access Clio Data in Python
Use standard Python scripting and the development environment of your choice to access live Clio data.
-
Access Live NASA Data in Coginiti Pro
Connect to and query live NASA data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Directory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Directory data.
-
Replicate Discord Data to Multiple Databases via the CData Sync CLI
Replicate Discord data to disparate databases with a single configuration.
-
Connect to Google Translate Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Translate data using standard SQL.
-
Getting Started with the CData ODBC Driver for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PDFMonkey.
-
Integrate Google's Antigravity Agent with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sugar CRM data using the Model Context Protocol.
-
Visualize Live FreeAgent Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FreeAgent data.
-
Create Apps from Exa Data in Qlik Sense Cloud
Use CData Connect AI to connect to Exa Data and build apps from live Exa data in Qlik Sense Cloud.
-
Connect Slack to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Slack data using the CData Python MCP Server.
-
Create Reports with BigCommerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BigCommerce data.
-
Viewing Microsoft Ads Data in RAD Studio Data Explorer
How to view Microsoft Ads data in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Ads.
-
Build Voice Agents in ElevenLabs with access to Live Avro Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Avro data.
-
Easily Integrate Shopify Data in Lazarus Pascal IDE
Learn how to easily integrate live Shopify data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MVC Applications with Connectivity to Jodoo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jodoo from an ASP.NET MVC application.
-
Connect AdRoll Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AdRoll data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access SAP Concur Data Using Entity Framework
This article shows how to access SAP Concur data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to JDBC-ODBC Bridge Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for JDBC-ODBC Bridge data in the Denodo Virtual DataPort Administrator.
-
Import Salesforce Pardot Data Using Azure Data Factory
Use CData Connect AI to connect to Salesforce Pardot Data from Azure Data Factory and import live Salesforce Pardot data.
-
Build LinkedIn Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LinkedIn Ads data.
-
Integrating LlamaIndex with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Slack data in real time.
-
How to Create Power BI Visual Reports with Real-Time Kintone Data
Use CData Power BI Connectors to visualize Kintone data in Power BI.
-
Visualize Parallel Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Parallel data into TIBCO Spotfire.
-
Analyze Act CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Act CRM from Power Pivot. You will use the Table Import Wizard to load Act CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Create SSAS Tabular Models from Oracle SCM Data
How to build a SQL Server Analysis Service Tabular Model from Oracle SCM data using CData drivers.
-
Integrate with SAP SuccessFactors Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors data to a JSON file on disk.
-
How to Query SAP ByDesign Data in MySQL Workbench
Execute MySQL queries against live SAP ByDesign data from MySQL Workbench.
-
Build Semantic Layer Views for LaunchDarkly Data in APOS Live Data Gateway
Use the CData Connector for LaunchDarkly in APOS Live Data Gateway to build Semantic Layer Views for LaunchDarkly data.
-
Integrate Real-Time Access to Snowflake in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Snowflake data in real time.
-
Consume Excel OData Feeds in PowerBuilder
This article demonstrates how to consume Excel data as OData feeds from PowerBuilder using the API Server.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Inventory Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Inventory data.
-
How to Work with MySQL Data in ETL Validator JDBC
Connect to MySQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Stripe Data in APOS Live Data Gateway
Use the CData Connector for Stripe in APOS Live Data Gateway to build Semantic Layer Views for Stripe data.
-
Integrate Open WebUI with Live HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live HDFS data from within the chat interface.
-
Build Anaplan-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Anaplan Data and create custom apps in Bubble.
-
Create HubDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HubDB data access from reports, embedded analytics, and more.
-
Access Live Optimizely 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 Optimizely data through MCP integration.
-
Use Agno to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your OData services for you.
-
Extract, Transform, and Load MYOB AccountRight Data in Informatica PowerCenter
Create a simple Workflow for MYOB AccountRight data in Informatica PowerCenter.
-
Build Airtable Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Airtable data and build visualizations in Tableau Cloud.
-
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Service Cloud data and build Oracle Service Cloud-connected web apps with Axios.
-
How to publish and share RSS Feeds dashboards with Tableau Server
The CData ODBC driver for RSS enables you integrate RSS feeds into Tableau dashboards.
-
DataBind Databricks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Databricks with the DevExpress Windows Forms and Web controls to provide Databricks data to a chart.
-
View Reports on Real-Time Strava Data in Power BI Report Server
Use the CData ODBC Driver for Strava to visualize Strava data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate OData with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OData with External Services.
-
Automated Continuous Xero Replication to Snowflake
Use CData Sync for automated, continuous, customizable Xero replication to Snowflake.
-
Build Automated Workflows with Live Redis Data in Workato
Use CData Connect AI to connect to live Redis data and build automated workflows in Workato.
-
Create Apps from Google Ads Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Ads Data and build apps from live Google Ads data in Qlik Sense Cloud.
-
Migrating data from Instagram to Databricks using CData SSIS Components.
Easily push Instagram data to Databricks using the CData SSIS Tasks for Instagram and Databricks.
-
How to Connect DBeaver to LinkedIn Ads via a JDBC Driver
Manage LinkedIn Ads data with visual tools in DBeaver like the query browser.
-
Analyze Chargebee Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Chargebee data in Microsoft R Open.
-
Connect to SAP Hybris C4C Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Hybris C4C data in Google Apps Script.
-
Configure the CData JDBC Driver for Splunk in a Connection Pool in Tomcat
Connect to Splunk data from a connection pool in Tomcat.
-
ETL SAP SuccessFactors in Oracle Data Integrator
This article shows how to transfer SAP SuccessFactors data into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live WooCommerce 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 WooCommerce data through natural language.
-
Query MYOB AccountRight Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MYOB AccountRight entities in PHP by modeling them as objects.
-
How to Visualize Slack Data in Python with pandas
Use pandas and other modules to analyze and visualize live Slack data in Python.
-
How to Connect to Live SAP Business One Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business One data securely in real time.
-
Automated Continuous Front Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Front replication to AlloyDB.