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
-
Operational Reporting on HBase from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache HBase.
-
DataBind Controls to AlloyDB in C++Builder
DataBind to Google AlloyDB in C++Builder with standard components and controls.
-
How to use SQLAlchemy ORM to access Slack in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Slack.
-
Create SSAS Tabular Models from Zoho Creator
How to build a SQL Server Analysis Service Tabular Model from Zoho Creator using CData drivers.
-
Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Commerce in Excel.
-
Trigger WordPress IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
DataBind Controls to Basecamp in Delphi
DataBind to Basecamp in Delphi with standard data access components and controls.
-
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.
-
Automated Continuous Typeform Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Typeform replication to Microsoft Access.
-
Connect to QuickBooks Online from a Connection Pool in WebLogic
Use the CData JDBC Driver for QuickBooks Online to connect to QuickBooks Online from Web applications running on WebLogic.
-
Create SAP HANA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP HANA data access from reports, embedded analytics, and more.
-
Extend Google Sheets with MariaDB
Make calls to the API Server from Google Apps Script.
-
Natively Connect to Cosmos DB in PHP
The CData ODBC driver for Cosmos DB enables you to create PHP applications with connectivity to Azure Cosmos DB. Leverage the native support for ODBC in PHP.
-
Trigger Sage Intacct IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build Snowflake-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Snowflake from Zoho Analytics and import live Snowflake.
-
How to connect PolyBase to HCL Domino
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HCL Domino.
-
Access Live GraphQL Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Work with Google Ads in AWS Glue Jobs Using JDBC
Connect to Google Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Salesloft Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesloft replication to Amazon S3.
-
Connect to Impala in NetBeans
Connect to Apache Impala in NetBeans with the data source configuration wizard.
-
How to connect to CSV from Spring Boot
Connect to CSV in a Spring Boot Application using CData JDBC CSV Driver
-
Build Pipelines with Live SAP Business One in Google Cloud Data Fusion (via CData Connect Cloud)
Use CData Connect Cloud to connect to SAP Business One from Google Cloud Data Fusion, enabling the integration of live SAP Business One into the building and management of effective data pipelines.
-
How to connect to OData Services in DBVisualizer
Integrate OData with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Harvest from Node.js
Use the OData endpoint of the CData API Server to connect to your Harvest and perform CRUD operations on Harvest from Node.js.
-
Automated Continuous Cosmos DB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Amazon S3.
-
Analyze CockroachDB with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CockroachDB from Power Pivot. You will use the Table Import Wizard to load CockroachDB. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Freshdesk in Power BI (via CData Connect Cloud)
Use the CData Power BI Connector and CData Connect Cloud to integrate live Freshdesk into custom reports in Power BI.
-
Access Live Excel in AWS Lambda
Connect to live Microsoft Excel in AWS Lambda using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Google Search on an SSRS Report Server
Connect to Google Search 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.
-
Query QuickBooks Online from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Online and perform CRUD operations on QuickBooks Online from Node.js.
-
Access Box 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 Box.
-
Import and Visualize Sugar CRM in Power View
Create data visualizations based on Sugar CRM in Excel.
-
Prepare, Blend, and Analyze HubSpot in Alteryx Designer (Connect Cloud)
Build workflows to access live HubSpot for self-service data analytics.
-
Visualize Twilio from Tableau
Use the Tableau Desktop business intelligence tool to connect to Twilio.
-
Visualize WordPress from Tableau
Use the Tableau Desktop business intelligence tool to connect to WordPress.
-
Connect to SendGrid in Google Apps Script via SQL Gateway
Use the ODBC Driver for SendGrid and the SQL Gateway to access SendGrid from Google Apps Script.
-
How to create an RPA flow for Neo4J in UiPath Studio
Use the Neo4J ODBC Driver to create workflows that access real-time Neo4J without any coding.
-
Connect to Clio in RapidMiner
Integrate Clio with standard components and data source configuration wizards in RapidMiner Studio.
-
Easily Integrate SAP Fieldglass in Lazarus Pascal IDE
Learn how to easily integrate live SAP Fieldglass in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Couchbase in Cognos Analytics
Use CData Connect Cloud to connect to Couchbase from Cognos Analytics and analyze live Couchbase.
-
How to Connect to & Open Excel Online in Microsoft Excel
This article uses the CData ODBC driver for Excel Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live QuickBooks in Coginiti Pro
Connect to and query live QuickBooks Desktop from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Reports with Wave Financial in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wave Financial.
-
Extract, Transform, and Load Amazon Athena in Informatica PowerCenter
Create a simple Workflow for Amazon Athena in Informatica PowerCenter.
-
Connect to Zoom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoom to connect to Zoom from Web applications running on WebLogic.
-
Connect to Splunk in NetBeans
Connect to Splunk in NetBeans with the data source configuration wizard.
-
How to connect to Google Drive with Squirrel SQL client
Connect to Google Drive and execute queries in the Squirrel SQL Client.
-
Access Adobe Analytics from MySQL in Amazon QuickSight
Connect to Adobe Analytics and build visualizations of Adobe Analytics using a MySQL Connection in Amazon QuickSight.
-
Build an OLAP Cube in SSAS from ShipStation
Establish a connection to ShipStation data from SQL Server Analysis Services, and use the ShipStation Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Facebook Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Facebook replication to Google BigQuery.
-
Connect to SuiteCRM in HULFT Integrate
Connect to SuiteCRM as a JDBC data source in HULFT Integrate
-
DataBind Controls to Klipfolio in Delphi
DataBind to Klipfolio in Delphi with standard data access components and controls.
-
Integrating Google Analytics in Talend Cloud Data Management Platform
-
