CData Software - Knowledge Base
Recent Articles
-
Seamlessly Bring BigQuery Data into Retool Using CData Connect AI
Integrate BigQuery data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate with Zoom Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoom data to a JSON file on disk.
-
DataBind Demio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Demio data to a chart.
-
Choosing the Best Method to Connect NASA to SQL Server: 5 Options Explained
Discover multiple ways to connect and use NASA data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Klaviyo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Klaviyo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Import and Visualize iContact Data in Power View
Create data visualizations based on iContact data in Excel.
-
How to Connect Flowise AI Agents to Live OneNote Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live OneNote data without replication.
-
Build Exact Online Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Exact Online data and build visualizations in Tableau Cloud.
-
Query Bitbucket Data in DataGrip
Create a Data Source for Bitbucket in DataGrip and use SQL to query live Bitbucket data.
-
Connect to Wistia Data in HULFT Integrate
Connect to Wistia as a JDBC data source in HULFT Integrate
-
Connect to Azure Synapse Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Synapse data in Airbyte.
-
Access Live SAP BusinessObjects BI Data in Excel 365 Online (Excel for the web)
Connect to SAP BusinessObjects BI data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Operational Reporting on SendInBlue Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendInBlue data.
-
Use ChatGPT to Talk to Your Marketo 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 Marketo data for you.
-
Integrate LibreChat with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sugar CRM data from within the chat interface.
-
Automated Continuous Jira Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Jira replication to PostgreSQL.
-
Extract, Transform, and Load Unbounce Data in Informatica PowerCenter
Create a simple Workflow for Unbounce data in Informatica PowerCenter.
-
Build Trello Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Trello data and build visualizations in Tableau Cloud.
-
Integrate Cursor with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Dynamics 365 Business Central data from within the editor.
-
Access Live Sendwithus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sendwithus data into the statistical analysis tools available in SAS JMP. This article shows how to use Sendwithus data in the Graph Builder and Query Builder.
-
Visualize Live Okta Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Okta data.
-
Publish Reports with Aweber Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aweber data.
-
Enable the ZohoMarketingHub JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoMarketingHub data.
-
Query Zuora Data in DataGrip
Create a Data Source for Zuora in DataGrip and use SQL to query live Zuora data.
-
Integrate Live Gong Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Gong data from within the IDE.
-
Build Automated LinkedIn-Connected Workflows in Zapier
Use CData Connect AI to connect to live LinkedIn data and build automated workflows in Zapier.
-
Access Live Tavily Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tavily data from your Excel spreadsheets.
-
Replicate Microsoft Dataverse Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Dataverse data to disparate databases with a single configuration.
-
Connect to Stripe Data in Jaspersoft Studio
Execute SQL to remote Stripe data in Jaspersoft Studio.
-
Visualize Greenplum Data in Tableau
The CData ODBC driver for Greenplum enables you integrate Greenplum data into Tableau dashboards.
-
How to Connect to Live Blackbaud FE NXT Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Blackbaud FE NXT data for you.
-
How to connect to Aircall Data with Squirrel SQL client
Connect to Aircall data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Mixpanel Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mixpanel replication to Google BigQuery.
-
Connect to Microsoft Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Ads data in Airbyte.
-
Connect to Live Anaplan Data in MicroStrategy through CData Connect AI
Create a live connection to Anaplan Data in CData Connect AI and connect to your Anaplan data from MicroStrategy.
-
Replicate Multiple Microsoft Teams Accounts via the CData Sync CLI
Replicate multiple Microsoft Teams accounts to one or many databases.
-
How to connect to Hugging Face Data from Spring Boot
Connect to Hugging Face in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze Mailjet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mailjet data with the CData JDBC Driver for Mailjet.
-
DataBind Controls to FreshBooks Data in Delphi
DataBind to FreshBooks data in Delphi with standard data access components and controls.
-
Write a Simple Go Application to work with Printful Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Printful data.
-
Connect to and Query Opsgenie Data in QlikView over ODBC
Create data visualizations with Opsgenie data in QlikView.
-
How to Visualize Oracle HCM Cloud 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 Oracle HCM Cloud data in Python.
-
Configure the CData JDBC Driver for Factorial in a Connection Pool in Tomcat
Connect to Factorial data from a connection pool in Tomcat.
-
Build Visualizations of Reckon Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Reckon data in Birst.
-
Automate ScrapingBee Data Replication to SAP HANA
Use CData Sync to customize and automate ScrapingBee data replication to SAP HANA.
-
Prepare, Blend, and Analyze Paymo Data in Alteryx Designer (Connect AI)
Build workflows to access live Paymo data for self-service data analytics.
-
Migrating data from Zuora to Google BigQuery using CData SSIS Components.
Easily push Zuora data to Google BigQuery using the CData SSIS Tasks for Zuora and Google BigQuery.
-
Integrating Cursor with Bright Data 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 Easily Query Timely Data in OpenOffice Base
Connect to Timely data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Trigger BigCommerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for BigCommerce with standard wizards in Logic Apps.
-
How to publish and share Flowlu Data dashboards with Tableau Server
The CData ODBC driver for Flowlu enables you integrate Flowlu data into Tableau dashboards.
-
Access ADP Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ADP data from your Oracle system.
-
Access Live Oracle Eloqua Reporting Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Eloqua Reporting data into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Eloqua Reporting data in the Graph Builder and Query Builder.
-
Automated Continuous MongoDB Replication to Vertica
Use CData Sync for automated, continuous, customizable MongoDB replication to Vertica.
-
How to import CSV Data into Apache Solr
Use the CData Software JDBC Driver for CSV in Data Import Handler and create an automated import of CSV data to Apache Solr Enterprise Search platform.
-
Build Dashboards with Google Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Analytics data in DBxtra.
-
Connect to ZendeskSell Data in Jaspersoft Studio
Execute SQL to remote ZendeskSell data in Jaspersoft Studio.
-
Create a Data Access Object for LinkedIn Data using JDBI
A brief overview of creating a SQL Object API for LinkedIn data in JDBI.
-
Load Exa Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Exa data to a database.
-
Integrating Gumloop with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Excel Online data within automated workflows.
-
Connect to Real-Time Recurly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Recurly data in Power Apps.
-
Integrating LlamaIndex with AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on AfterShip data in real time.
-
Discourse Reporting in OBIEE with the Discourse JDBC Driver
Deploy the Discourse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to and Query Jira Data in QlikView over ODBC
Create data visualizations with Jira data in QlikView.
-
Getting Started with the CData Excel Add-In for Scrapfly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Scrapfly.
-
Integrating Cursor 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.
-
Process & Analyze Azure Data Catalog Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Catalog Data.
-
Use the CData ODBC Driver for Guru in Microsoft Power Query
You can use the CData Guru ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Guru data into Microsoft Power Query.
-
Build eBay-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for eBay Data and create custom apps in Bubble.
-
Integrate Trae with Live SQL Analysis Services Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SQL Analysis Services data from within the AI-powered IDE.
-
Natively Connect to Lakebase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Lakebase data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy Desktop
Connect to Templated data in MicroStrategy Desktop using the CData Software ODBC Driver for Templated.
-
Create a Data Access Object for Perigon Data using JDBI
A brief overview of creating a SQL Object API for Perigon data in JDBI.
-
Integrate Goose with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Slack data from within the local AI agent.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy Desktop
Connect to Autopilot data in MicroStrategy Desktop using the CData Software ODBC Driver for Autopilot.
-
Build Microsoft Teams-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Teams data and build Microsoft Teams-connected web apps with Axios.
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Web
Connect to SharePoint Excel Services data in MicroStrategy Web using the CData Software JDBC Driver for SharePoint Excel Services.
-
Deploy the ADO.NET Provider for Sybase on an SSRS Report Server
Connect to Sybase data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Live ConstantContact Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ConstantContact data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Discord Data in ACL Analytics
Connect to Discord data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Discord data.
-
Integrate LibreChat with Live Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Jumpseller data from within the chat interface.
-
How to publish and share RabbitMQ Data dashboards with Tableau Server
The CData ODBC driver for RabbitMQ enables you integrate RabbitMQ data into Tableau dashboards.
-
Getting Started with the CData ODBC Driver for Bitbucket
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bitbucket.
-
Use the CData ODBC Driver for SparkPost in Microsoft Power Query
You can use the CData SparkPost ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SparkPost data into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time Codat Data
Use CData Power BI Connectors to visualize Codat data in Power BI.
-
Integrate Google's Vertex AI Agent with Live Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Cassandra data within intelligent workflows.
-
Integrating OpenCode with Dynamics 365 Business Central 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 Greenplum-Connected Business Apps in AppSheet
Connect to Greenplum Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Greenplum data.
-
Build Visualizations of Parquet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Parquet data in Birst.
-
Migrating data from Box to Snowflake using CData SSIS Components.
Easily push Box data to Snowflake using the CData SSIS Tasks for Box and Snowflake.
-
Automated Continuous MailerSend Replication to SQL Server
Use CData Sync for automated, continuous, customizable MailerSend replication to SQL Server.
-
Explore Geographical Relationships in CockroachDB Data with Power Map
Create data visualizations with CockroachDB data in Power Map.
-
How to connect PolyBase to Browserless
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Browserless data.
-
Connect to GitLab Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to GitLab.
-
Integrate with Bright Data Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bright Data data to a JSON file on disk.
-
Connect to and Visualize Live Monday.com Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Monday.com data.
-
Integrating ConstantContact Data in Talend Cloud Data Management Platform
Connect ConstantContact Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to WordPress Data in CloverDX (formerly CloverETL)
Transfer WordPress data using the visual workflow in the CloverDX data integration tool.
-
Integrate Open WebUI with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Exchange data from within the chat interface.
-
How to Query JSON Services in MySQL Workbench
Execute MySQL queries against live JSON services from MySQL Workbench.