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
-
How to Create Power BI Visual Reports with Real-Time Sage Cloud Accounting
Use CData Power BI Connectors to visualize Sage Business Cloud Accounting in Power BI.
-
Import Reckon into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Reckon. In this article, you will use the OData format to import Reckon into Microsoft Power Query.
-
How to load Kintone data into Elasticsearch via Logstash
Introducing a simple method to load Kintone data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy Web
Connect to DocuSign in MicroStrategy Web using the CData Software ODBC Driver for DocuSign.
-
How to Query Live Cassandra in Claude Desktop
Connect to and query live Cassandra in Claude Desktop using the CData MCP Server.
-
Migrating data from Salesforce Pardot to Google BigQuery using CData SSIS Components.
Easily push Salesforce Pardot to Google BigQuery using the CData SSIS Tasks for Salesforce Pardot and Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time ServiceNow
Use CData Power BI Connectors to visualize ServiceNow in Power BI.
-
Connect Impala to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Impala using the CData Python MCP Server.
-
How to integrate Spark with Apache Airflow
Access and process Apache Spark SQL in Apache Airflow using the CData JDBC Driver.
-
Analyze SurveyMonkey in R via JDBC
Use standard R functions and the development environment of your choice to analyze SurveyMonkey with the CData JDBC Driver for SurveyMonkey.
-
Query Couchbase through ODBC in Node.js
Use node-odbc to execute SQL queries against Couchbase from Node.js.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Data Cloud
Create Salesforce Data Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP ERP/NetWeaver in the Denodo Virtual DataPort Administrator.
-
Publish Reports with YouTube Analytics in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date YouTube Analytics.
-
Create Bullhorn CRM-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Bullhorn CRM from OutSystems and build custom enterprise apps using live Bullhorn CRM.
-
Automated Continuous Instagram Replication to MongoDB
Use CData Sync for automated, continuous, customizable Instagram replication to MongoDB.
-
Connect to Live Facebook Ads in MicroStrategy through CData Connect Cloud
Create a live connection to Facebook Ads in CData Connect Cloud and connect to your Facebook Ads from MicroStrategy.
-
Integrate Paylocity into Power Automate Desktop using CData Connect
CData Connect for Paylocity enables you to integrate Paylocity into workflows built using Microsoft Power Automate Desktop.
-
How to Use a Microsoft Access Database to Update Zoho Creator in Real Time
Update Zoho Creator data by creating a linked table in Microsoft Access with the CData Zoho Creator ODBC Driver.
-
How to connect to QuickBooks from IntelliJ
Integrate connectivity to QuickBooks Desktop with wizards in IntelliJ.
-
Query Sage 200 as a MySQL Database in Node.js
Execute MySQL queries against Sage 200 from Node.js.
-
Replicate Asana from PowerShell
Write a quick PowerShell script to query Asana. Use connectivity to the live data to replicate Asana to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for RSS
Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for NetSuite using the CData ODBC Driver
Use the SQL Gateway and NetSuite ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Pipedrive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.
-
How to Connect DBeaver to Sage 300 via a JDBC Driver
Manage Sage 300 with visual tools in DBeaver like the query browser.
-
Perform Batch Operations with Reckon Accounts Hosted in Apache NiFi
Connect to Reckon Accounts Hosted and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Stream Google Data Catalog into Apache Kafka Topics
Access and stream Google Data Catalog in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Microsoft Dataverse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Snowflake.
-
Automated Continuous SAP Hybris C4C Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to PostgreSQL.
-
Create Power BI Reports on Real-Time SAP Ariba Source
Use the CData ODBC Driver for SAP Ariba Source to visualize SAP Ariba Source in Power BI Desktop.
-
Access Live Impala in Excel (Desktop) via Connect Cloud
Use CData Connect Cloud to gain access to live Apache Impala from your Excel spreadsheets.
-
Access Live LinkedIn Ads in Coginiti Pro
Connect to and query live LinkedIn Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate SFTP from PowerShell
Write a quick PowerShell script to query SFTP. Use connectivity to the live data to replicate SFTP to SQL Server.
-
Bidirectional Access to Epicor Kinetic from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Epicor Kinetic in Filemaker Pro for Mac or Windows.
-
Connect to Microsoft OneDrive from a Connection Pool in JBoss
Integrate Microsoft OneDrive into Java servlets: Use the Management Console in JBoss to install the Microsoft OneDrive JDBC Driver.
-
Connect to SAP Netweaver Gateway from a Connection Pool in Jetty
The SAP Netweaver Gateway JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Netweaver Gateway from Web apps in Jetty.
-
Analyze Splunk in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Splunk and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Query BigQuery using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigQuery entities in PHP by modeling them as objects.
-
How to work with Microsoft Project in Apache Spark using SQL
Access and process Microsoft Project in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time Box
Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop.
-
Create Impala-Connected Dashboards in Grafana
Connect to Impala via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Apache Impala.
-
Replicate Reckon in Heroku for Use in Salesforce Connect
Replicate Reckon to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Microsoft Planner in Pentaho Data Integration
Build ETL pipelines based on Microsoft Planner in the Pentaho Data Integration tool.
-
Publish Reports with Dynamics 365 Business Central in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dynamics 365 Business Central.
-
Replicate SAP Netweaver Gateway to Multiple Databases
Replicate SAP Netweaver Gateway to disparate databases with a point-and-click configuration.
-
LINQ to Active Directory
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Active Directory Data Provider.
-
Create Datasets from Oracle in Domo Workbench and Build Visualizations of Oracle in Domo
Use the CData Software ODBC Driver for Oracle to create datasets from Oracle Database in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with Google Spanner using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Spanner to a JSON file on disk.
-
Object-Relational Mapping (ORM) with Klipfolio 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 Klipfolio into a Java-based ORM framework, Hibernate.
-
A PostgreSQL Interface for Email using the CData ODBC Driver
Use the SQL Gateway and Email ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SAP Ariba Procurement Replication to Azure Synapse
Use CData Sync to customize and automate SAP Ariba Procurement replication to Azure Synapse.
-
Import AlloyDB into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google AlloyDB. In this article, you will use the OData format to import Google AlloyDB into Microsoft Power Query.
-
Establish a Live Connection with GraphQL using Tableau Bridge
The CData ODBC Driver for GraphQL enables you to integrate live GraphQL into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to PostgreSQL from Filemaker Pro (Mac)
Use CData Connect Cloud to connect to and query live PostgreSQL from Filemaker Pro on Mac.
-
DataBind Charts to BigQuery
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google BigQuery 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.
-
Analyze Azure Data Lake Storage in Looker
Use CData Connect Cloud to connect to Azure Data Lake Storage from Looker and build custom apps using live Azure Data Lake Storage.
-
Visualize Live Access of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Access using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to LDAP through SSIS
Easily push SQL Server data to LDAP using the CData SSIS Tasks for LDAP.
-
DataBind Salesloft to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Salesloft with the DevExpress Windows Forms and Web controls to provide Salesloft to a chart.
-
Using the CData Software ODBC Driver for Azure Active Directory in PyCharm
Connect to Azure Active Directory as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Active Directory.
-
Automated Continuous Teradata Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teradata replication to delimited files (CSV/TSV).
-
Connect to SQL Analysis Services in DBArtisan
Use wizards in DBArtisan to configure SQL Analysis Services as a data source.
-
Connect to Workday in DBeaver
Use the CData ODBC Driver to connect to Workday in DBeaver.
-
Access Live Microsoft Teams in TIBCO Data Virtualization
Use the CData Software TIBCO DV Adapter for Microsoft Teams to create a Microsoft Teams source in TIBCO Data Virtualization Studio and gain access to live Microsoft Teams from your TDV Server.
-
Analyze TigerGraph in R via JDBC
Use standard R functions and the development environment of your choice to analyze TigerGraph with the CData JDBC Driver for TigerGraph.
-
Connect to Oracle Eloqua from a Connection Pool in Jetty
The Oracle Eloqua JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Eloqua from Web apps in Jetty.
-
Automated Continuous Tableau CRM Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to PostgreSQL.
-
Automated Continuous Shippo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Shippo replication to Snowflake.
-
Visualize Live Epicor Kinetic of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Epicor Kinetic using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to eBay as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live eBay.
-
Automated Continuous SharePoint Excel Services Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to PostgreSQL.
-
Replicate Multiple IBM Cloud Object Storage Accounts via the CData Sync CLI
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
Connect to Sage 50 UK in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sage 50 UK and the SQL Gateway to access Sage 50 UK from Google Apps Script.
-
Seamlessly Bring NetSuite into Retool Using CData Connect Cloud
Integrate NetSuite data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Connect to Couchbase from a Connection Pool in Jetty
The Couchbase JDBC Driver supports connection pooling: This article shows how to connect faster to Couchbase from Web apps in Jetty.
-
Automated Continuous WordPress Replication to AlloyDB
Use CData Sync for automated, continuous, customizable WordPress replication to AlloyDB.
-
Build a PostgreSQL Interface for Azure Table using the CData JDBC Driver
Use the Remoting features of the Azure Table JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Elasticsearch from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Elasticsearch to connect to Elasticsearch and execute queries in PowerBuilder.
-
Create CSV Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Biml to Build SSIS Tasks to Replicate Slack to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Slack to SQL Server.
-
Import Real-Time Microsoft Teams via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Teams in ColdFusion.
-
Connect to Authorize.Net as an External Source in Dremio
Use the CData JDBC Driver to connect to Authorize.Net as an External Source in Dremio.
-
Build Amazon DynamoDB-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Amazon DynamoDB and create custom apps in Mendix.
-
Use the CData ODBC Driver for Square in Microsoft Power Query
You can use the CData Square ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Square into Microsoft Power Query.
-
Automated Continuous Amazon S3 Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Microsoft Access.
-
How to import Google Search Results into Apache Solr
Use the CData Software JDBC Driver for Google Search in Data Import Handler and create an automated import of Google Search to Apache Solr Enterprise Search platform.
-
Natively Connect to Bitbucket in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bitbucket. Leverage the native support for ODBC in PHP.
-
Connect to Gmail in Claris FileMaker Pro
-