Loading Data from Microsoft Azure Marketplace


You can use the OData connector to load data from Microsoft Azure Marketplace into Spotfire.

Prerequisites

Before you can use the OData connector to load data from Azure Marketplace, you need to have a Microsoft Azure Marketplace account, and an active subscription to data on Azure Marketplace. For guidance with creating a Marketplace account, or subscribing to data, please view the official Microsoft Azure Marketplace documentation.

  1. Select File > Add Data Tables.

  2. Click Add.

  3. Select Connection To > OData.

    Comment: Alternatively, to add the connection to the library instead, select Tools > Manage Data Connections, locate the folder where you want to save the connection, then click Add New > Data Connection and select OData.

    Response: The OData Connection dialog is opened.

  4. In the Service URL field, paste the URL corresponding to the data you want to load into Spotfire from Azure Marketplace.

    Comment: If you are unsure where to find the service URL, see Finding the Service URL.

  5. Select Microsoft Azure Marketplace in the Authentication method drop-down list.

  6. Paste your Marketplace account key into the Account key text field.

    Comment: If you are unsure where to find your account key, see Finding your Account Key.

  7. Click Connect.

  8. In the Views in Connection dialog, add the data, and click OK twice to load the data into Spotfire.

    Comment: For general information about loading data into Spotfire, see Loading Data Overview.

To be able to load data from Azure Marketplace, you need to know the URL to the subscription data you want to load into Spotfire.

  1. Log into your Marketplace account.

  2. Locate the page named My Account, and from there, open the page named My Data.

    Response: You will see a list of all your active data subscriptions.

  3. Open the data of interest by clicking on the name.

  4. Open the tab named Details.

  5. Find the Service root URL located on the Details tab. This is the URL to use when you want to load the data into Spotfire.
  6. Copy the URL and paste it into the Service URL field in the OData Connection login dialog. Make sure not to include any spaces.

The account key is used as authorization method when loading data into Spotfire from Microsoft Azure Marketplace.

  1. Log into your Marketplace account.

  2. Locate the page named My Account, and make sure the Account Information page is opened.

  3. Find the Primary Account Key.

  4. Copy the account key and paste it into the Account key field in the OData Connection login dialog. Make sure not to include any spaces.

See also:

Details on OData Connection