CData Software - Knowledge Base
Recent Articles
-
Analyze Live Quickbase Data in SAS Viya
Use CData Connect AI to connect to Quickbase from SAS Viya and deploy self-service analytics using live Quickbase.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams for you.
-
Connect to IBM Cloud Object Storage Data from PowerBuilder via JDBC
This article demonstrates how to access IBM Cloud Object Storage from PowerBuilder using the IBM Cloud Object Storage JDBC Driver.
-
How to Access Gong Data Using Entity Framework
This article shows how to access Gong using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Excel Spreadsheet Automation on SharePoint Data with the QUERY Formula
Pull data from SharePoint, automate spreadsheets, and more with the QUERY formula.
-
Analyze Kafka Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache Kafka and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Automated Workflows with Live Avro Data in Workato
Use CData Connect AI to connect to live Apache Avro and build automated workflows in Workato.
-
How to Connect Adobe Analytics 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 Adobe Analytics data in real time using natural language.
-
Integrate SendGrid Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SendGrid and integrate live SendGrid into your Power Automate tasks.
-
Build Microsoft Teams-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft Teams to explore live Microsoft Teams Data in Gemini Code Assist to assist with building Microsoft Teams-powered applications.
-
Publish LinkedIn Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LinkedIn Ads.
-
Visualize Live Zoho Creator Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Creator into custom reports in Power BI.
-
Analyze Workday Data in Looker
Use CData Connect AI to connect to Workday Data from Looker and build custom apps using live Workday.
-
Connect to Zoho Inventory Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Inventory from Filemaker Pro on Mac.
-
Build Dashboards with Excel Online Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Excel Online in DBxtra.
-
How to connect to Mistral AI Data in DBVisualizer
Integrate Mistral AI with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Freshdesk Data as a MySQL Database in Node.js
Execute MySQL queries against Freshdesk from Node.js.
-
How to Connect the Power BI Service to Google Drive: Complete Guide
Connect to the CData Software Power BI Connector for Google Drive from PowerBI.com to provide real-time Google Drive across the organization.
-
Use the CData ODBC Driver for BigCommerce in Microsoft Power Query
You can use the CData BigCommerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BigCommerce into Microsoft Power Query.
-
DataBind Controls to Presto Data in Delphi
DataBind to Presto in Delphi with standard data access components and controls.
-
Access PingOne Data from MySQL in PHP
Connect to PingOne through the standard MySQL libraries in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Google Ad Manager Records from SQL Server
Easily push SQL Server data to Google Ad Manager using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Ad Manager or update existing records with data from a SQL Server database.
-
Add xBase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for xBase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Klaviyo Data in CloverDX (formerly CloverETL)
Transfer Klaviyo using the visual workflow in the CloverDX data integration tool.
-
Connect to DB2 Data from HeidiSQL
Use CData Connect AI to connect to and query live IBM DB2 from HeidiSQL.
-
Connect to ConvertKit Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ConvertKit in the Denodo Virtual DataPort Administrator.
-
Integrating Egnyte Data in Talend Cloud Data Management Platform
Connect Egnyte Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect to & Open QuickBooks Online Data in Microsoft Excel
This article uses the CData ODBC driver for QuickBooks Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to create an RPA flow for Mistral AI Data in UiPath Studio
Use the Mistral AI ODBC Driver to create workflows that access real-time Mistral AI without any coding.
-
Automated Continuous Teradata Replication to SQL Server
Use CData Sync for automated, continuous, customizable Teradata replication to SQL Server.
-
How to connect SharePoint with Anaplan Data through external lists
Provide Anaplan to SharePoint users as an external list.
-
How to Access Coinbase Data Using Entity Framework
This article shows how to access Coinbase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Stream Twilio Data into Apache Kafka Topics
Access and stream Twilio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software ODBC Driver for ZarMoney in MicroStrategy Web
Connect to ZarMoney in MicroStrategy Web using the CData Software ODBC Driver for ZarMoney.
-
Connecting Agentforce with Sage Intacct 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 Sage Intacct for you.
-
Query Lakebase Data as a MySQL Database in Node.js
Execute MySQL queries against Lakebase from Node.js.
-
How to integrate Metabase with Quickbase Data
Use CData Connect AI to connect to live Quickbase and create an interactive dashboard in Metabase from Quickbase.
-
Build Agents in Relevance AI with Access to Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Calendar within intelligent agent workflows.
-
How to Connect DBeaver to Redis via a JDBC Driver
Manage Redis with visual tools in DBeaver like the query browser.
-
Connect to Paylocity Data in Aqua Data Studio
Access Paylocity from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Pinterest in MicroStrategy Web
Connect to Pinterest in MicroStrategy Web using the CData Software ODBC Driver for Pinterest.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Guru
Provide connectivity to Guru through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for NASA in MicroStrategy
Connect to NASA in MicroStrategy Developer using the CData Software JDBC Driver for NASA.
-
Integrate with Live WooCommerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to WooCommerce from the MuleSoft Anypoint Platform to integrate live WooCommerce into custom reports and dashboards.
-
Integrate HubSpot with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HubSpot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HubSpot.
-
Automated Continuous Office 365 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Office 365 replication to SingleStore.
-
Automated Continuous SuiteCRM Replication to MySQL
Use CData Sync for automated, continuous, customizable SuiteCRM replication to MySQL.
-
Build Tally Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Tally ERP and build visualizations in Tableau Cloud.
-
Publish Crystal Reports on Superchat Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Superchat.
-
Access NASA Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for NASA.
-
Build Twilio-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Twilio and build Twilio-connected web apps with Axios.
-
Create Datasets from Templated in Domo Workbench and Build Visualizations of Templated Data in Domo
Use the CData Software ODBC Driver for Templated to create datasets from Templated in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Visualize Live NASA Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live NASA.
-
How to update IBM Informix from Excel
This article explains how to transfer data from Excel to IBM Informix using the Excel Add-In for IBM Informix.
-
Connect to Opsgenie Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Opsgenie in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Teamgate in Microsoft Power Query
You can use the CData Teamgate ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Teamgate into Microsoft Power Query.
-
DataBind ZohoExpense Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoExpense to a chart.
-
Visualize Exact Online Data in Tableau
The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.
-
Migrating data from Supabase to Databricks using CData SSIS Components.
Easily push Supabase to Databricks using the CData SSIS Tasks for Supabase and Databricks.
-
Build Dashboards with Attio Data in DBxtra
Create dynamic dashboards and perform analytics based on Attio in DBxtra.
-
Connect to SuiteCRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SuiteCRM and the SQL Gateway to access SuiteCRM from Google Apps Script.
-
Connect Tavily Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tavily using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to use SQLAlchemy ORM to access Short.io Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Short.io.
-
Connecting GenSpark with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google BigQuery without any replication or custom integration required.
-
Automated Continuous Google Calendar Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Calendar replication to SQL Server.
-
Connect to Salesforce CRM Analytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access Salesforce CRM Analytics in Google Apps Script.
-
Build Reckon-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Reckon and build web apps with connectivity to live Reckon.
-
Automated Continuous Impala Replication to SingleStore
Use CData Sync for automated, continuous, customizable Impala replication to SingleStore.
-
Natively Connect to Oracle Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Database. Leverage the native support for ODBC in PHP.
-
Visualize Live Avro Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache Avro into custom reports in Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Facebook Ads
Provide connectivity to Facebook Ads through an SAP BusinessObjects universe.
-
Landbot Reporting in OBIEE with the Landbot JDBC Driver
Deploy the Landbot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to GraphQL Data with Squirrel SQL client
Connect to GraphQL and execute queries in the Squirrel SQL Client.
-
Visualize Customer.io Data in TIBCO Spotfire through ADO.NET
Integrate Customer.io into dashboards in TIBCO Spotfire.
-
Operational Reporting on Calendly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Calendly.
-
Connecting Agentforce with GitHub 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 GitHub for you.
-
Create BigCommerce-Connected Business Apps in AppSheet
Connect to BigCommerce Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to BigCommerce.
-
Automated Continuous HBase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HBase replication to Azure SQL Database.
-
Build IBM Informix-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for IBM Informix to explore live IBM Informix Data in Claude Code to assist with building IBM Informix-powered applications.
-
Office 365 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Office 365 facts in real time.
-
Connect to FreeAgent Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FreeAgent and the SQL Gateway to access FreeAgent from Google Apps Script.
-
Automated Continuous Salesforce Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesforce replication to Databricks.
-
Create SSAS Tabular Models from Missive Data
How to build a SQL Server Analysis Service Tabular Model from Missive using CData drivers.
-
Connect to Live Sybase Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sybase in CData Connect AI and connect to your Sybase from PostgreSQL.
-
Build Intercom-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Intercom and build web apps with connectivity to live Intercom.
-
A PostgreSQL Interface for Recurly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Recurly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Active Directory Data in Pentaho Data Integration
Build ETL pipelines based on Active Directory in the Pentaho Data Integration tool.
-
Visualize Live MailChimp Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MailChimp using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for iContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import Real-Time SAP Ariba Source Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Ariba Source in ColdFusion.
-
How to Create Power BI Visual Reports with Real-Time ZendeskSell Data
Use CData Power BI Connectors to visualize ZendeskSell in Power BI.
-
Connect to Yelp Data from a Connection Pool in JBoss
Integrate Yelp into Java servlets: Use the Management Console in JBoss to install the Yelp JDBC Driver.
-
Integrating GitHub Copilot CLI with Microsoft OneNote 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 connect SharePoint with Lakebase Data through external lists
Provide Lakebase to SharePoint users as an external list.
-
Bridge Microsoft Planner Connectivity with Apache NiFi
Access and process Microsoft Planner in Apache NiFi using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Data
Use CData Power BI Connectors to visualize QuickBooks Desktop in Power BI.
-
Access Phoenix Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Phoenix from your Oracle system.
-
Migrating data from MySQL to Snowflake using CData SSIS Components.
Easily push MySQL to Snowflake using the CData SSIS Tasks for MySQL and Snowflake.
-
Feed ZohoInvoice Data into FineReport
How to set ZohoInvoice as a JDBC data source in FineReport.
-
Integrating Cursor CLI with JDBC-ODBC Bridge 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.