CData Software - Knowledge Base
Recent Articles
-
Create Supabase-Connected Applications in Appsmith
Connect to Supabase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Supabase data.
-
Getting Started with the CData ADO.NET Provider for Pinecone
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData ODBC Driver for Pinterest in Microsoft Power Query
You can use the CData Pinterest ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinterest data into Microsoft Power Query.
-
How to Connect the Power BI Service to GetResponse: Complete Guide
Connect to the CData Software Power BI Connector for GetResponse from PowerBI.com to provide real-time GetResponse data across the organization.
-
Build Pipelines with Live Quickbase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Quickbase from Google Cloud Data Fusion, enabling the integration of live Quickbase data into the building and management of effective data pipelines.
-
How to Connect to Live VWO Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your VWO data for you.
-
Connect to LinkedIn Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live LinkedIn Ads data from Filemaker Pro on Mac.
-
Create Datasets from Wrike in Domo Workbench and Build Visualizations of Wrike Data in Domo
Use the CData Software ODBC Driver for Wrike to create datasets from Wrike data in Domo Workbench and then build visualizations in the Domo service.
-
Query Notion Data as a MySQL Database in Node.js
Execute MySQL queries against Notion data from Node.js.
-
How to Use a Microsoft Access Database to Update Office 365 Data in Real Time
Update Office 365 data by creating a linked table in Microsoft Access with the CData Office 365 ODBC Driver.
-
Integrating GitHub Copilot with Bannerbear 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.
-
Use the CData ODBC Driver for Freshsales in Microsoft Power Query
You can use the CData Freshsales ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshsales data into Microsoft Power Query.
-
Automated Continuous Paylocity Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Paylocity replication to Apache Kafka.
-
Import Real-Time Act-On Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Act-On data in ColdFusion.
-
Build an OLAP Cube in SSAS from ServiceNow Data
Establish a connection to ServiceNow data data from SQL Server Analysis Services, and use the ServiceNow Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Toggl Data Replication to Azure Data Lake
Use CData Sync to customize and automate Toggl data replication to Azure Data Lake.
-
Build Teradata-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Teradata data without replication.
-
How to Work with Amazon S3 Data in ETL Validator JDBC
Connect to Amazon S3 from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Keap Data in HULFT Integrate
Connect to Keap as a JDBC data source in HULFT Integrate
-
Integrate with Workday Data in JReport Designer
Create charts and reports based on Workday data in JReport Designer.
-
Integrate with CloudConvert Data in JReport Designer
Create charts and reports based on CloudConvert data in JReport Designer.
-
Integrate Trae with Live ZohoPeople Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoPeople data from within the AI-powered IDE.
-
Build Supabase-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Supabase data without replication.
-
Connect and Visualize Live DocuSign Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live DocuSign data into the Databricks platform and create visualization dashboards with real-time DocuSign data.
-
Use Microsoft Copilot Studio to talk to your Google Cloud Storage 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 Google Cloud Storage data for you.
-
Connect and Query Live Quickbase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Quickbase data into Databricks and enable direct, live querying and analysis without replication.
-
Integrating Codex with Spotify 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 Google Spanner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Spanner data.
-
Creating ZohoExpense-Connected Applications in Unqork
You can use CData Connect AI to feed ZohoExpense data to Unqork and build custom business apps.
-
Connect to Databricks Data in JRuby
Create a simple JRuby app with access to live Databricks data.
-
How to connect SharePoint with SAS xpt Data through external lists
Provide SAS xpt data to SharePoint users as an external list.
-
Automated ConvertKit Data Replication to Teradata
Use CData Sync to Customize and automate ConvertKit data replication to Teradata.
-
Build Dashboards with Oracle Eloqua Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Eloqua data in Dundas BI.
-
Replicate Workday Data to Multiple Databases
Replicate Workday data to disparate databases with a point-and-click configuration.
-
Create CampaignMonitor Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CampaignMonitor from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Typeform Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Typeform data from PowerShell? This article demonstrates how to utilize the Typeform Cmdlets for tasks like connecting to Typeform data, automating operations, downloading data, and more.
-
Integrating LangChain with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Reckon Accounts Hosted data within automated workflows.
-
Create Power BI Reports on Real-Time Cassandra Data
Use the CData ODBC Driver for Cassandra to visualize Cassandra data in Power BI Desktop.
-
How to Connect to Live Cloudant Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Cloudant data securely in real time.
-
Connect to SAP Fieldglass Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Fieldglass data using standard SQL.
-
Use Claude to Talk to Your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Azure Data Lake Storage data for you.
-
Create Dynamic IBM Cloud Object Storage Grids Using the Infragistics XamDataGrid
Learn how you can connect IBM Cloud Object Storage to Infragistics XamDataGrid to build dynamic grids.
-
Back Up Salesforce Pardot data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Pardot. In this article, we will employ an SSIS workflow to populate a database with Salesforce Pardot data data.
-
Automated Continuous Microsoft OneLake Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to IBM DB2.
-
Connect Keap Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Keap data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Adobe Commerce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce data and execute queries in PowerBuilder.
-
How to Visualize Presto Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Presto data in Python.
-
Create Reports with QuickBooks Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Online data.
-
Use ChatGPT to Talk to Your Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Dataverse data for you.
-
Access Live SAP Data in AWS Lambda
Connect to live SAP data in AWS Lambda using the CData JDBC Driver.
-
Connect to Snowflake from a Connection Pool in WebLogic
Use the CData JDBC Driver for Snowflake to connect to Snowflake data from Web applications running on WebLogic.
-
Getting Started with the CData Connect AI Python SDK for Lakebase
Install the CData Connect AI Python SDK to read and write live Lakebase data with standard DB-API 2.0 Python code.
-
Connect to Basecamp Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Basecamp and the Script function in FileMaker Pro to connect to Basecamp and work with Basecamp data in your FileMaker application.
-
Create SSAS Tabular Models from Grafana Data
How to build a SQL Server Analysis Service Tabular Model from Grafana data using CData drivers.
-
Connect to PayPal Data from a Connection Pool in Jetty
The PayPal JDBC Driver supports connection pooling: This article shows how to connect faster to PayPal data from Web apps in Jetty.
-
Connect to Facebook Ads Data in ACL Analytics
Connect to Facebook Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Facebook Ads data.
-
How to Seamlessly Import YouTube Analytics Data into IBM SPSS Modeler
Integrate YouTube Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Cosmos DB Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Snowflake.
-
Working with MailerSend Data in LINQPad
Execute LINQ queries to MailerSend data in LINQPad.
-
Automate Insightly Data Replication to SAP HANA
Use CData Sync to customize and automate Insightly data replication to SAP HANA.
-
Seamlessly Bring PingOne Data into Retool Using CData Connect AI
Integrate PingOne data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Azure DevOps Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Snowflake.
-
How to connect to Zoom Data from Spring Boot
Connect to Zoom in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate SFTP Data in the Pentaho Report Designer
Publish reports based on SFTP data in the Pentaho BI tool.
-
Natively Connect to Zoho Books Data in PHP
The CData ODBC driver for Zoho Books enables you to create PHP applications with connectivity to Zoho Books data. Leverage the native support for ODBC in PHP.
-
Automated Continuous MongoDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MongoDB data replication to OneLake in Microsoft Fabric.
-
Connect to MariaDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live MariaDB data from Filemaker Pro on Mac.
-
Visualize Teamwork Data in Sisense
Create an ElastiCube in Sisense app with access to Teamwork data.
-
Getting Started with the CData Power BI Connector for Insightly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Real-Time Access to Twitter Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Twitter Ads data in real time.
-
Use Microsoft Copilot Studio to talk to your Facebook Ads 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 Facebook Ads data for you.
-
Build an OLAP Cube in SSAS from SendPulse Data
Establish a connection to SendPulse data data from SQL Server Analysis Services, and use the SendPulse Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Build an ETL App for FHIR Data in Python with CData Connect AI
Extract and transform live FHIR data in Python with petl and the CData Connect AI Python SDK.
-
Integrating LangChain with Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Kintone data within automated workflows.
-
Validate SuiteCRM Data with QuerySurge
Access and validate SuiteCRM data in QuerySurge using the CData JDBC Driver.
-
Integrate AlloyDB Data into Power Automate Desktop using CData Connect
CData Connect for AlloyDB Data enables you to integrate AlloyDB data into workflows built using Microsoft Power Automate Desktop.
-
Automate Parquet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Parquet data replication to Azure Data Lake.
-
Connect to Real-Time MailChimp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MailChimp and Dataflow to import and use MailChimp data in Power Apps.
-
How to Seamlessly Import Wave Financial Data into IBM SPSS Modeler
Integrate Wave Financial data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Acumatica Data in Excel 365 Online (Excel for the web)
Connect to Acumatica data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live OnePageCrm Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OnePageCrm data into the statistical analysis tools available in SAS JMP. This article shows how to use OnePageCrm data in the Graph Builder and Query Builder.
-
Build ADP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ADP data.
-
How to Access PostgreSQL Through an SSH Server (No PuTTY Required): CData PostgreSQL ODBC Driver
Learn how to connect securely to PostgreSQL (e.g., AWS RDS) via an SSH server using the CData PostgreSQL ODBC Driver — no PuTTY or manual port forwarding required.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy
Connect to SAS xpt data in MicroStrategy Developer using the CData Software ODBC Driver for SAS xpt.
-
Connect to Live RSS Feeds in MicroStrategy through CData Connect AI
Create a live connection to RSS Feeds in CData Connect AI and connect to your RSS feeds from MicroStrategy.
-
How to publish and share Planio Data dashboards with Tableau Server
The CData ODBC driver for Planio enables you integrate Planio data into Tableau dashboards.
-
Build Tally-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Tally Data and create custom apps in Bubble.
-
Natively Connect to Klaviyo Data in PHP
The CData ODBC driver for Klaviyo enables you to create PHP applications with connectivity to Klaviyo data. Leverage the native support for ODBC in PHP.
-
Connect to ZohoExpense Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoExpense data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Trigger Microsoft Entra ID IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Entra ID with standard wizards in Logic Apps.
-
Automated Continuous Sybase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sybase replication to Azure SQL Database.
-
Query Live Splunk Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Splunk data directly from the development environment.
-
Visualize Live Marketo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Marketo data.
-
Integrate ZarMoney Data in Pentaho Data Integration
Build ETL pipelines based on ZarMoney data in the Pentaho Data Integration tool.
-
Consume Kafka OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Kafka feeds that reflect any changes in SAP Lumira.
-
Using the CData Software ODBC Driver for FreshBooks in PyCharm
Connect to FreshBooks as an ODBC data source in PyCharm using the CData Software ODBC Driver for FreshBooks.
-
Integrating GitHub Copilot with Opsgenie 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 ClickUp 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 ClickUp data.
-
Analyze Sendwithus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sendwithus from Power Pivot. You will use the Table Import Wizard to load Sendwithus data. You can visually build the import query or use any SQL supported by the driver.
-
Link Teamgate with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Teamgate data in Filemaker Pro for Mac or Windows.