Creating the repository database

The repository database stores information about active sessions and tenants, resources, service managers and workers, and system information.

The database type can be Microsoft SQL Server or PostgreSQL.

  1. In the Repository and Access step, select Database. The Database connection dialog box opens. The subsequent steps describe the connections settings for a Microsoft SQL Server database as an example. The connection settings for a PostgreSQL database are different.
  2. By default, the database server type Microsoft SQL Server is selected from the Database type list. You can select one of these options:
    • Microsoft SQL Server
    • PostgreSQL Server
  3. On the Connection tab, specify this information:
    Select SQL server
    Select the server on which the new SQL Server database will be located from the list.
    Enter a system user
    A system user is required to create a new schema user or a new database. By default, the check box is selected.
    User name
    Specify the name of the system user that is used to connect to the database.
    Password
    Specify the password of the system user.
    Note: The system user requires the server role sysadmin.
  4. On the Schema tab, specify this information:
    Create new schema user
    Select this option, if you create a new schema user. Specify user name and password. By default, this option is selected.
    Use existing schema user
    Select this option, if you use an existing user as schema user.
    Use system user as schema user
    Select this check box, if you use the system user that you have specified on the Connection tab as schema user. You do not have to specify user name and password.
    User name
    Specify the name of the schema user.
    Password
    Specify the password of the schema user.
    Confirm password
    Confirm the password that you specified.
    New database
    Specify the name of the new repository database. By default, the option is selected. The default name is BIFarmRepository.
    Existing database
    Select this option, if you create the schema in an existing database. Select the database from the list.
    Note: On database level, the role db_owner must be assigned to the schema user.
  5. On the Options tab, specify the connection settings for the SQL Server as required. These settings are standard options for Microsoft SQL Server databases. For detailed information about the settings, refer to the Microsoft SQL Server documentation.
  6. To check the specified settings, click Validate. If the test is successful, the message The connection test was successful. is displayed. Click OK twice to close the dialog box.