Share via

  • Article

Data Source Designer Dialog Box (Analysis Services)

Use the Data Source Designer dialog box in Business Intelligence Development Studio to create or modify a data source. You can display the Data Source Designer dialog box by:

  • Right-clicking a data source for an Analysis Services project in Solution Explorer and selecting Open or View Designer from the context menu.

  • Double-clicking a data source for an Analysis Services project in Solution Explorer.

Options

  • Data source name
    Type the name of the data source.

  • Provider
    Displays the managed .NET or native OLE DB provider specified in Connection string.

  • Connection string
    Displays the connection string for the data source. Select one of the following options to define the connection string for the data source from the drop-down list:

    • < New Connection... >
      Select to display the Connection Manager dialog box and define a new connection string. For more information about the Connection Manager dialog box, see Connection Manager Dialog Box (Analysis Services - Multidimensional Data).

    • < Paste from Clipboard >
      Select to paste a connection string from the clipboard.

    • Other data sources
      Select a previously defined connection from which to copy the connection string.

    Note

    This option is disabled when you select the Maintain a reference to another object in the solution check box.

    Security noteSecurity Note

    The Connection Manager dialog provides an option to save any password entered as part of the connection string. If this option is selected, the password is saved in an unencrypted project file. This might create a security vulnerability if a malicious user gains access to the project files. If the password is not saved, a prompt will be displayed requesting the password when attempting to connect to the data source.

  • Edit
    Click to display the Connection Manager dialog box and define a new connection string. For more information about the Connection Manager dialog box, see Connection Manager Dialog Box (Analysis Services - Multidimensional Data).

    Security noteSecurity Note

    The Connection Manager dialog provides an option to save any password entered as part of the connection string. If this option is selected, the password is saved in an unencrypted project file. This might create a security vulnerability if a malicious user gains access to the project files. If the password is not saved, a prompt will be displayed requesting the password when attempting to connect to the data source.

  • Maintain a reference to another object in the solution
    Select this check box to create a connection string based on another data source or project. After you enable this option, select whether to create a data source based on an existing data source or to create a data source based on an Analysis Services project. After you select an object, the connection string based on your selection is displayed next to Connection string.

    The selected data source or project must match the provider type for the data source. Error messages are displayed for invalid selections.

  • Isolation
    Select the default isolation mode to use when reading data from the data source.

  • Query timeout
    Specify the query timeout (in seconds) for queries sent to this data source.

  • Maximum number of connections
    Select the maximum number of connections allowed by Analysis Services to the selected data source.

  • Data source description
    Type an optional description of the data source.

  • Impersonation information
    Select the Windows account that Analysis Services will use to connect to the data source when Windows Authentication is selected. OLAP processing does not support Use the credentials of the current user.