CData Software - Knowledge Base
Recent Articles
-
Connect Toggl to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Toggl with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Everhour Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Everhour data into the statistical analysis tools available in SAS JMP. This article shows how to use Everhour data in the Graph Builder and Query Builder.
-
Create Data Visualizations in Cognos BI with Amazon DynamoDB Data
Access Amazon DynamoDB data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Tickspot
Create Tickspot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze SQL Server Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SQL Server data and visualize SQL Server data in SAP Analytics Cloud.
-
Visualize Auth0 Data in Tableau
The CData ODBC driver for Auth0 enables you integrate Auth0 data into Tableau dashboards.
-
Connect to Square Data in DBArtisan
Use wizards in DBArtisan to configure Square data as a data source.
-
How to connect to DocuSign Data from IntelliJ
Integrate connectivity to DocuSign data with wizards in IntelliJ.
-
Integrating Gumloop with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Power BI XMLA data within automated workflows.
-
Migrating data from Jumpseller to Databricks using CData SSIS Components.
Easily push Jumpseller data to Databricks using the CData SSIS Tasks for Jumpseller and Databricks.
-
Create Datasets from Perigon in Domo Workbench and Build Visualizations of Perigon Data in Domo
Use the CData Software ODBC Driver for Perigon to create datasets from Perigon data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Deel Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Deel replication to Google Cloud SQL.
-
Connect to Webflow Data in Jaspersoft Studio
Execute SQL to remote Webflow data in Jaspersoft Studio.
-
Model SharePoint Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SharePoint, enabling the direct import of real-time SharePoint data.
-
Access OData Services in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for OData services.
-
Working with SAP Business Warehouse Data in LINQPad
Execute LINQ queries to SAP Business Warehouse data in LINQPad.
-
Stream Todoist Data into Apache Kafka Topics
Access and stream Todoist data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Zoho Recruit Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Recruit data for self-service data analytics.
-
How to Connect to Live HDFS Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live HDFS data without replication.
-
Build a Singer.io Tap for Mistral AI With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mistral AI data using the CData Python Connector.
-
Establish a Live Connection with Guru Data using Tableau Bridge
The CData ODBC Driver for Guru enables you to integrate live Guru data into Tableau Cloud dashboards using the Tableau Bridge.
-
Validate ServiceNow Data with QuerySurge
Access and validate ServiceNow data in QuerySurge using the CData JDBC Driver.
-
Model ZohoSubscriptions Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ZohoSubscriptions, enabling the direct import of real-time ZohoSubscriptions data.
-
How to Access Live Bitly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bitly enables you to integrate Bitly data into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with Amazon Athena Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Athena data in DBxtra.
-
Build Semantic Layer Views for Mouseflow Data in APOS Live Data Gateway
Use the CData Connector for Mouseflow in APOS Live Data Gateway to build Semantic Layer Views for Mouseflow data.
-
Query BigCommerce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against BigCommerce data from Node.js.
-
How to Visualize Amazon Athena 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 Amazon Athena data in Python.
-
Integrate Live Apollo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apollo data and integrate live Apollo data into apps built in Microsoft Power Apps.
-
Create Freshservice Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshservice from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Simple VCL Application for MariaDB Data
How to build a simple VCL Application to view MariaDB data in RAD Studio using the CData ODBC Driver for MariaDB.
-
Build Dashboards with Vimeo Data in DBxtra
Create dynamic dashboards and perform analytics based on Vimeo data in DBxtra.
-
Build Agents in Relevance AI with Access to Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle HCM Cloud data within intelligent agent workflows.
-
Import and Visualize SAP Concur Data in Power View
Create data visualizations based on SAP Concur data in Excel.
-
Visualize Authorize.Net Data in TIBCO Spotfire through OData
Integrate Authorize.Net data into dashboards in TIBCO Spotfire.
-
Automated Continuous Azure Data Catalog Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Google Cloud SQL.
-
Replicate Square Data to Multiple Databases via the CData Sync CLI
Replicate Square data to disparate databases with a single configuration.
-
Import and Visualize SendPulse Data in Power View
Create data visualizations based on SendPulse data in Excel.
-
Integrating Codex with Jumpseller 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 to ZeroBounce Data from Spring Boot
Connect to ZeroBounce in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Azure Data Catalog Data in Aqua Data Studio
Access Azure Data Catalog data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Add ActiveCampaign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ActiveCampaign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Query Live Timely Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Timely data into Databricks and enable direct, live querying and analysis without replication.
-
Access Teamwork Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teamwork data from HeidiSQL.
-
Getting Started with the CData Tableau Connector for Acumatica
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Acumatica.
-
Use Dash to Build Web Apps on SAP HANA Data via CData Connect AI
Build interactive Dash web apps on live SAP HANA data using pandas and the CData Connect AI Python SDK.
-
Access Live Oracle SCM Data in AWS Lambda
Connect to live Oracle SCM data in AWS Lambda using the CData JDBC Driver.
-
How to Access Live Exa Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Exa enables you to integrate Exa data into workflows built using Microsoft Power Automate Desktop.
-
Connect to JDBC-ODBC Bridge Data in RazorSQL
Connect to JDBC-ODBC Bridge from wizards and query JDBC-ODBC Bridge data from the GUI in the RazorSQL database management tool.
-
How to Create Power BI Visual Reports with Real-Time Testmonitor Data
Use CData Power BI Connectors to visualize Testmonitor data in Power BI.
-
Query Google Calendar Data in DataGrip
Create a Data Source for Google Calendar in DataGrip and use SQL to query live Google Calendar data.
-
Build Apps with Live Google Spanner Data Using the Low-Code Development Platform of Mendix
Connect Google Spanner data with Mendix to build apps using the CData JDBC Driver for Google Spanner.
-
Replicate SingleStore Data to Multiple Databases
Replicate SingleStore data to disparate databases with a point-and-click configuration.
-
How to Easily Query Pipedrive Data in OpenOffice Base
Connect to Pipedrive data in OpenOffice Base using the CData ODBC Driver for Pipedrive and generate reports with live data insights.
-
Bridge SageHR Connectivity with Apache NiFi
Access and process SageHR data in Apache NiFi using the CData JDBC Driver.
-
Connect to Nuclia Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Nuclia and the SQL Gateway to access Nuclia data from Google Apps Script.
-
Analyze Facebook Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Facebook data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to Google Ad Manager Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Ad Manager data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Vimeo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vimeo replication to MongoDB.
-
Query SharePoint Excel Services Data in DataGrip
Create a Data Source for SharePoint Excel Services in DataGrip and use SQL to query live SharePoint Excel Services data.
-
Build AI/ML Models with Live Reckon Data using Dataiku
Connect Reckon Data with Dataiku using the CData JDBC Driver for Reckon.
-
Connect to Trello Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Trello Data and connect to Trello data in Akorbi Digital RunMyProcess.
-
Create Power BI Reports on Real-Time Quickbase Data
Use the CData ODBC Driver for Quickbase to visualize Quickbase data in Power BI Desktop.
-
Consume Excel Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Excel Online feeds that reflect any changes in SAP Lumira.
-
Configure the CData JDBC Driver for SurveyMonkey in a Connection Pool in Tomcat
Connect to SurveyMonkey data from a connection pool in Tomcat.
-
Build Apps with Live Coda Data Using the Low-Code Development Platform of Mendix
Connect Coda data with Mendix to build apps using the CData API Driver for JDBC.
-
Use Manus AI to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Salesforce Pardot data.
-
Connect to Zoho Projects from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Projects data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Theia IDE with Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ShipEngine data from within the development environment.
-
Easily Integrate Rebilly Data in Lazarus Pascal IDE
Learn how to easily integrate live Rebilly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Kiro with RabbitMQ 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 Live SAP HANA XS Advanced Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP HANA XS Advanced from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP HANA XS Advanced data.
-
Automate Hubstaff Data Replication to Couchbase
Use CData Sync to Customize and automate Hubstaff data replication to Couchbase.
-
Access Google Cloud Storage Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Cloud Storage data from your Oracle system.
-
Stream Intercom Data into Apache Kafka Topics
Access and stream Intercom data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Sage 300 Data in Heroku for Use in Salesforce Connect
Replicate Sage 300 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Microsoft Entra ID Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Entra ID data from Node.js.
-
How to create Freshdesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshdesk data in MySQL .
-
Validate Azure Data Lake Storage Data with QuerySurge
Access and validate Azure Data Lake Storage data in QuerySurge using the CData JDBC Driver.
-
Access Live Billsby Data in AWS Lambda
Connect to live Billsby data in AWS Lambda using the CData JDBC Driver.
-
DataBind Charts to Oracle Financials Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Financials Cloud data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect Zuora to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zuora data using the CData Python MCP Server.
-
Use the CData Software JDBC Driver for Foursquare in MicroStrategy
Connect to Foursquare data in MicroStrategy Developer using the CData Software JDBC Driver for Foursquare.
-
Access Live DocuSign Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate DocuSign data into the statistical analysis tools available in SAS JMP. This article shows how to use DocuSign data in the Graph Builder and Query Builder.
-
How to Connect to Live Amazon Athena Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Amazon Athena data for you.
-
Access Tickspot Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Tickspot data.
-
How to Work with ConstantContact Data in ETL Validator JDBC
Connect to ConstantContact from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Gumroad Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gumroad data in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoInvoice
Create ZohoInvoice data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Microsoft Dataverse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Google BigQuery.
-
Connect to SAP Business Warehouse Data from AWS Glue
Use CData Connect AI to gain access to live SAP Business Warehouse data from your AWS Glue jobs.
-
Invoiced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Invoiced facts in real time.
-
Connecting GenSpark with Shopify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Shopify data without any replication or custom integration required.
-
Query Live Quickbase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Quickbase data through a conversational interface.
-
Connect to Avaza in SpagoBI
Create reports featuring live Avaza data in SpagoBI Studio. Host Avaza reports on SpagoBI Server.
-
Build AlloyDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live AlloyDB data and build visualizations in Tableau.
-
Bidirectional Access to Jira Assets Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Jira Assets data in Filemaker Pro for Mac or Windows.
-
Build AI/ML Models with Live Sugar CRM Data using Dataiku
Connect Sugar CRM Data with Dataiku using the CData JDBC Driver for Sugar CRM.
-
Getting Started with the CData Power BI Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to HelloSign Data in NetBeans
Connect to HelloSign data in NetBeans with the data source configuration wizard.