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
-
Integrate Salesforce Marketing in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Marketing Cloud from Informatica Cloud.
-
Connect to CockroachDB from a Connection Pool in JBoss
Integrate CockroachDB into Java servlets: Use the Management Console in JBoss to install the CockroachDB JDBC Driver.
-
Creating Confluence-Connected Applications in Unqork
You can use CData Connect Cloud to feed Atlassian Confluence to Unqork and build custom business apps.
-
How to connect to Azure Analysis Services from Spring Boot
Connect to Azure Analysis Services in a Spring Boot Application using CData JDBC Azure Analysis Services Driver
-
Connect to SQL Analysis Services in RazorSQL
Connect to SQL Analysis Services from wizards and query SQL Analysis Services from the GUI in the RazorSQL database management tool.
-
Load Teradata to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Teradata to a database.
-
Edit and Search External Azure DevOps Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Azure DevOps to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure DevOps objects that you can access from apps and the dashboard.
-
Analyze Sugar CRM with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM. You can visually build the import query or use any SQL supported by the driver.
-
Model, Search, and Visualize Live LinkedIn Ads in ThoughtSpot
Use CData Connect Cloud to connect to live LinkedIn Ads for modeling, searching, and visualizing.
-
Back Up SharePoint Excel Services to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SharePoint Excel Services. In this article, we will employ an SSIS workflow to populate a database with SharePoint Excel Services data.
-
Work with Google Ads in FoxPro
Load Google Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Shippo Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Shippo data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query, Visualize, and Share live Azure Synapse in Redash
Use CData Connect Cloud to connect to live Azure Synapse in Redash for querying, visualizing, and sharing.
-
Replicate Microsoft OneLake to Multiple Databases
Replicate Microsoft OneLake to disparate databases with a point-and-click configuration.
-
Publish Printful-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Printful.
-
How to Build an ETL App for Greenhouse in Python with CData
Create ETL applications and real-time data pipelines for Greenhouse in Python with petl.
-
How to Access Live Bullhorn CRM in Power Automate Desktop via ODBC
The CData ODBC Driver for Bullhorn CRM enables you to integrate Bullhorn CRM into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from SurveyMonkey in Domo Workbench and Build Visualizations of SurveyMonkey in Domo
Use the CData Software ODBC Driver for SurveyMonkey to create datasets from SurveyMonkey in Domo Workbench and then build visualizations in the Domo service.
-
Connect to ClickUp as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ClickUp.
-
Connect to Salesforce Marketing from AWS Glue
Use CData Connect Cloud to gain access to live Salesforce Marketing Cloud from your AWS Glue jobs.
-
Visualize Facebook in TIBCO Spotfire through OData
Integrate Facebook into dashboards in TIBCO Spotfire.
-
Access Live eBay in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live eBay from your Excel spreadsheets.
-
Migrating data from ADP to Databricks using CData SSIS Components.
Easily push ADP to Databricks using the CData SSIS Tasks for ADP and Databricks.
-
Build Visualizations of Amazon DynamoDB in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon DynamoDB in Birst.
-
Automate Sybase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sybase from PowerShell? This article demonstrates how to utilize the Sybase Cmdlets for tasks like connecting to Sybase, automating operations, downloading data, and more.
-
Access QuickBooks Online from MySQL in PHP
Connect to QuickBooks Online through the standard MySQL libraries in PHP.
-
Build Adobe Commerce-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Adobe Commerce.
-
View Reports on Real-Time Zuora in Power BI Report Server
Use the CData ODBC Driver for Zuora to visualize Zuora in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Snapchat Ads-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Snapchat Ads.
-
Connect to Stripe from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Stripe from Filemaker Pro on Mac.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Ariba Procurement in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Build Adobe Commerce Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Adobe Commerce and build visualizations in Tableau Cloud.
-
DataBind Controls to Salesforce Pardot in Delphi
DataBind to Salesforce Pardot in Delphi with standard data access components and controls.
-
Viewing SAP Ariba Source in RAD Studio Data Explorer
How to view SAP Ariba Source in RAD Studio Data Explorer using the CData ODBC Driver for SAP Ariba Source.
-
Access Live Stripe in Coginiti Pro
Connect to and query live Stripe from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Highrise in ColdFusion
Write standard ColdFusion data access code to connect to Highrise CRM.
-
Analyze SAP Concur in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Concur and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Oracle into Power Automate Desktop using CData Connect
CData Connect for Oracle enables you to integrate Oracle Database into workflows built using Microsoft Power Automate Desktop.
-
Connect to Azure Synapse from HeidiSQL
Use CData Connect Cloud to connect to and query live Azure Synapse from HeidiSQL.
-
Build a PostgreSQL Interface for Power BI XMLA using the CData JDBC Driver
Use the Remoting features of the Power BI XMLA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Asana from Tableau
Use the Tableau Desktop business intelligence tool to connect to Asana.
-
Connect to Act CRM in HULFT Integrate
Connect to Act CRM as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time Okta in Power BI Report Server
Use the CData ODBC Driver for Okta to visualize Okta in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous SAP Business One Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Business One replication to Azure SQL Database.
-
Connect to Azure Data Lake Storage as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Azure Data Lake Storage.
-
How to integrate Metabase with IBM Informix
Use CData Connect Cloud to connect to live IBM Informix and create an interactive dashboard in Metabase from IBM Informix.
-
Access Live Snapchat Ads in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live Snapchat Ads from your Excel spreadsheets.
-
Migrating data from Google Analytics to Snowflake using CData SSIS Components.
Easily push Google Analytics to Snowflake using the CData SSIS Tasks for Google Analytics and Snowflake.
-
Integrate Zoho Creator into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Zoho Creator and integrate live Zoho Creator into your Power Automate tasks.
-
Connect to Amazon S3 in HULFT Integrate
Connect to Amazon S3 as a JDBC data source in HULFT Integrate
-
Connect to SAP SuccessFactors in JRuby
Create a simple JRuby app with access to live SAP SuccessFactors.
-
Import Real-Time Google Analytics via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Analytics in ColdFusion.
-
How to connect and process Act CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Act CRM.
-
Build Apps with Live Veeva Vault & Vault CRM in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Veeva Vault & Vault CRM into the Adalo platform and build custom mobile and web applications with real-time Veeva Vault & Vault CRM.
-
Migrating data from Calendly to Databricks using CData SSIS Components.
Easily push Calendly to Databricks using the CData SSIS Tasks for Calendly and Databricks.
-
How to use SQLAlchemy ORM to access Box in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Box.
-
Build Jira Service Management-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Jira Service Management and create custom apps in Mendix.
-
Visualize Live Xero in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Xero Accounting into custom reports in Power BI.
-
Visualize Cassandra in TIBCO Spotfire through OData
Integrate Apache Cassandra into dashboards in TIBCO Spotfire.
-
Build Pipelines with Live Dynamics 365 in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Dynamics 365 from Google Cloud Data Fusion, enabling the integration of live Microsoft Dynamics 365 into the building and management of effective data pipelines.
-
Integrate Live Cloudant into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to IBM Cloudant and integrate live IBM Cloudant into apps built in Microsoft Power Apps.
-
Replicate NetSuite in Heroku for Use in Salesforce Connect
Replicate NetSuite CRM & ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to use SQLAlchemy ORM to access Workday in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Workday.
-
How to pipe Active Directory to CSV in PowerShell
Use standard PowerShell cmdlets to access Active Directory tables.
-
Create Power BI Reports on Real-Time Azure Analysis Services
Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services in Power BI Desktop.
-
Connect to Dynamics 365 Business Central from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics 365 Business Central, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Gmail in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail from your Google Sheets.
-
Connect to Outreach.io in SpagoBI
Create reports featuring live Outreach.io in SpagoBI Studio. Host Outreach.io reports on SpagoBI Server.
-
How to Connect to Couchbase in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Couchbase. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Microsoft OneDrive in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft OneDrive. Leverage the pyodbc module for ODBC in Python.
-
Connect to SAS xpt in Jaspersoft Studio
Execute SQL to remote SAS XPORT in Jaspersoft Studio.
-
Automated Continuous Oracle Service Cloud Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Snowflake.
-
Connect to Oracle in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Oracle Database in Airbyte.
-
Consume Oracle Eloqua OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Eloqua as OData feeds from PowerBuilder using the API Server.
-
Rapidly Develop Reckon Accounts Hosted-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
How to publish and share Shippo dashboards with Tableau Server
The CData ODBC driver for Shippo enables you integrate Shippo into Tableau dashboards.
-
Connect to Jira Assets from PowerBuilder via ADO.NET
This article demonstrates how to access Jira Assets from Appeon PowerBuilder using the CData ADO.NET Provider for Jira Assets.
-
Connect to Typeform in Google Apps Script via SQL Gateway
Use the ODBC Driver for Typeform and the SQL Gateway to access Typeform from Google Apps Script.
-
Connect Amazon Marketplace to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon Marketplace using the CData Python MCP Server.
-
How to Access Live Zoho CRM in Visual Studio Code via Cline
Run the CData MCP Server for Zoho CRM on Windows Subsytem for Linux (WSL) and connect to live Zoho CRM from the Cline extension in Visual Studio Code.
-
Build Dynamics CRM-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Microsoft Dynamics CRM.
-
Automated Continuous Printify Replication to SQLite
Use CData Sync for automated, continuous, customizable Printify replication to SQLite.
-
Access Odoo as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Odoo ERP from your Oracle system.
-
Manage Marketo in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Marketo.
-
Model Cosmos DB Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Cosmos DB, enabling the direct import of real-time Azure Cosmos DB.
-
DataBind Controls to HDFS in C++Builder
DataBind to Apache HDFS in C++Builder with standard components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Spanner
Create Google Spanner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to FTP in Ruby
Connect to FTP Servers in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to and Visualize Live Pipedrive in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pipedrive.
-
SAP Ariba Procurement Reporting in OBIEE with the SAP Ariba Procurement JDBC Driver
Deploy the SAP Ariba Procurement JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Google Drive-Connected Business Apps in AppSheet
Connect to Google Drive via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Google Drive.
-
Operational Reporting on Teradata from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teradata.
-
Query Spark as a MySQL Database in Node.js
Execute MySQL queries against Apache Spark SQL from Node.js.
-
Write a Simple Go Application to work with Sybase on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase.
-
Connect to WordPress from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live WordPress from Filemaker Pro on Mac.
-
Connect to Google Cloud Storage from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Cloud Storage using standard SQL.
-
CData API Server Overview
A detailed overview of CData API Server and its ability to create REST APIs for cloud and on-prem data.
-
DataBind Controls to Avro in Delphi
DataBind to Apache Avro in Delphi with standard data access components and controls.
-
DataBind Controls to SendGrid in Delphi
DataBind to SendGrid in Delphi with standard data access components and controls.
-
Access Adobe Analytics from MySQL in Amazon QuickSight
Connect to Adobe Analytics and build visualizations of Adobe Analytics using a MySQL Connection in Amazon QuickSight.