CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for ZohoSubscriptions in a Connection Pool in Tomcat
Connect to ZohoSubscriptions data from a connection pool in Tomcat.
-
Import and Visualize Avro Data in Power View
Create data visualizations based on Avro data in Excel.
-
How to Connect to & Open Aha! Data in Microsoft Excel
This article uses the CData ODBC driver for Aha! to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Google Search Results as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Search results from your Oracle system.
-
Manage Square Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Square.
-
Automated Continuous FreeAgent Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable FreeAgent replication to PostgreSQL.
-
Interact with Live Asana Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Asana data.
-
Visualize Live SAP Ariba Procurement Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Ariba Procurement data.
-
Create Dynamic OneNote Grids Using the Infragistics XamDataGrid
Learn how you can connect OneNote to Infragistics XamDataGrid to build dynamic grids.
-
Build an OLAP Cube in SSAS from Quickbase Data
Establish a connection to Quickbase data data from SQL Server Analysis Services, and use the Quickbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for ZarMoney in MicroStrategy Desktop
Connect to ZarMoney data in MicroStrategy Desktop using the CData Software ODBC Driver for ZarMoney.
-
Build a Simple VCL Application for Todoist Data
How to build a simple VCL Application to view Todoist data in RAD Studio using the CData ODBC Driver for Todoist.
-
Integrating Claude Code CLI with Hubstaff 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.
-
Connect to Freshdesk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk in FileMaker Pro to connect to Freshdesk and work with Freshdesk data in your FileMaker applications.
-
How to Connect to Live Guru Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Guru data securely in real time.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy Desktop
Connect to SingleStore data in MicroStrategy Desktop using the CData Software ODBC Driver for SingleStore.
-
Access Live IBM Cloud Object Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloud Object Storage data from your Excel spreadsheets.
-
Enable the Salesforce Pardot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Pardot data.
-
Access NASA Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live NASA data from HeidiSQL.
-
Moving Data from FTP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FTP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Multiple Rootly Accounts
Replicate multiple Rootly accounts to one or many databases.
-
Use Azure AI Foundry to Talk to Your Vertica 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 Vertica data for you.
-
Use Manus AI to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Facebook data.
-
Integrate with Helpscout Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Helpscout data to a JSON file on disk.
-
How to Connect to & Open OnePageCrm Data in Microsoft Excel
This article uses the CData ODBC driver for OnePageCrm to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Agno to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
Automated Continuous SAP Ariba Procurement Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Azure SQL Database.
-
Connect to Tavily Data in JRuby
Create a simple JRuby app with access to live Tavily data.
-
Integrate ShipEngine Data in the Pentaho Report Designer
Publish reports based on ShipEngine data in the Pentaho BI tool.
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting data and execute queries in PowerBuilder.
-
Prepare, Blend, and Analyze SAP Hybris C4C Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Hybris C4C data for self-service data analytics.
-
Query Live Testmonitor Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Testmonitor data through a conversational interface.
-
Access Live GraphQL Data in Excel 365 Online (Excel for the web)
Connect to GraphQL data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for Microsoft Ads Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Ads in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Ads data.
-
Connect to ServiceNow Data from PowerBuilder via JDBC
This article demonstrates how to access ServiceNow data from PowerBuilder using the ServiceNow JDBC Driver.
-
How to create Klipfolio federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Klipfolio data in MySQL .
-
How to Work with CampaignMonitor Data in AWS Glue Jobs Using JDBC
Connect to CampaignMonitor from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Bind Live Microsoft Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Feed SuiteCRM Data into FineReport
How to set SuiteCRM data as a JDBC data source in FineReport.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (Connect AI)
Build workflows to access live Workday data for self-service data analytics.
-
Connect to OpenWeatherMap Data in Jaspersoft Studio
Execute SQL to remote OpenWeatherMap data in Jaspersoft Studio.
-
LinkedIn Ads Reporting in OBIEE with the LinkedIn Ads JDBC Driver
Deploy the LinkedIn Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software JDBC Driver for Omnisend in MicroStrategy Web
Connect to Omnisend data in MicroStrategy Web using the CData Software JDBC Driver for Omnisend.
-
Import Elasticsearch Data Using Azure Data Factory
Use CData Connect AI to connect to Elasticsearch Data from Azure Data Factory and import live Elasticsearch data.
-
Working with RSS Feeds in LINQPad
Execute LINQ queries to RSS feeds in LINQPad.
-
Visualize GitHub Data in TIBCO Spotfire through ADO.NET
Integrate GitHub data into dashboards in TIBCO Spotfire.
-
Connect to Microsoft Teams Data in RapidMiner
Integrate Microsoft Teams data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Live Active Directory Data in MicroStrategy through CData Connect AI
Create a live connection to Active Directory Data in CData Connect AI and connect to your Active Directory data from MicroStrategy.
-
Query Oracle Service Cloud Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Service Cloud data from Node.js.
-
Extract, Transform, and Load Zoho CRM Data in Informatica PowerCenter
Create a simple Workflow for Zoho CRM data in Informatica PowerCenter.
-
Automated Continuous ZohoPeople Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Apache Cassandra.
-
Connect to Outreach.io Data in JRuby
Create a simple JRuby app with access to live Outreach.io data.
-
Integrate with live XML Data in Jitterbit
Use CData Connect AI to connect to and integrate live XML data in Jitterbit.
-
Provide OData Services of Xero Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Xero data by developing a WCF Service Application.
-
Create Reports from DB2 Data in Looker Studio
Use CData Connect AI to gain access to live DB2 data and create custom reports in Looker Studio.
-
Connect to Pipeline CRM Data in RazorSQL
Connect to Pipeline CRM from wizards and query Pipeline CRM data from the GUI in the RazorSQL database management tool.
-
Integrate with Apollo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apollo data in SnapLogic.
-
Visualize ZohoExpense 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 ZohoExpense data into TIBCO Spotfire.
-
Publish Google Translate-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Translate data.
-
Work with Live Wistia Data in Power Query
Use CData Connect AI to connect to Wistia data and work with live Wistia data in Microsoft Power Query.
-
Quick Setup Guide for CData HubSpot Drivers
Easy guide for using CData HubSpot Drivers and Connectors for the first time.
-
Integrate Live Cassandra Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cassandra from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cassandra data.
-
Automated Continuous Azure DevOps Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure DevOps replication to SingleStore.
-
Query Marketo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Marketo data from Node.js.
-
Getting Started with the CData Tableau Connector for Attio
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Stripe Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Stripe replication to delimited files (CSV/TSV).
-
Automate Spotify Data Replication to SAP HANA
Use CData Sync to customize and automate Spotify data replication to SAP HANA.
-
Natively Connect to WooCommerce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WooCommerce data. Leverage the native support for ODBC in PHP.
-
Connect Bannerbear Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bannerbear data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Singer.io Tap for Dynamics 365 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics 365 data using the CData Python Connector.
-
Query Live HCL Domino 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 HCL Domino data directly from the development environment.
-
Automated Continuous Humanity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Humanity replication to Google BigQuery.
-
Visualize Live Vertica Data in the Power BI Service
Use CData Connect AI to connect to live Vertica data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Shortcut 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 Shortcut data through MCP integration.
-
How to Connect to Live Zendesk 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 Zendesk data for you.
-
Easily Integrate Amazon DynamoDB Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon DynamoDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Ads in FileMaker Pro to connect to Microsoft Ads and work with Microsoft Ads data in your FileMaker applications.
-
Create a Data Access Object for Square Data using JDBI
A brief overview of creating a SQL Object API for Square data in JDBI.
-
Integrate with GraphQL Data in SnapLogic
Use CData Connect AI to connect to and integrate with live GraphQL data in SnapLogic.
-
Visualize MessageBird Data in Sisense
Create an ElastiCube in Sisense app with access to MessageBird data.
-
DataBind Notion Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Notion data to a chart.
-
Access Live Google Campaign Manager 360 Data in TIBCO Data Virtualization
Use the Google Campaign Manager 360 Tibco DV Adapter to create a Google Campaign Manager 360 data data source in TIBCO Data Virtualization Studio and gain access to live Google Campaign Manager 360 data from your TDV Server.
-
Moving Data from Google Directory to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Directory data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Smartsheet Data in DBeaver
Use the CData ODBC Driver to connect to Smartsheet data in DBeaver.
-
Build Apps with Live Hubstaff Data Using the Low-Code Development Platform of Mendix
Connect Hubstaff data with Mendix to build apps using the CData API Driver for JDBC.
-
How to integrate VWO with Apache Airflow
Access and process VWO data in Apache Airflow using the CData JDBC Driver.
-
Create Gmail Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gmail data access from reports, embedded analytics, and more.
-
Create Dashboards and Visualize Live ShipEngine Data in Geckoboard
Use CData Connect AI to connect to live ShipEngine data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Open WebUI with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Certinia data from within the chat interface.
-
Connect to Paymo Data from AWS Glue
Use CData Connect AI to gain access to live Paymo data from your AWS Glue jobs.
-
Publish OnePageCrm-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OnePageCrm data.
-
Import Real-Time Quickbase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Quickbase data in ColdFusion.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy Web
Connect to Oracle Service Cloud data in MicroStrategy Web using the CData Software ODBC Driver for Oracle Service Cloud.
-
How to integrate Confluence with Apache Airflow
Access and process Confluence data in Apache Airflow using the CData JDBC Driver.
-
Connect to DB2 Data in RazorSQL
Connect to DB2 from wizards and query DB2 data from the GUI in the RazorSQL database management tool.
-
How to create an RPA flow for Microsoft OneDrive Data in UiPath Studio
Use the Microsoft OneDrive ODBC Driver to create workflows that access real-time Microsoft OneDrive data without any coding.
-
Access Live CapsuleCRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CapsuleCRM data into the statistical analysis tools available in SAS JMP. This article shows how to use CapsuleCRM data in the Graph Builder and Query Builder.
-
SAP Ariba Procurement Reporting in OBIEE with the SAP Ariba Procurement JDBC Driver
Deploy the SAP Ariba Procurement JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Agents in Relevance AI with Access to Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PostgreSQL data within intelligent agent workflows.
-
Connect to Real-Time Quaderno Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Quaderno data in Power Apps.