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 Live Zoho CRM in PostGresSQL Interface through CData Connect Cloud
Create a live connection to Zoho CRM in CData Connect Cloud and connect to your Zoho CRM from PostgreSQL.
-
Analyze Google Data Catalog in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Data Catalog and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to work with Zoho Creator in Apache Spark using SQL
Access and process Zoho Creator in Apache Spark using the CData Software JDBC Driver.
-
Connect to Oracle Sales from Asprova with CData Software ODBC Driver for Oracle Sales
This article shows how to connect faster to Oracle Sales data from Asprova.
-
Excel Spreadsheet Automation on MYOB AccountRight with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Salesforce Data in QlikView Using the CData ODBC Driver for Salesforce
The CData ODBC drivers expand your ability to work with data from a wide variety of data sources. For example, you can use the ODBC drivers to create visualizations that organize and present your Salesforce data in QlikView. In this article we outline simple steps to use CData ODBC Drivers from QlikView.
-
How to pipe Elasticsearch to CSV in PowerShell
Use standard PowerShell cmdlets to access Elasticsearch tables.
-
Use the CData ODBC Driver for Couchbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Couchbase to connect to Couchbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Couchbase in Excel.
-
Automated Redis Replication to Teradata
Use CData Sync to Customize and automate Redis replication to Teradata.
-
Create Data Visualizations in Cognos BI with Oracle SCM
Access Oracle SCM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load PingOne in Informatica PowerCenter
Create a simple Workflow for PingOne in Informatica PowerCenter.
-
Automated Continuous Harvest Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Harvest replication to Microsoft Access.
-
Automated Continuous RSS Replication to Databricks
Use CData Sync for automated, continuous, customizable RSS replication to Databricks.
-
How to connect to Salesforce Marketing with Squirrel SQL client
Connect to Salesforce Marketing Cloud and execute queries in the Squirrel SQL Client.
-
Access Live Snapchat Ads in Coginiti Pro
Connect to and query live Snapchat Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Feed Google Ads into FineReport
How to set Google Ads as a JDBC data source in FineReport.
-
Migrating data from Act-On to Snowflake using CData SSIS Components.
Easily push Act-On to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.
-
PowerShell Scripting to Replicate HarperDB to MySQL
Write a simple PowerShell script to replicate HarperDB to a MySQL database.
-
Configure the CData JDBC Driver for Microsoft Project in a Connection Pool in Tomcat
Connect to Microsoft Project from a connection pool in Tomcat.
-
Write a Simple Go Application to work with WooCommerce on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to WooCommerce.
-
Import and Visualize XML in Power View
Create data visualizations based on XML Files in Excel.
-
How to connect PolyBase to Phoenix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Phoenix.
-
Build Data Flows from Jira Assets to SQL Server using SSIS
Easily back up Jira Assets to SQL Server using the SSIS components for Jira Assets.
-
LINQ to Wave Financial
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 Wave Financial Data Provider.
-
Automated Continuous IBM Cloud Object Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to SingleStore.
-
Access Dynamics GP from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics GP from HeidiSQL.
-
Connect to SAP HANA XS Advanced in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Marketo in Coginiti Pro
Connect to and query live Marketo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Real-Time Access to HarperDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HarperDB in real time.
-
Automated Continuous MYOB AccountRight Replication to Snowflake
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Snowflake.
-
Connect to Jira Service Management 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 Atlassian Jira Service Management.
-
Automate Hive Replication to Azure Synapse
Use CData Sync to customize and automate Apache Hive replication to Azure Synapse.
-
Create Datasets from OneNote in Domo Workbench and Build Visualizations of OneNote in Domo
Use the CData Software ODBC Driver for OneNote to create datasets from Microsoft OneNote in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live Snowflake in the Power BI Service
Use CData Connect Cloud to connect to live Snowflake and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Phoenix in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Phoenix with the CData JDBC Driver for Phoenix.
-
How to Work with Sybase in ETL Validator JDBC
Connect to Sybase from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Pinterest in Aqua Data Studio
Access Pinterest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Semantic Layer Views for SAP Ariba Procurement in APOS Live Data Gateway
Use the CData Connector for SAP Ariba Procurement in APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Procurement.
-
Provide OData Services of CouchDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache CouchDB by developing a WCF Service Application.
-
DataBind Charts to FHIR
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FHIR 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.
-
Rapidly Develop Oracle Service Cloud-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Visualize NetSuite in TIBCO Spotfire through ADO.NET
Integrate NetSuite CRM & ERP into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Drip in Python
Use standard Python scripting and the development environment of your choice to access live Drip.
-
Connect to Google Directory Using the Script Function in Claris FileMaker Pro
-
