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
-
Visualize QuickBooks Online in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks Online.
-
Build YouTube Analytics-Connected Apps in Choreo
Use CData Connect Cloud to connect to YouTube Analytics from Choreo and build custom apps using live YouTube Analytics.
-
How to update MySQL from Excel
This article explains how to transfer data from Excel to MySQL using the Excel Add-In for MySQL.
-
Create Reports with SAS Data Sets in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets.
-
How to Visualize Twitter Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Twitter Ads in Python.
-
Connect to Microsoft OneDrive in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft OneDrive and the SQL Gateway to access Microsoft OneDrive from Google Apps Script.
-
Connect to SharePoint Excel Services from PowerBuilder via JDBC
This article demonstrates how to access SharePoint Excel Services from PowerBuilder using the SharePoint Excel Services JDBC Driver.
-
Create Datasets from Amazon S3 in Domo Workbench and Build Visualizations of Amazon S3 in Domo
Use the CData Software ODBC Driver for Amazon S3 to create datasets from Amazon S3 in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Couchbase in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Couchbase from your Google Sheets.
-
How to integrate Google Campaign Manager 360 with Apache Airflow
Access and process Google Campaign Manager 360 in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Azure Table in MicroStrategy Web
Connect to Azure Table Storage in MicroStrategy Web using the CData Software ODBC Driver for Azure Table.
-
How to create Visio diagrams from Oracle Eloqua
Automatically update Oracle Eloqua with the changes you make to Visio master shapes.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for DB2
Provide connectivity to IBM DB2 through an SAP BusinessObjects universe.
-
Create Data Visualizations in Cognos BI with Azure DevOps
Access Azure DevOps as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Live Freshdesk in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Freshdesk into custom reports in Power BI.
-
How to Seamlessly Import Zoho Creator Data into IBM SPSS Modeler
Integrate Zoho Creator data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize SAS xpt in Sisense
Create an ElastiCube in Sisense app with access to SAS XPORT.
-
How to create Visio diagrams from SuiteCRM
Automatically update SuiteCRM with the changes you make to Visio master shapes.
-
Query ActiveCampaign through ODBC in Node.js
Use node-odbc to execute SQL queries against ActiveCampaign from Node.js.
-
Automate Amazon Marketplace Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Marketplace from PowerShell? This article demonstrates how to utilize the Amazon Marketplace Cmdlets for tasks like connecting to Amazon Marketplace, automating operations, downloading data, and more.
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Bridge SAP ByDesign Connectivity with Apache NiFi
Access and process SAP Business ByDesign in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FHIR
Provide connectivity to FHIR through an SAP BusinessObjects universe.
-
Connect to OneNote from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft OneNote using standard SQL.
-
How to Access Live Drift in Power Automate Desktop via ODBC
The CData ODBC Driver for Drift enables you to integrate Drift into workflows built using Microsoft Power Automate Desktop.
-
Installation Guide: CData MCP Servers on macOS
Learn how to install a CData MCP Server (Google Sheets) on macOS.
-
Replicate PayPal in Heroku for Use in Salesforce Connect
Replicate PayPal to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dynamic SAP HANA XS Advanced Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP HANA XS Advanced to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with Dynamics 365 Business Central using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics 365 Business Central to a JSON file on disk.
-
Connect to and Query Live Salesforce Data in QlikView (vina ODBC)
Create data visualizations with Salesforce data in QlikView.
-
Replicate Klipfolio from PowerShell
Write a quick PowerShell script to query Klipfolio. Use connectivity to the live data to replicate Klipfolio to SQL Server.
-
Access Dynamics NAV from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics NAV from HeidiSQL.
-
Connect to Exact Online from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online and execute queries in PowerBuilder.
-
Integrate EnterpriseDB in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live EnterpriseDB from Informatica Cloud.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Dropbox to Power BI dashboards. Simply drag and drop Dropbox into data visuals on the Power BI canvas.
-
Extract, Transform, and Load Trello in Informatica PowerCenter
Create a simple Workflow for Trello in Informatica PowerCenter.
-
Analyze Couchbase in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Couchbase and visualize live Couchbase in Infragistics Reveal.
-
Connect to SAP HANA XS Advanced Using the Script Function in Claris FileMaker Pro
-
