CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Tableau Connector for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for QuickBooks Online.
-
Analyze Live Azure Data Lake Storage Data in SAS Viya
Use CData Connect AI to connect to Azure Data Lake Storage data from SAS Viya and deploy self-service analytics using live Azure Data Lake Storage data.
-
Visualize Live Gorgias Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Gorgias data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to FreshBooks Data from a Connection Pool in Jetty
The FreshBooks JDBC Driver supports connection pooling: This article shows how to connect faster to FreshBooks data from Web apps in Jetty.
-
Publish Crystal Reports on PabblySubscriptions Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PabblySubscriptions data.
-
Build a Singer.io Tap for Mixpanel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mixpanel data using the CData Python Connector.
-
Trigger Wave Financial IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Wave Financial with standard wizards in Logic Apps.
-
Automated Continuous Vercel Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vercel replication to SingleStore.
-
Query Front Data in ColdFusion
Write standard ColdFusion data access code to connect to Front data.
-
Connecting Agentforce with BambooHR Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your BambooHR data for you.
-
Analyze Moosend Data in Looker
Use CData Connect AI to connect to Moosend Data from Looker and build custom apps using live Moosend data.
-
Use the CData ODBC Driver for Factorial from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Factorial to connect to Factorial data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Factorial data in Excel.
-
Getting Started with the CData Power BI Connector for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Boomi Agentstudio with Coda Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Coda data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Charts with Autopilot Data in Clear Analytics
Create dynamic charts and perform analytics based on Autopilot data in Clear Analytics.
-
How to integrate Perplexity with Apache Airflow
Access and process Perplexity data in Apache Airflow using the CData JDBC Driver.
-
Build Pinecone-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pinecone data and build web apps with connectivity to live Pinecone data.
-
Connect to Paylocity Data from Crystal Reports
Use CData Connect AI to connect to and report on live Paylocity data from Crystal Reports.
-
How to Connect to Live eBay Analytics 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 eBay Analytics data without replication.
-
How to create Visio diagrams from Stripe Data
Automatically update Stripe data with the changes you make to Visio master shapes.
-
Access Live SAP Concur Data in Excel 365 Online (Excel for the web)
Connect to SAP Concur data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Invoiced Data from PowerBuilder via ADO.NET
This article demonstrates how to access Invoiced data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create ShipStation-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ShipStation Data from Klipfolio and build custom visualizations using live ShipStation data.
-
Use the CData Software JDBC Driver for Quaderno in MicroStrategy Web
Connect to Quaderno data in MicroStrategy Web using the CData Software JDBC Driver for Quaderno.
-
DataBind Charts to Couchbase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Couchbase 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.
-
Getting Started with the CData JDBC Driver for CSV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CSV.
-
Access Live Dynamics CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Dynamics CRM data from your Excel spreadsheets.
-
Replicate Invoiced Data to Multiple Databases via the CData Sync CLI
Replicate Invoiced data to disparate databases with a single configuration.
-
Integrate Theia IDE with Live PingOne 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 PingOne data from within the development environment.
-
Access Live Google Spanner Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner data from your Google Sheets.
-
Query HubDB Data as a MySQL Database in Node.js
Execute MySQL queries against HubDB data from Node.js.
-
View Reports on Real-Time Copper Data in Power BI Report Server
Use the CData ODBC Driver for Copper to visualize Copper data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Live Microsoft Planner Data in SAS Viya
Use CData Connect AI to connect to Microsoft Planner data from SAS Viya and deploy self-service analytics using live Microsoft Planner data.
-
Visualize Live Phoenix Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Phoenix data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Dify with Live BigCommerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live BigCommerce data.
-
Use Grok to Talk to Your Google Forms 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 Google Forms data for you.
-
How to Query HDFS Data in MySQL Workbench
Execute MySQL queries against live HDFS data from MySQL Workbench.
-
Connect to Zuora from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zuora data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Databricks Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Databricks data.
-
Enable the Sendwithus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sendwithus data.
-
Connect to SAP HANA Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP HANA data.
-
Build eBay Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live eBay Analytics data and build visualizations in Tableau Cloud.
-
Stream MariaDB Data into Apache Kafka Topics
Access and stream MariaDB data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to use SQLAlchemy ORM to access IBM Cloud Object Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Cloud Object Storage data.
-
Integrate Cline with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Outreach.io data from within your IDE.
-
Integrate with Jodoo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jodoo data to a JSON file on disk.
-
Create Zoho Projects Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Projects data access from reports, embedded analytics, and more.
-
How to work with Aweber Data in Apache Spark using SQL
Access and process Aweber Data in Apache Spark using the CData Software JDBC Driver.
-
Build Data Flows from Wistia to SQL Server using SSIS
Easily back up Wistia data to SQL Server using the SSIS components for Wistia.
-
Connect to Supabase from Asprova with CData Software ODBC Driver for Supabase
This article shows how to connect faster to Supabase data from Asprova.
-
Model Trello Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Trello, enabling the direct import of real-time Trello data.
-
Analyze Live ZohoPeople Data in SAS Viya
Use CData Connect AI to connect to ZohoPeople data from SAS Viya and deploy self-service analytics using live ZohoPeople data.
-
Connect to Spark from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Spark data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Tavily Data to Multiple Databases
Replicate Tavily data to disparate databases with a point-and-click configuration.
-
View Reports on Real-Time Deel Data in Power BI Report Server
Use the CData ODBC Driver for Deel to visualize Deel data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to ZohoInvoice Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ZohoInvoice data.
-
How to create an RPA flow for Google Campaign Manager 360 Data in UiPath Studio
Use the Google Campaign Manager 360 ODBC Driver to create workflows that access real-time Google Campaign Manager 360 data without any coding.
-
Automated Continuous Freshsales Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshsales data replication to OneLake in Microsoft Fabric.
-
Visualize Google Forms Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Forms data into TIBCO Spotfire.
-
Connect to WooCommerce Data from AWS Glue
Use CData Connect AI to gain access to live WooCommerce data from your AWS Glue jobs.
-
Rapidly Develop GetResponse-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by GetResponse.
-
Use Manus AI to Talk to Your SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data.
-
Process & Analyze Google Tasks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Tasks Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bugsnag
Provide connectivity to Bugsnag data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Paymo
Create Paymo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
A PostgreSQL Interface for SAP Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query Microsoft Ads Data in QlikView over ODBC
Create data visualizations with Microsoft Ads data in QlikView.
-
Integrating Codex with SurveyMonkey 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.
-
Integrating Claude Code with Impala Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Impala data within assisted coding and automated development workflows.
-
Connect to Live YouTube Analytics Data in PostGresSQL Interface through CData Connect AI
Create a live connection to YouTube Analytics in CData Connect AI and connect to your YouTube Analytics data from PostgreSQL.
-
How to publish and share Printful Data dashboards with Tableau Server
The CData ODBC driver for Printful enables you integrate Printful data into Tableau dashboards.
-
Use the CData SSIS Components to Insert New or Update Existing SAP Ariba Source Records from SQL Server
Easily push SQL Server data to SAP Ariba Source using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAP Ariba Source or update existing records with data from a SQL Server database.
-
Consume MariaDB OData Feeds in PowerBuilder
This article demonstrates how to consume MariaDB data as OData feeds from PowerBuilder using the API Server.
-
How to publish and share Auth0 Data dashboards with Tableau Server
The CData ODBC driver for Auth0 enables you integrate Auth0 data into Tableau dashboards.
-
Use the CData Software ODBC Driver for Microsoft Exchange in MicroStrategy Web
Connect to Microsoft Exchange data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Exchange.
-
Connect to SAP Ariba Source Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Ariba Source data in Google Apps Script.
-
Visualize Instantly Data in Sisense
Create an ElastiCube in Sisense app with access to Instantly data.
-
Create Reports with Microsoft OneDrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneDrive data.
-
A PostgreSQL Interface for Tanda Data using the CData ODBC Driver
Use the SQL Gateway and Tanda ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate VWO Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to VWO data and integrate live VWO data into your Power Automate tasks.
-
Use the CData Software ODBC Driver for Sybase IQ in MicroStrategy Desktop
Connect to Sybase IQ data in MicroStrategy Desktop using the CData Software ODBC Driver for Sybase IQ.
-
Connect to Wrike Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Wrike as an External Source in Dremio.
-
Query TigerGraph Data as a MySQL Database in Node.js
Execute MySQL queries against TigerGraph data from Node.js.
-
Build Automated SAP SuccessFactors LMS-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and build automated workflows in Zapier.
-
Query OpenWeatherMap Data through ODBC in Node.js
Use node-odbc to execute SQL queries against OpenWeatherMap data from Node.js.
-
DataBind Controls to Freshsales Data in Delphi
DataBind to Freshsales data in Delphi with standard data access components and controls.
-
Analyze Smartsheet Data in Looker
Use CData Connect AI to connect to Smartsheet Data from Looker and build custom apps using live Smartsheet data.
-
Migrating data from Copper to Google BigQuery using CData SSIS Components.
Easily push Copper data to Google BigQuery using the CData SSIS Tasks for Copper and Google BigQuery.
-
Connecting Mastra with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Outreach.io data, no replication required.
-
Connect Okta to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Okta with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with Google Calendar 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.
-
Analyze Live AfterShip Data in SAS Viya
Use CData Connect AI to connect to AfterShip data from SAS Viya and deploy self-service analytics using live AfterShip data.
-
Visualize Todoist Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Todoist data.
-
How to Connect to Live Google Calendar Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Calendar data securely in real time.
-
Automated Continuous Paymo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Paymo replication to Google Cloud SQL.
-
DataBind Controls to PostgreSQL Data in Delphi
DataBind to PostgreSQL data in Delphi with standard data access components and controls.
-
Connect to SQL Server Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SQL Server as an External Source in Dremio.
-
Connect to SAP Ariba Procurement Data from a Connection Pool in JBoss
Integrate SAP Ariba Procurement data into Java servlets: Use the Management Console in JBoss to install the SAP Ariba Procurement JDBC Driver.
-
Integrate Salesforce Data 360 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce Data 360 with External Services.
-
Automated Continuous Excel Replication to Vertica
Use CData Sync for automated, continuous, customizable Excel replication to Vertica.