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 HeidiSQL
Use CData Connect Cloud to connect to and query live eBay from HeidiSQL.
-
Analyze Power BI XMLA in Infragistics Reveal
Use CData Connect Cloud to create on OData API on top of Power BI XMLA and visualize live Power BI XMLA in Infragistics Reveal.
-
Back Up PayPal to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PayPal. In this article, we will employ an SSIS workflow to populate a database with PayPal data.
-
Use the CData Software ODBC Driver for SAP Fieldglass in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Fieldglass in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Fieldglass.
-
How to connect PolyBase to Teradata
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Teradata.
-
Excel Spreadsheet Automation on SAP Netweaver Gateway with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live PCA Sales into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to PCA Sales from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PCA Sales.
-
Access Sage Cloud Accounting from MySQL in Amazon QuickSight
Connect to Sage Cloud Accounting and build visualizations of Sage Business Cloud Accounting using a MySQL Connection in Amazon QuickSight.
-
How to connect to Microsoft Dataverse from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Microsoft Dataverse and work with Microsoft Dataverse (CDS) in Microsoft Excel on Mac OS X.
-
Connect to Azure Active Directory in Aqua Data Studio
Access Azure Active Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bridge LinkedIn Connectivity with Apache NiFi
Access and process LinkedIn in Apache NiFi using the CData JDBC Driver.
-
Integrate AlloyDB into Power Automate Desktop using CData Connect
CData Connect for AlloyDB enables you to integrate Google AlloyDB into workflows built using Microsoft Power Automate Desktop.
-
Import Zuora into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zuora. In this article, you will use the OData format to import Zuora into Microsoft Power Query.
-
Provide OData Services of Presto from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Presto by developing a WCF Service Application.
-
Import Real-Time Unbounce via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Unbounce in ColdFusion.
-
Connect to Unbounce in Ruby
Connect to Unbounce in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Amazon Athena Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Amazon Redshift.
-
How to import AlloyDB into Apache Solr
Use the CData Software JDBC Driver for AlloyDB in Data Import Handler and create an automated import of Google AlloyDB to Apache Solr Enterprise Search platform.
-
Automated Continuous Workday Replication to Databricks
Use CData Sync for automated, continuous, customizable Workday replication to Databricks.
-
How to connect to Okta from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Okta and work with Okta in Microsoft Excel on Mac OS X.
-
Visualize Live HubSpot in the Power BI Service
Use CData Connect Cloud to connect to live HubSpot and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Configure the CData JDBC Driver for HDFS in a Connection Pool in Tomcat
Connect to Apache HDFS from a connection pool in Tomcat.
-
Access ClickUp as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ClickUp from your Oracle system.
-
Import SAP Business One into the Power BI Service for Visualizations
Use CData Connect Cloud to connect to SAP Business One and provide access to live SAP Business One for custom reports in the Power BI Service.
-
Design BIRT Reports on Bing Search Results
Provide current Bing Search to your embedded analytics.
-
Visualize Live Microsoft Dataverse in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Microsoft Dataverse (CDS) into custom reports in Power BI.
-
Use the CData Software ODBC Driver for Google Data Catalog in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Data Catalog in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Data Catalog.
-
Bridge SAP Concur Connectivity with Apache NiFi
Access and process SAP Concur in Apache NiFi using the CData JDBC Driver.
-
Explore Geographical Relationships in Azure Analysis Services with Power Map
Create data visualizations with Azure Analysis Services in Power Map.
-
Build Salesforce Data Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Data Cloud and build web apps with connectivity to live Salesforce Data Cloud.
-
How to Seamlessly Import Jira Data into IBM SPSS Modeler
Integrate Jira data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Design BIRT Reports on Salesloft
Provide current Salesloft to your embedded analytics.
-
How to Access Zoom Using Entity Framework
This article shows how to access Zoom using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Trello-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Trello.
-
Query Amazon Athena through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Athena from Node.js.
-
Access Live Sugar CRM in Google Sheets via Connect Cloud
Use CData Connect Cloud to gain access to live Sugar CRM from your Google Sheets.
-
Query Neo4J in DataGrip
Create a Data Source for Neo4J in DataGrip and use SQL to query live Neo4J.
-
Visualize Live Box of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Box using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live GitHub into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to GitHub from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live GitHub.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy
Connect to DocuSign in MicroStrategy Developer using the CData Software ODBC Driver for DocuSign.
-
Build MVC Applications with Connectivity to Greenhouse
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Greenhouse from an ASP.NET MVC application.
-
Connect to Excel Online in RapidMiner
Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.
-
Create a Data Access Object for SharePoint Excel Services using JDBI
A brief overview of creating a SQL Object API for SharePoint Excel Services in JDBI.
-
Automated Continuous Office 365 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Office 365 replication to SQL Server.
-
Use JayDeBeApi to access Box in Python
Use standard Python scripting and the development environment of your choice to access live Box.
-
Automated Continuous Zoho Projects Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SQLite.
-
A PostgreSQL Interface for Oracle HCM Cloud (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize OData Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load OData into TIBCO Spotfire.
-
Using the CData Software ODBC Driver for Databricks in PyCharm
Connect to Databricks as an ODBC data source in PyCharm using the CData Software ODBC Driver for Databricks.
-
Connect to Amazon DynamoDB from a Connection Pool in Jetty
The Amazon DynamoDB JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon DynamoDB from Web apps in Jetty.
-
Query, Visualize, and Share live Twilio in Redash
Use CData Connect Cloud to connect to live Twilio in Redash for querying, visualizing, and sharing.
-
How to import Amazon S3 into Apache Solr
Use the CData Software JDBC Driver for Amazon S3 in Data Import Handler and create an automated import of Amazon S3 to Apache Solr Enterprise Search platform.
-
Build MarkLogic-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MarkLogic.
-
Create Google Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access EnterpriseDB 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 EnterpriseDB.
-
Create Datasets from SAP SuccessFactors in Domo Workbench and Build Visualizations of SAP SuccessFactors in Domo
Use the CData Software ODBC Driver for SAP SuccessFactors to create datasets from SAP SuccessFactors in Domo Workbench and then build visualizations in the Domo service.
-
Query Azure DevOps in DataGrip
Create a Data Source for Azure DevOps in DataGrip and use SQL to query live Azure DevOps.
-
Access Live Xero in Excel 365 Online (Excel for the web)
Connect to Xero Accounting from Excel 365 Online (Excel for the web) with CData Connect Cloud.
-
How to Use a Microsoft Access Database to Update HubSpot in Real Time
Update HubSpot data by creating a linked table in Microsoft Access with the CData HubSpot ODBC Driver.
-
How to connect to Twilio from MS Excel on Mac OS X
Create a Data Source Name in iODBC with the CData ODBC Driver for Twilio and work with Twilio in Microsoft Excel on Mac OS X.
-
Automated Continuous Smartsheet Replication to SingleStore
Use CData Sync for automated, continuous, customizable Smartsheet replication to SingleStore.
-
Use the CData Software JDBC Driver for Jira Assets in MicroStrategy Web
Connect to Jira Assets in MicroStrategy Web using the CData Software JDBC Driver for Jira Assets.
-
Connect to SingleStore through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with SingleStore using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Instagram in DBeaver
Use the CData ODBC Driver to connect to Instagram in DBeaver.
-
Automated Continuous EventBrite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable EventBrite replication to PostgreSQL.
-
DataBind Controls to Amazon S3 in C++Builder
DataBind to Amazon S3 in C++Builder with standard components and controls.
-
Bridge YouTube Analytics Connectivity with Apache NiFi
Access and process YouTube Analytics in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Avalara AvaTax Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQL Server.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy
Connect to Printful in MicroStrategy Developer using the CData Software JDBC Driver for Printful.
-
Integrate with Google Ads in JReport Designer
Create charts and reports based on Google Ads in JReport Designer.
-
Create NetSuite-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to NetSuite from OutSystems and build custom enterprise apps using live NetSuite CRM & ERP.
-
Create Sage 200 Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Salesforce Data Cloud in CloverDX (formerly CloverETL)
Transfer Salesforce Data Cloud using the visual workflow in the CloverDX data integration tool.
-
Load Impala to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Impala to a database.
-
View Reports on Real-Time MarkLogic in Power BI Report Server
Use the CData ODBC Driver for MarkLogic to visualize MarkLogic in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy
Connect to WordPress in MicroStrategy Developer using the CData Software ODBC Driver for WordPress.
-
Access TigerGraph from MySQL in PHP
Connect to TigerGraph through the standard MySQL libraries in PHP.
-
Connect to Redis from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Redis using standard SQL.
-
Easily Integrate Google Ads in Lazarus Pascal IDE
Learn how to easily integrate live Google Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live BigQuery of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google BigQuery using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Twitter Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Twitter Ads to connect to Twitter Ads from Web applications running on WebLogic.
-
How to Easily Query Slack in OpenOffice Base
-