CData Software - Knowledge Base
Recent Articles
-
Build Jira Assets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Assets Data from Zoho Analytics and import live Jira Assets data.
-
Link SAP Ariba Procurement with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Ariba Procurement data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ADO.NET Provider for Recurly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot with AgileCRM 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 Dashboards and Visualize Live Sage 300 Data in Geckoboard
Use CData Connect AI to connect to live Sage 300 data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Viewing Planio Data in RAD Studio Data Explorer
How to view Planio data in RAD Studio Data Explorer using the CData ODBC Driver for Planio.
-
DataBind Teamwork Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Teamwork data to a chart.
-
Integrating Dataiku with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Power BI XMLA data.
-
Use Dash to Build Web Apps on BigQuery Data via CData Connect AI
Build interactive Dash web apps on live BigQuery data using pandas and the CData Connect AI Python SDK.
-
Visualize Google Campaign Manager 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Campaign Manager 360 data.
-
How to publish and share Zendesk Data dashboards with Tableau Server
The CData ODBC driver for Zendesk enables you integrate Zendesk data into Tableau dashboards.
-
How to Connect to RabbitMQ Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to RabbitMQ data. Leverage the pyodbc module for ODBC in Python.
-
Build HBase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for HBase Data and create custom apps in Bubble.
-
Create Datasets from Notion in Domo Workbench and Build Visualizations of Notion Data in Domo
Use the CData Software ODBC Driver for Notion to create datasets from Notion data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Salesforce Data 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Data 360 data.
-
Edit and Search External Google Sheets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Sheets data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for SAP Business One in Microsoft Power Query
You can use the CData SAP Business One ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Business One data into Microsoft Power Query.
-
Prepare, Blend, and Analyze Microsoft Teams Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Teams data for self-service data analytics.
-
How to Connect to YouTube Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to YouTube Analytics data. Leverage the pyodbc module for ODBC in Python.
-
Trigger Google Drive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Drive with standard wizards in Logic Apps.
-
Getting Started with the CData SSIS Components for Quaderno
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Quaderno.
-
Connect to CockroachDB Data from a Connection Pool in Jetty
The CockroachDB JDBC Driver supports connection pooling: This article shows how to connect faster to CockroachDB data from Web apps in Jetty.
-
Excel Spreadsheet Automation on Blackbaud FE NXT Data with the QUERY Formula
Pull data from Blackbaud FE NXT, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Short.io Data
Use CData Power BI Connectors to visualize Short.io data in Power BI.
-
Visualize Live MySQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MySQL data into custom reports in Power BI.
-
Build an OLAP Cube in SSAS from PDFMonkey Data
Establish a connection to PDFMonkey data data from SQL Server Analysis Services, and use the PDFMonkey Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Confluence Data in Heroku for Use in Salesforce Connect
Replicate Confluence data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Trae with Live Supabase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Supabase data from within the AI-powered IDE.
-
How to Connect DBeaver to Salesforce Marketing via a JDBC Driver
Manage Salesforce Marketing data with visual tools in DBeaver like the query browser.
-
Build Automated Workflows with Live NetSuite Data in Workato
Use CData Connect AI to connect to live NetSuite data and build automated workflows in Workato.
-
How to create CircleCI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CircleCI data in MySQL .
-
Connect to Suadeo Data in HULFT Integrate
Connect to Suadeo as a JDBC data source in HULFT Integrate
-
Connect to Aircall Data in Jaspersoft Studio
Execute SQL to remote Aircall data in Jaspersoft Studio.
-
Interact with Live FTP Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live FTP data.
-
Integrate Open WebUI with Live Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Forms data from within the chat interface.
-
How to create SAP Ariba Procurement federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Procurement data in MySQL .
-
Access Live Cohere Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Cohere data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Instagram Replication to Oracle
Use CData Sync for automated, continuous, customizable Instagram replication to Oracle.
-
How to publish and share XML Data dashboards with Tableau Server
The CData ODBC driver for XML enables you integrate XML data into Tableau dashboards.
-
Use Dash to Build Web Apps on Adobe Target Data via CData Connect AI
Build interactive Dash web apps on live Adobe Target data using pandas and the CData Connect AI Python SDK.
-
Connect to ChargeOver Data in CloverDX (formerly CloverETL)
Transfer ChargeOver data using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time ZohoPeople Data in Power BI Report Server
Use the CData ODBC Driver for ZohoPeople to visualize ZohoPeople data in Power BI Desktop and then publish them to Power BI Report Server.
-
Enable the Oracle Eloqua Reporting JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Eloqua Reporting data.
-
DataBind Teradata Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Teradata with the DevExpress Windows Forms and Web controls to provide Teradata data to a chart.
-
Automated Continuous HubDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable HubDB replication to PostgreSQL.
-
Explore Geographical Relationships in Exa Data with Power Map
Create data visualizations with Exa data in Power Map.
-
Access Live Outreach.io Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Outreach.io data from your Google Sheets.
-
Access Live SAP Business One Data in TIBCO Data Virtualization
Use the SAP Business One Tibco DV Adapter to create a SAP Business One data data source in TIBCO Data Virtualization Studio and gain access to live SAP Business One data from your TDV Server.
-
Automated Continuous Zoho Inventory Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to IBM DB2.
-
Access Outlook Data from MySQL in PHP
Connect to Outlook through the standard MySQL libraries in PHP.
-
Integrate Live BambooHR 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 BambooHR data from within the IDE.
-
Model, Search, and Visualize Live Figshare Data in ThoughtSpot
Use CData Connect AI to connect to live Figshare data for modeling, searching, and visualizing.
-
Easily Integrate Pipeline CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Pipeline CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access OpenWeatherMap Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OpenWeatherMap data from HeidiSQL.
-
Automate Smartsheet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Smartsheet data replication to Azure Data Lake.
-
Provide OData Services of Google Spanner Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Spanner data by developing a WCF Service Application.
-
Automate Raisers Edge NXT Data Replication to Azure Data Lake
Use CData Sync to customize and automate Raisers Edge NXT data replication to Azure Data Lake.
-
Create BenchmarkEmail-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BenchmarkEmail Data from Klipfolio and build custom visualizations using live BenchmarkEmail data.
-
Integrating LangGraph with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MySQL data within automated workflows.
-
Automate Webex Data Replication to Azure Data Lake
Use CData Sync to customize and automate Webex data replication to Azure Data Lake.
-
How to Visualize Salesloft 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 Salesloft data in Python.
-
Build Google Drive Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Drive data and build visualizations in Tableau Cloud.
-
Visualize LDAP Objects in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load LDAP objects into TIBCO Spotfire.
-
Build Visualizations of SAP HANA XS Advanced Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA XS Advanced data in Birst.
-
Bridge ScrapingBee Connectivity with Apache NiFi
Access and process ScrapingBee data in Apache NiFi using the CData JDBC Driver.
-
Replicate CapsuleCRM Data to Multiple Databases
Replicate CapsuleCRM data to disparate databases with a point-and-click configuration.
-
Analyze Avalara AvaTax Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avalara AvaTax from Power Pivot. You will use the Table Import Wizard to load Avalara AvaTax data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Flowlu Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Flowlu data in Microsoft R Open.
-
Integrating GitHub Copilot with Cassandra 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 Microsoft Teams Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Teams data using standard SQL.
-
Integrating LangChain with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Acumatica data within automated workflows.
-
Moving Data from Box to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Box data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Migrating data from Suadeo to Databricks using CData SSIS Components.
Easily push Suadeo data to Databricks using the CData SSIS Tasks for Suadeo and Databricks.
-
Integrating Dataiku with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Impala data.
-
How to work with Paylocity Data in Apache Spark using SQL
Access and process Paylocity Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP Netweaver Gateway in SpagoBI
Create reports featuring live SAP Netweaver Gateway data in SpagoBI Studio. Host SAP Netweaver Gateway reports on SpagoBI Server.
-
Perform Batch Operations with Avalara AvaTax Data in Apache NiFi
Connect to Avalara AvaTax data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
DataBind Charts to HBase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HBase 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.
-
Use the CData Software ODBC Driver for Oracle Eloqua in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Eloqua data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Eloqua.
-
Connect to Figshare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Figshare data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate with Raisers Edge NXT Data in JReport Designer
Create charts and reports based on Raisers Edge NXT data in JReport Designer.
-
Build a Singer.io Tap for Wave Financial With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Wave Financial data using the CData Python Connector.
-
Connect to Sage 200 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage 200 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Apps with Live YouTube Analytics Data Using the Low-Code Development Platform of Mendix
Connect YouTube Analytics data with Mendix to build apps using the CData JDBC Driver for YouTube Analytics.
-
Create Dynamics NAV-Connected Nintex Workflows
Use CData Connect AI to connect to Dynamics NAV Data from Nintex Workflow Cloud and build custom workflows using live Dynamics NAV data.
-
Model Square Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Square, enabling the direct import of real-time Square data.
-
Integrate Mistral AI Data in the Pentaho Report Designer
Publish reports based on Mistral AI data in the Pentaho BI tool.
-
Integrate Redshift Data in Pentaho Data Integration
Build ETL pipelines based on Redshift data in the Pentaho Data Integration tool.
-
Create Apps from Toggl Data in Qlik Sense Cloud
Use CData Connect AI to connect to Toggl Data and build apps from live Toggl data in Qlik Sense Cloud.
-
Connect to Bitly Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Bitly data in Airbyte.
-
Integrate Devin with Live Redshift Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Redshift data.
-
Connect to PayPal from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PayPal data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData ODBC Driver for Vimeo in Microsoft Power Query
You can use the CData Vimeo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Vimeo data into Microsoft Power Query.
-
Automated Continuous MailChimp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailChimp replication to Apache Cassandra.
-
Use JayDeBeApi to access Acumatica Data in Python
Use standard Python scripting and the development environment of your choice to access live Acumatica data.
-
Stream Couchbase Data into Apache Kafka Topics
Access and stream Couchbase data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from Oracle Service Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Service Cloud data to Google BigQuery using the CData SSIS Tasks for Oracle Service Cloud and Google BigQuery.
-
Import Real-Time Google Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Analytics data in ColdFusion.
-
Build Pipelines with Live TaxJar Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to TaxJar from Google Cloud Data Fusion, enabling the integration of live TaxJar data into the building and management of effective data pipelines.
-
Connect to Oracle Data in Aqua Data Studio
Access Oracle data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.