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
-
Natively Connect to Azure Data Lake Storage in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Data Lake Storage. Leverage the native support for ODBC in PHP.
-
Replicate Oracle Financials Cloud in Heroku for Use in Salesforce Connect
Replicate Oracle Financials Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Bridge Salesforce Data Cloud Connectivity with Apache NiFi
Access and process Salesforce Data Cloud in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Greenhouse in a Connection Pool in Tomcat
Connect to Greenhouse from a connection pool in Tomcat.
-
Access SingleStore from MySQL in PHP
Connect to SingleStore through the standard MySQL libraries in PHP.
-
Bridge SAS xpt Connectivity with Apache NiFi
Access and process SAS XPORT in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Google Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Analytics replication to SingleStore.
-
How to Connect DBeaver to Raisers Edge NXT via a JDBC Driver
Manage Raisers Edge NXT with visual tools in DBeaver like the query browser.
-
Use CData Connect Cloud to Access Gmail in Microsoft Power Pivot
Use CData Connect Cloud to connect to live Gmail in the Power Pivot business intelligence tool.
-
Automated Continuous Salesforce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Salesforce replication to AlloyDB.
-
Publish Crystal Reports on Outreach.io
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Outreach.io.
-
Connect to Airtable in HULFT Integrate
Connect to Airtable as a JDBC data source in HULFT Integrate
-
Integrate with SAP using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP ERP/NetWeaver to a JSON file on disk.
-
Analyze Zoho CRM in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho CRM with the CData JDBC Driver for Zoho CRM.
-
How to connect to Authorize.Net from Spring Boot
Connect to Authorize.Net in a Spring Boot Application using CData JDBC Authorize.Net Driver
-
Automated Continuous YouTube Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Apache Kafka.
-
Migrating data from Vault CRM to Snowflake using CData SSIS Components.
Easily push Veeva Vault & Vault CRM to Snowflake using the CData SSIS Tasks for Vault CRM and Snowflake.
-
Connect to Airtable from Asprova with CData Software ODBC Driver for Airtable
This article shows how to connect faster to Airtable data from Asprova.
-
Analyze Acumatica in Cognos Analytics
Use CData Connect Cloud to connect to Acumatica from Cognos Analytics and analyze live Acumatica ERP.
-
Connect to Live SendGrid in PostGresSQL Interface through CData Connect Cloud
Create a live connection to SendGrid in CData Connect Cloud and connect to your SendGrid from PostgreSQL.
-
Automated Continuous CouchDB Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable CouchDB replication to Microsoft Access.
-
How to Import Data from Twitter Ads into Google Sheets
Import Twitter Ads into a Google spreadsheet that is automatically refreshed.
-
Replicate Multiple Aha Accounts
Replicate multiple Aha accounts to one or many databases.
-
How to integrate Metabase with Instagram
Use CData Connect Cloud to connect to live Instagram and create an interactive dashboard in Metabase from Instagram.
-
Import and Visualize SAP HANA XS Advanced in Power View
Create data visualizations based on SAP HANA XS Advanced in Excel.
-
Connect to Office 365 from a Connection Pool in JBoss
Integrate Microsoft Office 365 into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.
-
How to create an RPA flow for SAP HANA in UiPath Studio
Use the SAP HANA ODBC Driver to create workflows that access real-time SAP HANA without any coding.
-
Use Biml to Build SSIS Tasks to Replicate ShipStation to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ShipStation to SQL Server.
-
How to Import Data from Acumatica into Google Sheets
Import Acumatica ERP into a Google spreadsheet that is automatically refreshed.
-
Create Data Visualizations in Cognos BI with Azure Table
Access Azure Table Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Amazon Athena to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Athena using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to integrate Metabase with CockroachDB
Use CData Connect Cloud to connect to live CockroachDB and create an interactive dashboard in Metabase from CockroachDB.
-
Connect to Hive from a Connection Pool in JBoss
Integrate Apache Hive into Java servlets: Use the Management Console in JBoss to install the Hive JDBC Driver.
-
Prepare, Blend, and Analyze Pinterest in Alteryx Designer (ODBC)
Build workflows to access live Pinterest for self-service data analytics.
-
Integrate SAP Hybris C4C in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Hybris C4C from Informatica Cloud.
-
How to Work with Authorize.Net in ETL Validator JDBC
Connect to Authorize.Net from ETL Validator jobs using the CData Software JDBC Driver.
-
Work with Excel in FoxPro
Load Microsoft Excel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Jira in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Atlassian Jira in SnapLogic.
-
Use the CData ODBC Driver for Zoho Projects from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Projects to connect to Zoho Projects from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Projects in Excel.
-
How to connect to Smartsheet from Spring Boot
Connect to Smartsheet in a Spring Boot Application using CData JDBC Smartsheet Driver
-
Model eBay Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and eBay, enabling the direct import of real-time eBay.
-
Use the CData API Server to Access LDAP Objects in Microsoft PowerPivot
Use the CData API Server to connect to live LDAP in the Power Pivot business intelligence tool.
-
Integrate with Google Cloud Storage in JReport Designer
Create charts and reports based on Google Cloud Storage in JReport Designer.
-
DataBind Controls to Todoist in C++Builder
DataBind to Todoist in C++Builder with standard components and controls.
-
How to create an RPA flow for Google Analytics in UiPath Studio
Use the Google Analytics ODBC Driver to create workflows that access real-time Google Analytics without any coding.
-
Build Salesforce Marketing-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Salesforce Marketing from Zoho Analytics and import live Salesforce Marketing Cloud.
-
Edit and Search Google Contacts External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Contacts to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Contacts objects that you can access from apps and the dashboard.
-
How to connect to Reckon from IntelliJ
Integrate connectivity to Reckon with wizards in IntelliJ.
-
How to publish and share MailChimp dashboards with Tableau Server
The CData ODBC driver for MailChimp enables you integrate MailChimp into Tableau dashboards.
-
How to Connect the Power BI Service to Freshdesk: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Natively Connect to Shippo in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Shippo. Leverage the native support for ODBC in PHP.
-
How to Connect the Power BI Service to QuickBooks Time: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Consume Dynamics 365 Business Central OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 Business Central feeds that reflect any changes in SAP Lumira.
-
How to Connect DBeaver to Epicor Kinetic via a JDBC Driver
Manage Epicor Kinetic with visual tools in DBeaver like the query browser.
-
How to pipe Google Cloud Storage to CSV in PowerShell
Use standard PowerShell cmdlets to access Google Cloud Storage tables.
-
Replicate Databricks to Multiple Databases via the CData Sync CLI
Replicate Databricks to disparate databases with a single configuration.
-
Connect to RSS Feeds in the Denodo Platform
Use CData driver technologies to create a virtual data source for RSS Feeds in the Denodo Virtual DataPort Administrator.
-
Connect to Google Drive in DBArtisan
Use wizards in DBArtisan to configure Google Drive as a data source.
-
Replicate Multiple ActiveCampaign Accounts via the CData Sync CLI
Replicate multiple ActiveCampaign accounts to one or many databases.
-
Working with SingleStore in LINQPad
Execute LINQ queries to SingleStore in LINQPad.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
Provide connectivity to SingleStore through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for DocuSign in Microsoft Power Query
You can use the CData DocuSign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import DocuSign into Microsoft Power Query.
-
Building Dynamic Web Pages with HCL Domino Using AngularJS
Create single-page applications with live connectivity to HCL Domino using the CData API Server.
-
Build Visualizations of Square in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Square in Birst.
-
Build MVC Applications with Connectivity to Sage Cloud Accounting
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Cloud Accounting from an ASP.NET MVC application.
-
Access Live HubSpot in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubSpot from your Excel spreadsheets.
-
Analyze Azure Analysis Services in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Analysis Services in Microsoft R Open.
-
Design BIRT Reports on MySQL
Provide current MySQL to your embedded analytics.
-
Connect to Outreach.io in RapidMiner
Integrate Outreach.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Zoom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoom replication to SQL Server.
-
Import Workday Using Azure Data Factory
Use CData Connect Cloud to connect to Workday from Azure Data Factory and import live Workday.
-
How to Access Live Azure Synapse in Visual Studio Code via Cline
Run the CData MCP Server for Azure Synapse on Windows Subsytem for Linux (WSL) and connect to live Azure Synapse from the Cline extension in Visual Studio Code.
-
Connect to Oracle HCM Cloud in RazorSQL
Connect to Oracle HCM Cloud from wizards and query Oracle HCM Cloud from the GUI in the RazorSQL database management tool.
-
Access Live Backlog in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Backlog from your Excel spreadsheets.
-
Create Reports with Google Contacts in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Contacts.
-
Automated Continuous Pinterest Replication to Databricks
Use CData Sync for automated, continuous, customizable Pinterest replication to Databricks.
-
Visualize Zuora in TIBCO Spotfire through ADO.NET
Integrate Zuora into dashboards in TIBCO Spotfire.
-
Query MarkLogic from Node.js
Use the OData endpoint of the CData API Server to connect to your MarkLogic and perform CRUD operations on MarkLogic from Node.js.
-
Viewing CockroachDB in RAD Studio Data Explorer
How to view CockroachDB in RAD Studio Data Explorer using the CData ODBC Driver for CockroachDB.
-
How to connect PolyBase to Cloudant
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Cloudant.
-
Automated Continuous Neo4J Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Neo4J replication to delimited files (CSV/TSV).
-
Access Okta from MySQL in PHP
Connect to Okta through the standard MySQL libraries in PHP.
-
Automated Continuous Zoho Creator Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Oracle.
-
Migrating data from Square to Google BigQuery using CData SSIS Components.
Easily push Square to Google BigQuery using the CData SSIS Tasks for Square and Google BigQuery.
-
Visualize Live Active Directory in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Active Directory.
-
Connect to Reckon in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reckon and the SQL Gateway to access Reckon from Google Apps Script.
-
Consume Workday OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Workday feeds that reflect any changes in SAP Lumira.
-
Automated Continuous SAP SuccessFactors Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to MySQL.
-
Bidirectional Access to Redshift from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon Redshift in Filemaker Pro for Mac or Windows.
-
Automated Continuous Oracle Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle replication to MongoDB.
-
Connect to Cosmos DB from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Cosmos DB from Appeon PowerBuilder using the CData ADO.NET Provider for Cosmos DB.
-
Integrate HubSpot in the Pentaho Report Designer
Publish reports based on HubSpot in the Pentaho BI tool.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams for you.
-
Connect to Real-Time NetSuite Data in Power Apps Using Dataflows to Build Custom Applications
-