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
-
Automated Continuous DB2 Replication to SQLite
Use CData Sync for automated, continuous, customizable DB2 replication to SQLite.
-
Import and Visualize Google Cloud Storage in Power View
Create data visualizations based on Google Cloud Storage in Excel.
-
How to load Power BI XMLA data into Elasticsearch via Logstash
Introducing a simple method to load Power BI XMLA data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up Sybase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase. In this article, we will employ an SSIS workflow to populate a database with Sybase data.
-
View Reports on Real-Time Freshdesk in Power BI Report Server
Use the CData ODBC Driver for Freshdesk to visualize Freshdesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Zoho Books in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Books and the SQL Gateway to access Zoho Books from Google Apps Script.
-
Access Live REST in AWS Lambda
Connect to live REST in AWS Lambda using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Hybris C4C
Create SAP Hybris C4C data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Stream Quickbase into Apache Kafka Topics
Access and stream Quickbase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect PolyBase to Bullhorn CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bullhorn CRM.
-
Build SAP Fieldglass-Connected Dashboards in Redash
Use CData Software Connect Server to create a virtual SQL Server Database for SAP Fieldglass and build visualizations and dashbaords from SAP Fieldglass in Redash.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy Desktop
Connect to ADP in MicroStrategy Desktop using the CData Software ODBC Driver for ADP.
-
Integrate with SuiteCRM using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SuiteCRM to a JSON file on disk.
-
Query Microsoft Dataverse through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Dataverse (CDS) from Node.js.
-
How to integrate Metabase with Square
Use CData Connect Cloud to connect to live Square and create an interactive dashboard in Metabase from Square.
-
How to Query Live Oracle Eloqua Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Eloqua data in natural language using Python.
-
Create Apps from Oracle in Qlik Sense Cloud
Use CData Connect Cloud to connect to Oracle and build apps from live Oracle Database in Qlik Sense Cloud.
-
How to create Visio diagrams from Cosmos DB
Automatically update Azure Cosmos DB with the changes you make to Visio master shapes.
-
Connect to Pipedrive in JRuby
Create a simple JRuby app with access to live Pipedrive.
-
Automated Continuous Sage 50 UK Replication to Azure SQL
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Azure SQL.
-
Connect to Google Ad Manager in JRuby
Create a simple JRuby app with access to live Google Ad Manager.
-
How to Connect to & Open Sage 300 in Microsoft Excel
This article uses the CData ODBC driver for Sage 300 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Blackbaud FE NXT Replication to SQLite
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SQLite.
-
Create Dynamics GP Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate PostgreSQL Replication to Couchbase
Use CData Sync to Customize and automate PostgreSQL replication to Couchbase.
-
Replicate Salesforce Marketing to Multiple Databases via the CData Sync CLI
Replicate Salesforce Marketing Cloud to disparate databases with a single configuration.
-
Provide OData Services of Outreach.io from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outreach.io by developing a WCF Service Application.
-
Operational Reporting on Oracle HCM Cloud from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle HCM Cloud.
-
Automated Continuous SurveyMonkey Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to delimited files (CSV/TSV).
-
Use the CData ODBC Driver for Greenplum from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Pivotal GreenPlum from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Pivotal GreenPlum in Excel.
-
Integrate Live Microsoft Teams into Custom Business Apps Built in Power Apps
Use CData Connect Cloud to connect to Microsoft Teams and integrate live Microsoft Teams into apps built in Microsoft Power Apps.
-
Integrating BigQuery in Talend Cloud Data Management Platform
-
