CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor CLI with CouchDB 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 a Simple VCL Application for SuiteCRM Data
How to build a simple VCL Application to view SuiteCRM in RAD Studio using the CData ODBC Driver for SuiteCRM.
-
Access Live SAP Ariba Source Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Source data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Spark Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Spark SQL. Leverage the pyodbc module for ODBC in Python.
-
Analyze Bullhorn CRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Bullhorn CRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Bridge SAP SuccessFactors LMS Connectivity with Apache NiFi
Access and process SAP SuccessFactors LMS in Apache NiFi using the CData JDBC Driver.
-
Visualize Microsoft Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Ads.
-
Seamlessly Bring Redis Data into Retool Using CData Connect AI
Integrate Redis data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Build an ETL App for Deel Data in Python with CData
Create ETL applications and real-time data pipelines for Deel in Python with petl.
-
Access Live Jira Assets Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Jira Assets from your Google Sheets.
-
Easily Integrate SAP Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP ERP/NetWeaver in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Shopify Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Shopify and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Analyze Greenhouse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Greenhouse in Microsoft R Open.
-
How to create an RPA flow for Power BI XMLA Data in UiPath Studio
Use the Power BI XMLA ODBC Driver to create workflows that access real-time Power BI XMLA without any coding.
-
Publish Reports with Omnisend Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Omnisend.
-
Establish a Live Connection with Dynamics 365 Business Central Data using Tableau Bridge
The CData ODBC Driver for Dynamics 365 Business Central enables you to integrate live Dynamics 365 Business Central into Tableau Cloud dashboards using the Tableau Bridge.
-
Stream DB2 Data into Apache Kafka Topics
Access and stream IBM DB2 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Facebook Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Facebook Ads from your Excel spreadsheets.
-
Create Data Visualizations in Cognos BI with Qualaroo Data
Access Qualaroo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to Vault CRM Data with Squirrel SQL client
Connect to Veeva Vault & Vault CRM and execute queries in the Squirrel SQL Client.
-
Automated Continuous Front Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Front replication to PostgreSQL.
-
Query Couchbase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Couchbase and perform CRUD operations on Couchbase from Node.js.
-
Getting Started with the CData Excel Add-In for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZohoInvoice.
-
Connect to MySQL Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MySQL Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Microsoft Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Ads and build visualizations in Tableau.
-
How to publish and share Google Analytics Data dashboards with Tableau Server
The CData ODBC driver for Google Analytics enables you integrate Google Analytics into Tableau dashboards.
-
Replicate Multiple Excel Accounts
Replicate multiple Excel accounts to one or many databases.
-
Getting Started with the CData Python Connector for ChartMogul
Learn to install and license the CData Python Connector
-
Publish Crystal Reports on Clio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clio.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce Marketing Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce Marketing Cloud.
-
Access Live MailerLite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MailerLite in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy Desktop
Connect to SAP Hybris C4C in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Hybris C4C.
-
How to create Rebilly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Rebilly in MySQL .
-
Write a Simple Go Application to work with SAP SuccessFactors Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP SuccessFactors.
-
Connect Spotify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Spotify using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Manage Cosmos DB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cosmos DB.
-
Using the CData Software ODBC Driver for Drip in PyCharm
Connect to Drip as an ODBC data source in PyCharm using the CData Software ODBC Driver for Drip.
-
Use the CData Software ODBC Driver for Demio in MicroStrategy Desktop
Connect to Demio in MicroStrategy Desktop using the CData Software ODBC Driver for Demio.
-
How to integrate JDBC-ODBC Bridge with Apache Airflow
Access and process JDBC-ODBC Bridge in Apache Airflow using the CData JDBC Driver.
-
Query Airtable Data as a MySQL Database in Node.js
Execute MySQL queries against Airtable from Node.js.
-
Instagram Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Instagram through CData Connect AI using different applications and tools.
-
Perform Batch Operations with JDBC-ODBC Bridge Data in Apache NiFi
Connect to JDBC-ODBC Bridge and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Authorize.Net Data from PowerBuilder via ADO.NET
This article demonstrates how to access Authorize.Net from Appeon PowerBuilder using the CData ADO.NET Provider for Authorize.Net.
-
Write a Simple Go Application to work with Aircall Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Aircall.
-
Connect Omnisend Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Omnisend using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Using the CData Software ODBC Driver for NetSuite in PyCharm
Connect to NetSuite as an ODBC data source in PyCharm using the CData Software ODBC Driver for NetSuite.
-
Automated Continuous Notion Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Notion replication to OneLake in Microsoft Fabric.
-
Rapidly Develop ElevenLabs-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 ElevenLabs.
-
How to Query ShipStation Data in MySQL Workbench
Execute MySQL queries against live ShipStation from MySQL Workbench.
-
ETL Bitbucket in Oracle Data Integrator
This article shows how to transfer Bitbucket into a data warehouse using Oracle Data Integrator.
-
Create Reports with FreshBooks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FreshBooks.
-
Automated Continuous Google Campaign Manager 360 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to delimited files (CSV/TSV).
-
Connect to LinkedIn Ads in SpagoBI
Create reports featuring live LinkedIn Ads in SpagoBI Studio. Host LinkedIn Ads reports on SpagoBI Server.
-
Connect to Reckon Data in RazorSQL
Connect to Reckon from wizards and query Reckon from the GUI in the RazorSQL database management tool.
-
Integrate MailChimp Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MailChimp and integrate live MailChimp into your Power Automate tasks.
-
Build Dashboards with MailChimp Data in DBxtra
Create dynamic dashboards and perform analytics based on MailChimp in DBxtra.
-
How to create Webflow federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Webflow in MySQL .
-
How to connect PolyBase to Short.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Short.io.
-
Build Salesforce-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Salesforce & Force.com.
-
View Reports on Real-Time MailChimp Data in Power BI Report Server
Use the CData ODBC Driver for MailChimp to visualize MailChimp in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to LaunchDarkly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LaunchDarkly to connect to LaunchDarkly and execute queries in PowerBuilder.
-
Access Reckon Accounts Hosted Data from MySQL in Amazon QuickSight
Connect to Reckon Accounts Hosted and build visualizations of Reckon Accounts Hosted using a MySQL Connection in Amazon QuickSight.
-
Visualize Opsgenie Data in TIBCO Spotfire through ADO.NET
Integrate Opsgenie into dashboards in TIBCO Spotfire.
-
Moving Data from Browserless to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Browserless data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Cloudflare Data in Tableau
The CData ODBC driver for Cloudflare enables you integrate Cloudflare into Tableau dashboards.
-
Connect and Query Live JSON Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live JSON into Databricks
-
Automated Continuous MessageBird Replication to SQL Server
Use CData Sync for automated, continuous, customizable MessageBird replication to SQL Server.
-
Connect to Real-Time Nethunt Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Nethunt in Power Apps.
-
Connect to Zuora Data in Jaspersoft Studio
Execute SQL to remote Zuora in Jaspersoft Studio.
-
Visualize Google Drive Data in TIBCO Spotfire through OData
Integrate Google Drive into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy
Connect to Amazon Athena in MicroStrategy Developer using the CData Software JDBC Driver for Amazon Athena.
-
View Reports on Real-Time IBM Cloud Object Storage Data in Power BI Report Server
Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Wrike Data in TIBCO Spotfire through ADO.NET
Integrate Wrike into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load ElevenLabs Data in Informatica PowerCenter
Create a simple Workflow for ElevenLabs in Informatica PowerCenter.
-
Create Databricks-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Databricks Data from OutSystems and build custom enterprise apps using live Databricks.
-
How to Connect to Live Google Cloud Storage Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Cloud Storage without replication.
-
Connect to Toggl Data from PowerBuilder via JDBC
This article demonstrates how to access Toggl from PowerBuilder using the Toggl JDBC Driver.
-
Viewing Eventbrite Data in RAD Studio Data Explorer
How to view Eventbrite in RAD Studio Data Explorer using the CData ODBC Driver for Eventbrite.
-
Migrating data from Excel to Snowflake using CData SSIS Components.
Easily push Microsoft Excel to Snowflake using the CData SSIS Tasks for Excel and Snowflake.
-
Building Dynamic Web Pages with SuiteCRM Data Using AngularJS
Create single-page applications with live connectivity to SuiteCRM using the CData API Server.
-
Connect to Autopilot Data in Ruby
Connect to Autopilot in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create Pingdom federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pingdom in MySQL .
-
Access Live Zoho Books 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 Zoho Books through MCP integration.
-
Getting Started with the CData Power BI Connector for Neo4J
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Neo4J.
-
Create SSAS Tabular Models from Jodoo Data
How to build a SQL Server Analysis Service Tabular Model from Jodoo using CData drivers.
-
Connect to BigCommerce Data from a Connection Pool in JBoss
Integrate BigCommerce into Java servlets: Use the Management Console in JBoss to install the BigCommerce JDBC Driver.
-
A PostgreSQL Interface for Nuclia Data (MySQL Remoting via JDBC)
Use the Remoting features of the Nuclia JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Import Data from Snowflake into Google Sheets
Import Snowflake into a Google spreadsheet that is automatically refreshed.
-
Automate Tasks in Power Automate Using the CData API Server
Automate LinkedIn actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Slack Data in RapidMiner
Integrate Slack with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create Visio diagrams from Google Directory Data
Automatically update Google Directory with the changes you make to Visio master shapes.
-
Access Live Instagram Data in Coginiti Pro
Connect to and query live Instagram from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Oracle Data in TIBCO Data Virtualization
Use the Oracle Tibco DV Adapter to create a Oracle Database data source in TIBCO Data Virtualization Studio and gain access to live Oracle Database from your TDV Server.
-
Build Dashboards with Apify Data in DBxtra
Create dynamic dashboards and perform analytics based on Apify in DBxtra.
-
Integrate Theia IDE with Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Testmonitor Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Testmonitor to connect to Testmonitor and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for Discourse
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Discourse.
-
How to Create Power BI Visual Reports with Real-Time Presto Data
Use CData Power BI Connectors to visualize Presto in Power BI.
-
Automated Continuous Google Spanner Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Spanner replication to Snowflake.
-
Visualize Twilio Data in TIBCO Spotfire through ADO.NET
Integrate Twilio into dashboards in TIBCO Spotfire.