1. Analytical Application Infrastructure User Guide
  2. System Configuration and Identity Management
  3. System Configuration
  4. Database Server

Database Server

Database server refers to a computer in network which is dedicated to support database storage and retrieval. The database layer of Infrastructure system can be represented by a single database server.

The Database Server Details window within the System Configuration section of Infrastructure system facilitates you to add and modify the database server details on which the Infrastructure Database, Application, and Web components have been installed. A database server can support multiple Information Domains, but however, one Information Domain can be mapped to only one database layer.

Click the Administration icon from the header to display the Administration tools in Tiles menu. Click System Configuration from the Tiles menu to view a submenu list. Click Configure Database Server to view the Database Server Details window.

Figure 13-3 Database Server Details window


This illustration shows the Database Server Details window, which displays the pre-configured database server details. The window has the Database Server Details and FTP Details pane. In the Database Server Details, you can specify the IP Address, Socket Server Port, OS Type, and Transfer Protocol. In the FTP Details pane, you can specify the details in the Technical Metadata, Business Metadata, and Staging Area tabs.

By default, the Database Server Details window displays the pre-configured database server details. In order to add or modify the database server details, you need to ensure that:

  • The FTP/SFTP service should be installed on the Web/Application and DB Server.
  • The FTP/SFTP ID for Web/App and DB server has to be created through the Computer Management option under Administrative Tools for all the installations other than UNIX installations.
  • This user should belong to the administrator group.
  • The FTP/SFTP password for Web/App and DB server needs to be specified in the Computer Management option under Administrative Tools. Also, the Password Never Expires option has to be checked.
  • If the User enters an incorrect username, password, FTP Share and/or Port and clicks Save, the following alert message is displayed.

Password or ShareName incorrect on XXXXXXXXXXXXXXXXXXXcom on port X2

Note:

  • The Password verification is enabled only when One-off patch (34763896) is applied on 8121 ML release.
  • The Database Server Details window displays the pre-configured Database Server Details specified during OFSAA Infrastructure Installation