Database aliases

Users who work with the report catalogs of Infor BI Application Studio or Infor BI Office Plus, use database aliases to connect to databases. The aliases are created in Infor BI Application Studio and Infor BI Office Plus. You edit the connection settings of the aliases in the Database Aliases view. You can save different settings for individual users or roles.

To open the Database Aliases view, click Database Aliases under the report catalog in the tree.

The Database Aliases view is divided into the sections _Default, Basic Users, and Roles. The sections contain the same setting possibilities. However, the settings have different scopes. In the _Default section, you administer the default settings. In the Basic Users and Roles sections you can save user-specific and role-specific settings. Click _Default or the name of a user or role under Basic Users or Roles, to show the settings.

To specify, whether individual settings are saved for a role or a user, select the check box in the Inherit column. Users inherit the settings of the role, which you select in the Settings of the Report Catalog or Report Catalog Permission Management views.

This role is shown in the Inherit from role field. For roles, you specify in the Inherit column, whether they inherit the setting you specify in the _Default section. Clear the Inherit check box, to save an individual setting for a user or a role.

You can configure these settings:

Settings	Description
Alias	Shows the name of the database alias. You cannot change the name here. Aliases are created in Infor BI Application Studio or Infor BI Office Plus.
Connect Automatically	Specify, whether the connection to the database is automatically established when users log on to Infor BI Application Studio or Infor BI Office Plus.
Inherit	Specifies for a user, whether he inherits the settings from the role. Specifies for a role, whether it inherits the default settings.
Authentication	Specifies the authentication type that is used to log on with the database alias. Windows and Infor Federation Services are example authentication types. The database type determines which authentication types are possible.
User Name	User name that is used to log on with the database alias. The user name only is required, if the selected authentication type requires it, for example, not required for Windows Authentication.
Save User Name	Specifies, whether the user name is saved, or whether users have to enter it each time they log on.
Password	Password that is used to log on with the database alias. The password only is required, if the selected authentication type requires it, for example, not required for Windows Authentication.
Save Password	Specifies, whether the password is saved, or whether users have to enter it each time they log on.
Settings	Click in a cell to open a dialog, in which you can edit additional settings, which are different according to the database type. For OLAP databases you specify here the status of the Event Agent that is required to establish the connection by the alias.