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

  Note

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

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

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

See Also

Reference

Analysis Services Designers and Dialog Boxes (SSAS)
Data Source View Designer (SSAS)

Other Resources

Data Sources (Analysis Services)
Working with Data Sources (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance