CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Outreach.io to Power BI dashboards. Simply drag and drop Outreach.io into data visuals on the Power BI canvas.
-
Connect to Cosmos DB Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure Cosmos DB from HeidiSQL.
-
Build eBay Analytics-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for eBay Analytics to explore live eBay Analytics Data in Gemini Code Assist to assist with building eBay Analytics-powered applications.
-
How to Access Microsoft Ads Data Using Entity Framework
This article shows how to access Microsoft Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Pipeliner CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipeliner CRM from Power Pivot. You will use the Table Import Wizard to load Pipeliner CRM. You can visually build the import query or use any SQL supported by the driver.
-
Build Automated SharePoint-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft SharePoint and build automated workflows in Zapier.
-
Visualize Microsoft Ads 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 Microsoft Ads into TIBCO Spotfire.
-
How to Query Live PivotalTracker Data in Perplexity MacOS Desktop
Connect to and query live PivotalTracker Data in Perplexity Desktop using CData MCP Server.
-
Create Discourse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Discourse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Rebilly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rebilly.
-
Connect to Accelo Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Accelo and work with Accelo in your FileMaker application.
-
Integrate with ZarMoney Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZarMoney to a JSON file on disk.
-
How to Work with HubDB Data in ETL Validator JDBC
Connect to HubDB from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with Shopify Data in AWS Glue Jobs Using JDBC
Connect to Shopify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to MailerLite Data with Squirrel SQL client
Connect to MailerLite and execute queries in the Squirrel SQL Client.
-
Build Apps with Live Bannerbear Data Using the Low-Code Development Platform of Mendix
Connect Bannerbear with Mendix to build apps using the CData API Driver for JDBC.
-
Use Microsoft Copilot Studio to talk to your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Monday.com for you.
-
How to Connect to Live SAP SuccessFactors LMS Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP SuccessFactors LMS securely in real time.
-
Rapidly Develop Intercom-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 Intercom.
-
Query ZohoDesk Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoDesk.
-
Access Live Google Drive Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Drive through MCP integration.
-
Access SurveyMonkey Data from MySQL in Amazon QuickSight
Connect to SurveyMonkey and build visualizations of SurveyMonkey using a MySQL Connection in Amazon QuickSight.
-
Access Unbounce Data from MySQL in Amazon QuickSight
Connect to Unbounce and build visualizations of Unbounce using a MySQL Connection in Amazon QuickSight.
-
Rapidly Develop CapsuleCRM-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 CapsuleCRM.
-
Analyze Zoho Creator Data in Looker
Use CData Connect AI to connect to Zoho Creator Data from Looker and build custom apps using live Zoho Creator.
-
Use Biml to Build SSIS Tasks to Replicate Excel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Excel to SQL Server.
-
Connect to Testmonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Testmonitor as an External Source in Dremio.
-
Viewing MailerSend Data in RAD Studio Data Explorer
How to view MailerSend in RAD Studio Data Explorer using the CData ODBC Driver for MailerSend.
-
A PostgreSQL Interface for Apify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Apify JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Printify Data in MySQL Workbench
Execute MySQL queries against live Printify from MySQL Workbench.
-
Replicate Multiple Timely Accounts
Replicate multiple Timely accounts to one or many databases.
-
Access Rootly Data from MySQL in PHP
Connect to Rootly through the standard MySQL libraries in PHP.
-
Build Dashboards with CircleCI Data in DBxtra
Create dynamic dashboards and perform analytics based on CircleCI in DBxtra.
-
How to connect SharePoint with MySQL Data through external lists
Provide MySQL to SharePoint users as an external list.
-
Build Freshteam-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshteam.
-
Build an OLAP Cube in SSAS from FTP Data
Establish a connection to FTP Servers data from SQL Server Analysis Services, and use the FTP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live EnterpriseDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to EnterpriseDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live EnterpriseDB.
-
Publish Miro-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Miro.
-
Use the CData Software ODBC Driver for Slack in MicroStrategy Web
Connect to Slack in MicroStrategy Web using the CData Software ODBC Driver for Slack.
-
Analyze Microsoft Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Ads with the CData JDBC Driver for Microsoft Ads.
-
Access Samanage Data from MySQL in Amazon QuickSight
Connect to Samanage and build visualizations of Samanage using a MySQL Connection in Amazon QuickSight.
-
Integrate Open WebUI with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Financials Cloud from within the chat interface.
-
Connect Excel to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel with IBM WebSphere for seamless data integration and connectivity.
-
Replicate PagerDuty Data to Multiple Databases via the CData Sync CLI
Replicate PagerDuty to disparate databases with a single configuration.
-
Consume Couchbase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Couchbase feeds that reflect any changes in SAP Lumira.
-
Build an OLAP Cube in SSAS from CapsuleCRM Data
Establish a connection to CapsuleCRM data from SQL Server Analysis Services, and use the CapsuleCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Provide OData Services of Act-On Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Act-On by developing a WCF Service Application.
-
Connect to Avalara AvaTax Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Avalara and the Script function in FileMaker Pro to connect to Avalara AvaTax and work with Avalara AvaTax in your FileMaker application.
-
Getting Started with the CData Python Connector for ZohoMarketingHub
Learn to install and license the CData Python Connector
-
Create a Data Access Object for Strava Data using JDBI
A brief overview of creating a SQL Object API for Strava in JDBI.
-
Automated Continuous Salesforce CRM Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Vertica.
-
Integrating Antigravity CLI with Missive via CData CLI
Connect Missive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to publish and share Clio Data dashboards with Tableau Server
The CData ODBC driver for Clio enables you integrate Clio into Tableau dashboards.
-
Integrate Live Factorial Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Factorial to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live ChargeOver Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ChargeOver to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Work with ZohoDesk Data in ETL Validator JDBC
Connect to ZohoDesk from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Access Live AdRoll Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live AdRoll from the Cline extension in Visual Studio Code.
-
Automated Continuous SageHR Replication to Databricks
Use CData Sync for automated, continuous, customizable SageHR replication to Databricks.
-
Create Reports from CSV Data in Looker Studio
Use CData Connect AI to gain access to live CSV/TSV Files and create custom reports in Looker Studio.
-
Analyze Miro Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Miro in Microsoft R Open.
-
Integrate BigQuery Data into Power Automate Desktop using CData Connect
CData Connect for BigQuery Data enables you to integrate Google BigQuery into workflows built using Microsoft Power Automate Desktop.
-
Consume Billsby OData Feeds in PowerBuilder
This article demonstrates how to consume Billsby as OData feeds from PowerBuilder using the API Server.
-
Build a Singer.io Tap for Smartsheet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Smartsheet data using
-
Build Dashboards with Shopify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shopify in Dundas BI.
-
Using the CData Software ODBC Driver for Intercom in PyCharm
Connect to Intercom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Intercom.
-
Analyze ZohoMarketingHub Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoMarketingHub in Microsoft R Open.
-
Connect to and Visualize Live Todoist Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Todoist.
-
Automated Continuous FreshBooks Replication to Vertica
Use CData Sync for automated, continuous, customizable FreshBooks replication to Vertica.
-
Connect to Cosmos DB Data in HULFT Integrate
Connect to Cosmos DB as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Bullhorn CRM for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Perigon
Provide connectivity to Perigon through an SAP BusinessObjects universe.
-
Build Automated Workflows with Live Zuora Data in Workato
Use CData Connect AI to connect to live Zuora and build automated workflows in Workato.
-
Visualize FreshBooks Data in TIBCO Spotfire through OData
Integrate FreshBooks into dashboards in TIBCO Spotfire.
-
Access Live Zoho Inventory Data in Excel 365 Online (Excel for the web)
Connect to Zoho Inventory from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Query Live Sage 200 Data in Perplexity MacOS Desktop
Connect to and query live Sage 200 Data in Perplexity Desktop using CData MCP Server.
-
Integrating Cursor CLI with Azure Synapse 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.
-
Access Live Reckon Data in AWS Lambda
Connect to live Reckon in AWS Lambda using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Egnyte
Create Egnyte data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bind Live Lakebase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Lakebase data
-
How to Visualize Email Data in Python with pandas
Use pandas and other modules to analyze and visualize live Email in Python.
-
Import and Visualize Bugsnag Data in Power View
Create data visualizations based on Bugsnag in Excel.
-
How to Import Data from Apify into Google Sheets
Import Apify into a Google spreadsheet that is automatically refreshed.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Telegram
Provide connectivity to Telegram through an SAP BusinessObjects universe.
-
Rapidly Develop Webflow-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 Webflow.
-
Create IBM Informix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to IBM Informix Data from OutSystems and build custom enterprise apps using live IBM Informix.
-
Connect to SAS Data Sets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAS Data Sets.
-
Connect to Nethunt Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Nethunt using standard SQL.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Web
Connect to Oracle HCM Cloud in MicroStrategy Web using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Integrate Box Data into Power Automate Desktop using CData Connect
CData Connect for Box Data enables you to integrate Box into workflows built using Microsoft Power Automate Desktop.
-
Excel Spreadsheet Automation on SAP Business Warehouse Data with the QUERY Formula
Pull data from SAP Business Warehouse, automate spreadsheets, and more with the QUERY formula.
-
Connect to Real-Time SAP Netweaver Gateway Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Netweaver Gateway and Dataflow to import and use SAP Netweaver Gateway in Power Apps.
-
Connect to CSV 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 CSV/TSV Files.
-
Integrate with ActiveCampaign Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ActiveCampaign to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Analytics.
-
Publish Crystal Reports on Helpscout Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Helpscout.
-
View Reports on Real-Time Clari Data in Power BI Report Server
Use the CData ODBC Driver for Clari to visualize Clari in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Webex Data in DataGrip
Create a Data Source for Webex in DataGrip and use SQL to query live Webex.
-
Consume Cvent OData Feeds in PowerBuilder
This article demonstrates how to consume Cvent as OData feeds from PowerBuilder using the API Server.
-
Create SSAS Tabular Models from SharePoint Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft SharePoint using CData drivers.
-
Integrating Codex CLI with Microsoft Ads 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.