CData Software - Knowledge Base
Recent Articles
-
Create Presto-Connected Applications in Appsmith
Connect to Presto Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Presto.
-
Perform Batch Operations with SFTP Data in Apache NiFi
Connect to SFTP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Migrating data from Workable to Databricks using CData SSIS Components.
Easily push Workable to Databricks using the CData SSIS Tasks for Workable and Databricks.
-
Automated Continuous Marketo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Marketo replication to Amazon S3.
-
Deploy the ADO.NET Provider for Planio on an SSRS Report Server
Connect to Planio 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.
-
ETL Apollo in Oracle Data Integrator
This article shows how to transfer Apollo into a data warehouse using Oracle Data Integrator.
-
Seamlessly Bring WooCommerce Data into Retool Using CData Connect AI
Integrate WooCommerce data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Operational Reporting on Couchbase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Couchbase.
-
Build Apollo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Apollo Data and create custom apps in Mendix.
-
Integrating Cursor CLI with Stripe 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 Avaza Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avaza to connect to Avaza and execute queries in PowerBuilder.
-
Connect to Hacker News from Asprova with CData Software ODBC Driver for Hacker News
This article shows how to connect faster to Hacker News data from Asprova.
-
Rapidly Develop Supabase-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 Supabase.
-
Bind Live Access Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Access data
-
Add JotForm Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JotForm with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live Confluence 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 Atlassian Confluence for you.
-
Integrate Live SingleStore Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SingleStore from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SingleStore.
-
Connect to Real-Time Apify Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Apify in Power Apps.
-
How to create Opsgenie federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Opsgenie in MySQL .
-
Getting Started with the CData JDBC Driver for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ElevenLabs.
-
How to Query Live AlloyDB Data in Perplexity MacOS Desktop
Connect to and query live AlloyDB Data in Perplexity Desktop using CData MCP Server.
-
Prepare, Blend, and Analyze SAP Ariba Source Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Ariba Source for self-service data analytics.
-
Connect to Live Asana Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Asana in CData Connect AI and connect to your Asana from PostgreSQL.
-
A PostgreSQL Interface for Quickbase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Quickbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Sage Cloud Accounting Data into FineReport
How to set Sage Business Cloud Accounting as a JDBC data source in FineReport.
-
How to work with MongoDB Data in Apache Spark using SQL
Access and process MongoDB Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Elasticsearch Data in DBxtra
Create dynamic dashboards and perform analytics based on Elasticsearch in DBxtra.
-
Easily Integrate Workday Data in Lazarus Pascal IDE
Learn how to easily integrate live Workday in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous CampaignMonitor Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Kafka.
-
Getting Started with the CData Excel Add-In for AdRoll
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AdRoll.
-
Access Live Cosmos DB Data in TIBCO Data Virtualization
Use the Cosmos DB Tibco DV Adapter to create a Azure Cosmos DB data source in TIBCO Data Virtualization Studio and gain access to live Azure Cosmos DB from your TDV Server.
-
Build AI/ML Models with Live Workable Data using Dataiku
Connect Workable Data with Dataiku using the CData API Driver for JDBC.
-
Build Paylocity-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Paylocity to explore live Paylocity Data in Claude Code to assist with building Paylocity-powered applications.
-
Creating Workday-Connected Applications in Unqork
You can use CData Connect AI to feed Workday to Unqork and build custom business apps.
-
Analyze PayPal Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of PayPal and visualize PayPal in SAP Analytics Cloud.
-
How to Create Power BI Visual Reports with Real-Time Monday.com Data
Use CData Power BI Connectors to visualize Monday.com in Power BI.
-
Create Power BI Reports on Real-Time ChargeOver Data
Use the CData ODBC Driver for ChargeOver to visualize ChargeOver in Power BI Desktop.
-
Connect to Parquet Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Parquet and the Script function in FileMaker Pro to connect to Parquet and work with Apache Parquet in your FileMaker application.
-
Natively Connect to MYOB AccountRight Data in PHP
The CData ODBC driver for MYOB AccountRight enables you to create PHP applications with connectivity to MYOB AccountRight. Leverage the native support for ODBC in PHP.
-
Connect and Visualize Live Cloudant Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM Cloudant into the Databricks platform and create visualization dashboards with real-time IBM Cloudant.
-
Build a Singer.io Tap for LionDesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LionDesk data using
-
Visualize Outreach.io Data in Sisense
Create an ElastiCube in Sisense app with access to Outreach.io.
-
Build Semantic Layer Views for Microsoft Exchange Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Exchange in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Exchange.
-
Moving Data from Dynamics CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Dynamics CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Access Lakebase Data Using Entity Framework
This article shows how to access Lakebase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Azure Data Lake Storage Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Data Lake Storage from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Data Lake Storage.
-
Integrate WordPress Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to WordPress and integrate live WordPress into your Power Automate tasks.
-
Automated Continuous Monday.com Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Monday.com replication to Apache Kafka.
-
Automated Continuous Paylocity Replication to MySQL
Use CData Sync for automated, continuous, customizable Paylocity replication to MySQL.
-
Access Live Xero Data in Coginiti Pro
Connect to and query live Xero Accounting from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Snowflake Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Snowflake securely in real time.
-
Integrating GitHub Copilot CLI with Supabase 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.
-
LINQ to Clio Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Clio Data Provider.
-
Connect to SAP ByDesign Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Business ByDesign from Filemaker Pro on Mac.
-
Import Real-Time FreeAgent Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FreeAgent in ColdFusion.
-
A PostgreSQL Interface for Certinia Data using the CData ODBC Driver
Use the SQL Gateway and Certinia ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live Google Translate Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Translate.
-
A PostgreSQL Interface for Cloudflare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudflare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search External Highrise Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Highrise CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Highrise Data objects that you can access from apps and the dashboard.
-
Create Zoho Books-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Books Data from Nintex Workflow Cloud and build custom workflows using live Zoho Books.
-
Provide OData Services of Adobe Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Adobe Analytics by developing a WCF Service Application.
-
Migrating data from Jodoo to Google BigQuery using CData SSIS Components.
Easily push Jodoo to Google BigQuery using the CData SSIS Tasks for Jodoo and Google BigQuery.
-
Create SSAS Tabular Models from Microsoft Dataverse Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Dataverse (CDS) using CData drivers.
-
Connect to BigCommerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BigCommerce from Filemaker Pro on Mac.
-
Use the CData ODBC Driver for ClickUp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ClickUp in Excel.
-
Connect to Outlook Data in RapidMiner
Integrate Outlook with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Hubstaff Data in the Pentaho Report Designer
Publish reports based on Hubstaff in the Pentaho BI tool.
-
Automated Continuous Grafana Replication to MySQL
Use CData Sync for automated, continuous, customizable Grafana replication to MySQL.
-
Query WooCommerce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against WooCommerce from Node.js.
-
Access Live DocuSign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live DocuSign in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect the Power BI Service to Zoho Projects: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Projects from PowerBI.com to provide real-time Zoho Projects across the organization.
-
Connect to Invoiced Data from a Connection Pool in JBoss
Integrate Invoiced into Java servlets: Use the Management Console in JBoss to install the Invoiced JDBC Driver.
-
Use the CData ODBC Driver for Strava in Microsoft Power Query
You can use the CData Strava ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Strava into Microsoft Power Query.
-
How to Query Live Blackbaud FE NXT Data in Perplexity MacOS Desktop
Connect to and query live Blackbaud FE NXT Data in Perplexity Desktop using CData MCP Server.
-
Build AI/ML Models with Live Trello Data using Dataiku
Connect Trello Data with Dataiku using the CData JDBC Driver for Trello.
-
Analyze Databricks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Databricks with the CData JDBC Driver for Databricks.
-
Create Dynamic Confluence Grids Using the Infragistics XamDataGrid
Learn how you can connect Confluence to Infragistics XamDataGrid to build dynamic grids.
-
Query ActiveCampaign Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ActiveCampaign from Node.js.
-
Migrating data from ElevenLabs to Snowflake using CData SSIS Components.
Easily push ElevenLabs to Snowflake using the CData SSIS Tasks for ElevenLabs and Snowflake.
-
Moving Data from NASA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live NASA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Real-Time Strava Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Strava in Power Apps.
-
Build MVC Applications with Connectivity to Google Drive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Drive from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Google Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Ads to connect to Google Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Ads in Excel.
-
DataBind Nethunt Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Nethunt to a chart.
-
Build Stripe Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Stripe and build visualizations in Tableau.
-
Access Live Klaviyo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Klaviyo from your Excel spreadsheets.
-
Build Automated GitHub-Connected Workflows in Zapier
Use CData Connect AI to connect to live GitHub and build automated workflows in Zapier.
-
Access Live ElevenLabs Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ElevenLabs in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Open WebUI with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ShipStation from within the chat interface.
-
Connect to Outreach.io Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Outreach.io Data and connect to Outreach.io in Akorbi Digital RunMyProcess.
-
Connect to Google Ad Manager Data in Jaspersoft Studio
Execute SQL to remote Google Ad Manager in Jaspersoft Studio.
-
Prepare, Blend, and Analyze Tavily Data in Alteryx Designer (ODBC)
Build workflows to access live Tavily for self-service data analytics.
-
Operational Reporting on Act-On Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Act-On.
-
Stream Tanda Data into Apache Kafka Topics
Access and stream Tanda in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Tickspot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Tickspot from Node.js.
-
How to Work with ChargeOver Data in ETL Validator JDBC
Connect to ChargeOver from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume QuickBooks Online OData Feeds in PowerBuilder
This article demonstrates how to consume QuickBooks Online as OData feeds from PowerBuilder using the API Server.
-
Connecting GenSpark with Oracle Eloqua Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Eloqua without any replication or custom integration required.
-
Build a Jira + Salesforce Unified Customer View with Cursor CLI and the CData CLI
Learn how to build a Java app that unifies Jira and Salesforce data into a single customer view using Cursor CLI and the CData CLI.
-
Connect to SingleStore in SpagoBI
Create reports featuring live SingleStore in SpagoBI Studio. Host SingleStore reports on SpagoBI Server.