CData Software - Knowledge Base
Recent Articles
-
How to integrate Metabase with Zoom Data
Use CData Connect AI to connect to live Zoom and create an interactive dashboard in Metabase from Zoom.
-
Integrating Claude Code with Spark Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Apache Spark SQL within assisted coding and automated development workflows.
-
View Reports on Real-Time Monday.com Data in Power BI Report Server
Use the CData ODBC Driver for Monday.com to visualize Monday.com in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Vercel from Asprova with CData Software ODBC Driver for Vercel
This article shows how to connect faster to Vercel data from Asprova.
-
Enable the Helpscout JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Helpscout.
-
Create Databricks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Databricks data access from reports, embedded analytics, and more.
-
Replicate Impala Data from PowerShell
Write a quick PowerShell script to query Apache Impala. Use connectivity to the live data to replicate Apache Impala to SQL Server.
-
Create Datasets from Snowflake in Domo Workbench and Build Visualizations of Snowflake Data in Domo
Use the CData Software ODBC Driver for Snowflake to create datasets from Snowflake in Domo Workbench and then build visualizations in the Domo service.
-
Query Azure Data Catalog Data in DataGrip
Create a Data Source for Azure Data Catalog in DataGrip and use SQL to query live Azure Data Catalog.
-
Integrating Antigravity CLI with XML Files via CData CLI
Connect XML Files to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Work with Live Gong Data in Power Query
Use CData Connect AI to connect to Gong and work with live Gong in Microsoft Power Query.
-
Integrate Slack Data in the Pentaho Report Designer
Publish reports based on Slack in the Pentaho BI tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 300
Create an ODBC connection to Sage 300 in Informatica and browse and transfer Sage 300.
-
Query Reckon Accounts Hosted Data as a SQL Server Database in Node.js
Execute SQL Server queries against Reckon Accounts Hosted from Node.js.
-
Build AI/ML Models with Live Google Spanner Data using Dataiku
Connect Google Spanner Data with Dataiku using the CData JDBC Driver for Google Spanner.
-
Connecting Pipedream with MariaDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on MariaDB data in real time.
-
Easily Integrate Bullhorn CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Bullhorn CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Edit and Search SFTP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SFTP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SFTP objects that you can access from apps and the dashboard.
-
Connect to Drift in SpagoBI
Create reports featuring live Drift in SpagoBI Studio. Host Drift reports on SpagoBI Server.
-
Create Informatica Mappings From/To a JDBC Data Source for WordPress
Create WordPress data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Oracle Service Cloud Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Service Cloud from your Excel spreadsheets.
-
Object-Relational Mapping (ORM) with BigQuery 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 Google BigQuery into a Java-based ORM framework, Hibernate.
-
How to Design LDAP Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to LDAP from mobile and tablet Power Apps.
-
Connect to Quaderno Data from a Connection Pool in JBoss
Integrate Quaderno into Java servlets: Use the Management Console in JBoss to install the Quaderno JDBC Driver.
-
Getting Started with the CData SSIS Components for Cloudant
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cloudant.
-
Create a Data Access Object for Instantly Data using JDBI
A brief overview of creating a SQL Object API for Instantly in JDBI.
-
Connect SFTP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SFTP with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Dynamics NAV Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Dynamics NAV and visualize live Microsoft Dynamics NAV in Infragistics Reveal.
-
Connect to Avalara AvaTax in SpagoBI
Create reports featuring live Avalara AvaTax in SpagoBI Studio. Host Avalara AvaTax reports on SpagoBI Server.
-
Easily Integrate Mailgun Data in Lazarus Pascal IDE
Learn how to easily integrate live Mailgun in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode Terminal with Oracle 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.
-
Add Paymo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paymo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Amazon S3 Data in CloverDX (formerly CloverETL)
Transfer Amazon S3 using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData SSIS Components for Workable
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Workable.
-
Connect to Smartsheet Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Smartsheet and the Script function in FileMaker Pro to connect to Smartsheet and work with Smartsheet in your FileMaker application.
-
Connect to Klaviyo Data from PowerBuilder via JDBC
This article demonstrates how to access Klaviyo from PowerBuilder using the Klaviyo JDBC Driver.
-
Integrate with Live eBay Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to eBay from the MuleSoft Anypoint Platform to integrate live eBay into custom reports and dashboards.
-
Access Live ZohoSubscriptions Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZohoSubscriptions into the statistical analysis tools available in SAS JMP. This article shows how to use ZohoSubscriptions in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for SQL Analysis Services in SAS for Real-Time Reporting and Analytics
Connect to real-time SQL Analysis Services in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SQL Analysis Services.
-
Use CData Connect AI to Access Freshdesk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Freshdesk in the Power Pivot business intelligence tool.
-
Analyze YouTube Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze YouTube Analytics with the CData JDBC Driver for YouTube Analytics.
-
DataBind Printful Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Printful to a chart.
-
How to Query Live Adobe Experience Manager Data in Perplexity MacOS Desktop
Connect to and query live Adobe Experience Manager Data in Perplexity Desktop using CData MCP Server.
-
Connect to REST Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for REST and the Script function in FileMaker Pro to connect to REST and work with REST in your FileMaker application.
-
Integrate with Bannerbear Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bannerbear to a JSON file on disk.
-
Prepare, Blend, and Analyze Stripe Data in Alteryx Designer (ODBC)
Build workflows to access live Stripe for self-service data analytics.
-
Access Zoho Recruit Data from MySQL in PHP
Connect to Zoho Recruit through the standard MySQL libraries in PHP.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zuora to Power BI dashboards. Simply drag and drop Zuora into data visuals on the Power BI canvas.
-
How to connect PolyBase to Autopilot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Autopilot.
-
Seamlessly Bring Facebook Data into Retool Using CData Connect AI
Integrate Facebook data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Dataiku with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sugar CRM.
-
How to create Active Directory federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Active Directory in MySQL .
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Web
Connect to Amazon DynamoDB in MicroStrategy Web using the CData Software ODBC Driver for Amazon DynamoDB.
-
Access Short.io Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Short.io from HeidiSQL.
-
Create Odoo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Odoo Data from Klipfolio and build custom visualizations using live Odoo ERP.
-
Visualize Databricks Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Databricks.
-
Connect to SurveyMonkey Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SurveyMonkey and the SQL Gateway to access SurveyMonkey from Google Apps Script.
-
Automate Anaplan Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Anaplan and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Grok to Talk to Your Google Campaign Manager 360 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 Campaign Manager 360 for you.
-
Automated Continuous Google Spanner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Spanner replication to Azure SQL Database.
-
Visualize Salesforce Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce & Force.com.
-
Integrating Claude Code CLI with MailerLite 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.
-
Connect to SharePoint Data in Ruby
Connect to Microsoft SharePoint in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to work with Beeminder Data in Apache Spark using SQL
Access and process Beeminder Data in Apache Spark using the CData Software JDBC Driver.
-
Model ADP Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ADP, enabling the direct import of real-time ADP.
-
Use the CData ODBC Driver for ConvertAPI in Microsoft Power Query
You can use the CData ConvertAPI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ConvertAPI into Microsoft Power Query.
-
How to Import Data from FHIR into Google Sheets
Import FHIR into a Google spreadsheet that is automatically refreshed.
-
Analyze Sage Intacct Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage Intacct and visualize live Sage Intacct in Infragistics Reveal.
-
How to work with SAP Hybris C4C Data in Apache Spark using SQL
Access and process SAP Hybris C4C Data in Apache Spark using the CData Software JDBC Driver.
-
Create Oracle Eloqua-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Eloqua Data from Nintex Workflow Cloud and build custom workflows using live Oracle Eloqua.
-
Create Data Visualizations in Cognos BI with Browserless Data
Access Browserless as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Antigravity CLI with ZohoDesk via CData CLI
Connect ZohoDesk to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect and process Reckon from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Reckon.
-
Create Elasticsearch-Connected Business Apps in AppSheet
Connect to Elasticsearch Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Elasticsearch.
-
Connecting GenSpark with Cloudant Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to IBM Cloudant without any replication or custom integration required.
-
How to connect and process PingOne from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PingOne.
-
Build Dashboards with Cassandra Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Cassandra in DBxtra.
-
Create Dropbox-Connected Applications in Appsmith
Connect to Dropbox Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dropbox.
-
Configure the CData JDBC Driver for MessageBird in a Connection Pool in Tomcat
Connect to MessageBird from a connection pool in Tomcat.
-
Getting Started with the CData SSIS Components for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pipeliner CRM.
-
Connect to and Query Vercel Data in QlikView over ODBC
Create data visualizations with Vercel in QlikView.
-
Replicate Freshdesk Data to Multiple Databases
Replicate Freshdesk to disparate databases with a point-and-click configuration.
-
Create Sage Cloud Accounting Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage Cloud Accounting from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to create an RPA flow for ElevenLabs Data in UiPath Studio
Use the ElevenLabs ODBC Driver to create workflows that access real-time ElevenLabs without any coding.
-
How to Connect the Power BI Service to Klipfolio: Complete Guide
Connect to the CData Software Power BI Connector for Klipfolio from PowerBI.com to provide real-time Klipfolio across the organization.
-
Connect to Gmail Data in DBArtisan
Use wizards in DBArtisan to configure Gmail as a data source.
-
Use the CData Software ODBC Driver for Coinbase in MicroStrategy Desktop
Connect to Coinbase in MicroStrategy Desktop using the CData Software ODBC Driver for Coinbase.
-
Connect to Figshare Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Figshare and the SQL Gateway to access Figshare from Google Apps Script.
-
Connect to Wave Financial Data in DBeaver
Use the CData ODBC Driver to connect to Wave Financial in DBeaver.
-
Integrate Salesforce Marketing with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce Marketing with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce Marketing Cloud.
-
Connect to Drip Data in CloverDX (formerly CloverETL)
Transfer Drip using the visual workflow in the CloverDX data integration tool.
-
How to connect PolyBase to Toggl
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Toggl.
-
Getting Started with the CData Power BI Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData Software ODBC Driver for ZeroBounce in SAS for Real-Time Reporting and Analytics
Connect to real-time ZeroBounce in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZeroBounce.
-
How to connect to Discord Data in DBVisualizer
Integrate Discord with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Antigravity CLI with SAP Hybris C4C via CData CLI
Connect SAP Hybris C4C to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Certinia Data in Cognos Analytics
Use CData Connect AI to connect to Certinia Data from Cognos Analytics and analyze live Certinia.
-
DataBind Testmonitor Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Testmonitor to a chart.
-
Connect Sage Cloud Accounting to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sage Cloud Accounting with IBM WebSphere for seamless data integration and connectivity.
-
Connecting Mastra with API Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time API, no replication required.