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
-
Access Live SQL Analysis Services in Coginiti Pro
Connect to and query live SQL Analysis Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAP Ariba Source in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for SAP Ariba Source in Airbyte.
-
Build Databricks-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live Databricks and build Databricks-connected web apps with Axios.
-
Build MVC Applications with Connectivity to Calendly
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Calendly from an ASP.NET MVC application.
-
Connect to Backlog from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live Backlog from Filemaker Pro on Mac.
-
Automated Continuous Paylocity Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paylocity replication to OneLake in Microsoft Fabric.
-
Connect to Avro in Jaspersoft Studio
Execute SQL to remote Apache Avro in Jaspersoft Studio.
-
DataBind Charts to Act-On
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Act-On from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build a PostgreSQL Interface for SAP Business One using the CData JDBC Driver
Use the Remoting features of the SAP Business One JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import FHIR Using Azure Data Factory
Use CData Connect Cloud to connect to FHIR from Azure Data Factory and import live FHIR.
-
How to Connect DBeaver to Stripe via a JDBC Driver
Manage Stripe with visual tools in DBeaver like the query browser.
-
Connect to SAP SuccessFactors from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP SuccessFactors, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Time
Use CData Power BI Connectors to visualize QuickBooks Time in Power BI.
-
Automated Continuous Snapchat Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to AlloyDB.
-
Connect to Stripe from PowerBuilder via JDBC
This article demonstrates how to access Stripe from PowerBuilder using the Stripe JDBC Driver.
-
Create Reports from MongoDB in Looker Studio
Use CData Connect Cloud to gain access to live MongoDB and create custom reports in Looker Studio.
-
Using the CData Software ODBC Driver for Google Search in PyCharm
Connect to Google Search as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Search.
-
Connect and Visualize Live Bing Ads Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Bing Ads into the Databricks platform and create visualization dashboards with real-time Bing Ads.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for SQL Analysis Services.
-
Using the CData Software ODBC Driver for Wave Financial in PyCharm
Connect to Wave Financial as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wave Financial.
-
Build an OLAP Cube in SSAS from OData Services
Establish a connection to OData data from SQL Server Analysis Services, and use the OData Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect and process ServiceNow from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ServiceNow.
-
How to connect to Amazon Marketplace with Squirrel SQL client
Connect to Amazon Marketplace and execute queries in the Squirrel SQL Client.
-
Create Microsoft Project-Connected Nintex Workflows
Use CData Connect Cloud to connect to Microsoft Project from Nintex Workflow Cloud and build custom workflows using live Microsoft Project.
-
Connect to Cosmos DB in DBArtisan
Use wizards in DBArtisan to configure Azure Cosmos DB as a data source.
-
Import and Visualize LinkedIn in Power View
Create data visualizations based on LinkedIn in Excel.
-
Visualize Wave Financial in TIBCO Spotfire through ADO.NET
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Connect to Cvent in NetBeans
Connect to Cvent in NetBeans with the data source configuration wizard.
-
How to integrate Azure Synapse with Apache Airflow
Access and process Azure Synapse in Apache Airflow using the CData JDBC Driver.
-
Build Pipelines with Live Freshdesk in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to Freshdesk from Google Cloud Data Fusion, enabling the integration of live Freshdesk into the building and management of effective data pipelines.
-
Connect to Aha in Jaspersoft Studio
Execute SQL to remote Aha! in Jaspersoft Studio.
-
Analyze Avro with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avro from Power Pivot. You will use the Table Import Wizard to load Apache Avro. You can visually build the import query or use any SQL supported by the driver.
-
How to create an RPA flow for Monday.com in UiPath Studio
Use the Monday.com ODBC Driver to create workflows that access real-time Monday.com without any coding.
-
Connect and Visualize Live Workday Data in Databricks Lakehouse Federation with CData Connect Cloud
Use CData Connect Cloud to integrate live Workday into the Databricks platform and create visualization dashboards with real-time Workday.
-
Use the CData API Server to Access Kintone in Microsoft PowerPivot
Use the CData API Server to connect to live Kintone in the Power Pivot business intelligence tool.
-
Analyze Office 365 in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Office 365 with the CData JDBC Driver for Office 365.
-
How to update Dynamics CRM from Excel
This article explains how to transfer data from Excel to Dynamics CRM using the Excel Add-In for Dynamics CRM.
-
Integrate with Coinbase using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Coinbase to a JSON file on disk.
-
How to Access Marketo Using Entity Framework
This article shows how to access Marketo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Procore from a Connection Pool in WebLogic
Use the CData JDBC Driver for Procore to connect to Procore from Web applications running on WebLogic.
-
Automated Continuous Smartsheet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Smartsheet replication to Snowflake.
-
How to Connect to & Open CouchDB in Microsoft Excel
This article uses the CData ODBC driver for CouchDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Live MYOB AccountRight in Claude Desktop
Connect to and query live MYOB AccountRight in Claude Desktop using the CData MCP Server.
-
Feed Excel into FineReport
How to set Microsoft Excel as a JDBC data source in FineReport.
-
Connect to SAP Business One in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access SAP Business One in Google Apps Script.
-
Connect to Cassandra from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cassandra to connect to Apache Cassandra from Web applications running on WebLogic.
-
How to connect to Dropbox from IntelliJ
Integrate connectivity to Dropbox with wizards in IntelliJ.
-
Automated Continuous Raisers Edge NXT Replication to Oracle
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Oracle.
-
Use the CData ODBC Driver for Spark in Microsoft Power Query
You can use the CData Spark ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Spark SQL into Microsoft Power Query.
-
Query Sugar CRM in ColdFusion
Write standard ColdFusion data access code to connect to Sugar CRM.
-
Creating Dynamics CRM-Connected Applications in Unqork
You can use CData Connect Cloud to feed Microsoft Dynamics CRM to Unqork and build custom business apps.
-
Build Automated IBM Informix-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live IBM Informix and build automated workflows in Zapier.
-
Use Claude to Talk to Your ADP via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your ADP for you.
-
Connect to Jira Assets in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jira Assets in the Denodo Virtual DataPort Administrator.
-
Migrating data from ShipStation to Snowflake using CData SSIS Components.
Easily push ShipStation to Snowflake using the CData SSIS Tasks for ShipStation and Snowflake.
-
Replicate Google Ads in Heroku for Use in Salesforce Connect
Replicate Google Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Claude to Talk to Your Oracle Financials Cloud via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Oracle Financials Cloud for you.
-
Automated Continuous Couchbase Replication to SQLite
Use CData Sync for automated, continuous, customizable Couchbase replication to SQLite.
-
Connect to Live Oracle Eloqua in MicroStrategy through CData Connect Cloud
Create a live connection to Oracle Eloqua in CData Connect Cloud and connect to your Oracle Eloqua from MicroStrategy.
-
Create Dynamic HCL Domino Grids Using the Infragistics XamDataGrid
Learn how you can connect HCL Domino to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Monday.com in Heroku for Use in Salesforce Connect
Replicate Monday.com to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Live Jira Service Management in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Jira Service Management in CData Connect Cloud and connect to your Atlassian Jira Service Management from PostgreSQL.
-
Connect to Outreach.io in JRuby
Create a simple JRuby app with access to live Outreach.io.
-
Establish a Live Connection with SAP Ariba Procurement using Tableau Bridge
The CData ODBC Driver for SAP Ariba Procurement enables you to integrate live SAP Ariba Procurement into Tableau Cloud dashboards using the Tableau Bridge.
-
View Reports on Real-Time Azure Data Lake Storage in Power BI Report Server
Use the CData ODBC Driver for Azure Data Lake Storage to visualize Azure Data Lake Storage in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Confluence-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Atlassian Confluence and build web apps with connectivity to live Atlassian Confluence.
-
PowerShell Scripting to Replicate Invoiced to MySQL
Write a simple PowerShell script to replicate Invoiced to a MySQL database.
-
Automated Continuous SAP Fieldglass Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Databricks.
-
Build Semantic Layer Views for SAS xpt in APOS Live Data Gateway
Use the CData Connector for SAS xpt in APOS Live Data Gateway to build Semantic Layer Views for SAS XPORT.
-
Integrate with Tally in JReport Designer
Create charts and reports based on Tally ERP in JReport Designer.
-
Process & Analyze Google Cloud Storage in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage .
-
Connect to and Query Azure Table in QlikView over ODBC
Create data visualizations with Azure Table Storage in QlikView.
-
Connect to Jira in DBArtisan
Use wizards in DBArtisan to configure Atlassian Jira as a data source.
-
Extract, Transform, and Load Cvent in Informatica PowerCenter
Create a simple Workflow for Cvent in Informatica PowerCenter.
-
Bind Live OData Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live OData data
-
Build Automated Workflows with Live Sage Cloud Accounting in Workato
Use CData Connect Cloud to connect to live Sage Business Cloud Accounting and build automated workflows in Workato.
-
Rapidly Develop Okta-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.
-
Access Live WooCommerce in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live WooCommerce from your Excel spreadsheets.
-
How to create Visio diagrams from Redis
Automatically update Redis with the changes you make to Visio master shapes.
-
How to Easily Query Google Drive in OpenOffice Base
-