Skip to content

Files

Latest commit

PatAltimorePatAltimore
Add retirement notice
Feb 18, 2022
d51bd14 · Feb 18, 2022

History

History
64 lines (40 loc) · 2.87 KB

data-excel.md

File metadata and controls

64 lines (40 loc) · 2.87 KB
title description ms.date ms.topic ms.reviewer
Use Azure Blockchain Workbench data in Microsoft Excel
Learn how to load and view Azure Blockchain Workbench Preview SQL DB data in Microsoft Excel.
02/18/2022
how-to
mmercuri

View Azure Blockchain Workbench data with Microsoft Excel

[!INCLUDE Retirement note]

You can use Microsoft Excel to view data in Azure Blockchain Workbench's SQL DB. This article provides the steps you need to:

  • Connect to the Blockchain Workbench database from Microsoft Excel
  • Look at Blockchain Workbench database tables and views
  • Load Blockchain Workbench view data into Excel

Connect to the Blockchain Workbench database

To connect to a Blockchain Workbench database:

  1. Open Microsoft Excel.

  2. On the Data tab, choose Get Data.

  3. Select From Azure and then select From Azure SQL Database.

    Connect to Azure SQL Database

  4. In the SQL Server database dialog box:

    • For Server, enter the name of the Blockchain Workbench server.
    • For Database (optional), enter the name of the database.

    Provide database server and database

  5. In the SQL Server database dialog navigation bar, select Database. Enter your Username and Password, and then select Connect.

    [!NOTE] If you're using the credentials created during the Azure Blockchain Workbench deployment process, the User name is dbadmin. The Password is the one you created when you deployed the Blockchain Workbench.

    Provide credentials to access database

Look at database tables and views

The Excel Navigator dialog opens after you connect to the database. You can use the Navigator to look at the tables and views in the database. The views are designed for reporting and their names are prefixed with vw.

Excel Navigator preview of a view

Load view data into an Excel workbook

The next example shows how you can load data from a view into an Excel workbook.

  1. In the Navigator scroll bar, select the vwContractAction view. The vwContractAction preview shows all the actions related to a contract in the Blockchain Workbench database.

  2. Select Load to retrieve all the data in the view and put it in your Excel workbook.

    Data loaded from a view

Now that you have the data loaded, you can use Excel features to create your own reports using the metadata and transaction data from the Azure Blockchain Workbench database.

Next steps

[!div class="nextstepaction"] Database views in Azure Blockchain Workbench