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
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse in MicroStrategy Desktop using the CData Software JDBC Driver for Greenhouse.
-
Connect TaxJar to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live TaxJar using the CData Python MCP Server.
-
Visualize Certinia from Tableau
Use the Tableau Desktop business intelligence tool to connect to Certinia.
-
Automated Continuous RSS Replication to SQL Server
Use CData Sync for automated, continuous, customizable RSS replication to SQL Server.
-
Visualize Salesforce Marketing in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Salesforce Marketing Cloud into TIBCO Spotfire.
-
Access Live Elasticsearch in Excel 365 Online (Excel for the web)
Connect to Elasticsearch from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
Query BigCommerce from Node.js
Use the OData endpoint of the CData API Server to connect to your BigCommerce and perform CRUD operations on BigCommerce from Node.js.
-
Connect to SAP BusinessObjects BI in Aqua Data Studio
Access SAP BusinessObjects BI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build MySQL-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to MySQL from Zoho Analytics and import live MySQL.
-
Connect Outreach.io to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Outreach.io using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Azure Data Lake Storage Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to OneLake in Microsoft Fabric.
-
Manage Cloudant in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cloudant.
-
Build Reckon Accounts Hosted-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Reckon Accounts Hosted and create custom apps in Mendix.
-
Build Avalara AvaTax-Connected Apps in Choreo
Use CData Connect Cloud to connect to Avalara AvaTax from Choreo and build custom apps using live Avalara AvaTax.
-
Excel Spreadsheet Automation on HarperDB with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to OneNote in HULFT Integrate
Connect to OneNote as a JDBC data source in HULFT Integrate
-
Analyze Redshift in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Amazon Redshift and visualize Amazon Redshift in SAP Analytics Cloud.
-
How to connect and process SAP HANA from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP HANA.
-
How to Design HarperDB 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 Box Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Box replication to OneLake in Microsoft Fabric.
-
Establish a Live Connection with Access using Tableau Bridge
The CData ODBC Driver for Access enables you to integrate live Microsoft Access into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Parquet in DBArtisan
Use wizards in DBArtisan to configure Apache Parquet as a data source.
-
Create a Data Access Object for Slack using JDBI
A brief overview of creating a SQL Object API for Slack in JDBI.
-
Automated Continuous Oracle Sales Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Vertica.
-
Replicate Salesforce Pardot to Multiple Databases
Replicate Salesforce Pardot to disparate databases with a point-and-click configuration.
-
How to Query Zoho Inventory in MySQL Workbench
Execute MySQL queries against live Zoho Inventory from MySQL Workbench.
-
Automated Continuous YouTube Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Snowflake.
-
LINQ to Stripe
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Stripe Data Provider.
-
Connect to Okta in HULFT Integrate
Connect to Okta as a JDBC data source in HULFT Integrate
-
How to Connect to & Open Zoho Creator in Microsoft Excel
This article uses the CData ODBC driver for Zoho Creator to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Explore Geographical Relationships in FTP with Power Map
Create data visualizations with FTP Servers in Power Map.
-
Create Data Visualizations in Cognos BI with CSV
Access CSV/TSV Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create PostgreSQL Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Salesforce Data Cloud in Aqua Data Studio
Access Salesforce Data Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to GitHub in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for GitHub in Airbyte.
-
Publish Crystal Reports on SingleStore
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SingleStore.
-
Integrate with Zendesk in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Zendesk in SnapLogic.
-
BambooHR Reporting in OBIEE with the BambooHR JDBC Driver
Deploy the BambooHR JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Printify in Aqua Data Studio
Access Printify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to SAP Fieldglass in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Fieldglass. Leverage the pyodbc module for ODBC in Python.
-
Connect to Salesforce Marketing from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Web applications running on WebLogic.
-
Access Live EnterpriseDB in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for EnterpriseDB to create a EnterpriseDB source in TIBCO Data Virtualization Studio and gain access to live EnterpriseDB from your TDV Server.
-
Create Shopify-Connected Applications in Appsmith
Connect to Shopify via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Shopify.
-
Build a Singer.io Tap for Coinbase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Coinbase data using
-
Automated Continuous eBay Replication to SQLite
Use CData Sync for automated, continuous, customizable eBay replication to SQLite.
-
Prepare, Blend, and Analyze Zuora in Alteryx Designer (ODBC)
Build workflows to access live Zuora for self-service data analytics.
-
DataBind Controls to OneNote in Delphi
DataBind to Microsoft OneNote in Delphi with standard data access components and controls.
-
Create Data Visualizations in Cognos BI with Twilio
Access Twilio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Sugar CRM from Node.js
Use the OData endpoint of the CData API Server to connect to your Sugar CRM and perform CRUD operations on Sugar CRM from Node.js.
-
Automated Continuous SAP Business One Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Business One replication to Apache Kafka.
-
Visualize EventBrite in TIBCO Spotfire through OData
Integrate Eventbrite into dashboards in TIBCO Spotfire.
-
Analyze Zoho Inventory in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Zoho Inventory and visualize Zoho Inventory in SAP Analytics Cloud.
-
Import and Visualize Google Sheets in Power View
Create data visualizations based on Google Sheets in Excel.
-
Integrate with PayPal in JReport Designer
Create charts and reports based on PayPal in JReport Designer.
-
How to work with IBM Cloud Object Storage in Apache Spark using SQL
Access and process IBM Cloud Object Storage in Apache Spark using the CData Software JDBC Driver.
-
Bidirectional Access to Jira Service Management from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Atlassian Jira Service Management in Filemaker Pro for Mac or Windows.
-
How to integrate Metabase with Reckon Accounts Hosted
Use CData Connect Cloud to connect to live Reckon Accounts Hosted and create an interactive dashboard in Metabase from Reckon Accounts Hosted.
-
Automated Continuous Vault CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Vault CRM replication to SQLite.
-
Connect to Act-On in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Act-On and connect to Act-On in Akorbi Digital RunMyProcess.
-
How to Access Live SAP SuccessFactors in Visual Studio Code via Cline
Run the CData MCP Server for SAP SuccessFactors on Windows Subsytem for Linux (WSL) and connect to live SAP SuccessFactors from the Cline extension in Visual Studio Code.
-
Access Live Couchbase in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Couchbase into the statistical analysis tools available in SAS JMP. This article shows how to use Couchbase in the Graph Builder and Query Builder.
-
Connect to Salesforce Marketing as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Marketing Cloud.
-
Build Visualizations of Workday in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Workday in Birst.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Web
Connect to SFTP in MicroStrategy Web using the CData Software JDBC Driver for SFTP.
-
Access Live Azure Synapse in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Synapse from your Google Sheets.
-
View Reports on Real-Time ClickUp in Power BI Report Server
Use the CData ODBC Driver for ClickUp to visualize ClickUp in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Create Power BI Visual Reports with Real-Time Azure Data Catalog
Use CData Power BI Connectors to visualize Azure Data Catalog in Power BI.
-
Edit and Search External Sage Cloud Accounting Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Sage Business Cloud Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sage Cloud Accounting objects that you can access from apps and the dashboard.
-
Enable the Okta JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Okta.
-
How to Access Spark Using Entity Framework
This article shows how to access Apache Spark SQL using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Access CouchDB Using Entity Framework
This article shows how to access Apache CouchDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query IBM Informix from Node.js
Use the OData endpoint of the CData API Server to connect to your IBM Informix and perform CRUD operations on IBM Informix from Node.js.
-
Connect to Power BI XMLA from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Power BI XMLA, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Yahoo! Japan Data Solution-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Yahoo! Japan Data Solution and create custom apps in Mendix.
-
Visualize Jira Assets in Sisense
Create an ElastiCube in Sisense app with access to Jira Assets.
-
Integrate HCL Domino in the Pentaho Report Designer
Publish reports based on HCL Domino in the Pentaho BI tool.
-
Analyze Dynamics NAV in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Dynamics NAV with the CData JDBC Driver for Dynamics NAV.
-
How to pipe Azure Data Catalog to CSV in PowerShell
Use standard PowerShell cmdlets to access Azure Data Catalog tables.
-
Extract, Transform, and Load Dropbox in Informatica PowerCenter
Create a simple Workflow for Dropbox in Informatica PowerCenter.
-
Build Microsoft Project-Connected Apps in Bubble
Use CData Connect Cloud to create an OData feed for Microsoft Project and create custom apps in Bubble.
-
Trigger Freshdesk IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Visualize Live Facebook in the Power BI Service
Use CData Connect Cloud to connect to live Facebook and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Live Snowflake in Power Automate Desktop via ODBC
The CData ODBC Driver for Snowflake enables you to integrate Snowflake into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Source
Create an ODBC connection to SAP Ariba Source in Informatica and browse and transfer SAP Ariba Source.
-
Query MariaDB through ODBC in Node.js
Use node-odbc to execute SQL queries against MariaDB from Node.js.
-
Query Redshift in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Redshift.
-
Create Reports with Microsoft OneDrive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneDrive.
-
Validate SAP Ariba Source with QuerySurge
Access and validate SAP Ariba Source in QuerySurge using the CData JDBC Driver.
-
Natively Connect to Azure Data Catalog in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Catalog. Leverage the native support for ODBC in PHP.
-
LINQ to Twitter Ads
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Twitter Ads Data Provider.
-
Automated Continuous Google Contacts Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Google Contacts replication to Microsoft Access.
-
Connect to Real-Time Drift Data in Power Apps Using Dataflows to Build Custom Applications
-