CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with AfterShip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AfterShip data.
-
Query IBM Informix Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume IBM Informix entities in PHP by modeling them as objects.
-
Connect to SAP Concur Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Concur data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy
Connect to Act CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Act CRM.
-
Migrating data from Freshsales to Google BigQuery using CData SSIS Components.
Easily push Freshsales data to Google BigQuery using the CData SSIS Tasks for Freshsales and Google BigQuery.
-
Work with Amazon DynamoDB Data in FoxPro
Load Amazon DynamoDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Claude to Talk to Your PayPal 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 PayPal data for you.
-
Replicate Wave Financial Data to Multiple Databases
Replicate Wave Financial data to disparate databases with a point-and-click configuration.
-
Automate HubSpot Data Replication to Azure Data Lake
Use CData Sync to customize and automate HubSpot data replication to Azure Data Lake.
-
How to Seamlessly Import Okta Data into IBM SPSS Modeler
Integrate Okta data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Impala Data in HULFT Integrate
Connect to Impala as a JDBC data source in HULFT Integrate
-
Create Hive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Hive Data from Klipfolio and build custom visualizations using live Hive data.
-
Automated Continuous Zuora Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zuora replication to delimited files (CSV/TSV).
-
Import Oracle HCM Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle HCM Cloud Data from Azure Data Factory and import live Oracle HCM Cloud data.
-
Integrate Real-Time Access to SingleStore in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SingleStore data in real time.
-
Import Salesforce Data 360 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce Data 360 Data and provide access to live Salesforce Data 360 data for custom reports in the Power BI Service.
-
Query, Visualize, and Share live Highrise Data in Redash
Use CData Connect AI to connect to live Highrise data in Redash for querying, visualizing, and sharing.
-
Connect to Azure DevOps from Asprova with CData Software ODBC Driver for Azure DevOps
This article shows how to connect faster to Azure DevOps data from Asprova.
-
Use Biml to Build SSIS Tasks to Replicate Customer.io Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Customer.io data to SQL Server.
-
Access Live BigQuery 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 BigQuery data through MCP integration.
-
Integrating LlamaIndex with Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Wave Financial data in real time.
-
Connect to SharePoint Data in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint in FileMaker Pro to connect to SharePoint and work with SharePoint data in your FileMaker applications.
-
Connect to Clari Data in RapidMiner
Integrate Clari data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous PabblySubscriptions Replication to Databricks
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Databricks.
-
Establish a Live Connection with Kintone Data using Tableau Bridge
The CData ODBC Driver for Kintone enables you to integrate live Kintone data into Tableau Cloud dashboards using the Tableau Bridge.
-
Establish a Live Connection with Demio Data using Tableau Bridge
The CData ODBC Driver for Demio enables you to integrate live Demio data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Microsoft Copilot Studio to talk to your Moosend 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 Moosend data for you.
-
Automated Continuous Qualaroo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Qualaroo replication to Apache Cassandra.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy
Connect to Discourse data in MicroStrategy Developer using the CData Software ODBC Driver for Discourse.
-
How to Easily Query Beeminder Data in OpenOffice Base
Connect to Beeminder data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to & Open Trello Data in Microsoft Excel
This article uses the CData ODBC driver for Trello to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy Desktop
Connect to JotForm data in MicroStrategy Desktop using the CData Software JDBC Driver for JotForm.
-
Analyze PagerDuty Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PagerDuty from Power Pivot. You will use the Table Import Wizard to load PagerDuty data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate with Dynamics CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics CRM data to a JSON file on disk.
-
Publish Crystal Reports on Stripe Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stripe data.
-
Connect to Splunk Data in Aqua Data Studio
Access Splunk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build JobNimbus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JobNimbus data and build web apps with connectivity to live JobNimbus data.
-
Build Visualizations of Perplexity Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Perplexity data in Birst.
-
How to Build an ETL App for Zoho Creator Data in Python with CData
Create ETL applications and real-time data pipelines for Zoho Creator data in Python with petl.
-
Create OnePageCrm Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OnePageCrm from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Quaderno 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 Quaderno data into TIBCO Spotfire.
-
How to Connect to Live Act-On Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Act-On data for you.
-
Visualize Trello 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 Trello data into TIBCO Spotfire.
-
Using the CData Software ODBC Driver for Supabase in PyCharm
Connect to Supabase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Supabase.
-
Integrate Devin with Live Sugar CRM 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 Sugar CRM data.
-
Provide OData Services of Parquet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Parquet data by developing a WCF Service Application.
-
How to Visualize Paylocity Data in Python with pandas
Use pandas and other modules to analyze and visualize live Paylocity data in Python.
-
Integrate LibreChat with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live JSON services from within the chat interface.
-
Create Informatica Mappings From/To an ODBC Data Source for XML
Create an ODBC connection to XML in Informatica and browse and transfer XML data.
-
How to Build an ETL App for PostgreSQL Data in Python with CData Connect AI
Build ETL pipelines that read and write live PostgreSQL data in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to Live YouTube Analytics 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 YouTube Analytics data without replication.
-
Import Real-Time iContact Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use iContact data in ColdFusion.
-
How to Easily Query Outlook Data in OpenOffice Base
Connect to Outlook data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Oracle Service Cloud Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Service Cloud data in the Pentaho Data Integration tool.
-
Connect to Dynamics NAV Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Dynamics NAV data from Filemaker Pro on Mac.
-
Publish CapsuleCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CapsuleCRM data.
-
Migrating data from Contentful to Databricks using CData SSIS Components.
Easily push Contentful data to Databricks using the CData SSIS Tasks for Contentful and Databricks.
-
Connect to Bitly Data from Crystal Reports
Use CData Connect AI to connect to and report on live Bitly data from Crystal Reports.
-
Access Hacker News Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Hacker News data from your Oracle system.
-
Create XML-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to XML Data from Klipfolio and build custom visualizations using live XML data.
-
Use Grok to Talk to Your Greenplum 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 Greenplum data for you.
-
Connect to Sage 300 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 Sage 300 data.
-
Automated Continuous QuickBooks Online Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to IBM DB2.
-
Replicate Sage Intacct Data from PowerShell
Write a quick PowerShell script to query Sage Intacct data. Use connectivity to the live data to replicate Sage Intacct data to SQL Server.
-
Create Reports with HubSpot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubSpot data.
-
Integrating Antigravity CLI with Printify data via CData CLI
Connect Printify data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData Software ODBC Driver for Quickbase in MicroStrategy
Connect to Quickbase data in MicroStrategy Developer using the CData Software ODBC Driver for Quickbase.
-
Build AI/ML Models with Live Hugging Face Data using Dataiku
Connect Hugging Face Data with Dataiku using the CData API Driver for JDBC.
-
Provide OData Services of Adobe Experience Manager Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Adobe Experience Manager data by developing a WCF Service Application.
-
How to Connect the Power BI Service to FTP: Complete Guide
Connect to the CData Software Power BI Connector for FTP from PowerBI.com to provide real-time FTP data across the organization.
-
Integrating Reckon Data in Talend Cloud Data Management Platform
Connect Reckon Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Reckon.
-
Build MVC Applications with Connectivity to JobNimbus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JobNimbus from an ASP.NET MVC application.
-
Connect Adobe Experience Manager Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Adobe Experience Manager data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to LightSpeedRetail Data in Ruby
Connect to LightSpeedRetail data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Dashboards with Freshsales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshsales data in Dundas BI.
-
Replicate Codat Data to Multiple Databases via the CData Sync CLI
Replicate Codat data to disparate databases with a single configuration.
-
Integrate Google's Antigravity Agent with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sybase data using the Model Context Protocol.
-
Build a PostgreSQL Interface for OData Services using the CData JDBC Driver
Use the Remoting features of the OData JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query QuickBooks Online Data in OpenOffice Base
Connect to QuickBooks Online data in OpenOffice Base using the CData ODBC Driver for QuickBooks Online and generate reports with live data insights.
-
Connect to and Visualize Live Opsgenie Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Opsgenie data.
-
Automated Continuous Paddle Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Paddle replication to Apache Cassandra.
-
Connect to and Visualize Live Freshsales Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshsales data.
-
Operational Reporting on ConvertAPI Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ConvertAPI data.
-
Create ShipStation-Connected Dashboards in Grafana
Connect to ShipStation Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ShipStation data.
-
Work with eBay Analytics Data in FoxPro
Load eBay Analytics data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Mocean Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mocean replication to Azure SQL Database.
-
Close Reporting in OBIEE with the Close JDBC Driver
Deploy the Close JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Cosmos DB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cosmos DB replication to IBM DB2.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Online data for you.
-
Connect to TaxJar Data from Crystal Reports
Use CData Connect AI to connect to and report on live TaxJar data from Crystal Reports.
-
Use the CData Software ODBC Driver for Perplexity in MicroStrategy
Connect to Perplexity data in MicroStrategy Developer using the CData Software ODBC Driver for Perplexity.
-
Create OpenWeatherMap Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time OpenWeatherMap data access from reports, embedded analytics, and more.
-
Model, Search, and Visualize Live Reckon Accounts Hosted Data in ThoughtSpot
Use CData Connect AI to connect to live Reckon Accounts Hosted data for modeling, searching, and visualizing.
-
ETL CSV in Oracle Data Integrator
This article shows how to transfer CSV data into a data warehouse using Oracle Data Integrator.
-
How to Visualize Excel Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Excel Online data in Python.
-
Integrating OpenCode with Monday.com 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.
-
Visualize Live Adobe Experience Manager Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Experience Manager data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Twilio Data in Aqua Data Studio
Access Twilio data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Paddle Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Paddle replication to PostgreSQL.
-
Access SAP SuccessFactors LMS Data from MySQL in Amazon QuickSight
Connect to SAP SuccessFactors LMS and build visualizations of SAP SuccessFactors LMS data using a MySQL Connection in Amazon QuickSight.