CData Software - Knowledge Base



Recent Excel Articles

Import and Visualize Azure Data Lake Storage in Power View

Create data visualizations based on Azure Data Lake Storage in Excel.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Bidirectional Access to Excel Services from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate SharePoint Excel Services in Filemaker Pro for Mac or Windows.

Use the CData ODBC Driver for JSON from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for JSON to connect to JSON from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JSON in Excel.

Transfer Data from Excel to Azure Table

This article explains how to transfer data from Excel to Azure Table using the Excel Add-In for Azure Table.

Connect to Excel Online in Jaspersoft Studio

Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

Author and Share Power BI Reports on Real-Time SAP HANA

Use the CData ODBC Driver for SAP HANA to visualize SAP HANA in Power BI Desktop and then upload to the Power BI service.

Build a Simple VCL Application for Excel

How to build a simple VCL Application to view Microsoft Excel in RAD Studio using the CData Software FireDAC Components for Excel.

Explore Geographical Relationhips in Couchbase with Power Map

Create data visualizations with Couchbase in Power Map.

Import and Visualize Cosmos DB in Power View

Create data visualizations based on Azure Cosmos DB in Excel.

Explore Geographical Relationhips in ServiceNow with Power Map

Create data visualizations with ServiceNow in Power Map.
 
 
 
Products


SOLUTIONS


Support
Purchase
Company
Subscriptions