CData Software - Knowledge Base
Recent Articles
-
How to connect Amazon QuickSight to Salesforce CRM Analytics Data
Create a connection to Salesforce CRM Analytics in CData Connect AI and insert Salesforce CRM Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to FreshBooks Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FreshBooks Data and connect to FreshBooks in Akorbi Digital RunMyProcess.
-
Visualize LinkedIn Data in Sisense
Create an ElastiCube in Sisense app with access to LinkedIn.
-
Use Dash to Build Web Apps on Oracle Service Cloud Data via CData Connect AI
Build interactive Dash web apps on live Oracle Service Cloud using pandas and the CData Connect AI Python SDK.
-
Create Jira Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jira data access from reports, embedded analytics, and more.
-
Connect to ClickUp Data from PowerBuilder via ADO.NET
This article demonstrates how to access ClickUp from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous BigCommerce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable BigCommerce replication to Google Cloud SQL.
-
Build OpenWeatherMap-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to OpenWeatherMap and build web apps with connectivity to live OpenWeatherMap.
-
Query Clockify Data as a MySQL Database in Node.js
Execute MySQL queries against Clockify from Node.js.
-
Access Live Google Contacts Data in AWS Lambda
Connect to live Google Contacts in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Raisers Edge NXT Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Raisers Edge NXT and integrate live Raisers Edge NXT into apps built in Microsoft Power Apps.
-
Connect to and Query Parallel Data in QlikView over ODBC
Create data visualizations with Parallel in QlikView.
-
Integrating Claude Code CLI with Datadog 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.
-
Publish Crystal Reports on Planio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Planio.
-
How to Build an ETL App for Bullhorn CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Bullhorn CRM in Python with petl and the CData Connect AI Python SDK.
-
Analyze Zuora Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zuora and visualize live Zuora in Infragistics Reveal.
-
Connect to Mouseflow Data in Ruby
Connect to Mouseflow in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ADO.NET Provider for Paylocity
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Paylocity.
-
Use the CData Software JDBC Driver for Salesforce Marketing in MicroStrategy Web
Connect to Salesforce Marketing Cloud in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Marketing.
-
Query Live Google Sheets 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 Google Sheets directly from the development environment.
-
Build Avalara AvaTax-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Avalara AvaTax Data from Zoho Analytics and import live Avalara AvaTax.
-
Build Apps with Live BenchmarkEmail Data Using the Low-Code Development Platform of Mendix
Connect BenchmarkEmail with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Live Rootly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Rootly to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Viewing Aweber Data in RAD Studio Data Explorer
How to view Aweber in RAD Studio Data Explorer using the CData ODBC Driver for Aweber.
-
Model, Search, and Visualize Live Jira Data in ThoughtSpot
Use CData Connect AI to connect to live Atlassian Jira for modeling, searching, and visualizing.
-
Build Dashboards with TigerGraph Data in Dundas BI
Create dynamic dashboards and perform analytics based on TigerGraph in Dundas BI.
-
Write a Simple Go Application to work with Zendesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zendesk.
-
How to Connect DBeaver to Retently via a JDBC Driver
Manage Retently with visual tools in DBeaver like the query browser.
-
Connect to Email Data in HULFT Integrate
Connect to Email as a JDBC data source in HULFT Integrate
-
Analyze GraphQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze GraphQL with the CData JDBC Driver for GraphQL.
-
How to Work with TigerGraph Data in AWS Glue Jobs Using JDBC
Connect to TigerGraph from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Dashboards with Instagram Data in DBxtra
Create dynamic dashboards and perform analytics based on Instagram in DBxtra.
-
Connect to Greenplum Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Greenplum Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build a PostgreSQL Interface for Nuclia Data using the CData JDBC Driver
Use the Remoting features of the Nuclia JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Mistral AI Data dashboards with Tableau Server
The CData ODBC driver for Mistral AI enables you integrate Mistral AI into Tableau dashboards.
-
Connect to Email Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Email and the SQL Gateway to access Email from Google Apps Script.
-
How to connect to ChargeOver Data in DBVisualizer
Integrate ChargeOver with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Mode Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mode from your Oracle system.
-
How to Connect DBeaver to Chargebee via a JDBC Driver
Manage Chargebee with visual tools in DBeaver like the query browser.
-
How to Query Live LightSpeedRetail Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live LightSpeedRetail data in natural language using Python.
-
Use the CData ODBC Driver for Raisers Edge NXT in Microsoft Power Query
You can use the CData Raisers Edge NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Raisers Edge NXT into Microsoft Power Query.
-
Connect to PingOne Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for PingOne and the Script function in FileMaker Pro to connect to PingOne and work with PingOne in your FileMaker application.
-
Use the CData Software JDBC Driver for Aha! in MicroStrategy Desktop
Connect to Aha! in MicroStrategy Desktop using the CData Software JDBC Driver for Aha!.
-
Build an OLAP Cube in SSAS from FormSite Data
Establish a connection to FormSite data from SQL Server Analysis Services, and use the FormSite Data Provider to build OLAP cubes for use in analytics and reporting.
-
Configure the CData JDBC Driver for RSS in a Connection Pool in Tomcat
Connect to RSS Feeds from a connection pool in Tomcat.
-
How to import Tavily Data into Apache Solr
Use the CData Software JDBC Driver for Tavily in Data Import Handler and create an automated import of Tavily to Apache Solr Enterprise Search platform.
-
Use the CData Software JDBC Driver for ZohoInvoice in MicroStrategy
Connect to ZohoInvoice in MicroStrategy Developer using the CData Software JDBC Driver for ZohoInvoice.
-
Migrating data from Superchat to Google BigQuery using CData SSIS Components.
Easily push Superchat to Google BigQuery using the CData SSIS Tasks for Superchat and Google BigQuery.
-
Use Grok to Talk to Your ShipStation 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 ShipStation for you.
-
Integrating OpenCode Terminal with Redis 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.
-
Analyze Google Translate Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Translate in Microsoft R Open.
-
Connect to Humanity from Asprova with CData Software ODBC Driver for Humanity
This article shows how to connect faster to Humanity data from Asprova.
-
Access Live Epicor Kinetic Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Epicor Kinetic from your Excel spreadsheets.
-
Explore Geographical Relationships in Billsby Data with Power Map
Create data visualizations with Billsby in Power Map.
-
Create SendGrid Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SendGrid from PowerBI.com to create Power BI Dataflows with real-time data.
-
Natively Connect to iContact Data in PHP
The CData ODBC driver for iContact enables you to create PHP applications with connectivity to iContact. Leverage the native support for ODBC in PHP.
-
Access Live BigCommerce Data in Coginiti Pro
Connect to and query live BigCommerce from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Cursor CLI with Oracle Eloqua Reporting 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.
-
Create Power BI Reports on Real-Time Demio Data
Use the CData ODBC Driver for Demio to visualize Demio in Power BI Desktop.
-
Integrate Monday.com Data in Pentaho Data Integration
Build ETL pipelines based on Monday.com in the Pentaho Data Integration tool.
-
Integrate Egnyte with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Egnyte with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Egnyte.
-
Create Data Visualizations in Cognos BI with Access Data
Access Microsoft Access as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access Live Phoenix Data in Visual Studio Code via Cline
Run CData MCP Server for Phoenix on Windows Subsytem for Linux (WSL) and connect to live Apache Phoenix from the Cline extension in Visual Studio Code.
-
How to Access Live Google Calendar Data in Visual Studio Code via Cline
Run CData MCP Server for Google Calendar on Windows Subsytem for Linux (WSL) and connect to live Google Calendar from the Cline extension in Visual Studio Code.
-
Import and Visualize Moosend Data in Power View
Create data visualizations based on Moosend in Excel.
-
Work with Live Hive Data in Power Query
Use CData Connect AI to connect to Apache Hive and work with live Apache Hive in Microsoft Power Query.
-
Automated Continuous Zendesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zendesk replication to SQL Server.
-
Connect to Calendly Data in JRuby
Create a simple JRuby app with access to live Calendly.
-
Publish Reports with Paddle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paddle.
-
Build Snowflake-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Snowflake and build Snowflake-connected web apps with Axios.
-
Build a Simple VCL Application for Authorize.Net Data
How to build a simple VCL Application to view Authorize.Net in RAD Studio using the CData ODBC Driver for Authorize.Net.
-
Process & Analyze Oracle Financials Cloud Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Financials Cloud Data.
-
How to connect to Omnisend Data with Squirrel SQL client
Connect to Omnisend and execute queries in the Squirrel SQL Client.
-
Create Reports from Zoho CRM Data in Looker Studio
Use CData Connect AI to gain access to live Zoho CRM and create custom reports in Looker Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pipeline CRM
Provide connectivity to Pipeline CRM through an SAP BusinessObjects universe.
-
Migrating data from TaxJar to Databricks using CData SSIS Components.
Easily push TaxJar to Databricks using the CData SSIS Tasks for TaxJar and Databricks.
-
Import Real-Time Harvest Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Harvest in ColdFusion.
-
Create Datasets from Authorize.Net in Domo Workbench and Build Visualizations of Authorize.Net Data in Domo
Use the CData Software ODBC Driver for Authorize.Net to create datasets from Authorize.Net in Domo Workbench and then build visualizations in the Domo service.
-
Replicate SAP Data to Multiple Databases
Replicate SAP ERP/NetWeaver to disparate databases with a point-and-click configuration.
-
Connect to Epicor Kinetic from a Connection Pool in WebLogic
Use the CData JDBC Driver for Epicor Kinetic to connect to Epicor Kinetic from Web applications running on WebLogic.
-
Connect to Authorize.Net from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Authorize.Net, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Codex CLI with Front 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 and Query Suadeo Data in QlikView over ODBC
Create data visualizations with Suadeo in QlikView.
-
How to Visualize Highrise Data in Python with pandas
Use pandas and other modules to analyze and visualize live Highrise CRM in Python.
-
How to work with Cosmos DB Data in Apache Spark using SQL
Access and process Cosmos DB Data in Apache Spark using the CData Software JDBC Driver.
-
Stream Webflow Data into Apache Kafka Topics
Access and stream Webflow in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize SAP ByDesign Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP Business ByDesign in Python.
-
How to Create Power BI Visual Reports with Real-Time Clio Data
Use CData Power BI Connectors to visualize Clio in Power BI.
-
Use the CData Software ODBC Driver for Parquet in MicroStrategy Web
Connect to Apache Parquet in MicroStrategy Web using the CData Software ODBC Driver for Parquet.
-
Build Marketo-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Marketo to explore live Marketo Data in Claude Code to assist with building Marketo-powered applications.
-
Provide OData Services of Moosend Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Moosend by developing a WCF Service Application.
-
Access Live Slack Data in AWS Lambda
Connect to live Slack in AWS Lambda using the CData JDBC Driver.
-
View Reports on Real-Time Microsoft Dataverse Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Dataverse to visualize Microsoft Dataverse (CDS) in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Coda Data in Pentaho Data Integration
Build ETL pipelines based on Coda in the Pentaho Data Integration tool.
-
Connect to xBase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for xBase and the Script function in FileMaker Pro to connect to xBase and work with xBase in your FileMaker application.
-
Connect to Todoist Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Todoist as an External Source in Dremio.
-
Use Dash to Build Web Apps on HBase Data via CData Connect AI
Build interactive Dash web apps on live Apache HBase using pandas and the CData Connect AI Python SDK.
-
Connect to Greenplum Data in ACL Analytics
Connect to Pivotal GreenPlum via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Pivotal GreenPlum.
-
Connect to Dotmailer Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dotmailer from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Establish a Live Connection with Active Directory Data using Tableau Bridge
The CData ODBC Driver for Active Directory enables you to integrate live Active Directory into Tableau Cloud dashboards using the Tableau Bridge.