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 SAP Hybris C4C in JRuby
Create a simple JRuby app with access to live SAP Hybris C4C.
-
Build Dashboards with IBM Cloud Object Storage in DBxtra
Create dynamic dashboards and perform analytics based on IBM Cloud Object Storage in DBxtra.
-
Automate Active Directory Replication to Azure Data Lake
Use CData Sync to customize and automate Active Directory replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from Harvest
Establish a connection to Harvest data from SQL Server Analysis Services, and use the Harvest Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Datasets from Slack in Domo Workbench and Build Visualizations of Slack in Domo
Use the CData Software ODBC Driver for Slack to create datasets from Slack in Domo Workbench and then build visualizations in the Domo service.
-
Analyze SingleStore in Cognos Analytics
Use CData Connect Cloud to connect to SingleStore from Cognos Analytics and analyze live SingleStore.
-
Use the CData ODBC Driver for Office 365 in Microsoft Power Query
You can use the CData Office 365 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Office 365 into Microsoft Power Query.
-
Automated Continuous Google Campaign Manager 360 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Cassandra.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Web
Connect to SAS XPORT in MicroStrategy Web using the CData Software ODBC Driver for SAS xpt.
-
Access Live SingleStore in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SingleStore into the statistical analysis tools available in SAS JMP. This article shows how to use SingleStore in the Graph Builder and Query Builder.
-
Access Teradata as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teradata from your Oracle system.
-
Create Data Visualizations in Cognos BI with Google Ads
Access Google Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Excel Spreadsheet Automation on Cvent with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Elasticsearch
Use CData Power BI Connectors to visualize Elasticsearch in Power BI.
-
Connect to SingleStore in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Shopify Replication to Azure SQL
Use CData Sync for automated, continuous, customizable Shopify replication to Azure SQL.
-
Automated Continuous Azure Active Directory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Amazon S3.
-
Stream BambooHR into Apache Kafka Topics
Access and stream BambooHR in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use JayDeBeApi to access SAP HANA in Python
Use standard Python scripting and the development environment of your choice to access live SAP HANA.
-
Build IBM Cloud Data Engine-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM Cloud Data Engine and build web apps with connectivity to live IBM Cloud Data Engine.
-
Automated Continuous Coinbase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Coinbase replication to Snowflake.
-
Query JotForm in MySQL Workbench
Create a virtual MySQL database for JotForm in CData Software Connect (or Connect Server) and work with live JotForm in MySQL Workbench.
-
Publish Reports with MYOB AccountRight in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MYOB AccountRight.
-
How to publish and share REST dashboards with Tableau Server
The CData ODBC driver for REST enables you integrate REST into Tableau dashboards.
-
Create Hive Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Apache Hive to build custom dashboards in Bold BI.
-
Model Azure DevOps Using Azure Analysis Services
Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Azure DevOps, enabling the direct import of real-time Azure DevOps.
-
How to publish and share Azure Active Directory dashboards with Tableau Server
The CData ODBC driver for Azure Active Directory enables you integrate Azure Active Directory into Tableau dashboards.
-
Connect to Bitbucket from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket and execute queries in PowerBuilder.
-
Connect to Live Google Directory in MicroStrategy through CData Connect Cloud
Create a live connection to Google Directory in CData Connect Cloud and connect to your Google Directory from MicroStrategy.
-
Seamlessly Bring Google Campaign Manager 360 into Retool Using CData Connect Cloud
Integrate Google Campaign Manager 360 data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
-
Connect to Sugar CRM through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Sugar CRM using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Salesforce Marketing in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Marketing Cloud.
-
Connect to Sage 50 UK from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage 50 UK to connect to Sage 50 UK and execute queries in PowerBuilder.
-
Build Dashboards with EnterpriseDB in Dundas BI
Create dynamic dashboards and perform analytics based on EnterpriseDB in Dundas BI.
-
Create Datasets from FHIR in Domo Workbench and Build Visualizations of FHIR in Domo
Use the CData Software ODBC Driver for FHIR to create datasets from FHIR in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Reckon in AWS Lambda
Connect to live Reckon in AWS Lambda using the CData JDBC Driver.
-
Connect to Amazon Athena from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Athena, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Access Live Presto in Power Automate Desktop via ODBC
The CData ODBC Driver for Presto enables you to integrate Presto into workflows built using Microsoft Power Automate Desktop.
-
Visualize Google Ad Manager in TIBCO Spotfire through ADO.NET
Integrate Google Ad Manager into dashboards in TIBCO Spotfire.
-
Use the Connect Server to Access Coinbase in Microsoft Power Pivot
Use the Connect Server to connect to live Coinbase in the Power Pivot business intelligence tool.
-
How to Seamlessly Import Oracle HCM Cloud Data into IBM SPSS Modeler
Integrate Oracle HCM Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time Oracle Financials Cloud via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Financials Cloud in ColdFusion.
-
Access Live LinkedIn in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn from your Google Sheets.
-
Working with SFTP in LINQPad
Execute LINQ queries to SFTP in LINQPad.
-
Use JayDeBeApi to access Freshdesk in Python
Use standard Python scripting and the development environment of your choice to access live Freshdesk.
-
Build Google Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Analytics and build web apps with connectivity to live Google Analytics.
-
How to work with OData Services in Apache Spark using SQL
Access and process OData Services in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Excel of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Excel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live HBase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache HBase data in natural language using Python.
-
How to work with Outreach.io in Apache Spark using SQL
Access and process Outreach.io in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Phoenix via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Phoenix in ColdFusion.
-
Build NetSuite-Connected Visualizations in datapine
Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live NetSuite CRM & ERP.
-
Validate Act CRM with QuerySurge
Access and validate Act CRM in QuerySurge using the CData JDBC Driver.
-
Analyze SAS Data Sets with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAS Data Sets from Power Pivot. You will use the Table Import Wizard to load SAS Data Sets. You can visually build the import query or use any SQL supported by the driver.
-
Use Biml to Build SSIS Tasks to Replicate Tableau CRM Analytics to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tableau CRM Analytics to SQL Server.
-
Build a Simple VCL Application for Zoho Projects
How to build a simple VCL Application to view Zoho Projects in RAD Studio using the CData ODBC Driver for Zoho Projects.
-
Automated Continuous REST Replication to MySQL
Use CData Sync for automated, continuous, customizable REST replication to MySQL.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in SAS for Real-Time Reporting and Analytics
Connect to real-time Raisers Edge NXT in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Raisers Edge NXT.
-
Connect to Kintone through External Services in Salesforce
Use CData Connect Cloud to securely connect Salesforce External Services with Kintone using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Provide OData Services of Google Ad Manager from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Ad Manager by developing a WCF Service Application.
-
Access Gmail from MySQL in PHP
Connect to Gmail through the standard MySQL libraries in PHP.
-
Import Real-Time BigCommerce via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BigCommerce in ColdFusion.
-
Automated Continuous YouTube Analytics Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to OneLake in Microsoft Fabric.
-
Automated Continuous Active Directory Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Active Directory replication to OneLake in Microsoft Fabric.
-
Bing Ads Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Bing Ads through CData Connect Cloud using different applications and tools.
-
How to pipe LDAP Objects to CSV in PowerShell
Use standard PowerShell cmdlets to access LDAP tables.
-
Access Live Azure Data Catalog in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Catalog in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
ETL Splunk in Oracle Data Integrator
This article shows how to transfer Splunk into a data warehouse using Oracle Data Integrator.
-
Add Quickbase to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Quickbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live Spark in Power Automate Desktop via ODBC
The CData ODBC Driver for Spark enables you to integrate Apache Spark SQL into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Stripe Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Stripe replication to Amazon Redshift.
-
How to Build Dynamic React Apps with Sage 50 UK
Use the CData Connect and React to Build Dynamic Web Apps with Live Sage 50 UK .
-
Access Live SAP HANA in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP HANA from your Excel spreadsheets.
-
Connect to SAP Ariba Procurement in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for SAP Ariba Procurement and connect to SAP Ariba Procurement in Akorbi Digital RunMyProcess.
-
How to connect PolyBase to CouchDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache CouchDB.
-
Create SAP BusinessObjects BI-Connected Nintex Workflows
Use CData Connect Cloud to connect to SAP BusinessObjects BI from Nintex Workflow Cloud and build custom workflows using live SAP BusinessObjects BI.
-
Access Elasticsearch from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elasticsearch from HeidiSQL.
-
LINQ to IBM Cloud Object Storage
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 IBM Cloud Object Storage Data Provider.
-
How to publish and share Square dashboards with Tableau Server
The CData ODBC driver for Square enables you integrate Square into Tableau dashboards.
-
Automate Monday.com Replication to SAP HANA
Use CData Sync to customize and automate Monday.com replication to SAP HANA.
-
Add Clio to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Acumatica from a Connection Pool in JBoss
Integrate Acumatica ERP into Java servlets: Use the Management Console in JBoss to install the Acumatica JDBC Driver.
-
Creating Amazon Athena-Connected Applications in Unqork
You can use CData Connect Cloud to feed Amazon Athena to Unqork and build custom business apps.
-
Connect to Authorize.Net in Google Apps Script via SQL Gateway
Use the ODBC Driver for Authorize.Net and the SQL Gateway to access Authorize.Net from Google Apps Script.
-
Replicate Multiple Invoiced Accounts via the CData Sync CLI
Replicate multiple Invoiced accounts to one or many databases.
-
Build Semantic Layer Views for Elasticsearch in APOS Live Data Gateway
Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Elasticsearch.
-
Connect to Google Calendar from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Calendar using standard SQL.
-
Integrating Trello in Talend Cloud Data Management Platform
-