CData Software - Knowledge Base
Recent Articles
-
Integrate Retently Data in the Pentaho Report Designer
Publish reports based on Retently data in the Pentaho BI tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing data through an SAP BusinessObjects universe.
-
Integrate Avalara AvaTax Data in the Pentaho Report Designer
Publish reports based on Avalara AvaTax data in the Pentaho BI tool.
-
Automated Continuous Basecamp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon S3.
-
How to connect to ShipEngine Data with Squirrel SQL client
Connect to ShipEngine data and execute queries in the Squirrel SQL Client.
-
Create Dynamic Coinbase Grids Using the Infragistics XamDataGrid
Learn how you can connect Coinbase to Infragistics XamDataGrid to build dynamic grids.
-
Import and Visualize OnePageCrm Data in Power View
Create data visualizations based on OnePageCrm data in Excel.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Web
Connect to AfterShip data in MicroStrategy Web using the CData Software JDBC Driver for AfterShip.
-
Create Notion Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Notion data access from reports, embedded analytics, and more.
-
Load SAP Hybris C4C Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Hybris C4C data to a database.
-
Query Chargebee Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Chargebee data from Node.js.
-
Getting Started with the CData Python Connector for IBM Cloud Object Storage
Learn to install and license the CData Python Connector and configure a connection to live IBM Cloud Object Storage data.
-
Create a Data Access Object for ClickTime Data using JDBI
A brief overview of creating a SQL Object API for ClickTime data in JDBI.
-
Connect to Greenhouse Data in Ruby
Connect to Greenhouse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Dash to Build to Web Apps on Dynamics 365 Data
Create Python applications that use pandas and Dash to build Dynamics 365-connected web apps.
-
Connect to Productboard Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Productboard data.
-
Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy Desktop
Connect to SAP ByDesign data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP ByDesign.
-
Analyze Moosend Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Moosend data and visualize live Moosend data in Infragistics Reveal.
-
Enable the SAP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP data.
-
Automated Continuous Presto Replication to SQLite
Use CData Sync for automated, continuous, customizable Presto replication to SQLite.
-
Build Automated Gmail-Connected Workflows in Zapier
Use CData Connect AI to connect to live Gmail data and build automated workflows in Zapier.
-
Automated Continuous Confluence Replication to SQLite
Use CData Sync for automated, continuous, customizable Confluence replication to SQLite.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads data for you.
-
DataBind Controls to Airtable Data in C++Builder
DataBind to Airtable data in C++Builder with standard components and controls.
-
Connect to FTP Data in Ruby
Connect to FTP data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Coda-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Coda Data and create custom apps in Bubble.
-
Use Agno to Talk to Your Optimizely Data 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 Optimizely data for you.
-
LINQ to SpaceX Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SpaceX Data Provider.
-
How to Work with ConvertAPI Data in ETL Validator JDBC
Connect to ConvertAPI from ETL Validator jobs using the CData Software JDBC Driver.
-
Bridge Cloudant Connectivity with Apache NiFi
Access and process Cloudant data in Apache NiFi using the CData JDBC Driver.
-
How to connect Amazon QuickSight to VWO Data
Create a connection to VWO data in CData Connect AI and insert VWO data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Dropbox Data from PowerShell
Write a quick PowerShell script to query Dropbox data. Use connectivity to the live data to replicate Dropbox data to SQL Server.
-
Prepare, Blend, and Analyze CouchDB Data in Alteryx Designer (ODBC)
Build workflows to access live CouchDB data for self-service data analytics.
-
Query Live GitHub Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live GitHub data directly from the development environment.
-
How to Query Live SAP SuccessFactors LMS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP SuccessFactors LMS data data in natural language using Python.
-
Enable the SpaceX JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SpaceX data.
-
How to integrate Metabase with SAP Ariba Source Data
Use CData Connect AI to connect to live SAP Ariba Source data and create an interactive dashboard in Metabase from SAP Ariba Source data.
-
Connect to Tally Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Tally and the SQL Gateway to access Tally data from Google Apps Script.
-
Integrating Claude Code with Grafana Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Grafana data within assisted coding and automated development workflows.
-
How to Connect to Live Confluence 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 Confluence data for you.
-
Consume xBase OData Feeds in PowerBuilder
This article demonstrates how to consume xBase data as OData feeds from PowerBuilder using the API Server.
-
How to Build an ETL App for Miro Data in Python with CData
Create ETL applications and real-time data pipelines for Miro data in Python with petl.
-
DataBind Highrise Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Highrise with the DevExpress Windows Forms and Web controls to provide Highrise data to a chart.
-
Connect to Cosmos DB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Cosmos DB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Perigon Data in Aqua Data Studio
Access Perigon data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for SpaceX Data (MySQL Remoting via JDBC)
Use the Remoting features of the SpaceX JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live LaunchDarkly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LaunchDarkly data into the statistical analysis tools available in SAS JMP. This article shows how to use LaunchDarkly data in the Graph Builder and Query Builder.
-
Access SpaceX Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SpaceX data from your Oracle system.
-
Integrating Codex with Gong 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.
-
Analyze Yelp Data in Looker
Use CData Connect AI to connect to Yelp Data from Looker and build custom apps using live Yelp data.
-
Connect to Live MySQL Data in MicroStrategy through CData Connect AI
Create a live connection to MySQL Data in CData Connect AI and connect to your MySQL data from MicroStrategy.
-
Cassandra Reporting in OBIEE with the Cassandra JDBC Driver
Deploy the Cassandra JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Guru Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Guru data and visualize Guru data in SAP Analytics Cloud.
-
Excel Spreadsheet Automation on Coinbase Data with the QUERY Formula
Pull data from Coinbase, automate spreadsheets, and more with the QUERY formula.
-
Prepare, Blend, and Analyze Float Data in Alteryx Designer (ODBC)
Build workflows to access live Float data for self-service data analytics.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy Desktop
Connect to Google Spanner data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Spanner.
-
Link PabblySubscriptions with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PabblySubscriptions data in Filemaker Pro for Mac or Windows.
-
How to connect PolyBase to Google Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Ads data.
-
Create Nuclia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Nuclia data access from reports, embedded analytics, and more.
-
Integrating Antigravity CLI with Quickbase data via CData CLI
Connect Quickbase data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting GenSpark with Okta Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Okta data without any replication or custom integration required.
-
Connect to NASA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for NASA to connect to NASA data and execute queries in PowerBuilder.
-
Connect to PolarTeamPro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PolarTeamPro as an External Source in Dremio.
-
Access Wistia Data from MySQL in PHP
Connect to Wistia through the standard MySQL libraries in PHP.
-
Integrate Live SAP Ariba Source Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Ariba Source data to Blue Prism using the CData ODBC Driver for SAP Ariba Source to create automated workflows for repetitive business tasks.
-
Replicate Multiple Vertica Accounts via the CData Sync CLI
Replicate multiple Vertica accounts to one or many databases.
-
Using the CData Software ODBC Driver for Paddle in PyCharm
Connect to Paddle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paddle.
-
How to Work with Google Calendar Data in AWS Glue Jobs Using JDBC
Connect to Google Calendar from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Microsoft Teams Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to MongoDB.
-
Bridge Pingdom Connectivity with Apache NiFi
Access and process Pingdom data in Apache NiFi using the CData JDBC Driver.
-
How to Use a Microsoft Access Database to Update Databricks Data in Real Time
Update Databricks data by creating a linked table in Microsoft Access with the CData Databricks ODBC Driver.
-
Import Real-Time Databricks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Databricks data in ColdFusion.
-
Integrate Factorial Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Factorial data from Informatica Cloud.
-
Connect to Elorus Data from a Connection Pool in JBoss
Integrate Elorus data into Java servlets: Use the Management Console in JBoss to install the Elorus JDBC Driver.
-
Automated Continuous Box Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Box replication to Amazon Redshift.
-
Build Shippo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shippo data.
-
Act-On Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Act-On data through CData Connect AI using different applications and tools.
-
How to connect PolyBase to Microsoft Planner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Planner data.
-
Connect to Live Oracle HCM Cloud Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle HCM Cloud Data in CData Connect AI and connect to your Oracle HCM Cloud data from MicroStrategy.
-
Connect to Outreach.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Outreach.io data from Appeon PowerBuilder using the CData ADO.NET Provider for Outreach.io.
-
Automated Continuous Wrike Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Wrike replication to Google BigQuery.
-
Build MVC Applications with Connectivity to Datadog Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Datadog from an ASP.NET MVC application.
-
Access Live Couchbase Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Couchbase data from your Excel spreadsheets.
-
Build Charts with WordPress Data in Clear Analytics
Create dynamic charts and perform analytics based on WordPress data in Clear Analytics.
-
Automated Continuous Amazon DynamoDB Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Oracle.
-
Build Gong-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Gong Data and create custom apps in Mendix.
-
How to Connect to & Open Stripe Data in Microsoft Excel
This article uses the CData ODBC driver for Stripe to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for MailChimp in Microsoft Power Query
You can use the CData MailChimp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MailChimp data into Microsoft Power Query.
-
Automate Reply.io Data Replication to SAP HANA
Use CData Sync to customize and automate Reply.io data replication to SAP HANA.
-
Integrating Cursor with Mailjet 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 LaunchDarkly Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LaunchDarkly data replication to OneLake in Microsoft Fabric.
-
Integrating OpenCode with ZohoMarketingHub 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.
-
Query SAP BusinessObjects BI Data as a MySQL Database in Node.js
Execute MySQL queries against SAP BusinessObjects BI data from Node.js.
-
Visualize SAP Hybris C4C Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Hybris C4C data.
-
Integrating OpenCode with Zoho Inventory 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.
-
Back Up Discord data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Discord data data.
-
Publish Reports with Slack Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Slack data.
-
How to Work with Front Data in AWS Glue Jobs Using JDBC
Connect to Front from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ZohoMarketingHub Data in DBeaver
Use the CData ODBC Driver to connect to ZohoMarketingHub data in DBeaver.
-
Integrating Codex with Shopify 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.