CData Software - Knowledge Base
Recent Articles
-
Connect to Templated from Asprova with CData Software ODBC Driver for Templated
This article shows how to connect faster to Templated data from Asprova.
-
Connect to Bullhorn CRM Data in Jaspersoft Studio
Execute SQL to remote Bullhorn CRM in Jaspersoft Studio.
-
Automated Continuous SingleStore Replication to Databricks
Use CData Sync for automated, continuous, customizable SingleStore replication to Databricks.
-
Automated Continuous ZohoSubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to delimited files (CSV/TSV).
-
Automated SpaceX Data Replication to Teradata
Use CData Sync to Customize and automate SpaceX replication to Teradata.
-
Query Mouseflow Data in DataGrip
Create a Data Source for Mouseflow in DataGrip and use SQL to query live Mouseflow.
-
Easily Integrate Coinbase Data in Lazarus Pascal IDE
Learn how to easily integrate live Coinbase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live FHIR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FHIR.
-
Use Dash to Build to Web Apps on Freshsales Data
Create Python applications that use pandas and Dash to build Freshsales-connected web apps.
-
How to connect to ElevenLabs Data from Spring Boot
Connect to ElevenLabs in a Spring Boot Application using the CData API Driver for JDBC
-
Snowflake Reporting in OBIEE with the Snowflake JDBC Driver
Deploy the Snowflake JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Act CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Act CRM Data and create custom apps in Mendix.
-
Use Dash to Build to Web Apps on Highrise Data
Create Python applications that use pandas and Dash to build Highrise-connected web apps.
-
Connecting Agentforce with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your QuickBooks Online for you.
-
How to Connect Blackbaud FE NXT Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Blackbaud FE NXT data in real time using natural language.
-
How to connect Amazon QuickSight to Klaviyo Data
Create a connection to Klaviyo in CData Connect AI and insert Klaviyo into Amazon QuickSight SPICE to build interactive dashboards.
-
Rapidly Develop Customer.io-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Customer.io.
-
Connect to Postmark in SpagoBI
Create reports featuring live Postmark in SpagoBI Studio. Host Postmark reports on SpagoBI Server.
-
Analyze Salesforce Pardot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Pardot from Power Pivot. You will use the Table Import Wizard to load Salesforce Pardot. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for Workable
Learn to install and license the CData Python Connector
-
Build Semantic Layer Views for Cloudflare Data in APOS Live Data Gateway
Use the CData Connector for Cloudflare in APOS Live Data Gateway to build Semantic Layer Views for Cloudflare.
-
How to Seamlessly Import Clio Data into IBM SPSS Modeler
Integrate Clio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search External WooCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of WooCommerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create WooCommerce Data objects that you can access from apps and the dashboard.
-
Connect to Asana Data in JRuby
Create a simple JRuby app with access to live Asana.
-
Getting Started with the CData ADO.NET Provider for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Import Real-Time Zoho Recruit Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Recruit in ColdFusion.
-
Automated Continuous Sage 200 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQL Server.
-
Integrate FHIR Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FHIR and integrate live FHIR into your Power Automate tasks.
-
Write a Simple Go Application to work with Autopilot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Autopilot.
-
Automate Instagram Data Replication to SAP HANA
Use CData Sync to customize and automate Instagram replication to SAP HANA.
-
Using the CData Software ODBC Driver for Foursquare in PyCharm
Connect to Foursquare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Foursquare.
-
Query DB2 Data as a SQL Server Database in Node.js
Execute SQL Server queries against IBM DB2 from Node.js.
-
View Reports on Real-Time ConstantContact Data in Power BI Report Server
Use the CData ODBC Driver for ConstantContact to visualize ConstantContact in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Biml to Build SSIS Tasks to Replicate Qualaroo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Qualaroo to SQL Server.
-
Analyze Live Vertica Data in SAS Viya
Use CData Connect AI to connect to Vertica from SAS Viya and deploy self-service analytics using live Vertica.
-
Use Biml to Build SSIS Tasks to Replicate Monday.com Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Monday.com to SQL Server.
-
Connect to Salesforce from Asprova with CData Software ODBC Driver for Salesforce
This article shows how to connect faster to Salesforce data from Asprova.
-
Connect to Google Ads Data in NetBeans
Connect to Google Ads in NetBeans with the data source configuration wizard.
-
Connect to Superchat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Superchat and work with Superchat in your FileMaker applications.
-
Create SAP HANA XS Advanced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP HANA XS Advanced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous MailerLite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailerLite replication to Apache Cassandra.
-
Work with Live Airtable Data in Power Query
Use CData Connect AI to connect to Airtable and work with live Airtable in Microsoft Power Query.
-
Query DB2 Data in DataGrip
Create a Data Source for DB2 in DataGrip and use SQL to query live IBM DB2.
-
Connect to Greenplum Data in HULFT Integrate
Connect to Greenplum as a JDBC data source in HULFT Integrate
-
Add Zoho Creator Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Creator with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon S3 to Power BI dashboards. Simply drag and drop Amazon S3 into data visuals on the Power BI canvas.
-
Intercom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Intercom facts in real time.
-
Integrate with ShipEngine Data in JReport Designer
Create charts and reports based on ShipEngine in JReport Designer.
-
Automated Continuous Greenhouse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Greenhouse replication to Google BigQuery.
-
How to Connect to Live Google Drive Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Drive for you.
-
Integrate with NetSuite SuiteAnalytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live NetSuite SuiteAnalytics in SnapLogic.
-
Build MYOB AccountRight-Connected Apps in Choreo
Use CData Connect AI to connect to MYOB AccountRight Data from Choreo and build custom apps using live MYOB AccountRight.
-
Load Vercel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vercel to a database.
-
Use the CData Software JDBC Driver for Drip in MicroStrategy Web
Connect to Drip in MicroStrategy Web using the CData Software JDBC Driver for Drip.
-
Integrate Real-Time Access to Sage 300 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage 300 in real time.
-
How to Connect the Power BI Service to HBase: Complete Guide
Connect to the CData Software Power BI Connector for HBase from PowerBI.com to provide real-time Apache HBase across the organization.
-
Analyze HBase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HBase from Power Pivot. You will use the Table Import Wizard to load Apache HBase. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time Snowflake Data in Power BI Report Server
Use the CData ODBC Driver for Snowflake to visualize Snowflake in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Oracle SCM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle SCM from your Google Sheets.
-
Build Apps with Live Yelp Data Using the Low-Code Development Platform of Mendix
Connect Yelp with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize ConvertAPI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ConvertAPI.
-
How to Connect the Power BI Service to Azure DevOps: Complete Guide
Connect to the CData Software Power BI Connector for Azure DevOps from PowerBI.com to provide real-time Azure DevOps across the organization.
-
Query Act-On Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Act-On from Node.js.
-
How to Query Dynamics 365 Data in MySQL Workbench
Execute MySQL queries against live Microsoft Dynamics 365 from MySQL Workbench.
-
Getting Started with the CData Excel Add-In for Freshsales
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshsales.
-
Build a Singer.io Tap for ZendeskSell With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZendeskSell data using
-
Analyze SAP Fieldglass Data in Looker
Use CData Connect AI to connect to SAP Fieldglass Data from Looker and build custom apps using live SAP Fieldglass.
-
Integrate Theia IDE with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Build an ETL App for ServiceNow Data in Python with CData
Create ETL applications and real-time data pipelines for ServiceNow in Python with petl.
-
Automated Continuous Coinbase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Coinbase replication to Amazon Redshift.
-
Integrating Cursor CLI with YouTube Analytics 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.
-
How to Connect to & Open ZohoDesk Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Multiple Cloudflare Accounts
Replicate multiple Cloudflare accounts to one or many databases.
-
Automated Continuous HDFS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HDFS replication to AlloyDB.
-
How to connect to HubSpot Data from Spring Boot
Connect to HubSpot in a Spring Boot Application using the CData JDBC Driver for HubSpot
-
Visualize Live Outreach.io Data in the Power BI Service
Use CData Connect AI to connect to live Outreach.io and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with live MarkLogic Data in Jitterbit
Use CData Connect AI to connect to and integrate live MarkLogic in Jitterbit.
-
ETL Authorize.Net in Oracle Data Integrator
This article shows how to transfer Authorize.Net into a data warehouse using Oracle Data Integrator.
-
Connect to IBM Cloud Object Storage Data in Aqua Data Studio
Access IBM Cloud Object Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to work with Teradata Data in Apache Spark using SQL
Access and process Teradata Data in Apache Spark using the CData Software JDBC Driver.
-
Create Stripe-Connected Nintex Workflows
Use CData Connect AI to connect to Stripe Data from Nintex Workflow Cloud and build custom workflows using live Stripe.
-
Getting Started with the CData Python Connector for Suadeo
Learn to install and license the CData Python Connector
-
Rapidly Develop PhantomBuster-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PhantomBuster.
-
Moving Data from Miro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Miro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Amplitude Data from MySQL in Amazon QuickSight
Connect to Amplitude and build visualizations of Amplitude using a MySQL Connection in Amazon QuickSight.
-
Connect to Gong Data from HeidiSQL
Use CData Connect AI to connect to and query live Gong from HeidiSQL.
-
Connect to Oracle Eloqua Data in RazorSQL
Connect to Oracle Eloqua from wizards and query Oracle Eloqua from the GUI in the RazorSQL database management tool.
-
How to Import Data from Odoo into Google Sheets
Import Odoo ERP into a Google spreadsheet that is automatically refreshed.
-
Use Dash to Build to Web Apps on Suadeo Data
Create Python applications that use pandas and Dash to build Suadeo-connected web apps.
-
Publish Clockify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clockify.
-
Build a PostgreSQL Interface for Eventbrite Data using the CData JDBC Driver
Use the Remoting features of the Eventbrite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Email Data in Ruby
Connect to Email in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Migrating data from YouTube Analytics to Databricks using CData SSIS Components.
Easily push YouTube Analytics to Databricks using the CData SSIS Tasks for YouTube Analytics and Databricks.
-
Integrate with Landbot Data in JReport Designer
Create charts and reports based on Landbot in JReport Designer.
-
Integrating Codex CLI with Amazon DynamoDB 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.
-
Getting Started with the CData ODBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dynamics NAV.
-
How to Query Acumatica Data in MySQL Workbench
Execute MySQL queries against live Acumatica ERP from MySQL Workbench.
-
Use Grok to Talk to Your Zoho Inventory 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 Zoho Inventory for you.
-
Prepare, Blend, and Analyze xBase Data in Alteryx Designer (ODBC)
Build workflows to access live xBase for self-service data analytics.
-
Build SAP Business One-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Business One to explore live SAP Business One Data in Claude Code to assist with building SAP Business One-powered applications.