CData Software - Knowledge Base
Recent Articles
-
Confluence Reporting in OBIEE with the Confluence JDBC Driver
Deploy the Confluence JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live Campaigner Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Campaigner using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to QuickBooks Online Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Online in FileMaker Pro to connect to QuickBooks Online and work with QuickBooks Online in your FileMaker applications.
-
Automated Continuous ADP Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ADP replication to IBM DB2.
-
Model, Search, and Visualize Live Box Data in ThoughtSpot
Use CData Connect AI to connect to live Box for modeling, searching, and visualizing.
-
Build GraphQL-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for GraphQL to explore live GraphQL Data in Claude Code to assist with building GraphQL-powered applications.
-
Automated Continuous Square Replication to Vertica
Use CData Sync for automated, continuous, customizable Square replication to Vertica.
-
Query, Visualize, and Share live Zoho Projects Data in Redash
Use CData Connect AI to connect to live Zoho Projects in Redash for querying, visualizing, and sharing.
-
Moving Data from ZendeskSell to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZendeskSell data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Live SendGrid Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SendGrid from the MuleSoft Anypoint Platform to integrate live SendGrid into custom reports and dashboards.
-
Access Live Billsby Data in Coginiti Pro
Connect to and query live Billsby from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Crystal Reports on MYOB AccountRight Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MYOB AccountRight.
-
Automated Continuous Blackbaud FE NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to PostgreSQL.
-
Use Biml to Build SSIS Tasks to Replicate Clari Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Clari to SQL Server.
-
How to Access Live Codat Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Codat enables you to integrate Codat into workflows built using Microsoft Power Automate Desktop.
-
Connect to Act CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Act CRM, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to and Visualize Live SAP Concur Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Concur.
-
Establish a Live Connection with iContact Data using Tableau Bridge
The CData ODBC Driver for iContact enables you to integrate live iContact into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Authorize.Net Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Authorize.Net data access from reports, embedded analytics, and more.
-
Building Dynamic Web Pages with TaxJar Data Using AngularJS
Create single-page applications with live connectivity to TaxJar using the CData API Server.
-
Write a Simple Go Application to work with Excel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Excel.
-
A PostgreSQL Interface for MongoDB Data using the CData ODBC Driver
Use the SQL Gateway and MongoDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for Jodoo on an SSRS Report Server
Connect to Jodoo 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.
-
How to connect and process SageHR from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SageHR.
-
How to Connect to Live CouchDB 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 Apache CouchDB for you.
-
Build AI/ML Models with Live Klipfolio Data using Dataiku
Connect Klipfolio Data with Dataiku using the CData API Driver for JDBC.
-
Work with Exa Data in FoxPro
Load Exa into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live CSV Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate CSV/TSV Files into the statistical analysis tools available in SAS JMP. This article shows how to use CSV/TSV Files in the Graph Builder and Query Builder.
-
Visualize Contentful Data in Tableau
The CData ODBC driver for Contentful enables you integrate Contentful into Tableau dashboards.
-
Automated Oracle Eloqua Reporting Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Eloqua Reporting replication to Teradata.
-
Connect to Sage Cloud Accounting Data in Jaspersoft Studio
Execute SQL to remote Sage Business Cloud Accounting in Jaspersoft Studio.
-
Query Access Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Access and perform CRUD operations on Access from Node.js.
-
Establish a Live Connection with LionDesk Data using Tableau Bridge
The CData ODBC Driver for LionDesk enables you to integrate live LionDesk into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to PolarTeamPro Data from Spring Boot
Connect to PolarTeamPro in a Spring Boot Application using the CData API Driver for JDBC
-
How to Visualize ElevenLabs Data in Python with pandas
Use pandas and other modules to analyze and visualize live ElevenLabs in Python.
-
Visualize Oracle Financials Cloud Data in Tableau
The CData ODBC driver for Oracle Financials Cloud enables you integrate Oracle Financials Cloud into Tableau dashboards.
-
Build Mailgun-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mailgun and build web apps with connectivity to live Mailgun.
-
Visualize Telegram 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 Telegram into TIBCO Spotfire.
-
Build Shopify-Connected Apps in Choreo
Use CData Connect AI to connect to Shopify Data from Choreo and build custom apps using live Shopify.
-
Automated Continuous Wrike Replication to Oracle
Use CData Sync for automated, continuous, customizable Wrike replication to Oracle.
-
Validate SAP ByDesign Data with QuerySurge
Access and validate SAP Business ByDesign in QuerySurge using the CData JDBC Driver.
-
Operational Reporting on Intercom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Intercom.
-
Build Elasticsearch-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Elasticsearch Data and create custom apps in Bubble.
-
Automated Continuous Exa Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Exa replication to Google BigQuery.
-
How to create Visio diagrams from Hive Data
Automatically update Apache Hive with the changes you make to Visio master shapes.
-
Getting Started with the CData Excel Add-In for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle SCM.
-
How to Access Live Stripe Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Stripe enables you to integrate Stripe into workflows built using Microsoft Power Automate Desktop.
-
How to Import Data from Google Drive into Google Sheets
Import Google Drive into a Google spreadsheet that is automatically refreshed.
-
Rapidly Develop Freshservice-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 Freshservice.
-
How to Work with Chargebee Data in AWS Glue Jobs Using JDBC
Connect to Chargebee from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to HubDB Data in RazorSQL
Connect to HubDB from wizards and query HubDB from the GUI in the RazorSQL database management tool.
-
How to connect to Brex Data from IntelliJ
Integrate connectivity to Brex with wizards in IntelliJ.
-
Access Live SAP HANA Data in AWS Lambda
Connect to live SAP HANA in AWS Lambda using the CData JDBC Driver.
-
Create Reports from Square Data in Looker Studio
Use CData Connect AI to gain access to live Square and create custom reports in Looker Studio.
-
Access Live CockroachDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live CockroachDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating OpenCode Terminal with LaunchDarkly 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 the Power BI Service to ActiveCampaign: Complete Guide
Connect to the CData Software Power BI Connector for ActiveCampaign from PowerBI.com to provide real-time ActiveCampaign across the organization.
-
Integrating Cursor CLI with Pipedrive 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 Live Shortcut Data in Coginiti Pro
Connect to and query live Shortcut from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Snapchat Ads Data from IntelliJ
Integrate connectivity to Snapchat Ads with wizards in IntelliJ.
-
Connect to Google Cloud Storage Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Cloud Storage in FileMaker Pro to connect to Google Cloud Storage and work with Google Cloud Storage in your FileMaker applications.
-
Connect to Eventbrite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Eventbrite to connect to Eventbrite and execute queries in PowerBuilder.
-
Connecting Moonlit Workflow with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Couchbase in real time.
-
Manage Zendesk Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zendesk.
-
Build MVC Applications with Connectivity to Sugar CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sugar CRM from an ASP.NET MVC application.
-
Connect to ServiceNow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ServiceNow using standard SQL.
-
How to Connect the Power BI Service to Bullhorn CRM: Complete Guide
Connect to the CData Software Power BI Connector for Bullhorn CRM from PowerBI.com to provide real-time Bullhorn CRM across the organization.
-
Integrate Live Sage Intacct Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sage Intacct to Blue Prism using the CData ODBC Driver for Sage Intacct to create automated workflows for repetitive business tasks.
-
Integrate with eBay Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy eBay to a JSON file on disk.
-
Automated Continuous Azure Blob Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Oracle.
-
Connect to Zoho Projects Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Projects from HeidiSQL.
-
Build Charts with Guru Data in Clear Analytics
Create dynamic charts and perform analytics based on Guru in Clear Analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for VWO
Provide connectivity to VWO through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for Avaza
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Avaza.
-
How to load Smartsheet data into Elasticsearch via Logstash
Introducing a simple method to load Smartsheet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build YouTube Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for YouTube Analytics Data and create custom apps in Bubble.
-
How to integrate Freshsales with Apache Airflow
Access and process Freshsales in Apache Airflow using the CData JDBC Driver.
-
Publish Crystal Reports on Figshare Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Figshare.
-
Build Dashboards with Zoho Projects Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Projects in Dundas BI.
-
Import Real-Time Short.io Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Short.io in ColdFusion.
-
Build Adobe Analytics-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Adobe Analytics to explore live Adobe Analytics Data in Cursor to assist with building Adobe Analytics-powered applications.
-
Publish WordPress-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live WordPress.
-
Connect to and Query Instantly Data in QlikView over ODBC
Create data visualizations with Instantly in QlikView.
-
Use JayDeBeApi to access Lakebase Data in Python
Use standard Python scripting and the development environment of your choice to access live Lakebase.
-
Connect to Oracle Eloqua Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Eloqua from HeidiSQL.
-
Automated Continuous Clockify Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Clockify replication to IBM DB2.
-
Automated Continuous Zoho Inventory Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Databricks.
-
Create Oracle Financials Cloud-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Financials Cloud Data from OutSystems and build custom enterprise apps using live Oracle Financials Cloud.
-
Automated Continuous Ontraport Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Ontraport replication to Apache Cassandra.
-
Connect to Confluence Data in DBeaver
Use the CData ODBC Driver to connect to Atlassian Confluence in DBeaver.
-
Connect to Grafana Data in Jaspersoft Studio
Execute SQL to remote Grafana in Jaspersoft Studio.
-
How to Work with Tickspot Data in ETL Validator JDBC
Connect to Tickspot from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live Teradata Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Teradata into the statistical analysis tools available in SAS JMP. This article shows how to use Teradata in the Graph Builder and Query Builder.
-
Create Adobe Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Adobe Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Vault CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Vault CRM to connect to Veeva Vault & Vault CRM and execute queries in PowerBuilder.
-
Build MongoDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MongoDB.
-
How to create an RPA flow for Vimeo Data in UiPath Studio
Use the Vimeo ODBC Driver to create workflows that access real-time Vimeo without any coding.
-
Publish Odoo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Odoo ERP.
-
Build Google Ads-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Google Ads to explore live Google Ads Data in Gemini Code Assist to assist with building Google Ads-powered applications.
-
Use CData Connect AI to Access SAS xpt Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAS XPORT in the Power Pivot business intelligence tool.