Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
CData Software - Knowledge Base
Recent Articles
-
Connect to Workday from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Workday using standard SQL.
-
Query Backlog as a SQL Server Database in Node.js
Execute SQL Server queries against Backlog from Node.js.
-
Visualize SAP Ariba Procurement in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Ariba Procurement into TIBCO Spotfire.
-
Replicate Multiple REST Accounts via the CData Sync CLI
Replicate multiple REST accounts to one or many databases.
-
Operational Reporting on HarperDB from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HarperDB.
-
Trigger Outreach.io IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
How to Work with Zendesk in ETL Validator JDBC
Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Access with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Build an ETL App for Avro in Python with CData
Create ETL applications and real-time data pipelines for Apache Avro in Python with petl.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Projects to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Projects to SQL Server.
-
Query, Visualize, and Share live Snapchat Ads in Redash
Use CData Connect Cloud to connect to live Snapchat Ads in Redash for querying, visualizing, and sharing.
-
Connect to Microsoft Project as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Microsoft Project.
-
How to Access Bullhorn CRM Using Entity Framework
This article shows how to access Bullhorn CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Power BI XMLA from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA and execute queries in PowerBuilder.
-
ETL Zuora in Oracle Data Integrator
This article shows how to transfer Zuora into a data warehouse using Oracle Data Integrator.
-
Query SingleStore using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SingleStore entities in PHP by modeling them as objects.
-
Build Dashboards with SAS Data Sets in DBxtra
Create dynamic dashboards and perform analytics based on SAS Data Sets in DBxtra.
-
Access Live Google Contacts in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Contacts from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Dynamics NAV from PowerShell
Write a quick PowerShell script to query Microsoft Dynamics NAV. Use connectivity to the live data to replicate Microsoft Dynamics NAV to SQL Server.
-
Prepare, Blend, and Analyze Google Sheets in Alteryx Designer (ODBC)
Build workflows to access live Google Sheets for self-service data analytics.
-
Provide OData Services of Excel from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Excel by developing a WCF Service Application.
-
Analyze Google Spanner in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Google Spanner and visualize live Google Spanner in Infragistics Reveal.
-
Connect to Zoho CRM in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Zoho CRM in Airbyte.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HarperDB
Provide connectivity to HarperDB through an SAP BusinessObjects universe.
-
Natively Connect to MongoDB in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MongoDB. Leverage the native support for ODBC in PHP.
-
Access Live Azure DevOps in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Azure DevOps to create a Azure DevOps source in TIBCO Data Virtualization Studio and gain access to live Azure DevOps from your TDV Server.
-
Process & Analyze XML in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live XML .
-
Connect to Drift in Aqua Data Studio
Access Drift from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for Zuora (MySQL Remoting via JDBC)
Use the Remoting features of the Zuora JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SharePoint Replication to SQL Server
Use CData Sync for automated, continuous, customizable SharePoint replication to SQL Server.
-
Create Datasets from Invoiced in Domo Workbench and Build Visualizations of Invoiced in Domo
Use the CData Software ODBC Driver for Invoiced to create datasets from Invoiced in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Cloudant in Looker
Use CData Connect Cloud to connect to Cloudant from Looker and build custom apps using live IBM Cloudant.
-
Integrate Live SharePoint into Blue Prism for Intelligent Robotic Process Automation (RPA)
-
