Connect to a Report or Data Feed (SSAS)

  • Article

This page of the Table Import Wizard enables you to connect to a data feed. To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.

From a Report

  • Friendly Connection Name
    Type a friendly name for the data feed connection.

  • Report Path
    Lists the URL for a SQL Server Reporting Services report that generates data feeds. Click Browse to specify the URL for the report.

    Click View Report to display the report.

  • Browse
    Navigate to a location where a report is available.

  • Advanced
    Set additional connection properties by using the Set Advanced Properties dialog box..

  • Test Connection
    Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.

From an Azure DataMarket Dataset

  • Friendly Connection Name
    Type a friendly name for the data feed connection.

  • Data Feed URL
    Type the full path to an Atom service document (.atomsvc, .atom) or the URL for a single data feed, or click Browse to select an Atom service document.

  • Browse
    Navigate to a location where a report is available.

    Click View available Azure DataMarket datasets to display available datasets.

  • Account key
    Specify the account key used to access your Windows Azure Marketplace dataset subscriptions.

  • Find
    Locate an account key associated with a Windows Live account.

  • Save my account key
    Saves the account key (encrypted) with the data connection.

  • Advanced
    Set additional connection properties by using the Set Advanced Properties dialog box..

  • Test Connection
    Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.

From Other Feeds

  • Friendly Connection Name
    Type a friendly name for the data feed connection.

  • Data Feed URL
    Type the full path to an Atom service document (.atomsvc, .atom) or the URL for a single data feed, or click Browse to select an Atom service document.

    Click Include all feed columns to specify whether all the data feed columns are imported.

  • Browse
    Navigate to a location where a data feed is available.

  • Advanced
    Set additional connection properties by using the Set Advanced Properties dialog box.

  • Test Connection
    Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.