CData Software - Knowledge Base
Recent Articles
-
How to create MYOB AccountRight federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MYOB AccountRight in MySQL .
-
Explore Geographical Relationships in Certinia Data with Power Map
Create data visualizations with Certinia in Power Map.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exa
Provide connectivity to Exa through an SAP BusinessObjects universe.
-
Access Live SAP Netweaver Gateway Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Netweaver Gateway data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Claude Code CLI with Google Translate 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.
-
Access Grafana Data from MySQL in PHP
Connect to Grafana through the standard MySQL libraries in PHP.
-
Query Demio Data as a MySQL Database in Node.js
Execute MySQL queries against Demio from Node.js.
-
Process & Analyze Accelo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Accelo Data.
-
Build Automated SAP Netweaver Gateway-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Netweaver Gateway and build automated workflows in Zapier.
-
Use CData Connect AI to Access FHIR Data in Microsoft Power Pivot
Use CData Connect AI to connect to live FHIR in the Power Pivot business intelligence tool.
-
Query Sybase IQ Data as a MySQL Database in Node.js
Execute MySQL queries against Sybase IQ from Node.js.
-
Excel Spreadsheet Automation on Azure Synapse Data with the QUERY Formula
Pull data from Azure Synapse, automate spreadsheets, and more with the QUERY formula.
-
Connect to Real-Time Instagram Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Instagram and Dataflow to import and use Instagram in Power Apps.
-
Connect to NetSuite Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live NetSuite CRM & ERP from Filemaker Pro on Mac.
-
Migrating data from IBM Informix to Snowflake using CData SSIS Components.
Easily push IBM Informix to Snowflake using the CData SSIS Tasks for IBM Informix and Snowflake.
-
Access Live NetSuite Data in TIBCO Data Virtualization
Use the NetSuite Tibco DV Adapter to create a NetSuite CRM & ERP data source in TIBCO Data Virtualization Studio and gain access to live NetSuite CRM & ERP from your TDV Server.
-
Integrate Calendly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Calendly from Informatica Cloud.
-
Bidirectional Access to Hacker News Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hacker News in Filemaker Pro for Mac or Windows.
-
Create Procore-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Procore Data from OutSystems and build custom enterprise apps using live Procore.
-
Integrating LangChain with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Stripe within automated workflows.
-
DataBind Billsby Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Billsby to a chart.
-
Viewing FTP Data in RAD Studio Data Explorer
How to view FTP Servers in RAD Studio Data Explorer using the CData ODBC Driver for FTP.
-
How to connect to ShipStation Data in DBVisualizer
Integrate ShipStation with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Calendly Data in DBVisualizer
Integrate Calendly with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Dashboards with ShipEngine Data in Dundas BI
Create dynamic dashboards and perform analytics based on ShipEngine in Dundas BI.
-
Analyze Cloudflare Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cloudflare with the CData JDBC Driver for Cloudflare.
-
Create Dashboards and Visualize Live Facebook Data in Geckoboard
Use CData Connect AI to connect to live Facebook and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Sybase IQ Data from PowerBuilder via JDBC
This article demonstrates how to access Sybase IQ from PowerBuilder using the Sybase IQ JDBC Driver.
-
Integrating Kiro CLI with HubSpot 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.
-
Extract, Transform, and Load Customer.io Data in Informatica PowerCenter
Create a simple Workflow for Customer.io in Informatica PowerCenter.
-
Connect to Zendesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zendesk and the SQL Gateway to access Zendesk from Google Apps Script.
-
Integrating Claude Code CLI with SendPulse 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.
-
Integrate with Marketo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Marketo in SnapLogic.
-
Connect to ADP Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ADP Data and connect to ADP in Akorbi Digital RunMyProcess.
-
Integrating Boomi Agentstudio with OneNote Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft OneNote, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
DataBind Charts to Delighted Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Delighted from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Google Directory Data in Looker
Use CData Connect AI to connect to Google Directory Data from Looker and build custom apps using live Google Directory.
-
Natively Connect to Shopify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Shopify. Leverage the native support for ODBC in PHP.
-
Visualize Live Bitly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bitly.
-
Connect to SFTP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SFTP.
-
How to Connect to & Open Jodoo Data in Microsoft Excel
This article uses the CData ODBC driver for Jodoo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Freshsales Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshsales from Power Pivot. You will use the Table Import Wizard to load Freshsales. You can visually build the import query or use any SQL supported by the driver.
-
How to connect PolyBase to Egnyte
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Egnyte.
-
Connect to Sendwithus Data in Aqua Data Studio
Access Sendwithus from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Controls to Figshare Data in Delphi
DataBind to Figshare in Delphi with standard data access components and controls.
-
Automated Delighted Data Replication to Teradata
Use CData Sync to Customize and automate Delighted replication to Teradata.
-
Build Automated Workflows with Live Sybase IQ Data in Workato
Use CData Connect AI to connect to live Sybase IQ and build automated workflows in Workato.
-
Replicate Tickspot Data to Multiple Databases via the CData Sync CLI
Replicate Tickspot to disparate databases with a single configuration.
-
How to Connect to Live Sybase IQ 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 Sybase IQ for you.
-
Import and Visualize Helpscout Data in Power View
Create data visualizations based on Helpscout in Excel.
-
Connect to Adobe Target Data in RapidMiner
Integrate Adobe Target with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live eBay 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 eBay through MCP integration.
-
Integrate with Autopilot Data in JReport Designer
Create charts and reports based on Autopilot in JReport Designer.
-
Build a Singer.io Tap for Zoom With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoom data using
-
Connect to Templated Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Templated as an External Source in Dremio.
-
Integrate Open WebUI with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Books from within the chat interface.
-
Migrating data from Optimizely to Databricks using CData SSIS Components.
Easily push Optimizely to Databricks using the CData SSIS Tasks for Optimizely and Databricks.
-
Operational Reporting on Sugar CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sugar CRM.
-
Analyze Act-On Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Act-On and visualize Act-On in SAP Analytics Cloud.
-
Analyze Google Ad Manager Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Ad Manager and visualize live Google Ad Manager in Infragistics Reveal.
-
Integrating Antigravity CLI with Microsoft Access via CData CLI
Connect Microsoft Access to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for Google Analytics Data using JDBI
A brief overview of creating a SQL Object API for Google Analytics in JDBI.
-
Process & Analyze CampaignMonitor Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CampaignMonitor Data.
-
Integrate Slack Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Slack and integrate live Slack into your Power Automate tasks.
-
Query Okta Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Okta and perform CRUD operations on Okta from Node.js.
-
Build an OLAP Cube in SSAS from Freshdesk Data
Establish a connection to Freshdesk data from SQL Server Analysis Services, and use the Freshdesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Google Ad Manager Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Ad Manager from Informatica Cloud.
-
Load Wistia Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Wistia to a database.
-
Edit and Search External eBay Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of eBay to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create eBay Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Connect AI Python SDK for Adobe Commerce
Install the CData Connect AI Python SDK to read and write live Adobe Commerce with standard DB-API 2.0 Python code.
-
Build HubDB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HubDB to explore live HubDB Data in Claude Code to assist with building HubDB-powered applications.
-
DataBind SparkPost Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SparkPost to a chart.
-
Choosing the Best Method to Connect Gong to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Gong from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with SAP SuccessFactors Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP SuccessFactors in Dundas BI.
-
Getting Started with the CData Python Connector for Keap
Learn to install and license the CData Python Connector
-
Deploy the ADO.NET Provider for Testmonitor on an SSRS Report Server
Connect to Testmonitor 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.
-
Visualize Live Notion Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Notion using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for SAP SuccessFactors LMS Data using the CData ODBC Driver
Use the SQL Gateway and SAP SuccessFactors LMS ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Google Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Analytics to a JSON file on disk.
-
Build Semantic Layer Views for SendInBlue Data in APOS Live Data Gateway
Use the CData Connector for SendInBlue in APOS Live Data Gateway to build Semantic Layer Views for SendInBlue.
-
Query, Visualize, and Share live Cosmos DB Data in Redash
Use CData Connect AI to connect to live Azure Cosmos DB in Redash for querying, visualizing, and sharing.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Google Campaign Manager 360 using the Model Context Protocol.
-
Connect to Amazon Athena Data in Ruby
Connect to Amazon Athena in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Google Cloud Storage Data with Squirrel SQL client
Connect to Google Cloud Storage and execute queries in the Squirrel SQL Client.
-
Build Spark-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Spark Data and create custom apps in Bubble.
-
Stream LinkedIn Ads Data into Apache Kafka Topics
Access and stream LinkedIn Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Data Flows from SQL Server to SAS Data Sets through SSIS
Easily push SQL Server data to SAS Data Sets using the CData SSIS Tasks for SAS Data Sets.
-
Getting Started with the CData SSIS Components for Qualaroo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Qualaroo.
-
Create Reports with Dynamics 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics 365.
-
Access Live Avro Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Avro from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Oracle Service Cloud Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Vertica.
-
Connect to and Visualize Live Box Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Box.
-
Write a Simple Go Application to work with Certinia Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Certinia.
-
Automated Continuous AgileCRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AgileCRM replication to Amazon S3.
-
Query Live SurveyMonkey 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 SurveyMonkey directly from the development environment.
-
Bridge Browserless Connectivity with Apache NiFi
Access and process Browserless in Apache NiFi using the CData JDBC Driver.
-
Use Agno to Talk to Your Shopify 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 Shopify for you.
-
Create Informatica Mappings From/To an ODBC Data Source for SageHR
Create an ODBC connection to SageHR in Informatica and browse and transfer SageHR.
-
Connect Onfleet Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Onfleet using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Feed Webflow Data into FineReport
How to set Webflow as a JDBC data source in FineReport.