Setting Up Repository Connection

To set up repository connection and work with it, use the Set Up Repository Connection dialog box.

IMPORTANT. For security reasons use the Metabases.xml file to create a list of repositories in the web application.

To open the dialog box

Set the parameters:

Name. Enter repository name that will be displayed in the login dialog box on starting Foresight Analytics Platform. Name may differ from the identifier.
Identifier. Enter repository identifier that is a metadata schema stored on the database server.
Driver. Select the driver in use in the drop-down list. For details about available drivers see the Supported DBMS section.

Set additional DBMS parameters depending on the selected driver type:

Server. Enter IP address or DNS name, with which the server with connected database (repository) is registered. The box is displayed if the driver type is selected: Oracle, Microsoft SQL Server, Microsoft SQL Server (ODBC), PostgreSQL.

If DBMS server port differs from the default port, parameters value is set in the format:

For Microsoft SQL Server: <IP address or DNS server name>,<port number>
For PostgreSQL: <IP address or DNS server name>:<port number>.

When Oracle DBMS is used, server port is determined in the tnsnames.ora file.

NOTE. When setting up repository connection, make sure that server IP address or DNS server name matches with the server specified on creating a service user on each client computer.

Database. Enter identifier of the database, to which the connection is established. Database identifier should match the repository identifier. The box is displayed if the driver type is selected: Oracle, Microsoft SQL Server, Microsoft SQL Server (ODBC), PostgreSQL.
Schema. Enter identifier of the custom schema if it was created on preparing DMS back end. The box is displayed if the driver type is selected: Microsoft SQL Server, Microsoft SQL Server (ODBC), PostgreSQL. The default schema for Microsoft SQL Server is "dbo" and for PostgreSQL is "public".

Authentication Type. Select in the drop-down list one of the user authentication types on the database server:

Password. Default value. The user is authenticated by means of specifying user name and password explicitly.
Integrated Domain. The user is authenticated by means of specifying domain user name and password explicitly (of the current operating system account). If the authentication type is selected for Oracle in Windows OS, determine additional server settings.
Domain. The user is authenticated by means of specifying domain, user name and password explicitly. The authentication type is available if the driver type is selected: Oracle, Microsoft SQL Server, Microsoft SQL Server (ODBC), PostgreSQL.

NOTE. To use the Integrated Domain or Domain authentication type, first, add domain users or domain groups in the security manager file is used.

DBMS is Case Sensitive. If required, select the checkbox to work with the repository, objects and their fields in DBMS having different character case in their physical names. After the checkbox is selected, database objects will be available only if their exact physical names are specified. If the checkbox is deselected, the repository name, physical names of objects and their fields in DBMS are converted to lower case while the platform addresses the server.

IMPORTANT. The parameter is set once on the primary setup of repository connection. If the parameter is changed again, it may result in data loss.

Case sensitivity settings, during repository connection parameters setup, should match the corresponding settings determined on repository creation.

Default Repository. Select the checkbox to display this repository automatically in the login dialog box on starting Foresight Analytics Platform if required.

NOTE. The default repository can be only one. If another default repository is already used, after the checkbox is selected, the default repository will be changed for the current connected repository.

If the default repository is not set, on starting Foresight Analytics Platform, the login dialog box will display the latest connected repository. If web application cache was cleared, the login dialog box will display the repository specified in the PP.xml file in the <metabase> section.

After executing the operations the repository connection is set up.

To save the settings, click the Apply button.