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
-
Import Real-Time Microsoft Exchange in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Exchange in ColdFusion.
-
Analyze Excel Online with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Excel Online from Power Pivot. You will use the Table Import Wizard to load Microsoft Excel Online. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Google Campaign Manager 360 with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Campaign Manager 360 from Power Pivot. You will use the Table Import Wizard to load Google Campaign Manager 360. You can visually build the import query or use any SQL supported by the driver.
-
Query BigCommerce in DataGrip
Create a Data Source for BigCommerce in DataGrip and use SQL to query live BigCommerce.
-
Build Workday-Connected Apps in Choreo
Use CData Connect Cloud to connect to Workday from Choreo and build custom apps using live Workday.
-
Use JayDeBeApi to access Todoist in Python
Use standard Python scripting and the development environment of your choice to access live Todoist.
-
Integrate Raisers Edge NXT into Automated Tasks with Power Automate
Use CData Connect Cloud to connect to Raisers Edge NXT and integrate live Raisers Edge NXT into your Power Automate tasks.
-
Deploy the ADO.NET Provider for Unbounce on an SSRS Report Server
Connect to Unbounce 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.
-
Use CData Connect Cloud to Access SAP Concur in Microsoft Power Pivot
Use CData Connect Cloud to connect to live SAP Concur in the Power Pivot business intelligence tool.
-
Integrate Live Teradata into Custom Business Apps Built in Power Apps
Use CData Software Connect Server to create a virtual SQL Server Database for Teradata and integrate live Teradata into apps built in Microsoft Power Apps.
-
Access Live Unbounce in AWS Lambda
Connect to live Unbounce in AWS Lambda using the CData JDBC Driver.
-
Connect to CouchDB from a Connection Pool in Jetty
The CouchDB JDBC Driver supports connection pooling: This article shows how to connect faster to Apache CouchDB from Web apps in Jetty.
-
Automated Aha Replication to Teradata
Use CData Sync to Customize and automate Aha! replication to Teradata.
-
How to integrate SendGrid with Apache Airflow
Access and process SendGrid in Apache Airflow using the CData JDBC Driver.
-
Connect to Asana from a Connection Pool in WebLogic
Use the CData JDBC Driver for Asana to connect to Asana from Web applications running on WebLogic.
-
Publish Crystal Reports on Procore
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Procore.
-
Analyze SAP in SAP Analytics Cloud
Use the CData Connect Server to create an OData API on top of SAP ERP/NetWeaver and visualize SAP ERP/NetWeaver in SAP Analytics Cloud.
-
How to connect to Jira with Squirrel SQL client
Connect to Atlassian Jira and execute queries in the Squirrel SQL Client.
-
How to Connect to & Open SQL Server in Microsoft Excel
This article uses the CData ODBC driver for SQL Server to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Prepare, Blend, and Analyze MongoDB in Alteryx Designer
Build workflows to access live MongoDB for self-service data analytics.
-
Analyze Aha with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aha from Power Pivot. You will use the Table Import Wizard to load Aha!. You can visually build the import query or use any SQL supported by the driver.
-
Extract, Transform, and Load Dynamics GP in Informatica PowerCenter
Create a simple Workflow for Microsoft Dynamics GP in Informatica PowerCenter.
-
How to Connect to Monday.com in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Monday.com. Leverage the pyodbc module for ODBC in Python.
-
How to Query Email in MySQL Workbench
Execute MySQL queries against live Email from MySQL Workbench.
-
Automated Continuous CSV Replication to SingleStore
Use CData Sync for automated, continuous, customizable CSV replication to SingleStore.
-
Connect to Instagram from HeidiSQL
Use CData Connect Cloud to connect to and query live Instagram from HeidiSQL.
-
Integrate with Dynamics NAV using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Dynamics NAV to a JSON file on disk.
-
Perform Batch Operations with QuickBooks Online in Apache NiFi
Connect to QuickBooks Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live eBay into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to eBay from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live eBay.
-
Query OData Services through ODBC in Node.js
Use node-odbc to execute SQL queries against OData from Node.js.
-
Connect to BigQuery 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 Google BigQuery.
-
Connect to and Visualize Live Dynamics GP in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics GP.
-
Perform Batch Operations with Splunk in Apache NiFi
Connect to Splunk and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
ClickUp Reporting in OBIEE with the ClickUp JDBC Driver
Deploy the ClickUp JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous CouchDB Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable CouchDB replication to Microsoft Access.
-
How to Access Live Slack in Power Automate Desktop via ODBC
The CData ODBC Driver for Slack enables you to integrate Slack into workflows built using Microsoft Power Automate Desktop.
-
Replicate Airtable to Multiple Databases
Replicate Airtable to disparate databases with a point-and-click configuration.
-
Import Oracle Service Cloud into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to Oracle Service Cloud and provide access to live Oracle Service Cloud for custom reports in the Power BI Service.
-
Create Dynamic SAP Fieldglass Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Fieldglass to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Highrise Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Highrise replication to AlloyDB.
-
Access Live EventBrite in AWS Lambda (with IntelliJ IDEA)
Connect to live Eventbrite in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous SendGrid Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SendGrid replication to Apache Cassandra.
-
Automated Continuous TaxJar Replication to Azure SQL
Use CData Sync for automated, continuous, customizable TaxJar replication to Azure SQL.
-
Access Live Shopify in Google Sheets
Use CData Connect Cloud to gain access to live Shopify from your Google Sheets.
-
Access Sage Cloud Accounting from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
How to connect to xBase from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for xBase and work with xBase in Microsoft Excel on Mac OS X.
-
Build Semantic Layer Views for Sage Cloud Accounting in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Sage Business Cloud Accounting.
-
Build Zoom-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for Zoom and build visualizations and dashbaords from Zoom in Redash.
-
Automated Continuous Odoo Replication to Databricks
Use CData Sync for automated, continuous, customizable Odoo replication to Databricks.
-
Build Microsoft Teams-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Teams.
-
Visualize MySQL in Tableau Desktop (through CData Connect)
Create a virtual SQL Server database for MySQL in CData Software Connect (or Connect Server) and build visualizations from live MySQL in Tableau Desktop.
-
Natively Connect to Presto in PHP
The CData ODBC driver for Presto enables you to create PHP applications with connectivity to Presto. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for FHIR in PyCharm
Connect to FHIR as an ODBC data source in PyCharm using the CData Software ODBC Driver for FHIR.
-
Connect to Bing Ads in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Real-Time Access to Zoom in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoom in real time.
-
Query Google Spanner through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Spanner from Node.js.
-
How to create Azure Data Catalog federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Catalog in MySQL .
-
Replicate Freshdesk to Multiple Databases
Replicate Freshdesk to disparate databases with a single configuration.
-
Automated Continuous Acumatica Replication to Vertica
Use CData Sync for automated, continuous, customizable Acumatica replication to Vertica.
-
Build Semantic Layer Views for Couchbase in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Couchbase.
-
Connect to Cloudant as a Linked Server
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloudant.
-
Use CData Connect Cloud to Access Workday in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Workday in the Power Pivot business intelligence tool.
-
How to pipe Oracle SCM to CSV in PowerShell
Use standard PowerShell cmdlets to access Oracle SCM tables.
-
Visualize Live Google Search Results of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Search using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Charts with Highrise in Clear Analytics
Create dynamic charts and perform analytics based on Highrise CRM in Clear Analytics.
-
Integrate Live Cosmos DB into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to Cosmos DB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Cosmos DB.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps in MicroStrategy Desktop using the CData Software ODBC Driver for Azure DevOps.
-
How to connect to SAP Hybris C4C in DBVisualizer
Integrate SAP Hybris C4C with visual data analysis tools and data connection wizards in DBVisualizer
-
Prepare, Blend, and Analyze Azure Active Directory in Alteryx Designer
Build workflows to access live Azure Active Directory for self-service data analytics.
-
How to Access Live CSV in Power Automate Desktop via ODBC
The CData ODBC Driver for CSV enables you to integrate CSV/TSV Files into workflows built using Microsoft Power Automate Desktop.
-
Connect to HBase from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for HBase to connect to Apache HBase and execute queries in PowerBuilder.
-
How to integrate ActiveCampaign with Apache Airflow
Access and process ActiveCampaign in Apache Airflow using the CData JDBC Driver.
-
Import Kintone Using Azure Data Factory
Use CData Connect Cloud to connect to Kintone from Azure Data Factory and import live Kintone.
-
How to Build Dynamic React Apps with Microsoft Teams
Use the CData Connect and React to Build Dynamic Web Apps with Live Microsoft Teams .
-
How to connect to QuickBooks from IntelliJ
Integrate connectivity to QuickBooks Desktop with wizards in IntelliJ.
-
Rapidly Develop Confluence-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 Marketo in PHP through Connect Server
Connect to Marketo through the standard SQL Server libraries in PHP.
-
Integrating CockroachDB in Talend Cloud Data Management Platform
-