Before you use the Apache Hadoop on Windows Azure portal to import Windows Azure Marketplace data into Hadoop on Windows Azure, you must know the following information:

  • User name: the live ID used to sign in to the marketplace.
  • PassKey
    1. Sign in with your live ID.
    2. Click My Account.
    3. Click Account Keys. The GUID number on the Value column is the pass key.
  • Query
    1. Sign in with your live ID.
    2. Click Data.
    3. In the Search the Marketplace textbox, type the keywords.
    4. Clck the dataset.
    6. From the BUILD QUERY pane on the right, click DEVELOP.
    7. (Optional) From the BUILD QUERY PANE on the right, type the parameters.
    8. Click Run Query. The sample data is display on the main pane.
    9. From the Build Query pane, click DEVELOP. The URL listed there is the query URL.

To import data from the marketplace

  1. Browse to
  2. Sign in with your live ID.
  3. Click the Manage Data tile.
  4. Click DataMarket.
  5. Type the DataMarket subscription account information, the Query, and the hive table where you want to import the data.

  6. Click Import data.

See Also

  1. Apache Hadoop Based Services for Windows Azure How To Guide
  2. Apache Hadoop On Windows
  3. HDInsight
Another important place to find an extensive amount of Cortana Intelligence Suite related articles is the TechNet Wiki itself. The best entry point is Cortana Intelligence Suite Resources on the TechNet Wiki.