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 eBay from a Connection Pool in Jetty
The eBay JDBC Driver supports connection pooling: This article shows how to connect faster to eBay from Web apps in Jetty.
-
Excel Spreadsheet Automation on Odoo with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Sales Records from SQL Server
Easily push SQL Server data to Oracle Sales using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle Sales or update existing records with data from a SQL Server database.
-
Import Real-Time Bullhorn CRM via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bullhorn CRM in ColdFusion.
-
Integrate with Facebook in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Facebook in SnapLogic.
-
Integrate with Google Campaign Manager 360 using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Campaign Manager 360 to a JSON file on disk.
-
Use Dash to Build to Web Apps on SAP HANA
Create Python applications that use pandas and Dash to build SAP HANA-connected web apps.
-
How to Connect to & Open Oracle HCM Cloud in Microsoft Excel
This article uses the CData ODBC driver for Oracle HCM Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to BigCommerce in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for BigCommerce and connect to BigCommerce in Akorbi Digital RunMyProcess.
-
Connect to Drift as an External Source in Dremio
Use the CData JDBC Driver to connect to Drift as an External Source in Dremio.
-
How to Access Live Sage 200 in Visual Studio Code via Cline
Run the CData MCP Server for Sage 200 on Windows Subsytem for Linux (WSL) and connect to live Sage 200 from the Cline extension in Visual Studio Code.
-
Rapidly Develop Box-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.
-
Connect to and Visualize Live Oracle Service Cloud in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Service Cloud.
-
How to Design Reckon Accounts Hosted Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Visualize Live Avro in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Avro.
-
Replicate MySQL to Multiple Databases
Replicate MySQL to disparate databases with a point-and-click configuration.
-
Connect to FTP from PowerBuilder via JDBC
This article demonstrates how to access FTP Servers from PowerBuilder using the FTP JDBC Driver.
-
Build a PostgreSQL Interface for ADP using the CData JDBC Driver
Use the Remoting features of the ADP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Asana with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SAP from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP ERP/NetWeaver using standard SQL.
-
Connect to and Visualize Live SAP in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP ERP/NetWeaver.
-
Visualize Live MarkLogic in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MarkLogic.
-
ETL Tally in Oracle Data Integrator
This article shows how to transfer Tally ERP into a data warehouse using Oracle Data Integrator.
-
Viewing Google Search Results in RAD Studio Data Explorer
How to view Google Search in RAD Studio Data Explorer using the CData ODBC Driver for Google Search.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Contacts
Provide connectivity to Google Contacts through an SAP BusinessObjects universe.
-
Feed Google Spanner into FineReport
How to set Google Spanner as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for Microsoft Dataverse in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Dataverse (CDS) in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Dataverse.
-
Natively Connect to WooCommerce in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
How to update CouchDB from Excel
This article explains how to transfer data from Excel to CouchDB using the Excel Add-In for CouchDB.
-
Automated Continuous xBase Replication to MongoDB
Use CData Sync for automated, continuous, customizable xBase replication to MongoDB.
-
Build Data Flows from SQL Server to OneNote through SSIS
Easily push SQL Server data to OneNote using the CData SSIS Tasks for OneNote.
-
Access Square from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Square from HeidiSQL.
-
Replicate Zuora to Multiple Databases via the CData Sync CLI
Replicate Zuora to disparate databases with a single configuration.
-
Integrate Square in Pentaho Data Integration
Build ETL pipelines based on Square in the Pentaho Data Integration tool.
-
Automated Continuous HBase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HBase replication to Amazon S3.
-
Integrate with live Zoho Inventory in Jitterbit
Use CData Connect Cloud to connect to and integrate live Zoho Inventory in Jitterbit.
-
How to Connect the Power BI Service to SAP BusinessObjects BI: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Connect TigerGraph to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your TigerGraph using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Claude to Talk to Your API via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your API for you.
-
Connect to Sage 300 in Claris FileMaker Pro
-
