CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Zoho Recruit Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Recruit to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Dify with Live SQL Server 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 SQL Server data.
-
Automated Continuous ClickUp Replication to Oracle
Use CData Sync for automated, continuous, customizable ClickUp replication to Oracle.
-
Visualize Scrapfly 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 Scrapfly data into TIBCO Spotfire.
-
Process & Analyze SFTP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SFTP Data.
-
Connect to Workday Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Workday to connect to Workday data and execute queries in PowerBuilder.
-
Replicate ChargeOver Data from PowerShell
Write a quick PowerShell script to query ChargeOver data. Use connectivity to the live data to replicate ChargeOver data to SQL Server.
-
Replicate Multiple Vercel Accounts via the CData Sync CLI
Replicate multiple Vercel accounts to one or many databases.
-
Connect to SAP Business Warehouse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Business Warehouse data.
-
How to load Grafana data into Elasticsearch via Logstash
Introducing a simple method to load Grafana data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to PDFMonkey Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PDFMonkey data in the Denodo Virtual DataPort Administrator.
-
Excel Spreadsheet Automation on DB2 Data with the QUERY Formula
Pull data from DB2, automate spreadsheets, and more with the QUERY formula.
-
Connect to SageHR Data in HULFT Integrate
Connect to SageHR as a JDBC data source in HULFT Integrate
-
Use Claude to Talk to Your SAS Data Sets 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 SAS Data Sets data for you.
-
Analyze Scrapfly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Scrapfly from Power Pivot. You will use the Table Import Wizard to load Scrapfly data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to ConstantContact Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ConstantContact data in Airbyte.
-
Natively Connect to Tally Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Tally data. Leverage the native support for ODBC in PHP.
-
DataBind Charts to FreshBooks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FreshBooks data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Vercel Data in Pentaho Data Integration
Build ETL pipelines based on Vercel data in the Pentaho Data Integration tool.
-
Prepare, Blend, and Analyze Microsoft Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Ads data for self-service data analytics.
-
Access Live Exa Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Exa data through MCP integration.
-
How to work with ZeroBounce Data in Apache Spark using SQL
Access and process ZeroBounce Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize PDFMonkey Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PDFMonkey data.
-
How to Access Google Calendar Data Using Entity Framework
This article shows how to access Google Calendar data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Google's Vertex AI Agent with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Financials Cloud data within intelligent workflows.
-
Query SAP SuccessFactors Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP SuccessFactors entities in PHP by modeling them as objects.
-
Build Automated Zoho Books-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho Books data and build automated workflows in Zapier.
-
Access Live Xero Data in Excel 365 Online (Excel for the web)
Connect to Xero data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Building Dynamic Web Pages with Hive Data Using AngularJS
Create single-page applications with live connectivity to Hive using the CData API Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Onfleet
Provide connectivity to Onfleet data through an SAP BusinessObjects universe.
-
Connect to Jodoo Data in Ruby
Connect to Jodoo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Access Teamgate Data Using Entity Framework
This article shows how to access Teamgate data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Templated Data in Coginiti Pro
Connect to and query live Templated data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Factorial Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Factorial replication to PostgreSQL.
-
Create Apps from SAP BusinessObjects BI Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP BusinessObjects BI Data and build apps from live SAP BusinessObjects BI data in Qlik Sense Cloud.
-
Access Live Mistral AI Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mistral AI data into the statistical analysis tools available in SAS JMP. This article shows how to use Mistral AI data in the Graph Builder and Query Builder.
-
Visualize Teradata Data in TIBCO Spotfire through OData
Integrate Teradata data into dashboards in TIBCO Spotfire.
-
Connect to Pipeline CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pipeline CRM data using standard SQL.
-
Build Voice Agents in ElevenLabs with access to Live Jira Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Jira data.
-
Automated Continuous Power BI XMLA Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to AlloyDB.
-
Use Agno to Talk to Your Spark 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 Spark data for you.
-
Connect to Jumpseller Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jumpseller to connect to Jumpseller data and execute queries in PowerBuilder.
-
Build Agents in Relevance AI with Access to Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Planner data within intelligent agent workflows.
-
Access Live PolarTeamPro Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live PolarTeamPro data through MCP integration.
-
Integrating Codex with Dotmailer 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.
-
Provide OData Services of Azure DevOps Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure DevOps data by developing a WCF Service Application.
-
Create SageHR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SageHR Data from OutSystems and build custom enterprise apps using live SageHR data.
-
Object-Relational Mapping (ORM) with Strava Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Strava data into a Java-based ORM framework, Hibernate.
-
Validate Samanage Data with QuerySurge
Access and validate Samanage data in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy Web
Connect to Azure Analysis Services data in MicroStrategy Web using the CData Software JDBC Driver for Azure Analysis Services.
-
Build LaunchDarkly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LaunchDarkly data and build web apps with connectivity to live LaunchDarkly data.
-
Integrating Cursor with SAP Fieldglass 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.
-
View Reports on Real-Time Microsoft Planner Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Planner to visualize Microsoft Planner data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Data Visualizations Based On ActiveCampaign Data in Mode
Use CData Connect AI to connect to ActiveCampaign Data from Mode and build visualizations using live ActiveCampaign data.
-
Integrate CSV Data into Power Automate Desktop using CData Connect
CData Connect for CSV Data enables you to integrate CSV data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Google Sheets Data in TIBCO Spotfire through ADO.NET
Integrate Google Sheets data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for Anaplan
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Anaplan.
-
Create Azure Data Lake Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Data Lake Storage data access from reports, embedded analytics, and more.
-
Integrating LangChain with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CouchDB data within automated workflows.
-
Seamlessly Bring Freshdesk Data into Retool Using CData Connect AI
Integrate Freshdesk data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Live TaxJar Data in MicroStrategy through CData Connect AI
Create a live connection to TaxJar Data in CData Connect AI and connect to your TaxJar data from MicroStrategy.
-
How to create an RPA flow for PingOne Data in UiPath Studio
Use the PingOne ODBC Driver to create workflows that access real-time PingOne data without any coding.
-
Connect to Calendly Data in RapidMiner
Integrate Calendly data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect and Visualize Live Monday.com Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Monday.com data into the Databricks platform and create visualization dashboards with real-time Monday.com data.
-
Build an OLAP Cube in SSAS from Bitbucket Data
Establish a connection to Bitbucket data data from SQL Server Analysis Services, and use the Bitbucket Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Apify Data Using Azure Data Factory
Use CData Connect AI to connect to Apify Data from Azure Data Factory and import live Apify data.
-
Integrate Sage 200 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage 200 with External Services.
-
Automate PolarTeamPro Data Replication to Azure Data Lake
Use CData Sync to customize and automate PolarTeamPro data replication to Azure Data Lake.
-
Create Datasets from Microsoft Dataverse in Domo Workbench and Build Visualizations of Microsoft Dataverse Data in Domo
Use the CData Software ODBC Driver for Microsoft Dataverse to create datasets from Microsoft Dataverse data in Domo Workbench and then build visualizations in the Domo service.
-
Configure the CData JDBC Driver for Datadog in a Connection Pool in Tomcat
Connect to Datadog data from a connection pool in Tomcat.
-
View Reports on Real-Time Salesloft Data in Power BI Report Server
Use the CData ODBC Driver for Salesloft to visualize Salesloft data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate LibreChat with Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live PayPal data from within the chat interface.
-
Establish a Live Connection with PingOne Data using Tableau Bridge
The CData ODBC Driver for PingOne enables you to integrate live PingOne data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Bullhorn CRM Data Using Entity Framework
This article shows how to access Bullhorn CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous PayPal Replication to Oracle
Use CData Sync for automated, continuous, customizable PayPal replication to Oracle.
-
Automate Parquet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Parquet data from PowerShell? This article demonstrates how to utilize the Parquet Cmdlets for tasks like connecting to Parquet data, automating operations, downloading data, and more.
-
Integrate with LinkedIn Data in SnapLogic
Use CData Connect AI to connect to and integrate with live LinkedIn data in SnapLogic.
-
Access CouchDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CouchDB data from HeidiSQL.
-
Use Dash to Build Web Apps on Oracle Eloqua Data via CData Connect AI
Build interactive Dash web apps on live Oracle Eloqua data using pandas and the CData Connect AI Python SDK.
-
Operational Reporting on Keap Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Keap data.
-
Deploy the ADO.NET Provider for Dynamics 365 Business Central on an SSRS Report Server
Connect to Dynamics 365 Business Central 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.
-
DataBind Controls to Testmonitor Data in C++Builder
DataBind to Testmonitor data in C++Builder with standard components and controls.
-
Visualize BigQuery Data in Tableau
The CData ODBC driver for BigQuery enables you integrate BigQuery data into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Printful
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Printful.
-
Connect to Instagram Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Instagram data.
-
Query SAP SuccessFactors Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP SuccessFactors data from Node.js.
-
Visualize Live Databricks Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Databricks data.
-
How to Connect to Live ZohoMarketingHub Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoMarketingHub data without replication.
-
ETL ZohoInvoice in Oracle Data Integrator
This article shows how to transfer ZohoInvoice data into a data warehouse using Oracle Data Integrator.
-
Connect to Google Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Analytics data from HeidiSQL.
-
Trigger Google Drive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Drive with standard wizards in Logic Apps.
-
Connecting Agentforce with Microsoft OneDrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft OneDrive data for you.
-
Connect to CockroachDB Data from a Connection Pool in Jetty
The CockroachDB JDBC Driver supports connection pooling: This article shows how to connect faster to CockroachDB data from Web apps in Jetty.
-
Integrate Goose with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SendGrid data from within the local AI agent.
-
Connect to QuickBooks Online Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks Online data from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks Online.
-
Integrating Claude Code with Typeform Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Typeform data within assisted coding and automated development workflows.
-
Access MySQL 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 MySQL data.
-
DataBind Controls to Deel Data in Delphi
DataBind to Deel data in Delphi with standard data access components and controls.
-
Build Salesloft Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesloft data and build visualizations in Tableau.
-
Connect to Snapchat Ads Data in ACL Analytics
Connect to Snapchat Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Snapchat Ads data.