CData Software - Knowledge Base
Recent Articles
-
DataBind CloudConvert Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CloudConvert to a chart.
-
Import Real-Time Demio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Demio in ColdFusion.
-
Operational Reporting on Eventbrite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Eventbrite.
-
Extend Google Sheets with Odoo Data
Make calls to Odoo from Google Apps Script via the API Server.
-
Edit and Search External SAP BusinessObjects BI Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP BusinessObjects BI to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP BusinessObjects BI Data objects that you can access from apps and the dashboard.
-
Build Dashboards with Webflow Data in Dundas BI
Create dynamic dashboards and perform analytics based on Webflow in Dundas BI.
-
Connect to Instantly Data from PowerBuilder via JDBC
This article demonstrates how to access Instantly from PowerBuilder using the Instantly JDBC Driver.
-
Connect to Drip Data in JRuby
Create a simple JRuby app with access to live Drip.
-
Natively Connect to Reckon Data in PHP
The CData ODBC driver for Reckon enables you to create PHP applications with connectivity to Reckon. Leverage the native support for ODBC in PHP.
-
Create Reports with Google Ad Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ad Manager.
-
Build Semantic Layer Views for WordPress Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WordPress.
-
Extend Google Sheets with Paylocity Data
Make calls to Paylocity from Google Apps Script via the API Server.
-
Automate ShipStation Data Replication to Azure Data Lake
Use CData Sync to customize and automate ShipStation replication to Azure Data Lake.
-
Connect Adobe Experience Manager to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Experience Manager using the CData Python MCP Server.
-
Bridge Billsby Connectivity with Apache NiFi
Access and process Billsby in Apache NiFi using the CData JDBC Driver.
-
Build GitHub-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for GitHub Data and create custom apps in Bubble.
-
How to Import Data from SurveyMonkey into Google Sheets
Import SurveyMonkey into a Google spreadsheet that is automatically refreshed.
-
Build Apps with Live Cassandra Data Using the Low-Code Development Platform of Mendix
Connect Apache Cassandra with Mendix to build apps using the CData JDBC Driver for Cassandra.
-
Create SSAS Tabular Models from Impala Data
How to build a SQL Server Analysis Service Tabular Model from Apache Impala using CData drivers.
-
Deploy the ADO.NET Provider for MailerLite on an SSRS Report Server
Connect to MailerLite 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.
-
Connect to Slack from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Slack, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Parallel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Parallel and build web apps with connectivity to live Parallel.
-
Analyze Oracle HCM Cloud Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle HCM Cloud and visualize live Oracle HCM Cloud in Infragistics Reveal.
-
Getting Started with the CData Python Connector for Quickbase
Learn to install and license the CData Python Connector
-
View Reports on Real-Time OData Services in Power BI Report Server
Use the CData ODBC Driver for OData to visualize OData in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Agno to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Add MongoDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MongoDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Build an ETL App for Odoo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Odoo ERP in Python with petl and the CData Connect AI Python SDK.
-
Connect to and Visualize Live Parquet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Parquet.
-
Access ZohoDesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoDesk from HeidiSQL.
-
How to integrate Gumroad with Apache Airflow
Access and process Gumroad in Apache Airflow using the CData JDBC Driver.
-
Viewing ScrapingBee Data in RAD Studio Data Explorer
How to view ScrapingBee in RAD Studio Data Explorer using the CData ODBC Driver for ScrapingBee.
-
Connect to Google Tasks Data in Aqua Data Studio
Access Google Tasks from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Lakebase Data Replication to SAP HANA
Use CData Sync to customize and automate Lakebase replication to SAP HANA.
-
Connect to ElevenLabs Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ElevenLabs in the Denodo Virtual DataPort Administrator.
-
Create CouchDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to CouchDB Data from OutSystems and build custom enterprise apps using live Apache CouchDB.
-
Connect to Teamwork Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Teamwork and the SQL Gateway to access Teamwork from Google Apps Script.
-
How to publish and share SFTP Data dashboards with Tableau Server
The CData ODBC driver for SFTP enables you integrate SFTP into Tableau dashboards.
-
Create Apps from NetSuite SuiteAnalytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data and build apps from live NetSuite SuiteAnalytics in Qlik Sense Cloud.
-
Integrating Codex CLI with Drip 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.
-
Use the CData Software ODBC Driver for CouchDB in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache CouchDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CouchDB.
-
How to publish and share SuiteCRM Data dashboards with Tableau Server
The CData ODBC driver for SuiteCRM enables you integrate SuiteCRM into Tableau dashboards.
-
Integrate with Azure Analysis Services Data in JReport Designer
Create charts and reports based on Azure Analysis Services in JReport Designer.
-
Migrating data from Simplesat to Snowflake using CData SSIS Components.
Easily push Simplesat to Snowflake using the CData SSIS Tasks for Simplesat and Snowflake.
-
Use Manus AI to Talk to Your Kintone 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 Kintone.
-
Integrate with live Sybase IQ Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sybase IQ in Jitterbit.
-
Connect to ZohoInvoice Data in RazorSQL
Connect to ZohoInvoice from wizards and query ZohoInvoice from the GUI in the RazorSQL database management tool.
-
Access Live Airtable Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Airtable into the statistical analysis tools available in SAS JMP. This article shows how to use Airtable in the Graph Builder and Query Builder.
-
Design BIRT Reports on Microsoft Ads Data
Provide current Microsoft Ads to your embedded analytics.
-
DataBind Controls to Confluence Data in C++Builder
DataBind to Atlassian Confluence in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access Presto Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Presto.
-
How to import Pipeline CRM Data into Apache Solr
Use the CData Software JDBC Driver for Pipeline CRM in Data Import Handler and create an automated import of Pipeline CRM to Apache Solr Enterprise Search platform.
-
Automated Continuous Billsby Replication to Snowflake
Use CData Sync for automated, continuous, customizable Billsby replication to Snowflake.
-
How to use SQLAlchemy ORM to access CapsuleCRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of CapsuleCRM.
-
Getting Started with the CData Tableau Connector for Bright Data
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Google Calendar-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Calendar Data and create custom apps in Mendix.
-
Automated Continuous xBase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable xBase replication to AlloyDB.
-
Replicate Google Directory Data from PowerShell
Write a quick PowerShell script to query Google Directory. Use connectivity to the live data to replicate Google Directory to SQL Server.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through OData
Integrate Dynamics 365 Business Central into dashboards in TIBCO Spotfire.
-
Connect to SendPulse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SendPulse.
-
Getting Started with the CData Python Connector for Parquet
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Sybase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Parallel Data in HULFT Integrate
Connect to Parallel as a JDBC data source in HULFT Integrate
-
Pipedrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Pipedrive through CData Connect AI using different applications and tools.
-
Connect to Microsoft OneDrive Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft OneDrive and the Script function in FileMaker Pro to connect to Microsoft OneDrive and work with Microsoft OneDrive in your FileMaker application.
-
Access Printful 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 Printful.
-
Troubleshooting Column Size Restrictions in Microsoft Query
Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.
-
How to Connect to & Open Onfleet Data in Microsoft Excel
This article uses the CData ODBC driver for Onfleet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect Oracle Sales 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 Oracle Sales data in real time using natural language.
-
Build Visualizations of Cvent Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cvent in Birst.
-
Build Apps with Live Invoiced Data Using the Low-Code Development Platform of Mendix
Connect Invoiced with Mendix to build apps using the CData API Driver for JDBC.
-
Create SSAS Tabular Models from SAP ByDesign Data
How to build a SQL Server Analysis Service Tabular Model from SAP Business ByDesign using CData drivers.
-
Integrate LinkedIn Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn Ads and integrate live LinkedIn Ads into your Power Automate tasks.
-
Analyze Freshdesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshdesk and visualize Freshdesk in SAP Analytics Cloud.
-
Integrate Goose with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Netweaver Gateway from within the local AI agent.
-
How to Connect to Google Calendar Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Calendar. Leverage the pyodbc module for ODBC in Python.
-
Connect to CockroachDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CockroachDB Data and connect to CockroachDB in Akorbi Digital RunMyProcess.
-
Use Dash to Build Web Apps on Odoo Data via CData Connect AI
Build interactive Dash web apps on live Odoo ERP using pandas and the CData Connect AI Python SDK.
-
Create SSAS Tabular Models from Highrise Data
How to build a SQL Server Analysis Service Tabular Model from Highrise CRM using CData drivers.
-
How to use SQLAlchemy ORM to access Azure DevOps Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure DevOps.
-
How to connect PolyBase to FTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FTP Servers.
-
Model, Search, and Visualize Live SurveyMonkey Data in ThoughtSpot
Use CData Connect AI to connect to live SurveyMonkey for modeling, searching, and visualizing.
-
Connect to Salesforce Data 360 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Data 360 as an External Source in Dremio.
-
How to Build an ETL App for Avalara AvaTax Data in Python with CData
Create ETL applications and real-time data pipelines for Avalara AvaTax in Python with petl.
-
How to import Bannerbear Data into Apache Solr
Use the CData Software JDBC Driver for Bannerbear in Data Import Handler and create an automated import of Bannerbear to Apache Solr Enterprise Search platform.
-
Create AlloyDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to AlloyDB Data from OutSystems and build custom enterprise apps using live Google AlloyDB.
-
Visualize Marketo Data in Tableau
The CData ODBC driver for Marketo enables you integrate Marketo into Tableau dashboards.
-
Integrating LangGraph with Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Elasticsearch within automated workflows.
-
Automated Continuous Dynamics NAV Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Apache Cassandra.
-
Connect to LDAP Objects from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LDAP to connect to LDAP and execute queries in PowerBuilder.
-
How to Query Live HubDB Data in Perplexity MacOS Desktop
Connect to and query live HubDB Data in Perplexity Desktop using CData MCP Server.
-
How to Query Microsoft Ads Data in MySQL Workbench
Execute MySQL queries against live Microsoft Ads from MySQL Workbench.
-
Automated Continuous Google Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Analytics replication to MongoDB.
-
Connect to Real-Time Mistral AI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mistral AI in Power Apps.
-
Create Power BI Reports on Real-Time ServiceNow Data
Use the CData ODBC Driver for ServiceNow to visualize ServiceNow in Power BI Desktop.
-
How to Query LeadDesk Data in MySQL Workbench
Execute MySQL queries against live LeadDesk from MySQL Workbench.
-
Automate IBM Cloud Object Storage Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Cassandra Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cassandra from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Apps with Live Testmonitor Data Using the Low-Code Development Platform of Mendix
Connect Testmonitor with Mendix to build apps using the CData API Driver for JDBC.
-
Build AI Agents with Monday.com Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Monday.com through CData Connect AI.