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 Live HubSpot of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubSpot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Authorize.Net in DBVisualizer
Integrate Authorize.Net with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate SAP Business One Replication to SAP HANA
Use CData Sync to customize and automate SAP Business One replication to SAP HANA.
-
Build Dashboards with QuickBooks in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Desktop in DBxtra.
-
How to integrate Impala with Apache Airflow
Access and process Apache Impala in Apache Airflow using the CData JDBC Driver.
-
Import Zoho CRM Using Azure Data Factory
Use CData Connect Cloud to connect to Zoho CRM from Azure Data Factory and import live Zoho CRM.
-
Access Live Sage 200 in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage 200 into the statistical analysis tools available in SAS JMP. This article shows how to use Sage 200 in the Graph Builder and Query Builder.
-
Dynamics CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dynamics CRM facts in real time.
-
How to connect to SQL Analysis Services with Squirrel SQL client
Connect to SQL Analysis Services and execute queries in the Squirrel SQL Client.
-
Create a Data Access Object for Bullhorn CRM using JDBI
A brief overview of creating a SQL Object API for Bullhorn CRM in JDBI.
-
Connect to Azure Data Catalog in RapidMiner
Integrate Azure Data Catalog with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate with live AlloyDB in Jitterbit
Use CData Connect Cloud to connect to and integrate live Google AlloyDB in Jitterbit.
-
Connect to CockroachDB in Google Apps Script via SQL Gateway
Use the ODBC Driver for CockroachDB and the SQL Gateway to access CockroachDB from Google Apps Script.
-
Seamlessly Bring SQL Server into Retool Using CData Connect Cloud
Integrate SQL Server data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Connect to Phoenix in Ruby
Connect to Apache Phoenix in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Access WooCommerce Using Entity Framework
This article shows how to access WooCommerce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Exact Online in MySQL Workbench
Create a virtual MySQL database for Exact Online in CData Software Connect (or Connect Server) and work with live Exact Online in MySQL Workbench.
-
Connect to Certinia as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Certinia.
-
Use CData Connect Cloud to Access MYOB AccountRight in Microsoft Power Pivot
Use CData Connect Cloud to connect to live MYOB AccountRight in the Power Pivot business intelligence tool.
-
Replicate LinkedIn Ads from PowerShell
Write a quick PowerShell script to query LinkedIn Ads. Use connectivity to the live data to replicate LinkedIn Ads to SQL Server.
-
Build Visualizations of Salesloft in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesloft in Birst.
-
Query Kafka in DataGrip
Create a Data Source for Kafka in DataGrip and use SQL to query live Apache Kafka.
-
Prepare, Blend, and Analyze Excel Online in Alteryx Designer (Connect Cloud)
Build workflows to access live Microsoft Excel Online for self-service data analytics.
-
Build Google Search-Connected Apps in Mendix
Use CData Connect Cloud to create an OData feed for Google Search Results and create custom apps in Mendix.
-
Connect to Live SuiteCRM in MicroStrategy through CData Software Connect Server
Create a virtual database for SuiteCRM in CData Software Connect Server and connect to it from MicroStrategy.
-
DataBind Charts to Cosmos DB
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Cosmos DB 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.
-
How to Use a Microsoft Access Database to Update Snapchat Ads in Real Time
Update Snapchat Ads data by creating a linked table in Microsoft Access with the CData Snapchat Ads ODBC Driver.
-
Access SAP HANA XS Advanced as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA XS Advanced from your Oracle system.
-
Create Sage 50 UK-Connected Nintex Workflows
Use CData Software Connect Server to connect to Sage 50 UK from Nintex Workflow Cloud and build custom workflows using live Sage 50 UK.
-
Create SSAS Tabular Models from Klipfolio
How to build a SQL Server Analysis Service Tabular Model from Klipfolio using CData drivers.
-
Analyze Facebook Ads in SAP Analytics Cloud
Use CData Connect Cloud to create an OData API on top of Facebook Ads and visualize Facebook Ads in SAP Analytics Cloud.
-
Connect to Clio in Aqua Data Studio
Access Clio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to ADP in NetBeans
Connect to ADP in NetBeans with the data source configuration wizard.
-
Viewing Zendesk in RAD Studio Data Explorer
How to view Zendesk in RAD Studio Data Explorer using the CData ODBC Driver for Zendesk.
-
Integrate Live Azure Data Lake Storage into Blue Prism for Intelligent Robotic Process Automation (RPA)
-
