CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Testmonitor Data in Dundas BI
Create dynamic dashboards and perform analytics based on Testmonitor data in Dundas BI.
-
Connect to Bugsnag Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bugsnag data in the Denodo Virtual DataPort Administrator.
-
Publish Reports with Bugsnag Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bugsnag data.
-
How to connect Amazon QuickSight to SurveyMonkey Data
Create a connection to SurveyMonkey data in CData Connect AI and insert SurveyMonkey data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Create Power BI Visual Reports with Real-Time Yelp Data
Use CData Power BI Connectors to visualize Yelp data in Power BI.
-
View Reports on Real-Time PostgreSQL Data in Power BI Report Server
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Bullhorn CRM Data in Ruby
Connect to Bullhorn CRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Charts to HCL Domino Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HCL Domino 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.
-
Replicate Multiple Raisers Edge NXT Accounts
Replicate multiple Raisers Edge NXT accounts to one or many databases.
-
Use Claude to Talk to Your Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Greenhouse data for you.
-
Visualize Live Apify Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apify data into custom reports in Power BI.
-
Build QuickBooks Time Visualizations in Tableau Desktop
Use CData Connect AI to connect to live QuickBooks Time data and build visualizations in Tableau.
-
Connect to Mouseflow Data in HULFT Integrate
Connect to Mouseflow as a JDBC data source in HULFT Integrate
-
Integrating LangChain with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Couchbase data within automated workflows.
-
How to connect PolyBase to Jira
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jira data.
-
Extract, Transform, and Load Nethunt Data in Informatica PowerCenter
Create a simple Workflow for Nethunt data in Informatica PowerCenter.
-
Use Grok to Talk to Your Adobe Commerce 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 Adobe Commerce data for you.
-
Access Exa Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exa data from your Oracle system.
-
Design BIRT Reports on Zoom Data
Provide current Zoom data to your embedded analytics.
-
Connect to Cloudflare Data from HeidiSQL
Use CData Connect AI to connect to and query live Cloudflare data from HeidiSQL.
-
How to connect to Testmonitor Data with Squirrel SQL client
Connect to Testmonitor data and execute queries in the Squirrel SQL Client.
-
Load Mistral AI Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mistral AI data to a database.
-
Build Charts with SAP SuccessFactors Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP SuccessFactors data in Clear Analytics.
-
Building Dynamic Web Pages with Presto Data Using AngularJS
Create single-page applications with live connectivity to Presto using the CData API Server.
-
How to Connect Anaplan Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Anaplan data in real time using natural language.
-
How to integrate Google Ads with Apache Airflow
Access and process Google Ads data in Apache Airflow using the CData JDBC Driver.
-
Visualize JSON Services in TIBCO Spotfire through ADO.NET
Integrate JSON services into dashboards in TIBCO Spotfire.
-
Build Pipelines with Live MYOB AccountRight Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from Google Cloud Data Fusion, enabling the integration of live MYOB AccountRight data into the building and management of effective data pipelines.
-
Natively Connect to Sage Cloud Accounting Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Cloud Accounting data. Leverage the native support for ODBC in PHP.
-
Automated Continuous MailerLite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MailerLite replication to Amazon Redshift.
-
Query Stripe Data as a MySQL Database in Node.js
Execute MySQL queries against Stripe data from Node.js.
-
Integrating Gumloop with Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Teradata data within automated workflows.
-
How to Build an ETL App for Bannerbear Data in Python with CData Connect AI
Extract and transform live Bannerbear data in Python with petl and the CData Connect AI Python SDK.
-
Choosing the Best Method to Connect Pipedrive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipedrive data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Greenplum in SpagoBI
Create reports featuring live Greenplum data in SpagoBI Studio. Host Greenplum reports on SpagoBI Server.
-
Access Zuora Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zuora data from your Oracle system.
-
Build ZohoSubscriptions-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoSubscriptions Data from Zoho Analytics and import live ZohoSubscriptions data.
-
Integrating OpenCode with PayPal 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 Semantic Layer Views for Microsoft Dataverse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dataverse data.
-
Connect to MySQL Data in Google Apps Script via Connect AI
Use CData Connect AI to access MySQL data in Google Apps Script.
-
Query BenchmarkEmail Data through ODBC in Node.js
Use node-odbc to execute SQL queries against BenchmarkEmail data from Node.js.
-
How to use SQLAlchemy ORM to access MailerLite Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MailerLite data.
-
Build Visualizations of Greenplum Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Greenplum data in Birst.
-
Create Informatica Mappings From/To a JDBC Data Source for Dotmailer
Create Dotmailer data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Amazon Marketplace Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon Marketplace data from Appeon PowerBuilder using the CData ADO.NET Provider for Amazon Marketplace.
-
Create Apps from SAP Business One Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Business One Data and build apps from live SAP Business One data in Qlik Sense Cloud.
-
Moving Data from Freshsales to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshsales data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Seamlessly Bring Authorize.Net Data into Retool Using CData Connect AI
Integrate Authorize.Net data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Coda Data in Heroku for Use in Salesforce Connect
Replicate Coda data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Exa Data to Multiple Databases via the CData Sync CLI
Replicate Exa data to disparate databases with a single configuration.
-
Connect to Parquet Data in DBeaver
Use the CData ODBC Driver to connect to Parquet data in DBeaver.
-
Connect to YouTube Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live YouTube Analytics data from Crystal Reports.
-
Google Cloud Storage Reporting in OBIEE with the Google Cloud Storage JDBC Driver
Deploy the Google Cloud Storage JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize SingleStore Data in Sisense
Create an ElastiCube in Sisense app with access to SingleStore data.
-
Integrating Gumloop with ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ZohoExpense data within automated workflows.
-
Create Sage 200-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sage 200 Data from Klipfolio and build custom visualizations using live Sage 200 data.
-
How to Connect DBeaver to Google Search via a JDBC Driver
Manage Google Search results with visual tools in DBeaver like the query browser.
-
Feed Chargebee Data into FineReport
How to set Chargebee data as a JDBC data source in FineReport.
-
Create Smartsheet-Connected Dashboards in Grafana
Connect to Smartsheet Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Smartsheet data.
-
Use ChatGPT to Talk to Your Bullhorn 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 Bullhorn CRM data for you.
-
Build Charts with Egnyte Data in Clear Analytics
Create dynamic charts and perform analytics based on Egnyte data in Clear Analytics.
-
Getting Started with the CData Excel Add-In for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Sales.
-
Use Biml to Build SSIS Tasks to Replicate ZohoPeople Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoPeople data to SQL Server.
-
Connect to QuickBooks from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks to connect to QuickBooks data from Web applications running on WebLogic.
-
Integrating Gumloop with Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Creator data within automated workflows.
-
Getting Started with the CData SSIS Components for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoPeople.
-
Integrating GitHub Copilot 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.
-
Getting Started with the CData Excel Add-In for MailerSend
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MailerSend.
-
Access Teamwork Data from MySQL in Amazon QuickSight
Connect to Teamwork and build visualizations of Teamwork data using a MySQL Connection in Amazon QuickSight.
-
Visualize OneNote Data in Tableau
The CData ODBC driver for OneNote enables you integrate OneNote data into Tableau dashboards.
-
Automated Continuous Lakebase Replication to Databricks
Use CData Sync for automated, continuous, customizable Lakebase replication to Databricks.
-
Use Agno to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your GitHub data for you.
-
Replicate Salesforce Marketing Data in Heroku for Use in Salesforce Connect
Replicate Salesforce Marketing data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Trae with Live Amazon DynamoDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Amazon DynamoDB data from within the AI-powered IDE.
-
Publish Coinbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Coinbase data.
-
Establish a Live Connection with Scrapfly Data using Tableau Bridge
The CData ODBC Driver for Scrapfly enables you to integrate live Scrapfly data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Automated Workflows with Live ADP Data in Workato
Use CData Connect AI to connect to live ADP data and build automated workflows in Workato.
-
Automate Billsby Data Replication to Couchbase
Use CData Sync to Customize and automate Billsby data replication to Couchbase.
-
Connect to GitLab Data in JRuby
Create a simple JRuby app with access to live GitLab data.
-
Enable the Webflow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webflow data.
-
Migrating data from Notion to Snowflake using CData SSIS Components.
Easily push Notion data to Snowflake using the CData SSIS Tasks for Notion and Snowflake.
-
Automated Continuous ChartMogul Replication to Snowflake
Use CData Sync for automated, continuous, customizable ChartMogul replication to Snowflake.
-
Connect to SharePoint Data from AWS Glue
Use CData Connect AI to gain access to live SharePoint data from your AWS Glue jobs.
-
Getting Started with the CData JDBC Driver for Perigon
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Perigon.
-
Oracle Service Cloud Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Service Cloud data through CData Connect AI using different applications and tools.
-
How to Connect Zendesk Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zendesk data in real time using natural language.
-
Access Live Presto Data in Excel 365 Online (Excel for the web)
Connect to Presto data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Outreach.io from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Outreach.io data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Creating Shippo-Connected Applications in Unqork
You can use CData Connect AI to feed Shippo data to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Flowlu in a Connection Pool in Tomcat
Connect to Flowlu data from a connection pool in Tomcat.
-
Integrate Adobe Experience Manager Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Experience Manager data from Informatica Cloud.
-
How to import Grafana Data into Apache Solr
Use the CData Software JDBC Driver for Grafana in Data Import Handler and create an automated import of Grafana data to Apache Solr Enterprise Search platform.
-
Connect to Zoho Books Data in JRuby
Create a simple JRuby app with access to live Zoho Books data.
-
Query Live SAP Business Warehouse 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 SAP Business Warehouse data through a conversational interface.
-
Connect to FreeAgent from Asprova with CData Software ODBC Driver for FreeAgent
This article shows how to connect faster to FreeAgent data from Asprova.
-
Query, Visualize, and Share live Google Analytics Data in Redash
Use CData Connect AI to connect to live Google Analytics data in Redash for querying, visualizing, and sharing.
-
How to Build an ETL App for Mixpanel Data in Python with CData
Create ETL applications and real-time data pipelines for Mixpanel data in Python with petl.
-
How to publish and share Optimizely Data dashboards with Tableau Server
The CData ODBC driver for Optimizely enables you integrate Optimizely data into Tableau dashboards.
-
Integrate LibreChat with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live CSV data from within the chat interface.
-
Import and Visualize Snapchat Ads Data in Power View
Create data visualizations based on Snapchat Ads data in Excel.