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
-
Access Live Authorize.Net in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Authorize.Net into the statistical analysis tools available in SAS JMP. This article shows how to use Authorize.Net in the Graph Builder and Query Builder.
-
Analyze Sage 50 UK with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage 50 UK from Power Pivot. You will use the Table Import Wizard to load Sage 50 UK. You can visually build the import query or use any SQL supported by the driver.
-
Create Excel Online-Connected Applications in Appsmith
Connect to Excel Online via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Microsoft Excel Online.
-
PowerShell Scripting to Replicate Impala to MySQL
Write a simple PowerShell script to replicate Apache Impala to a MySQL database.
-
Prepare, Blend, and Analyze IBM Informix in Alteryx Designer (Connect Cloud)
Build workflows to access live IBM Informix for self-service data analytics.
-
Visualize Kafka from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Kafka.
-
Analyze Google Drive with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Drive from Power Pivot. You will use the Table Import Wizard to load Google Drive. You can visually build the import query or use any SQL supported by the driver.
-
Extend Google Sheets with MYOB AccountRight
Make calls to the API Server from Google Apps Script.
-
Visualize Google Campaign Manager 360 in TIBCO Spotfire through ADO.NET
Integrate Google Campaign Manager 360 into dashboards in TIBCO Spotfire.
-
Connect to Xero in NetBeans
Connect to Xero Accounting in NetBeans with the data source configuration wizard.
-
Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Avalara AvaTax to SQL Server.
-
Create SSAS Tabular Models from Marketo
How to build a SQL Server Analysis Service Tabular Model from Marketo using CData drivers.
-
Create Data Visualizations in Cognos BI with Tableau CRM Analytics
Access Tableau CRM Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
PowerShell Scripting to Replicate Shippo to MySQL
Write a simple PowerShell script to replicate Shippo to a MySQL database.
-
Create Datasets from SAP Hybris C4C in Domo Workbench and Build Visualizations of SAP Hybris C4C in Domo
Use the CData Software ODBC Driver for SAP Hybris C4C to create datasets from SAP Hybris C4C in Domo Workbench and then build visualizations in the Domo service.
-
How to use SQLAlchemy ORM to access HubDB in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of HubDB.
-
PowerShell Scripting to Replicate Databricks to MySQL
Write a simple PowerShell script to replicate Databricks to a MySQL database.
-
Connect to Spark in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Spark and connect to Apache Spark SQL in Akorbi Digital RunMyProcess.
-
Connect to Oracle Service Cloud in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle Service Cloud and the SQL Gateway to access Oracle Service Cloud from Google Apps Script.
-
Viewing Microsoft Dataverse in RAD Studio Data Explorer
How to view Microsoft Dataverse (CDS) in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Dataverse.
-
Provide OData Services of Zoho Creator from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Creator by developing a WCF Service Application.
-
Query Acumatica using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Acumatica entities in PHP by modeling them as objects.
-
Connect to SQL Server in Ruby
Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Data Flows from Drift to SQL Server using SSIS
Easily back up Drift to SQL Server using the SSIS components for Drift.
-
Connect to and Visualize Live Dynamics NAV in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics NAV.
-
How to Create Power BI Visual Reports with Real-Time Exact Online
Use CData Power BI Connectors to visualize Exact Online in Power BI.
-
Build AI/ML Models with Live Google Ad Manager Data using Dataiku
-
