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
-
Provide OData Services of MariaDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MariaDB by developing a WCF Service Application.
-
Query Shippo in ColdFusion
Write standard ColdFusion data access code to connect to Shippo.
-
Automated Continuous Todoist Replication to Oracle
Use CData Sync for automated, continuous, customizable Todoist replication to Oracle.
-
How to Connect to Live Xero in n8n Workflows and Agents (via CData Connect Cloud)
Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Xero Accounting for you.
-
Access Live MariaDB in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for MariaDB to create a MariaDB source in TIBCO Data Virtualization Studio and gain access to live MariaDB from your TDV Server.
-
Connect to Oracle HCM Cloud from HeidiSQL
Use CData Connect Cloud to connect to and query live Oracle HCM Cloud from HeidiSQL.
-
Automated Continuous eBay Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable eBay replication to Apache Cassandra.
-
Access Live Bing Ads in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bing Ads into the statistical analysis tools available in SAS JMP. This article shows how to use Bing Ads in the Graph Builder and Query Builder.
-
Connect to Power BI XMLA in DBArtisan
Use wizards in DBArtisan to configure Power BI XMLA as a data source.
-
Connect to Shippo in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Confluence as a MySQL Database in Node.js
Execute MySQL queries against Atlassian Confluence from Node.js.
-
Integrate Real-Time Access to Oracle Eloqua in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Eloqua in real time.
-
Create JDBC-ODBC Bridge Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JDBC-ODBC Bridge data access from reports, embedded analytics, and more.
-
Integrate Act CRM in Pentaho Data Integration
Build ETL pipelines based on Act CRM in the Pentaho Data Integration tool.
-
Extend Google Sheets with Instagram
Make calls to the API Server from Google Apps Script.
-
Back Up SAP HANA XS Advanced to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP HANA XS Advanced. In this article, we will employ an SSIS workflow to populate a database with SAP HANA XS Advanced data.
-
Create Zoho Projects-Connected Applications in Appsmith
Connect to Zoho Projects via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Zoho Projects.
-
Connect to Stripe in Aqua Data Studio
Access Stripe from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access Zuora in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zuora.
-
Create MailChimp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailChimp data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with MySQL Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MySQL into a Java-based ORM framework, Hibernate.
-
Build SAP Ariba Source-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live SAP Ariba Source and build SAP Ariba Source-connected web apps with Axios.
-
How to Connect to QuickBooks Time in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Time. Leverage the pyodbc module for ODBC in Python.
-
Back Up LinkedIn Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn Ads. In this article, we will employ an SSIS workflow to populate a database with LinkedIn Ads data.
-
Visualize Exact Online in TIBCO Spotfire through OData
Integrate Exact Online into dashboards in TIBCO Spotfire.
-
Query Quickbase as a SQL Server Database in Node.js
Execute SQL Server queries against Quickbase from Node.js.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Teams.
-
Connect to and Visualize Live DB2 in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM DB2.
-
How to Connect to & Open ADP in Microsoft Excel
This article uses the CData ODBC driver for ADP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Work with Outreach.io in AWS Glue Jobs Using JDBC
Connect to Outreach.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Salesforce Marketing in Airbyte ELT Pipelines
Use CData Connect Cloud to build ELT pipelines for Salesforce Marketing Cloud in Airbyte.
-
How to Work with REST in AWS Glue Jobs Using JDBC
Connect to REST from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Crystal Reports on Drift
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Drift.
-
Automate Couchbase Replication to Couchbase
Use CData Sync to Customize and automate Couchbase replication to Couchbase.
-
Create Datasets from Aha in Domo Workbench and Build Visualizations of Aha in Domo
Use the CData Software ODBC Driver for Aha to create datasets from Aha! in Domo Workbench and then build visualizations in the Domo service.
-
Query Elasticsearch in ColdFusion
Write standard ColdFusion data access code to connect to Elasticsearch.
-
Build a Simple VCL Application for REST
How to build a simple VCL Application to view REST in RAD Studio using the CData ODBC Driver for REST.
-
How to Work with Dynamics 365 in AWS Glue Jobs Using JDBC
Connect to Dynamics 365 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Data Visualizations in Cognos BI with XML
Access XML Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Okta from PowerBuilder via JDBC
This article demonstrates how to access Okta from PowerBuilder using the Okta JDBC Driver.
-
How to Access Oracle Eloqua Using Entity Framework
This article shows how to access Oracle Eloqua using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Power BI Reports on Real-Time Drip
Use the CData ODBC Driver for Drip to visualize Drip in Power BI Desktop.
-
Access Tableau CRM Analytics from MySQL in Amazon QuickSight
Connect to Tableau CRM Analytics and build visualizations of Tableau CRM Analytics using a MySQL Connection in Amazon QuickSight.
-
Connect to Acumatica in Jaspersoft Studio
Execute SQL to remote Acumatica ERP in Jaspersoft Studio.
-
Publish Google Spanner-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Spanner.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online
Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.
-
Back Up Microsoft Excel to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel data.
-
Integrate WooCommerce into Power Automate Desktop using CData Connect
CData Connect for WooCommerce enables you to integrate WooCommerce into workflows built using Microsoft Power Automate Desktop.
-
Create Google Ads-Connected Applications in Appsmith
Connect to Google Ads via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Google Ads.
-
Import Real-Time Zoho Projects via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Projects in ColdFusion.
-
Connect to SharePoint in SpagoBI
Create reports featuring live Microsoft SharePoint in SpagoBI Studio. Host SharePoint reports on SpagoBI Server.
-
How to create EventBrite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Eventbrite in MySQL .
-
Extract, Transform, and Load SAP BusinessObjects BI in Informatica PowerCenter
Create a simple Workflow for SAP BusinessObjects BI in Informatica PowerCenter.
-
Build Visualizations of SAP Ariba Procurement in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Ariba Procurement in Birst.
-
Import Asana Using Azure Data Factory
Use CData Connect Cloud to connect to Asana from Azure Data Factory and import live Asana.
-
Connect to Sage Cloud Accounting Using the Script Function in Claris FileMaker Pro
-
