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
-
Connect to Kintone from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Kintone, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Biml to Build SSIS Tasks to Replicate eBay to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate eBay to SQL Server.
-
Visualize Live Google Ad Manager in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Ad Manager.
-
Microsoft Planner Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Planner through CData Connect Cloud using different applications and tools.
-
Automated Continuous Sage 300 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage 300 replication to SingleStore.
-
Consume Dynamics 365 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 feeds that reflect any changes in SAP Lumira.
-
Integrate Live CockroachDB into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to CockroachDB and integrate live CockroachDB into apps built in Microsoft Power Apps.
-
Query Salesforce Marketing through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesforce Marketing Cloud from Node.js.
-
How to connect to SAP Fieldglass with Squirrel SQL client
Connect to SAP Fieldglass and execute queries in the Squirrel SQL Client.
-
Consume Facebook Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Facebook Ads as OData feeds from PowerBuilder using the API Server.
-
Migrating data from Redshift to Google BigQuery using CData SSIS Components.
Easily push Amazon Redshift to Google BigQuery using the CData SSIS Tasks for Redshift and Google BigQuery.
-
Connect to Jira Service Management in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to CSV in Jaspersoft Studio
Execute SQL to remote CSV/TSV Files in Jaspersoft Studio.
-
How to Work with Avalara AvaTax in AWS Glue Jobs Using JDBC
Connect to Avalara AvaTax from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ClickUp from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ClickUp using standard SQL.
-
Build Box-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Box.
-
Access Live Excel Online in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Excel spreadsheets.
-
Edit and Search External Presto Objects in Salesforce Connect
Use CData Connect Cloud to securely provide OData feeds of Presto to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Presto objects that you can access from apps and the dashboard.
-
Automate Outreach.io Replication to Couchbase
Use CData Sync to Customize and automate Outreach.io replication to Couchbase.
-
Natively Connect to Dropbox in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dropbox. Leverage the native support for ODBC in PHP.
-
Connect to and Query Azure Active Directory in QlikView over ODBC
Create data visualizations with Azure Active Directory in QlikView.
-
Automated Continuous Microsoft Planner Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Google Cloud SQL.
-
Create Dynamic Clio Grids Using the Infragistics XamDataGrid
Learn how you can connect Clio to Infragistics XamDataGrid to build dynamic grids.
-
How to Build an ETL App for QuickBooks in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Desktop in Python with petl.
-
Import Real-Time SAP Hybris C4C via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Hybris C4C in ColdFusion.
-
Connect to Paylocity in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Paylocity in Google Apps Script.
-
Explore Geographical Relationships in Cvent with Power Map
Create data visualizations with Cvent in Power Map.
-
Connect to Adobe Commerce in NetBeans
Connect to Adobe Commerce in NetBeans with the data source configuration wizard.
-
Automated Continuous Harvest Replication to SingleStore
Use CData Sync for automated, continuous, customizable Harvest replication to SingleStore.
-
How to connect to Twitter Ads from Spring Boot
Connect to Twitter Ads in a Spring Boot Application using CData JDBC Twitter Ads Driver
-
Import WooCommerce Using Azure Data Factory
Use CData Connect Cloud to connect to WooCommerce from Azure Data Factory and import live WooCommerce.
-
Automated Continuous Exact Online Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Exact Online replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for SAS Data Sets in SAS for Real-Time Reporting and Analytics
Connect to real-time SAS Data Sets in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAS Data Sets.
-
Access Live Presto in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Presto from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Dynamics CRM in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Reports with OneNote in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.
-
How to publish and share SAP Ariba Procurement dashboards with Tableau Server
The CData ODBC driver for SAP Ariba Procurement enables you integrate SAP Ariba Procurement into Tableau dashboards.
-
Query Clio in ColdFusion
Write standard ColdFusion data access code to connect to Clio.
-
How to Connect DBeaver to eBay Analytics via a JDBC Driver
Manage eBay Analytics with visual tools in DBeaver like the query browser.
-
How to Connect to & Open Pipedrive in Microsoft Excel
This article uses the CData ODBC driver for Pipedrive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Google Analytics Replication to Azure Data Lake
Use CData Sync to customize and automate Google Analytics replication to Azure Data Lake.
-
Connect to Yahoo! Ads in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Yahoo! Ads in Google Apps Script.
-
Rapidly Develop Salesloft-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.
-
Automated Oracle HCM Cloud Replication to Teradata
Use CData Sync to Customize and automate Oracle HCM Cloud replication to Teradata.
-
Deploy the ADO.NET Provider for Sugar CRM on an SSRS Report Server
Connect to Sugar CRM from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to SurveyMonkey in Aqua Data Studio
Access SurveyMonkey from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bind Live Cosmos DB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cosmos DB data
-
Automate SAP Ariba Source Replication to Couchbase
Use CData Sync to Customize and automate SAP Ariba Source replication to Couchbase.
-
Access Live Smartsheet in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smartsheet from your Excel spreadsheets.
-
How to Access Live Adobe Target in Visual Studio Code via Cline
Run the CData MCP Server for Adobe Target on Windows Subsytem for Linux (WSL) and connect to live Adobe Target from the Cline extension in Visual Studio Code.
-
How to create an RPA flow for Avalara AvaTax in UiPath Studio
Use the Avalara AvaTax ODBC Driver to create workflows that access real-time Avalara AvaTax without any coding.
-
Integrate with HubDB in JReport Designer
Create charts and reports based on HubDB in JReport Designer.
-
Connect to Access from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Access from Appeon PowerBuilder using the CData ADO.NET Provider for Access.
-
Write a Simple Go Application to work with Marketo on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Marketo.
-
Connect to Google Sheets in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Sheets in the Denodo Virtual DataPort Administrator.
-
Deploy the ADO.NET Provider for Amazon Marketplace on an SSRS Report Server
Connect to Amazon Marketplace from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Stripe Visualizations in Tableau Cloud
Use CData Connect Cloud to connect to live Stripe and build visualizations in Tableau Cloud.
-
Import HDFS into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache HDFS. In this article, you will use the OData format to import Apache HDFS into Microsoft Power Query.
-
Connect to Live Marketo in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Marketo in CData Connect Cloud and connect to your Marketo from PostgreSQL.
-
Excel Spreadsheet Automation on Vault CRM with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Apps with Live Clio Using the Low-Code Development Platform of Mendix
-