CData Software - Knowledge Base
Recent Articles
-
Connect to Suadeo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Suadeo data in Google Apps Script.
-
Deploy the ADO.NET Provider for Planio on an SSRS Report Server
Connect to Planio data 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 data into a data warehouse using Oracle Data Integrator.
-
Use CData Connect AI to Access ZohoInvoice Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ZohoInvoice data in the Power Pivot business intelligence tool.
-
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 data.
-
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 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 data and execute queries in PowerBuilder.
-
How to Connect to Live Freshteam Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshteam data securely in real time.
-
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 and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
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 Confluence data 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 data.
-
How to integrate Metabase with Teradata Data
Use CData Connect AI to connect to live Teradata data and create an interactive dashboard in Metabase from Teradata data.
-
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 data 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 data 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.
-
Prepare, Blend, and Analyze SAP Ariba Source Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Ariba Source data for self-service data analytics.
-
Automated Continuous Hugging Face Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hugging Face replication to PostgreSQL.
-
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 data 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 Cloud Accounting data 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 data in DBxtra.
-
Easily Integrate Workday Data in Lazarus Pascal IDE
Learn how to easily integrate live Workday data 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 Cosmos DB data data source in TIBCO Data Virtualization Studio and gain access to live Cosmos DB data 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.
-
Creating Workday-Connected Applications in Unqork
You can use CData Connect AI to feed Workday data to Unqork and build custom business apps.
-
Integrate Dify with Live Figshare 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 Figshare data.
-
Analyze PayPal Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of PayPal data and visualize PayPal data 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 data in Power BI.
-
Create Power BI Reports on Real-Time ChargeOver Data
Use the CData ODBC Driver for ChargeOver to visualize ChargeOver data in Power BI Desktop.
-
Use Microsoft Copilot Studio to talk to your Samanage 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 Samanage data for you.
-
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 Parquet data in your FileMaker application.
-
Analyze Salesloft Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesloft data and visualize Salesloft data in SAP Analytics Cloud.
-
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 data. 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 Cloudant data into the Databricks platform and create visualization dashboards with real-time Cloudant data.
-
Visualize Outreach.io Data in Sisense
Create an ElastiCube in Sisense app with access to Outreach.io data.
-
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 data.
-
Create Sendwithus-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Sendwithus Data from Klipfolio and build custom visualizations using live Sendwithus data.
-
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 data 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 data 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 data and integrate live WordPress data 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 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Bitbucket Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Bitbucket data and visualize live Bitbucket data in Infragistics Reveal.
-
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 data securely in real time.
-
Integrating GitHub Copilot with Supabase 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.
-
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 SageHR Data from Crystal Reports
Use CData Connect AI to connect to and report on live SageHR data from Crystal Reports.
-
Connect to SAP ByDesign Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP ByDesign data 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 data 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 data.
-
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 data 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 data.
-
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 data by developing a WCF Service Application.
-
Connect to Coda Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Coda data.
-
Migrating data from Jodoo to Google BigQuery using CData SSIS Components.
Easily push Jodoo data 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 data using CData drivers.
-
Connect to BigCommerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BigCommerce data 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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ClickUp data in Excel.
-
Connect to Outlook Data in RapidMiner
Integrate Outlook data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Hubstaff Data in the Pentaho Report Designer
Publish reports based on Hubstaff data in the Pentaho BI tool.
-
Use Agno to Talk to Your Sendwithus 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 Sendwithus data for you.
-
Create Dashboards and Visualize Live Moosend Data in Geckoboard
Use CData Connect AI to connect to live Moosend data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
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 data from Node.js.
-
Access Live DocuSign Data in AWS Lambda (with IntelliJ IDEA)
Connect to live DocuSign data 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 data across the organization.
-
Connect to Invoiced Data from a Connection Pool in JBoss
Integrate Invoiced data 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 data into Microsoft Power Query.
-
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 data 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 data from Node.js.
-
Migrating data from ElevenLabs to Snowflake using CData SSIS Components.
Easily push ElevenLabs data to Snowflake using the CData SSIS Tasks for ElevenLabs and Snowflake.
-
Build Pipelines with Live SAP HANA XS Advanced Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA XS Advanced from Google Cloud Data Fusion, enabling the integration of live SAP HANA XS Advanced data into the building and management of effective data pipelines.
-
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 data 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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Ads data 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 data to a chart.
-
Connect and Query Live TaxJar Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live TaxJar data into Databricks and enable direct, live querying and analysis without replication.
-
Build Stripe Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Stripe data 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 data from your Excel spreadsheets.
-
Build Automated GitHub-Connected Workflows in Zapier
Use CData Connect AI to connect to live GitHub data and build automated workflows in Zapier.
-
Access Live ElevenLabs Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ElevenLabs data 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 data 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 data in Akorbi Digital RunMyProcess.
-
Connect to Google Ad Manager Data in Jaspersoft Studio
Execute SQL to remote Google Ad Manager data in Jaspersoft Studio.
-
Use CData Connect AI to Access HubDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live HubDB data in the Power Pivot business intelligence tool.