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
-
Prepare, Blend, and Analyze Office 365 in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Office 365 for self-service data analytics.
-
Extract, Transform, and Load Jira in Informatica PowerCenter
Create a simple Workflow for Atlassian Jira in Informatica PowerCenter.
-
Connect Microsoft Exchange to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Exchange using the CData Python MCP Server.
-
How to Connect to Zoom in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoom. Leverage the pyodbc module for ODBC in Python.
-
Integrate Amazon DynamoDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon DynamoDB with External Services.
-
How to integrate Workday with Apache Airflow
Access and process Workday in Apache Airflow using the CData JDBC Driver.
-
Build Charts with LinkedIn in Clear Analytics
Create dynamic charts and perform analytics based on LinkedIn in Clear Analytics.
-
How to pipe Twitter Ads to CSV in PowerShell
Use standard PowerShell cmdlets to access Twitter Ads tables.
-
Write a Simple Go Application to work with Workday on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workday.
-
Automated Continuous RSS Replication to Snowflake
Use CData Sync for automated, continuous, customizable RSS replication to Snowflake.
-
Create Dashboards and Visualize Live Zuora in Geckoboard
Use CData Connect Cloud to connect to live Zuora and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Databricks in AWS Lambda
Connect to live Databricks in AWS Lambda using the CData JDBC Driver.
-
Create a Data Access Object for Email using JDBI
A brief overview of creating a SQL Object API for Email in JDBI.
-
Integrate with WooCommerce in JReport Designer
Create charts and reports based on WooCommerce in JReport Designer.
-
Automated Continuous Azure Data Lake Storage Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Microsoft Access.
-
Connect to Instagram from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instagram to connect to Instagram and execute queries in PowerBuilder.
-
Automated Continuous Neo4J Replication to Oracle
Use CData Sync for automated, continuous, customizable Neo4J replication to Oracle.
-
Use Claude to Talk to Your Paylocity via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Paylocity for you.
-
Connect to Google Sheets in DBeaver
Use the CData ODBC Driver to connect to Google Sheets in DBeaver.
-
Connect to Neo4J in SpagoBI
Create reports featuring live Neo4J in SpagoBI Studio. Host Neo4J reports on SpagoBI Server.
-
Provide OData Services of WordPress from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for WordPress by developing a WCF Service Application.
-
How to create Visio diagrams from Spark
Automatically update Apache Spark SQL with the changes you make to Visio master shapes.
-
Connect to Live ADP in PostGresSQL Interface through CData Connect Cloud
Create a live connection to ADP in CData Connect Cloud and connect to your ADP from PostgreSQL.
-
Build Cassandra-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Cassandra and create custom apps in Bubble.
-
How to Design Salesforce Pardot Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automated Continuous BigCommerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable BigCommerce replication to PostgreSQL.
-
Integrate Salesforce Marketing in the Pentaho Report Designer
Publish reports based on Salesforce Marketing Cloud in the Pentaho BI tool.
-
Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver
Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with OneNote in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft OneNote in Dundas BI.
-
Build Pipelines with Live Excel Online in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Excel Online from Google Cloud Data Fusion, enabling the integration of live Microsoft Excel Online into the building and management of effective data pipelines.
-
Create Reports from Zendesk in Looker Studio
Use CData Connect Cloud to gain access to live Zendesk and create custom reports in Looker Studio.
-
Build HarperDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HarperDB and build web apps with connectivity to live HarperDB.
-
Automated Continuous Google Calendar Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Calendar replication to Apache Kafka.
-
Visualize ShipStation in TIBCO Spotfire through ADO.NET
Integrate ShipStation into dashboards in TIBCO Spotfire.
-
Create SSAS Tabular Models from Cvent
How to build a SQL Server Analysis Service Tabular Model from Cvent using CData drivers.
-
Work with Live Freshdesk in Power Query
Use CData Connect Cloud to connect to Freshdesk and work with live Freshdesk in Microsoft Power Query.
-
Connect to IBM Informix as an External Source in Dremio
Use the CData JDBC Driver to connect to IBM Informix as an External Source in Dremio.
-
Build Pipelines with Live Google Ads in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Google Ads from Google Cloud Data Fusion, enabling the integration of live Google Ads into the building and management of effective data pipelines.
-
Automated Continuous Highrise Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Highrise replication to Amazon Redshift.
-
Analyze Authorize.Net in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Authorize.Net in Microsoft R Open.
-
Create Reports from Kintone in Looker Studio
Use CData Connect Cloud to gain access to live Kintone and create custom reports in Looker Studio.
-
How to create an RPA flow for RSS Feeds in UiPath Studio
Use the RSS ODBC Driver to create workflows that access real-time RSS Feeds without any coding.
-
Publish Microsoft Dataverse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dataverse (CDS).
-
Create SSAS Tabular Models from Freshdesk
How to build a SQL Server Analysis Service Tabular Model from Freshdesk using CData drivers.
-
Work with Live SAP Ariba Procurement in Power Query
Use CData Connect Cloud to connect to SAP Ariba Procurement and work with live SAP Ariba Procurement in Microsoft Power Query.
-
Connect to Access from a Connection Pool in JBoss
Integrate Microsoft Access into Java servlets: Use the Management Console in JBoss to install the Access JDBC Driver.
-
Create Reports with MariaDB in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MariaDB.
-
Publish Oracle HCM Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle HCM Cloud.
-
Automated Continuous Google Directory Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Directory replication to Google Cloud SQL.
-
Export/Import Users, Connections, and Endpoints in Connect Server
Walk through exporting and importing users, connections, and endpoints in CData Connect Server
-
How to connect to Greenplum with Squirrel SQL client
Connect to Pivotal GreenPlum and execute queries in the Squirrel SQL Client.
-
Connect to Amazon Marketplace in ACL Analytics
Connect to Amazon Marketplace via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Amazon Marketplace.
-
Analyze Kintone in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Kintone and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Amazon DynamoDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon DynamoDB.
-
Automated Continuous Sage 50 UK Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to MongoDB.
-
A PostgreSQL Interface for Oracle HCM Cloud (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import Sage 300 Data into IBM SPSS Modeler
Integrate Sage 300 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build an OLAP Cube in SSAS from CouchDB
Establish a connection to Apache CouchDB data from SQL Server Analysis Services, and use the CouchDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho CRM
Create an ODBC connection to Zoho CRM in Informatica and browse and transfer Zoho CRM.
-
Access Live Microsoft Dataverse in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Bind Live Google Campaign Manager 360 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Campaign Manager 360 data
-
How to integrate DB2 with Apache Airflow
Access and process IBM DB2 in Apache Airflow using the CData JDBC Driver.
-
Connect to GitHub as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live GitHub.
-
How to create Visio diagrams from Shopify
Automatically update Shopify with the changes you make to Visio master shapes.
-
Connect to Dynamics CRM as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics CRM.
-
Connect to Live Oracle HCM Cloud in MicroStrategy through CData Connect Cloud
Create a live connection to Oracle HCM Cloud in CData Connect Cloud and connect to your Oracle HCM Cloud from MicroStrategy.
-
Visualize Raisers Edge NXT in TIBCO Spotfire through ADO.NET
Integrate Raisers Edge NXT into dashboards in TIBCO Spotfire.
-
Visualize Drift in TIBCO Spotfire through ADO.NET
Integrate Drift into dashboards in TIBCO Spotfire.
-
Connect to Zendesk from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zendesk to connect to Zendesk and execute queries in PowerBuilder.
-
How to integrate Google Cloud Storage with Apache Airflow
Access and process Google Cloud Storage in Apache Airflow using the CData JDBC Driver.
-
Connect to Amazon Marketplace as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Marketplace.
-
Easily Integrate Impala in Lazarus Pascal IDE
Learn how to easily integrate live Apache Impala in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Data Catalog from a Connection Pool in Jetty
The Google Data Catalog JDBC Driver supports connection pooling: This article shows how to connect faster to Google Data Catalog from Web apps in Jetty.
-
Viewing Airtable in RAD Studio Data Explorer
How to view Airtable in RAD Studio Data Explorer using the CData ODBC Driver for Airtable.
-
Establish a Live Connection with Google Campaign Manager 360 using Tableau Bridge
The CData ODBC Driver for Google Campaign Manager 360 enables you to integrate live Google Campaign Manager 360 into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Bitbucket with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bitbucket from Power Pivot. You will use the Table Import Wizard to load Bitbucket. You can visually build the import query or use any SQL supported by the driver.
-
Build Odoo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Odoo ERP and build web apps with connectivity to live Odoo ERP.
-
DataBind Controls to HDFS in Delphi
DataBind to Apache HDFS in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 200
Create an ODBC connection to Sage 200 in Informatica and browse and transfer Sage 200.
-
Use Claude to Talk to Your Jira via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Atlassian Jira for you.
-
Import Tally into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Tally ERP. In this article, you will use the OData format to import Tally ERP into Microsoft Power Query.
-
How to Query Live Workday Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Workday data in natural language using Python.
-
Integrate with Redshift in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Amazon Redshift in SnapLogic.
-
Visualize Live HDFS of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache HDFS using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Paylocity in MySQL Workbench
Execute MySQL queries against live Paylocity from MySQL Workbench.
-
Create Zuora-Connected Dashboards in Grafana
Connect to Zuora via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Zuora.
-
Connect to and Visualize Live Google Ads in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Ads.
-
Integrate with Live Twilio in MuleSoft (via CData Connect Cloud)
Use CData Connect Cloud to connect to Twilio from the MuleSoft Anypoint Platform to integrate live Twilio into custom reports and dashboards.
-
Query Microsoft OneDrive from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft OneDrive and perform CRUD operations on Microsoft OneDrive from Node.js.
-
SAP BusinessObjects BI Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP BusinessObjects BI through CData Connect Cloud using different applications and tools.
-
Use the CData Software JDBC Driver for Teradata in MicroStrategy Web
Connect to Teradata in MicroStrategy Web using the CData Software JDBC Driver for Teradata.
-
Integrate Cassandra into Power Automate Desktop using CData Connect
CData Connect for Cassandra enables you to integrate Apache Cassandra into workflows built using Microsoft Power Automate Desktop.
-
Edit and Search Harvest External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Harvest to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Harvest objects that you can access from apps and the dashboard.
-
Migrating data from PingOne to Snowflake using CData SSIS Components.
Easily push PingOne to Snowflake using the CData SSIS Tasks for PingOne and Snowflake.
-
Connect to Zoho Inventory in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Zoho Inventory in Google Apps Script.
-
Connect to SAP Netweaver Gateway in Aqua Data Studio
Access SAP Netweaver Gateway from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Real-Time Exact Online Data in Power Apps Using Dataflows to Build Custom Applications
-