CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server to Access HDFS in Microsoft PowerPivot
Use the CData API Server to connect to live Apache HDFS in the Power Pivot business intelligence tool.
-
Connect to and Query Coinbase in QlikView over ODBC
Create data visualizations with Coinbase in QlikView.
-
Getting Started with the CData Excel Add-In for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP HANA XS Advanced.
-
Validate Teradata with QuerySurge
Access and validate Teradata in QuerySurge using the CData JDBC Driver.
-
How to connect Amazon QuickSight to GraphQL
Create a connection to GraphQL in CData Connect AI and insert GraphQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to MariaDB in Aqua Data Studio
Access MariaDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Zoho Projects as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zoho Projects.
-
Create Informatica Mappings From/To an ODBC Data Source for Excel Online
Create an ODBC connection to Excel Online in Informatica and browse and transfer Microsoft Excel Online.
-
Connect to Oracle Eloqua in ACL Analytics
Connect to Oracle Eloqua via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Eloqua.
-
Access Sybase IQ as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase IQ from your Oracle system.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Planner Records from SQL Server
Easily push SQL Server data to Microsoft Planner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Planner or update existing records with data from a SQL Server database.
-
How to Create Power BI Visual Reports with Real-Time Tally
Use CData Power BI Connectors to visualize Tally ERP in Power BI.
-
Add SAP SuccessFactors LMS to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP SuccessFactors LMS with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Moonlit Workflow with Zoho CRM via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho CRM in real time.
-
Enable the Databricks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Databricks.
-
Build a Simple VCL Application for HCL Domino
How to build a simple VCL Application to view HCL Domino in RAD Studio using the CData ODBC Driver for HCL Domino.
-
Build Semantic Layer Views for SFTP in APOS Live Data Gateway
Use the CData Connector for SFTP in APOS Live Data Gateway to build Semantic Layer Views for SFTP.
-
Extend Google Sheets with AlloyDB
Make calls to the API Server from Google Apps Script.
-
LINQ to MySQL
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 MySQL Data Provider.
-
How to connect to CSV with Squirrel SQL client
Connect to CSV/TSV Files and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for PingOne from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PingOne to connect to PingOne from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PingOne in Excel.
-
Build Pinterest-Powered Applications in Claude Code with CData Code Assist MCP
-