CData Software - Knowledge Base
Recent Articles
-
Create Apps from HCL Domino Data in Qlik Sense Cloud
Use CData Connect AI to connect to HCL Domino Data and build apps from live HCL Domino in Qlik Sense Cloud.
-
How to connect to Hugging Face Data in DBVisualizer
Integrate Hugging Face with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Google Search-Connected Dashboards in Grafana
Connect to Google Search Results via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Search.
-
Working with FormSite Data in LINQPad
Execute LINQ queries to FormSite in LINQPad.
-
Natively Connect to PDFMonkey Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PDFMonkey. Leverage the native support for ODBC in PHP.
-
Publish Zuora-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zuora.
-
How to update MarkLogic from Excel
This article explains how to transfer data from Excel to MarkLogic using the Excel Add-In for MarkLogic.
-
How to create Visio diagrams from Redis Data
Automatically update Redis with the changes you make to Visio master shapes.
-
Connect to Everhour Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Everhour as an External Source in Dremio.
-
Analyze Dynamics 365 Business Central Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Dynamics 365 Business Central and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Visualize Adobe Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live Adobe Analytics in Python.
-
How to Query Eventbrite Data in MySQL Workbench
Execute MySQL queries against live Eventbrite from MySQL Workbench.
-
Publish QuickBooks Online-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Online.
-
How to Import Data from Zoho CRM into Google Sheets
Import Zoho CRM into a Google spreadsheet that is automatically refreshed.
-
Establish a Live Connection with Aweber Data using Tableau Bridge
The CData ODBC Driver for Aweber enables you to integrate live Aweber into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Billsby Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Billsby to a JSON file on disk.
-
Automated Continuous Oracle Sales Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Amazon Redshift.
-
Automated Continuous Shippo Replication to Oracle
Use CData Sync for automated, continuous, customizable Shippo replication to Oracle.
-
Build Pipelines with Live Sugar CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sugar CRM from Google Cloud Data Fusion, enabling the integration of live Sugar CRM into the building and management of effective data pipelines.
-
Integrating Raisers Edge NXT Data in Talend Cloud Data Management Platform
Connect Raisers Edge NXT Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Raisers Edge NXT.
-
Object-Relational Mapping (ORM) with Spotify Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Spotify into a Java-based ORM framework, Hibernate.
-
Integrate with Parallel Data in JReport Designer
Create charts and reports based on Parallel in JReport Designer.
-
Bidirectional Access to Codat Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Codat in Filemaker Pro for Mac or Windows.
-
How to Import Data from CouchDB into Google Sheets
Import Apache CouchDB into a Google spreadsheet that is automatically refreshed.
-
Use Grok to Talk to Your PayPal 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 PayPal for you.
-
Visualize Live Tavily Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tavily using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Amplitude in MicroStrategy Web
Connect to Amplitude in MicroStrategy Web using the CData Software ODBC Driver for Amplitude.
-
Create Impala Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Impala data access from reports, embedded analytics, and more.
-
Connect and Visualize Live IBM Cloud Object Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM Cloud Object Storage into the Databricks platform and create visualization dashboards with real-time IBM Cloud Object Storage.
-
Connect to Square Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Exa Data in Sisense
Create an ElastiCube in Sisense app with access to Exa.
-
Load Short.io Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Short.io to a database.
-
Automated Continuous Cloudflare Replication to Databricks
Use CData Sync for automated, continuous, customizable Cloudflare replication to Databricks.
-
Integrate Elasticsearch Data in the Pentaho Report Designer
Publish reports based on Elasticsearch in the Pentaho BI tool.
-
Create Reports with Amazon Marketplace Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Marketplace.
-
Connect to Dynamics 365 Data in ACL Analytics
Connect to Microsoft Dynamics 365 via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Dynamics 365.
-
Automated Continuous Google Ad Manager Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to PostgreSQL.
-
Import Real-Time Epicor Kinetic Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Epicor Kinetic in ColdFusion.
-
Access Live Nuclia Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Nuclia into the statistical analysis tools available in SAS JMP. This article shows how to use Nuclia in the Graph Builder and Query Builder.
-
Connect to Bugsnag Data in HULFT Integrate
Connect to Bugsnag as a JDBC data source in HULFT Integrate
-
Connect to Coinbase Data in CloverDX (formerly CloverETL)
Transfer Coinbase using the visual workflow in the CloverDX data integration tool.
-
Visualize Redshift Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Redshift.
-
Bidirectional Access to Square Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Square in Filemaker Pro for Mac or Windows.
-
Build AI/ML Models with Live FreshBooks Data using Dataiku
Connect FreshBooks Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Cline with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache Spark SQL from within your IDE.
-
Enable the Dropbox JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dropbox.
-
Use the CData ODBC Driver for Sendwithus in Microsoft Power Query
You can use the CData Sendwithus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sendwithus into Microsoft Power Query.
-
Publish Pushbullet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pushbullet.
-
Connect to Bright Data Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bright Data.
-
SAP HANA XS Advanced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP HANA XS Advanced facts in real time.
-
Analyze Freshservice Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Freshservice and visualize live Freshservice in Infragistics Reveal.
-
Connect to Exa Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Exa and work with Exa in your FileMaker application.
-
Consume Oracle HCM Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle HCM Cloud as OData feeds from PowerBuilder using the API Server.
-
Connect to Oracle SCM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle SCM from Crystal Reports.
-
Replicate Multiple Amazon DynamoDB Accounts via the CData Sync CLI
Replicate multiple Amazon DynamoDB accounts to one or many databases.
-
Build Azure Synapse-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Synapse to explore live Azure Synapse Data in Claude Code to assist with building Azure Synapse-powered applications.
-
Connect to Redshift Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon Redshift from HeidiSQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Netweaver Gateway using the Model Context Protocol.
-
Use the CData ODBC Driver for JobNimbus from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for JobNimbus to connect to JobNimbus from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JobNimbus in Excel.
-
How to Connect to Live SAS xpt Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAS XPORT through natural language.
-
Use the CData Software ODBC Driver for Telegram in MicroStrategy Web
Connect to Telegram in MicroStrategy Web using the CData Software ODBC Driver for Telegram.
-
Connect to Twitter Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Twitter Ads.
-
Use Grok to Talk to Your Google Directory 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 Google Directory for you.
-
Create Landbot Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Landbot from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate AgileCRM Data Replication to Azure Synapse
Use CData Sync to customize and automate AgileCRM replication to Azure Synapse.
-
Connect to Microsoft Ads Data in CloverDX (formerly CloverETL)
Transfer Microsoft Ads using the visual workflow in the CloverDX data integration tool.
-
Create Datasets from MailerSend in Domo Workbench and Build Visualizations of MailerSend Data in Domo
Use the CData Software ODBC Driver for MailerSend to create datasets from MailerSend in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Real-Time Onfleet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Onfleet in Power Apps.
-
Analyze MongoDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MongoDB in Microsoft R Open.
-
Create SSAS Tabular Models from Webflow Data
How to build a SQL Server Analysis Service Tabular Model from Webflow using CData drivers.
-
Integrating LangChain with Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Greenhouse within automated workflows.
-
How to create Printful federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Printful in MySQL .
-
Build Charts with Omnisend Data in Clear Analytics
Create dynamic charts and perform analytics based on Omnisend in Clear Analytics.
-
Access Live PostgreSQL Data in Excel 365 Online (Excel for the web)
Connect to PostgreSQL from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query Shopify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Shopify from Node.js.
-
Integrating Claude Code CLI with Exa 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 live Cosmos DB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Cosmos DB in Jitterbit.
-
Build Dashboards with Gmail Data in DBxtra
Create dynamic dashboards and perform analytics based on Gmail in DBxtra.
-
Build Google Campaign Manager 360-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Campaign Manager 360 to explore live Google Campaign Manager 360 Data in Claude Code to assist with building Google Campaign Manager 360-powered applications.
-
Connect to Typeform Data in Jaspersoft Studio
Execute SQL to remote Typeform in Jaspersoft Studio.
-
Analyze OneNote Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft OneNote and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Open WebUI with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live YouTube Analytics from within the chat interface.
-
Access Live Salesforce Marketing Data in Coginiti Pro
Connect to and query live Salesforce Marketing Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Stream Gong Data into Apache Kafka Topics
Access and stream Gong in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Using the CData Software ODBC Driver for Azure Data Catalog in PyCharm
Connect to Azure Data Catalog as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Data Catalog.
-
How to connect to Office 365 Data from Spring Boot
Connect to Office 365 in a Spring Boot Application using the CData JDBC Driver for Office 365
-
Create Reports with Gong Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gong.
-
Connect and Visualize Live PostgreSQL Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PostgreSQL into the Databricks platform and create visualization dashboards with real-time PostgreSQL.
-
Feed Bitly Data into FineReport
How to set Bitly as a JDBC data source in FineReport.
-
Extract, Transform, and Load CloudConvert Data in Informatica PowerCenter
Create a simple Workflow for CloudConvert in Informatica PowerCenter.
-
Automated Continuous Retently Replication to MongoDB
Use CData Sync for automated, continuous, customizable Retently replication to MongoDB.
-
Connect to MailChimp Data in ACL Analytics
Connect to MailChimp via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MailChimp.
-
Visualize SingleStore Data in TIBCO Spotfire through OData
Integrate SingleStore into dashboards in TIBCO Spotfire.
-
Integrate Apollo Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apollo and integrate live Apollo into your Power Automate tasks.
-
How to Easily Query Clari Data in OpenOffice Base
Connect to Clari data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build GitLab Visualizations in Tableau Desktop
Use CData Connect AI to connect to live GitLab and build visualizations in Tableau.
-
Build Phoenix-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Phoenix and build web apps with connectivity to live Apache Phoenix.
-
Automated Continuous Paymo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Paymo replication to Google BigQuery.
-
Visualize BigCommerce Data in TIBCO Spotfire through OData
Integrate BigCommerce into dashboards in TIBCO Spotfire.
-
Integrating Claude Code CLI with SAP HANA XS Advanced 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.