CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy Desktop
Connect to Apache Phoenix in MicroStrategy Desktop using the CData Software JDBC Driver for Phoenix.
-
How to integrate Webex with Apache Airflow
Access and process Webex in Apache Airflow using the CData JDBC Driver.
-
Connect to Pinecone Data in Jaspersoft Studio
Execute SQL to remote Pinecone in Jaspersoft Studio.
-
How to Create Power BI Visual Reports with Real-Time Bitly Data
Use CData Power BI Connectors to visualize Bitly in Power BI.
-
Build SAS xpt-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SASxpt to explore live SAS xpt Data in Claude Code to assist with building SAS xpt-powered applications.
-
Create Datasets from ServiceNow in Domo Workbench and Build Visualizations of ServiceNow Data in Domo
Use the CData Software ODBC Driver for ServiceNow to create datasets from ServiceNow in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with Missive Data in Clear Analytics
Create dynamic charts and perform analytics based on Missive in Clear Analytics.
-
How to connect to Flowlu Data from Spring Boot
Connect to Flowlu in a Spring Boot Application using the CData API Driver for JDBC
-
Query, Visualize, and Share live OData Services in Redash
Use CData Connect AI to connect to live OData in Redash for querying, visualizing, and sharing.
-
Integrating Antigravity CLI with RabbitMQ via CData CLI
Connect RabbitMQ to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live ClickTime Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ClickTime using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Figshare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Figshare.
-
Build a PostgreSQL Interface for Helpscout Data using the CData JDBC Driver
Use the Remoting features of the Helpscout JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live Sage 300 Data in Perplexity MacOS Desktop
Connect to and query live Sage 300 Data in Perplexity Desktop using CData MCP Server.
-
Extract, Transform, and Load GitLab Data in Informatica PowerCenter
Create a simple Workflow for GitLab in Informatica PowerCenter.
-
Query Placid Data in DataGrip
Create a Data Source for Placid in DataGrip and use SQL to query live Placid.
-
Build Automated YouTube Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live YouTube Analytics and build automated workflows in Zapier.
-
Automated Continuous Timely Replication to MySQL
Use CData Sync for automated, continuous, customizable Timely replication to MySQL.
-
Access Live Square Data in AWS Lambda
Connect to live Square in AWS Lambda using the CData JDBC Driver.
-
Visualize SharePoint Excel Services Data in Tableau
The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services into Tableau dashboards.
-
Natively Connect to Mixpanel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mixpanel. Leverage the native support for ODBC in PHP.
-
How to Work with SQL Analysis Services Data in ETL Validator JDBC
Connect to SQL Analysis Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating OpenCode Terminal with Adobe Analytics 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.
-
Build Apps with Live Lakebase Data Using the Low-Code Development Platform of Mendix
Connect Lakebase with Mendix to build apps using the CData JDBC Driver for Lakebase.
-
Create Dynamic Instagram Grids Using the Infragistics XamDataGrid
Learn how you can connect Instagram to Infragistics XamDataGrid to build dynamic grids.
-
Automate SQL Server Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft SQL Server replication to Azure Synapse.
-
How to connect to JotForm Data with Squirrel SQL client
Connect to JotForm and execute queries in the Squirrel SQL Client.
-
Twitter Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Twitter Ads through CData Connect AI using different applications and tools.
-
Automated Continuous Helpscout Replication to MongoDB
Use CData Sync for automated, continuous, customizable Helpscout replication to MongoDB.
-
Analyze FreshBooks Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of FreshBooks and visualize FreshBooks in SAP Analytics Cloud.
-
Building Dynamic Web Pages with Customer.io Data Using AngularJS
Create single-page applications with live connectivity to Customer.io using the CData API Server.
-
How to connect to Slack Data from Spring Boot
Connect to Slack in a Spring Boot Application using the CData JDBC Driver for Slack
-
Feed SAS Data Sets Data into FineReport
How to set SAS Data Sets as a JDBC data source in FineReport.
-
Use ChatGPT to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zoho CRM for you.
-
Publish Mailjet-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mailjet.
-
Connect to and Query Sage 200 Data in QlikView over ODBC
Create data visualizations with Sage 200 in QlikView.
-
Automated Continuous Oracle Eloqua Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Databricks.
-
Integrate SAP HANA XS Advanced Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP HANA XS Advanced from Informatica Cloud.
-
Connect to Live Outreach.io Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Outreach.io in CData Connect AI and connect to your Outreach.io from PostgreSQL.
-
Getting Started with the CData ADO.NET Provider for Mouseflow
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData Excel Add-In for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon Athena.
-
Publish Reports with ZohoSubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoSubscriptions.
-
Automated Continuous Dynamics NAV Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Vertica.
-
How to connect to Landbot Data from Spring Boot
Connect to Landbot in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Live Teamgate Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Teamgate using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Oracle Sales Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle Sales from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Sales.
-
Connect to and Visualize Live Sage Cloud Accounting Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Business Cloud Accounting.
-
Configure the CData JDBC Driver for Reply.io in a Connection Pool in Tomcat
Connect to Reply.io from a connection pool in Tomcat.
-
How to Connect to Live OneNote Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft OneNote securely in real time.
-
How to Build an ETL App for Google Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Google Ads in Python with petl.
-
Build Apps with Live Azure DevOps Data Using the Low-Code Development Platform of Mendix
Connect Azure DevOps with Mendix to build apps using the CData JDBC Driver for Azure DevOps.
-
Integrate LibreChat with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live QuickBooks Online from within the chat interface.
-
Publish Reports with SAP SuccessFactors LMS Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors LMS.
-
Use the CData Software ODBC Driver for Moosend in MicroStrategy Desktop
Connect to Moosend in MicroStrategy Desktop using the CData Software ODBC Driver for Moosend.
-
Load SAP Ariba Source Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Ariba Source to a database.
-
Integrate SAP Business One Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Business One and integrate live SAP Business One into your Power Automate tasks.
-
Build Apps with Live Cvent Data Using the Low-Code Development Platform of Mendix
Connect Cvent with Mendix to build apps using the CData JDBC Driver for Cvent.
-
Connect to WordPress Data from AWS Glue
Use CData Connect AI to gain access to live WordPress from your AWS Glue jobs.
-
Getting Started with the CData Tableau Connector for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Instagram Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Instagram replication to Apache Kafka.
-
Connect to SAP ByDesign Data in HULFT Integrate
Connect to SAP ByDesign as a JDBC data source in HULFT Integrate
-
Use ChatGPT to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Ads for you.
-
Build Data Flows from SQL Server to Kintone through SSIS
Easily push SQL Server data to Kintone using the CData SSIS Tasks for Kintone.
-
Create Reports from PayPal Data in Looker Studio
Use CData Connect AI to gain access to live PayPal and create custom reports in Looker Studio.
-
How to Connect to Live Lakebase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Lakebase for you.
-
Integrating OpenCode Terminal with Zoho Creator 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.
-
Resolving NetSuite Schema Replication Failures in Microsoft Fabric using CData
A practical guide to fixing NetSuite schema mapping, custom field replication, and SavedSearch failures in Microsoft Fabric using the CData JDBC Driver.
-
Build Apps with Live HubSpot Data Using the Low-Code Development Platform of Mendix
Connect HubSpot with Mendix to build apps using the CData JDBC Driver for HubSpot.
-
Automated Continuous Apify Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Apify replication to Azure SQL Database.
-
Integrate Reckon Accounts Hosted Data in the Pentaho Report Designer
Publish reports based on Reckon Accounts Hosted in the Pentaho BI tool.
-
Analyze Live Microsoft Exchange Data in SAS Viya
Use CData Connect AI to connect to Microsoft Exchange from SAS Viya and deploy self-service analytics using live Microsoft Exchange.
-
How to Visualize JSON Data in Python with pandas
Use pandas and other modules to analyze and visualize live JSON in Python.
-
DataBind Charts to CSV Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CSV/TSV Files 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.
-
Integrating Gumloop with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zendesk within automated workflows.
-
Connect to Pinterest Data in DBArtisan
Use wizards in DBArtisan to configure Pinterest as a data source.
-
Connect to GetResponse Data from PowerBuilder via JDBC
This article demonstrates how to access GetResponse from PowerBuilder using the GetResponse JDBC Driver.
-
How to import Excel Online Data into Apache Solr
Use the CData Software JDBC Driver for Excel Online in Data Import Handler and create an automated import of Microsoft Excel Online to Apache Solr Enterprise Search platform.
-
Process & Analyze Parquet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Parquet Data.
-
Use the CData Software ODBC Driver for ShipStation in SAS for Real-Time Reporting and Analytics
Connect to real-time ShipStation in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipStation.
-
Automated Continuous Instagram Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Instagram replication to Amazon Redshift.
-
How to connect SharePoint with Placid Data through external lists
Provide Placid to SharePoint users as an external list.
-
Feed CloudConvert Data into FineReport
How to set CloudConvert as a JDBC data source in FineReport.
-
Publish Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.
-
Connect to eBay Analytics Data in DBeaver
Use the CData ODBC Driver to connect to eBay Analytics in DBeaver.
-
Extend Google Sheets with Paymo Data
Make calls to Paymo from Google Apps Script via the API Server.
-
Build Pipelines with Live Google Spanner Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Spanner from Google Cloud Data Fusion, enabling the integration of live Google Spanner into the building and management of effective data pipelines.
-
Migrating data from Azure Data Lake Storage to Snowflake using CData SSIS Components.
Easily push Azure Data Lake Storage to Snowflake using the CData SSIS Tasks for Azure Data Lake Storage and Snowflake.
-
How to Connect to LionDesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LionDesk. Leverage the pyodbc module for ODBC in Python.
-
Trigger OneNote IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for OneNote with standard wizards in Logic Apps.
-
Getting Started with the CData ODBC Driver for Clari
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Clari.
-
Build Apps with Live Amazon Marketplace in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace into the Adalo platform and build custom mobile and web applications with real-time Amazon Marketplace.
-
Analyze CircleCI Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CircleCI and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Prepare, Blend, and Analyze HBase Data in Alteryx Designer (Connect AI)
Build workflows to access live Apache HBase for self-service data analytics.
-
Create Reports with Copper Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Copper.
-
Integrating Cursor CLI with Placid 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.
-
Use JayDeBeApi to access Instagram Data in Python
Use standard Python scripting and the development environment of your choice to access live Instagram.
-
Connect and Visualize Live Act CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Act CRM into the Databricks platform and create visualization dashboards with real-time Act CRM.
-
Visualize SAP BusinessObjects BI Data in Tableau
The CData ODBC driver for SAP BusinessObjects BI enables you integrate SAP BusinessObjects BI into Tableau dashboards.
-
Build Azure Table-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Table Data and create custom apps in Mendix.
-
Integrating Boomi Agentstudio with Airtable Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Airtable, enabling AI agents to act on live enterprise data within your integration and automation workflows.