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
-
Visualize Odoo in Sisense
Create an ElastiCube in Sisense app with access to Odoo ERP.
-
Build Apps with Live Salesforce & Force.com in Adalo using CData Connect Cloud
Use CData Connect Cloud to integrate live Salesforce & Force.com into the Adalo platform and build custom mobile and web applications with real-time Salesforce & Force.com.
-
Automated Continuous ADP Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ADP replication to OneLake in Microsoft Fabric.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Twilio
Provide connectivity to Twilio through an SAP BusinessObjects universe.
-
Build Yahoo! Japan Data Solution-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Yahoo! Japan Data Solution from Zoho Analytics and import live Yahoo! Japan Data Solution.
-
Automated Continuous SAS xpt Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAS xpt replication to MongoDB.
-
Build Data Flows from SQL Server to Highrise through SSIS
Easily push SQL Server data to Highrise using the CData SSIS Tasks for Highrise.
-
How to import Snapchat Ads into Apache Solr
Use the CData Software JDBC Driver for Snapchat Ads in Data Import Handler and create an automated import of Snapchat Ads to Apache Solr Enterprise Search platform.
-
Access ServiceNow as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ServiceNow from your Oracle system.
-
Connect to GitHub in HULFT Integrate
Connect to GitHub as a JDBC data source in HULFT Integrate
-
Automate Twilio Replication to Couchbase
Use CData Sync to Customize and automate Twilio replication to Couchbase.
-
Integrate Live SAP BusinessObjects BI into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to SAP BusinessObjects BI and integrate live SAP BusinessObjects BI into apps built in Microsoft Power Apps.
-
Connect to Sybase in RazorSQL
Connect to Sybase from wizards and query Sybase from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for Salesloft from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesloft to connect to Salesloft from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesloft in Excel.
-
Migrating data from GraphQL to Google BigQuery using CData SSIS Components.
Easily push GraphQL to Google BigQuery using the CData SSIS Tasks for GraphQL and Google BigQuery.
-
Access Live DocuSign in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DocuSign from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to IBM Informix
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access IBM Informix from an ASP.NET MVC application.
-
Replicate Multiple Zoho Projects Accounts via the CData Sync CLI
Replicate multiple Zoho Projects accounts to one or many databases.
-
Create Google Calendar-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Google Calendar from Klipfolio and build custom visualizations using live Google Calendar.
-
Create Apps from Salesforce Marketing in Qlik Sense Cloud
Use CData Connect Cloud to connect to Salesforce Marketing and build apps from live Salesforce Marketing Cloud in Qlik Sense Cloud.
-
Create SurveyMonkey Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect and process Azure Synapse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Synapse.
-
Design BIRT Reports on Marketo
Provide current Marketo to your embedded analytics.
-
How to Query Live Acumatica in Claude Desktop
Connect to and query live Acumatica in Claude Desktop using the CData MCP Server.
-
Connect to MongoDB in Aqua Data Studio
Access MongoDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Marketo in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Marketo from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Datasets from Microsoft OneDrive in Domo Workbench and Build Visualizations of Microsoft OneDrive in Domo
Use the CData Software ODBC Driver for Microsoft OneDrive to create datasets from Microsoft OneDrive in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Charts to Oracle Service Cloud
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Service Cloud 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.
-
Integrate Adobe Commerce in the Pentaho Report Designer
Publish reports based on Adobe Commerce in the Pentaho BI tool.
-
How to publish and share SuiteCRM dashboards with Tableau Server
The CData ODBC driver for SuiteCRM enables you integrate SuiteCRM into Tableau dashboards.
-
Natively Connect to WooCommerce in PHP
The CData ODBC driver for WooCommerce enables you to create PHP applications with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
Use Claude to Talk to Your ActiveCampaign via CData Connect Cloud
Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your ActiveCampaign for you.
-
Deploy the ADO.NET Provider for Avalara AvaTax on an SSRS Report Server
Connect to Avalara AvaTax 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.
-
How to Query SurveyMonkey in MySQL Workbench
Execute MySQL queries against live SurveyMonkey from MySQL Workbench.
-
Automated Continuous Microsoft Teams Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Google BigQuery.
-
Create a Data Access Object for AlloyDB using JDBI
A brief overview of creating a SQL Object API for Google AlloyDB in JDBI.
-
Excel Spreadsheet Automation on Google Directory with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign in MicroStrategy Desktop using the CData Software JDBC Driver for ActiveCampaign.
-
Connect to Dynamics NAV in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Jira Assets from a Connection Pool in Jetty
The Jira Assets JDBC Driver supports connection pooling: This article shows how to connect faster to Jira Assets from Web apps in Jetty.
-
Access Procore in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Procore.
-
Create Vault CRM-Connected Business Apps in AppSheet
Connect to Vault CRM via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Veeva Vault & Vault CRM.
-
Process & Analyze Todoist in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist .
-
Design BIRT Reports on QuickBooks Time
Provide current QuickBooks Time to your embedded analytics.
-
Import Kintone Using Azure Data Factory
Use CData Connect Cloud to connect to Kintone from Azure Data Factory and import live Kintone.
-
Connect to Confluence from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Atlassian Confluence using standard SQL.
-
How to Connect to & Open Oracle in Microsoft Excel
This article uses the CData ODBC driver for Oracle to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SAP SuccessFactors Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP SuccessFactors data access from reports, embedded analytics, and more.
-
Connect to Snowflake in Jaspersoft Studio
Execute SQL to remote Snowflake in Jaspersoft Studio.
-
Build Visualizations of HubDB in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HubDB in Birst.
-
Migrating data from SAP Hybris C4C to Google BigQuery using CData SSIS Components.
Easily push SAP Hybris C4C to Google BigQuery using the CData SSIS Tasks for SAP Hybris C4C and Google BigQuery.
-
How to Access Live Epicor Kinetic in Power Automate Desktop via ODBC
The CData ODBC Driver for Epicor Kinetic enables you to integrate Epicor Kinetic into workflows built using Microsoft Power Automate Desktop.
-
Connect to and Query SAP BusinessObjects BI in QlikView over ODBC
Create data visualizations with SAP BusinessObjects BI in QlikView.
-
Use the CData ODBC Driver for Microsoft Project in Microsoft Power Query
You can use the CData Microsoft Project ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Project into Microsoft Power Query.
-
DataBind Controls to Oracle SCM in C++Builder
DataBind to Oracle SCM in C++Builder with standard components and controls.
-
Build Pipelines with Live PostgreSQL in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to PostgreSQL from Google Cloud Data Fusion, enabling the integration of live PostgreSQL into the building and management of effective data pipelines.
-
Invoiced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Invoiced facts in real time.
-
Automated Continuous JSON Replication to Vertica
Use CData Sync for automated, continuous, customizable JSON replication to Vertica.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy Web
Connect to Harvest in MicroStrategy Web using the CData Software JDBC Driver for Harvest.
-
Connect to Slack in Aqua Data Studio
Access Slack from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Controls to SAP HANA in C++Builder
DataBind to SAP HANA in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Web
Connect to Authorize.Net in MicroStrategy Web using the CData Software JDBC Driver for Authorize.Net.
-
How to Use a Microsoft Access Database to Update Workday in Real Time
Update Workday data by creating a linked table in Microsoft Access with the CData Workday ODBC Driver.
-
Build an OLAP Cube in SSAS from SQL Analysis Services
Establish a connection to SQL Analysis Services data from SQL Server Analysis Services, and use the SQL Analysis Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish EventBrite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Eventbrite.
-
Build a Simple VCL Application for Google Spanner
How to build a simple VCL Application to view Google Spanner in RAD Studio using the CData ODBC Driver for Google Spanner.
-
Import Real-Time Clio via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Clio in ColdFusion.
-
Import Real-Time Microsoft Planner via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Planner in ColdFusion.
-
DataBind Controls to Jira Service Management in Delphi
DataBind to Atlassian Jira Service Management in Delphi with standard data access components and controls.
-
Build Data Flows from Zoho Books to SQL Server using SSIS
Easily back up Zoho Books to SQL Server using the SSIS components for Zoho Books.
-
Analyze Splunk in Looker
Use CData Connect Cloud to connect to Splunk from Looker and build custom apps using live Splunk.
-
Create Microsoft Planner Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open Printify in Microsoft Excel
This article uses the CData ODBC driver for Printify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to integrate SAS Data Sets with Apache Airflow
Access and process SAS Data Sets in Apache Airflow using the CData JDBC Driver.
-
Visualize Wave Financial from Tableau
Use the Tableau Desktop business intelligence tool to connect to Wave Financial.
-
Write a Simple Go Application to work with SAP Ariba Source on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Source.
-
Automated Continuous Shopify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Shopify replication to Amazon S3.
-
Use the CData ODBC Driver for SAS Data Sets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAS Data Sets to connect to SAS Data Sets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAS Data Sets in Excel.
-
How to Connect to RSS Feeds in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to RSS Feeds. Leverage the pyodbc module for ODBC in Python.
-
Access Salesforce from MySQL in PHP
Connect to Salesforce through the standard MySQL libraries in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for EventBrite
Create an ODBC connection to EventBrite in Informatica and browse and transfer Eventbrite.
-
Connect to Oracle Eloqua in Google Apps Script via Connect Cloud
Use CData Connect Cloud to access Oracle Eloqua in Google Apps Script.
-
PowerShell Scripting to Replicate Google Analytics to MySQL
Write a simple PowerShell script to replicate Google Analytics to a MySQL database.
-
Replicate Sugar CRM to Multiple Databases via the CData Sync CLI
Replicate Sugar CRM to disparate databases with a single configuration.
-
Build Automated Bing Ads-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Bing Ads and build automated workflows in Zapier.
-
Automated Continuous Harvest Replication to SQLite
Use CData Sync for automated, continuous, customizable Harvest replication to SQLite.
-
DataBind LDAP Objects to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for LDAP with the DevExpress Windows Forms and Web controls to provide LDAP to a chart.
-
Enable the Zendesk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zendesk.
-
Automated Continuous LinkedIn Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LinkedIn replication to OneLake in Microsoft Fabric.
-
How to connect to WooCommerce in DBVisualizer
Integrate WooCommerce with visual data analysis tools and data connection wizards in DBVisualizer
-
Stripe Reporting in OBIEE with the Stripe JDBC Driver
Deploy the Stripe JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Using the CData Software ODBC Driver for Splunk in PyCharm
Connect to Splunk as an ODBC data source in PyCharm using the CData Software ODBC Driver for Splunk.
-
Connect to Oracle Financials Cloud in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build IBM Informix-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM Informix and build web apps with connectivity to live IBM Informix.
-
Connect to SAP Business One from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Business One using standard SQL.
-
Migrating data from Google Sheets to Snowflake using CData SSIS Components.
Easily push Google Sheets to Snowflake using the CData SSIS Tasks for Google Sheets and Snowflake.
-
Automated Continuous Vault CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vault CRM replication to SingleStore.
-
Object-Relational Mapping (ORM) with SharePoint Excel Services 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 SharePoint Excel Services into a Java-based ORM framework, Hibernate.
-
Integrate with live Epicor Kinetic in Jitterbit
Use CData Connect Cloud to connect to and integrate live Epicor Kinetic in Jitterbit.
-
Automated Continuous SAP HANA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA replication to Apache Kafka.