CData Software - Knowledge Base
Recent Articles
-
Connect to Shippo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shippo to connect to Shippo from Web applications running on WebLogic.
-
Connect to Zoho Books Data in Aqua Data Studio
Access Zoho Books from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Square-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Square Data and create custom apps in Mendix.
-
Replicate SparkPost Data in Heroku for Use in Salesforce Connect
Replicate SparkPost to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Greenplum Data in Jaspersoft Studio
Execute SQL to remote Pivotal GreenPlum in Jaspersoft Studio.
-
Build SAP SuccessFactors-Connected Apps in Choreo
Use CData Connect AI to connect to SAP SuccessFactors Data from Choreo and build custom apps using live SAP SuccessFactors.
-
Integrating GitHub Copilot CLI with Microsoft Dataverse (CDS) 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 Cosmos DB Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cosmos DB replication to SingleStore.
-
Use the CData Software JDBC Driver for Dropbox in MicroStrategy Desktop
Connect to Dropbox in MicroStrategy Desktop using the CData Software JDBC Driver for Dropbox.
-
Access Live Lakebase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase from your Excel spreadsheets.
-
Access Live Raisers Edge NXT Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Raisers Edge NXT from your Excel spreadsheets.
-
Getting Started with the CData ADO.NET Provider for SendGrid
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SendGrid.
-
Connect to Instagram Data in Aqua Data Studio
Access Instagram from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Google Sheets in MicroStrategy Desktop
Connect to Google Sheets in MicroStrategy Desktop using the CData Software ODBC Driver for Google Sheets.
-
How to import Drift Data into Apache Solr
Use the CData Software JDBC Driver for Drift in Data Import Handler and create an automated import of Drift to Apache Solr Enterprise Search platform.
-
Use the CData SSIS Components to Insert New or Update Existing SAS Data Sets Records from SQL Server
Easily push SQL Server data to SAS Data Sets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAS Data Sets or update existing records with data from a SQL Server database.
-
Visualize Discourse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Discourse.
-
Build a PostgreSQL Interface for Google Translate Data using the CData JDBC Driver
Use the Remoting features of the Google Translate JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up SAP Fieldglass to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Fieldglass. In this article, we will employ an SSIS workflow to populate a database with SAP Fieldglass data.
-
Automated Continuous OnePageCrm Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Apache Cassandra.
-
Prepare, Blend, and Analyze Mocean Data in Alteryx Designer (ODBC)
Build workflows to access live Mocean for self-service data analytics.
-
Create MailChimp-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MailChimp Data from OutSystems and build custom enterprise apps using live MailChimp.
-
Analyze Google Directory Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Directory and visualize live Google Directory in Infragistics Reveal.
-
Query Freshservice Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Freshservice entities in PHP by modeling them as objects.
-
Build Charts with Pipedrive Data in Clear Analytics
Create dynamic charts and perform analytics based on Pipedrive in Clear Analytics.
-
Analyze Tavily Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tavily with the CData JDBC Driver for Tavily.
-
Connect to SAP Business Warehouse Data in RazorSQL
Connect to SAP Business Warehouse from wizards and query SAP Business Warehouse from the GUI in the RazorSQL database management tool.
-
Work with Live MailChimp Data in Power Query
Use CData Connect AI to connect to MailChimp and work with live MailChimp in Microsoft Power Query.
-
Integrate Real-Time Access to Google Campaign Manager 360 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Campaign Manager 360 in real time.
-
Automated Continuous SendPulse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendPulse replication to Google BigQuery.
-
Getting Started with the CData Tableau Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect SharePoint with Twitter Ads Data through external lists
Provide Twitter Ads to SharePoint users as an external list.
-
Write a Simple Go Application to work with Productboard Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Productboard.
-
Connect to Pingdom Data in RapidMiner
Integrate Pingdom with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Google Ad Manager Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Ad Manager in Dundas BI.
-
Connect to Redshift Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Redshift in the Denodo Virtual DataPort Administrator.
-
Integrating Claude Code CLI with Recurly 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.
-
Build AI/ML Models with Live Salesforce Pardot Data using Dataiku
Connect Salesforce Pardot Data with Dataiku using the CData JDBC Driver for Salesforce Pardot.
-
Integrate with Live Presto Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Presto from the MuleSoft Anypoint Platform to integrate live Presto into custom reports and dashboards.
-
Access Live Bullhorn CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bullhorn CRM from your Excel spreadsheets.
-
Access Beeminder Data from MySQL in Amazon QuickSight
Connect to Beeminder and build visualizations of Beeminder using a MySQL Connection in Amazon QuickSight.
-
How to Query Live Qualaroo Data in Perplexity MacOS Desktop
Connect to and query live Qualaroo Data in Perplexity Desktop using CData MCP Server.
-
Create Dynamic Zendesk Grids Using the Infragistics XamDataGrid
Learn how you can connect Zendesk to Infragistics XamDataGrid to build dynamic grids.
-
Automate Sybase IQ Data Replication to Azure Synapse
Use CData Sync to customize and automate Sybase IQ replication to Azure Synapse.
-
Stream Dynamics NAV Data into Apache Kafka Topics
Access and stream Microsoft Dynamics NAV in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze SAP Ariba Procurement Data in Cognos Analytics
Use CData Connect AI to connect to SAP Ariba Procurement Data from Cognos Analytics and analyze live SAP Ariba Procurement.
-
Import Real-Time BenchmarkEmail Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BenchmarkEmail in ColdFusion.
-
Integrating Kiro CLI with ZohoDesk 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.
-
Build Gumroad-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Gumroad Data in Cursor to assist with building Gumroad-powered applications.
-
How to import Float Data into Apache Solr
Use the CData Software JDBC Driver for Float in Data Import Handler and create an automated import of Float to Apache Solr Enterprise Search platform.
-
View Reports on Real-Time Reckon Data in Power BI Report Server
Use the CData ODBC Driver for Reckon to visualize Reckon in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Printful Data from MySQL in Amazon QuickSight
Connect to Printful and build visualizations of Printful using a MySQL Connection in Amazon QuickSight.
-
Connect to Browserless from a Connection Pool in WebLogic
Use the CData JDBC Driver for Browserless to connect to Browserless from Web applications running on WebLogic.
-
Connect to Oracle Data in RapidMiner
Integrate Oracle Database with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Microsoft Entra ID Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Entra ID from your AWS Glue jobs.
-
Migrating data from Keap to Databricks using CData SSIS Components.
Easily push Keap to Databricks using the CData SSIS Tasks for Keap and Databricks.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (ODBC)
Build workflows to access live IBM Informix for self-service data analytics.
-
Jira Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira facts in real time.
-
Build Sage 200-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sage 200 to explore live Sage 200 Data in Cursor to assist with building Sage 200-powered applications.
-
Analyze XML Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze XML Files in Microsoft R Open.
-
Extend Google Sheets with Dynamics 365 Data
Make calls to Dynamics 365 from Google Apps Script via the API Server.
-
How to connect to Exact Online Data from IntelliJ
Integrate connectivity to Exact Online with wizards in IntelliJ.
-
Access Codat Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Codat from your Oracle system.
-
Connect to Real-Time Hugging Face Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hugging Face in Power Apps.
-
Getting Started with the CData Excel Add-In for Apollo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Apollo.
-
Automated Continuous CapsuleCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Kafka.
-
Getting Started with the CData JDBC Driver for Xero
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Xero.
-
Access Live Strava Data in Coginiti Pro
Connect to and query live Strava from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Multiple QuickBooks Time Accounts
Replicate multiple QuickBooks Time accounts to one or many databases.
-
Connect to BigQuery Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BigQuery and the SQL Gateway to access Google BigQuery from Google Apps Script.
-
Import Real-Time Attio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Attio in ColdFusion.
-
Access Access Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Access from your Oracle system.
-
How to connect to Zoho Recruit Data with Squirrel SQL client
Connect to Zoho Recruit and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live Facebook Data in ThoughtSpot
Use CData Connect AI to connect to live Facebook for modeling, searching, and visualizing.
-
Work with SuiteCRM Data in FoxPro
Load SuiteCRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Deploy the ADO.NET Provider for SingleStore on an SSRS Report Server
Connect to SingleStore 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 Dynamics NAV Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQLite.
-
Working with Shippo Data in LINQPad
Execute LINQ queries to Shippo in LINQPad.
-
Build AI Agents with OData Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live OData through CData Connect AI.
-
Integrate Theia IDE with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Attio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Acumatica in MicroStrategy Desktop
Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software ODBC Driver for Acumatica.
-
Build a Singer.io Tap for Guru With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Guru data using
-
Visualize Amazon Athena Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Athena.
-
Excel Spreadsheet Automation on Act CRM Data with the QUERY Formula
Pull data from Act CRM, automate spreadsheets, and more with the QUERY formula.
-
A PostgreSQL Interface for Square Data (MySQL Remoting via JDBC)
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Time for you.
-
How to integrate Teradata with Apache Airflow
Access and process Teradata in Apache Airflow using the CData JDBC Driver.
-
Connect to Klipfolio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Klipfolio in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Opsgenie Replication to Oracle
Use CData Sync for automated, continuous, customizable Opsgenie replication to Oracle.
-
Connect to PivotalTracker Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PivotalTracker and the SQL Gateway to access PivotalTracker from Google Apps Script.
-
Build MarkLogic Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MarkLogic and build visualizations in Tableau Cloud.
-
Query Sage Intacct Data as a MySQL Database in Node.js
Execute MySQL queries against Sage Intacct from Node.js.
-
Automated Continuous Quickbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Kafka.
-
Migrating data from Hubstaff to Databricks using CData SSIS Components.
Easily push Hubstaff to Databricks using the CData SSIS Tasks for Hubstaff and Databricks.
-
How to connect PolyBase to AfterShip
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live AfterShip.
-
Analyze Avaza Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Avaza and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Zoho Projects Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Projects in FileMaker Pro to connect to Zoho Projects and work with Zoho Projects in your FileMaker applications.
-
Query Salesforce from Node.js
Execute CRUD queries to live Salesforce data in Node.js.
-
How to import Google Ad Manager Data into Apache Solr
Use the CData Software JDBC Driver for Google Ad Manager in Data Import Handler and create an automated import of Google Ad Manager to Apache Solr Enterprise Search platform.