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.

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 (SSAS).

< 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.

ms188949.note(en-US,SQL.90).gifNote:
This option is disabled when you select the Maintain a reference to another object in the solution check box.

ms188949.security(en-US,SQL.90).gifSecurity 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 (SSAS).

ms188949.security(en-US,SQL.90).gifSecurity 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.

Community Additions

ADD
Show: