Registering a PostgreSQL repository database

You use the New Registration command to register a PostgreSQL repository database. The registration contains the information to connect to the selected database.

To register a PostgreSQL repository database:

  1. Right-click Repository Registrations in the tree and select the New Registration command. The New Registration dialog opens.
  2. Specify this information:
    Name

    Specify the name of the new repository registration.

    Note: Registrations of the same name are not allowed in Repository Administration.
    Configuration
    Select the configuration source that will be used to save the repository registration from the drop-down list. You can select the configuration sources User, Computer, Enterprise, or Service.
    See Configurations.
    Description
    Specify the description of the repository registration.
    Note: 

    If the check box Use Computer configuration as default is selected in the Options dialog, new registrations are saved to the configuration source Computer.

    See Options.

  3. To configure the database connection, click Edit. The dialog Database Connection opens.
  4. Select PostgrSQL Server from the Database type drop-down list.
  5. On the Connection tab, specify this information:
    Select PostgreSQL server
    Specify the name of the server on which the PostgreSQL database is located. If the connection string is used by several computers, specify the complete server name, for example, bi_app.infor.com.
    Port
    Specify the port number of the PostgreSQL server. By defaut, the port number is 5432.
  6. On the Schema tab, specify this information:
    Authentication
    Select the authentication method that you use for the schema user from the drop-down list. You can select Basic or Windows authentication.
    User name
    If Basic authentication is selected, specify the name and password of the schema user. If Windows authentication is selected, you do not have to specify a user name and password. The log-in data of the current user is used.
    Password
    Specify the password of the schema user.
    Select database
    Select the Repository database from the drop-down list.
  7. On the Options tab, specify the connection settings for the PostgreSQL server as required. These settings are standard options for PostgreSQL databases. For detail information about the settings, see the manual of PostgreSQL Server.
  8. To check the specified settings, click Validate. If the test is successful, the message The connection test was successful. is displayed. Click OK to save the settings and to close the dialog.
  9. Specify the log-on information of the Repository administrator:
    Authentication
    By default, the authentication method that you use for the Repository administrator is Basic.
    User name
    Specify the user name of the Repository administrator.
    Password
    Specify the password of the Repository administrator.
    Save password
    Select this check box to save the password of the Repository administrator.
  10. Click Create to start the creation of the new Repository registration. After the creation, the new Repository registration is displayed underneath the Repository Registrations node.
Parent topic: Repository registrations and databases