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 with SAP Ariba Procurement using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Procurement to a JSON file on disk.
-
Connect to IBM Informix in HULFT Integrate
Connect to IBM Informix as a JDBC data source in HULFT Integrate
-
Publish Reports with QuickBooks in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Desktop.
-
Creating Jira-Connected Applications in Unqork
You can use CData Connect Cloud to feed Atlassian Jira to Unqork and build custom business apps.
-
Automated Continuous GraphQL Replication to Snowflake
Use CData Sync for automated, continuous, customizable GraphQL replication to Snowflake.
-
Analyze GraphQL in Infragistics Reveal
Use the CData API Server to create an OData API on top of GraphQL and visualize live GraphQL in Ingragistics Reveal.
-
Query Freshdesk from Node.js
Use the OData endpoint of the CData API Server to connect to your Freshdesk and perform CRUD operations on Freshdesk from Node.js.
-
Stream Redis into Apache Kafka Topics
Access and stream Redis in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Using the CData Software ODBC Driver for BambooHR in PyCharm
Connect to BambooHR as an ODBC data source in PyCharm using the CData Software ODBC Driver for BambooHR.
-
How to Work with Salesforce in ETL Validator JDBC
Connect to Salesforce from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect AlloyDB to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google AlloyDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query PayPal in DataGrip
Create a Data Source for PayPal in DataGrip and use SQL to query live PayPal.
-
Create Informatica Mappings From/To a JDBC Data Source for Tableau CRM Analytics
Create Tableau CRM Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load EnterpriseDB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load EnterpriseDB to a database.
-
How to Access Google Calendar Information with a Service Account
Learn how to set up service account authentication with Google Calendar and then authenticate for live Google Calendar access.
-
Operational Reporting on RSS Feeds from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote RSS Feeds.
-
Replicate Trello in Heroku for Use in Salesforce Connect
Replicate Trello to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Cloudant with Squirrel SQL client
Connect to IBM Cloudant and execute queries in the Squirrel SQL Client.
-
Easily Integrate Couchbase in Lazarus Pascal IDE
Learn how to easily integrate live Couchbase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Analysis Services
Create an ODBC connection to Azure Analysis Services in Informatica and browse and transfer Azure Analysis Services.
-
How to connect to PingOne with Squirrel SQL client
Connect to PingOne and execute queries in the Squirrel SQL Client.
-
Rapidly Develop Avalara AvaTax-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.
-
PowerShell Scripting to Replicate SharePoint Excel Services to MySQL
Write a simple PowerShell script to replicate SharePoint Excel Services to a MySQL database.
-
Establish a Live Connection with Pipedrive using Tableau Bridge
The CData ODBC Driver for Pipedrive enables you to integrate live Pipedrive into Tableau Cloud dashboards using the Tableau Bridge.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SQL Analysis Services
Provide connectivity to SQL Analysis Services through an SAP BusinessObjects universe.
-
Connect to SendGrid in SpagoBI
Create reports featuring live SendGrid in SpagoBI Studio. Host SendGrid reports on SpagoBI Server.
-
How to Import Data from Harvest into Google Sheets
Import Harvest into a Google spreadsheet that is automatically refreshed.
-
How to connect PolyBase to Twitter Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Twitter Ads.
-
Analyze Acumatica in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Acumatica ERP in Microsoft R Open.
-
Work with Live BigCommerce in Power Query
Use CData Connect Cloud to connect to BigCommerce and work with live BigCommerce in Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time REST
Use CData Power BI Connectors to visualize REST in Power BI.
-
Create Slack-Connected Nintex Workflows
Use CData Connect Cloud to connect to Slack from Nintex Workflow Cloud and build custom workflows using live Slack.
-
Automate Salesforce Marketing Replication to SAP HANA
Use CData Sync to customize and automate Salesforce Marketing Cloud replication to SAP HANA.
-
Connect to PingOne in Google Apps Script via SQL Gateway
Use the ODBC Driver for PingOne and the SQL Gateway to access PingOne from Google Apps Script.
-
Automated Continuous Databricks Replication to SQLite
Use CData Sync for automated, continuous, customizable Databricks replication to SQLite.
-
Prepare, Blend, and Analyze Splunk in Alteryx Designer (ODBC)
Build workflows to access live Splunk for self-service data analytics.
-
Automated Continuous Coinbase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Coinbase replication to Google Cloud SQL.
-
Create Data Visualizations Based On Tableau CRM Analytics in Mode
Use CData Connect Cloud to connect to Tableau CRM Analytics from Mode and build visualizations using live
-
Create Greenplum Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenplum data access from reports, embedded analytics, and more.
-
How to Access Live eBay Analytics in Power Automate Desktop via ODBC
The CData ODBC Driver for eBay Analytics enables you to integrate eBay Analytics into workflows built using Microsoft Power Automate Desktop.
-
Replicate MongoDB in Heroku for Use in Salesforce Connect
Replicate MongoDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Live Certinia in Claude Desktop
Connect to and query live Certinia in Claude Desktop using the CData MCP Server.
-
How to pipe Aha to CSV in PowerShell
Use standard PowerShell cmdlets to access Aha tables.
-
Import and Visualize YouTube Analytics in Power View
Create data visualizations based on YouTube Analytics in Excel.
-
Bridge MailChimp Connectivity with Apache NiFi
Access and process MailChimp in Apache NiFi using the CData JDBC Driver.
-
Connect to Presto in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Presto in Airbyte.
-
Build Charts with SAP Ariba Source in Clear Analytics
Create dynamic charts and perform analytics based on SAP Ariba Source in Clear Analytics.
-
Connect SharePoint to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft SharePoint using the CData Python MCP Server.
-
Automated Continuous Amazon S3 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Google Cloud SQL.
-
Use the CData ODBC Driver for Sugar CRM in Microsoft Power Query
You can use the CData Sugar CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sugar CRM into Microsoft Power Query.
-
How to connect and process LDAP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LDAP.
-
Access Live Microsoft OneDrive in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft OneDrive into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft OneDrive in the Graph Builder and Query Builder.
-
Access Live Xero in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Xero Accounting from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Use a Microsoft Access Database to Update Cassandra in Real Time
Update Cassandra data by creating a linked table in Microsoft Access with the CData Cassandra ODBC Driver.
-
Connect to Live Quickbase in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Quickbase in CData Connect Cloud and connect to your Quickbase from PostgreSQL.
-
Analyze Smartsheet in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Smartsheet and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Edit and Search Certinia External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Certinia to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Certinia objects that you can access from apps and the dashboard.
-
Use Biml to Build SSIS Tasks to Replicate Dynamics 365 to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics 365 to SQL Server.
-
Add Google Cloud Storage to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Cloud Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Multiple JSON Accounts
Replicate multiple JSON accounts to one or many databases.
-
Automated Continuous Pinterest Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pinterest replication to Azure SQL Database.
-
View Reports on Real-Time Clio in Power BI Report Server
Use the CData ODBC Driver for Clio to visualize Clio in Power BI Desktop and then publish them to Power BI Report Server.
-
How to integrate HarperDB with Apache Airflow
Access and process HarperDB in Apache Airflow using the CData JDBC Driver.
-
Build Yahoo! Japan Data Solution-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Yahoo! Japan Data Solution.
-
Design BIRT Reports on Databricks
Provide current Databricks to your embedded analytics.
-
Using the CData Software ODBC Driver for Tableau CRM Analytics in PyCharm
Connect to Tableau CRM Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tableau CRM Analytics.
-
Access Clio from MySQL in PHP
Connect to Clio through the standard MySQL libraries in PHP.
-
Excel Spreadsheet Automation on Redshift with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAS Data Sets
Provide connectivity to SAS Data Sets through an SAP BusinessObjects universe.
-
Automated Continuous SAP Hybris C4C Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Google BigQuery.
-
Create SendGrid-Connected Applications in Appsmith
Connect to SendGrid via CData Connect Cloud in Appsmith and create custom business applications with real-time access to SendGrid.
-
Write a Simple Go Application to work with Bullhorn CRM on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bullhorn CRM.
-
Explore Geographical Relationships in Microsoft Dataverse with Power Map
Create data visualizations with Microsoft Dataverse (CDS) in Power Map.
-
Query Google Sheets in ColdFusion
Write standard ColdFusion data access code to connect to Google Sheets.
-
DataBind ADP to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for ADP with the DevExpress Windows Forms and Web controls to provide ADP to a chart.
-
Migrating data from Confluence to Databricks using CData SSIS Components.
Easily push Atlassian Confluence to Databricks using the CData SSIS Tasks for Confluence and Databricks.
-
Analyze SAP Ariba Source in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Ariba Source in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Fieldglass
Create SAP Fieldglass data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Tally Replication to SAP HANA
Use CData Sync to customize and automate Tally ERP replication to SAP HANA.
-
Analyze FHIR in R via JDBC
Use standard R functions and the development environment of your choice to analyze FHIR with the CData JDBC Driver for FHIR.
-
Migrating data from SharePoint Excel Services to Databricks using CData SSIS Components.
Easily push SharePoint Excel Services to Databricks using the CData SSIS Tasks for SharePoint Excel Services and Databricks.
-
Build Apps with Live Coinbase Using the Low-Code Development Platform of Mendix
-