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
-
Integrate PostgreSQL with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PostgreSQL with External Services.
-
PowerShell Scripting to Replicate Twitter to MySQL
Write a simple PowerShell script to replicate Twitter to a MySQL database.
-
Bridge Avro Connectivity with Apache NiFi
Access and process Apache Avro in Apache NiFi using the CData JDBC Driver.
-
Connect to Live Adobe Commerce in MicroStrategy through CData Connect Cloud
Create a live connection to Adobe Commerce in CData Connect Cloud and connect to your Adobe Commerce from MicroStrategy.
-
Visualize FHIR in TIBCO Spotfire through OData
Integrate FHIR into dashboards in TIBCO Spotfire.
-
Create Reports with TigerGraph in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date TigerGraph.
-
Connect to SAP Concur from Crystal Reports
Use CData Connect Cloud to connect to and report on live SAP Concur from Crystal Reports.
-
Visualize HarperDB in TIBCO Spotfire through OData
Integrate HarperDB into dashboards in TIBCO Spotfire.
-
Connect to Sybase IQ as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sybase IQ.
-
Connect to Clio in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Extract, Transform, and Load Reckon Accounts Hosted in Informatica PowerCenter
Create a simple Workflow for Reckon Accounts Hosted in Informatica PowerCenter.
-
Automated Continuous Monday.com Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Monday.com replication to Apache Kafka.
-
Visualize eBay in TIBCO Spotfire through ADO.NET
Integrate eBay into dashboards in TIBCO Spotfire.
-
Enable the Act CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Act CRM.
-
Explore Geographical Relationships in Gmail with Power Map
Create data visualizations with Gmail in Power Map.
-
Configure the CData JDBC Driver for Sugar CRM in a Connection Pool in Tomcat
Connect to Sugar CRM from a connection pool in Tomcat.
-
Access Live Sugar CRM Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sugar CRM data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Work with Microsoft Planner in FoxPro
Load Microsoft Planner into a FoxPro database. This article includes full code and a walk-through of the process.
-
NetSuite Reporting in OBIEE with the NetSuite JDBC Driver
Deploy the NetSuite JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Dashboards and Visualize Live Avalara AvaTax in Geckoboard
Use CData Connect Cloud to connect to live Avalara AvaTax and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize SAP Netweaver Gateway from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Netweaver Gateway.
-
TigerGraph Reporting in OBIEE with the TigerGraph JDBC Driver
Deploy the TigerGraph JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Sage Intacct from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sage Intacct from HeidiSQL.
-
Connect to DocuSign as an External Data Source using PolyBase
Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live DocuSign.
-
How to connect Amazon QuickSight to Kintone
Create a connection to Kintone in CData Connect Cloud and insert Kintone into Amazon QuickSight SPICE to build interactive dashboards.
-
Access CSV from MySQL in Amazon QuickSight
Connect to CSV and build visualizations of CSV/TSV Files using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software ODBC Driver for Sage 50 UK in MicroStrategy Desktop
Connect to Sage 50 UK in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 50 UK.
-
Connect to Sugar CRM from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sugar CRM to connect to Sugar CRM and execute queries in PowerBuilder.
-
How to Import Data from Power BI XMLA into Google Sheets
Import Power BI XMLA into a Google spreadsheet that is automatically refreshed.
-
Query SAS xpt from Node.js
Use the OData endpoint of the CData API Server to connect to your SAS XPORT and perform CRUD operations on SAS xpt from Node.js.
-
Migrating data from JSON to Snowflake using CData SSIS Components.
Easily push JSON to Snowflake using the CData SSIS Tasks for JSON and Snowflake.
-
Create Datasets from Azure Active Directory in Domo Workbench and Build Visualizations of Azure Active Directory in Domo
Use the CData Software ODBC Driver for Azure Active Directory to create datasets from Azure Active Directory in Domo Workbench and then build visualizations in the Domo service.
-
Automate Klipfolio Replication to Azure Data Lake
Use CData Sync to customize and automate Klipfolio replication to Azure Data Lake.
-
How to publish and share SAP Business One dashboards with Tableau Server
The CData ODBC driver for SAP Business One enables you integrate SAP Business One into Tableau dashboards.
-
Connect to JSON Services in RapidMiner
Integrate JSON with standard components and data source configuration wizards in RapidMiner Studio.
-
Choosing the Best Method to Connect Greenhouse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Greenhouse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to use SQLAlchemy ORM to access RSS Feeds in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of RSS Feeds.
-
Build Semantic Layer Views for Zendesk in APOS Live Data Gateway
Use the CData Connector for Zendesk in APOS Live Data Gateway to build Semantic Layer Views for Zendesk.
-
Connect Twitter to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Twitter using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Multiple Teradata Accounts
Replicate multiple Teradata accounts to one or many databases.
-
Create SAP Business One-Connected Business Apps in AppSheet
Connect to SAP Business One via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to SAP Business One.
-
Build a Singer.io Tap for QuickBooks Time With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks Time data using
-
DataBind Charts to Cloudant
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Cloudant 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.
-
Query Azure Active Directory as a MySQL Database in Node.js
Execute MySQL queries against Azure Active Directory from Node.js.
-
Working with Salesforce Marketing in LINQPad
Execute LINQ queries to Salesforce Marketing Cloud in LINQPad.
-
Create SSAS Tabular Models from TigerGraph
How to build a SQL Server Analysis Service Tabular Model from TigerGraph using CData drivers.
-
How to connect to Acumatica with Squirrel SQL client
Connect to Acumatica ERP and execute queries in the Squirrel SQL Client.
-
Create Snowflake-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Snowflake from Klipfolio and build custom visualizations using live Snowflake.
-
Automated Continuous Acumatica Replication to Vertica
Use CData Sync for automated, continuous, customizable Acumatica replication to Vertica.
-
Connect to ADP in CloverDX (formerly CloverETL)
Transfer ADP using the visual workflow in the CloverDX data integration tool.
-
Analyze Smartsheet with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Smartsheet from Power Pivot. You will use the Table Import Wizard to load Smartsheet. You can visually build the import query or use any SQL supported by the driver.
-
Build Apps with Live Act-On Using the Low-Code Development Platform of Mendix
-
