Using DB Configuration Tool

• Overview
• Invoking DB Configuration tool in Windows
• Invoking DB Configuration tool in Linux
• Steps to change Applications Manager DB configuration from PGSQL to MSSQL
• Steps to change Applications Manager DB configuration from MSSQL to PGSQL

Overview

Changing the backend database server used by Applications Manager requires multiple configuration files to be updated manually. DB Configuration tool helps in reducing the manual interaction with the configuration files. It is used to change the database server configuration by obtaining credentials from you. This document explains how to change DB configuration from PGSQL to MSSQL and vice versa.

Note: DB Migration cannot be performed using this DB Configuration tool.

Invoking DB Configuration tool in Windows

• Start Command prompt with administrator privilege..
• Navigate to <Applications Manager Home>/bin.
• Execute the command DBConfiguration.bat

Invoking DB Configuration tool in Linux

• Open Terminal.
• Navigate to <Applications Manager Home>/bin>.
• Execute the command sh DBConfiguration.sh

Steps to change Applications Manager DB configuration from PGSQL to MSSQL

1. Select the DB : Choose MSSQL as DB.



If you are choosing MSSQL follow the below steps:

2. Select the Driver : Select the driver to be used.(jTDS / JDBC)
3. Select Authentication : In this step, you can select the type of authentication.{SQL/Windows/Kerberos (JDBC)}
4. Provide the credentials with respect to the selected type of authentication. It includes mandatory credentials like Username and Password(mandatory for all authentication types except Kerberos), DB Host/FQDN(Kerberos), Port, Database name and Domain.
5. Once you click OK, the database server configuration will begin with the given credentials and Authentication type.
6. Authentication message : On successful authentication, a pop-up message will appear where you can choose to proceed or not with configuring database server details.



7. Database server details will be configured once you click on Yes. A final message will be displayed stating "Database server details updated successfully. Please restart Applications Manager".



8. If the authentication fails, you will be notified and database server configuration will not happen.

Steps to change Applications Manager DB configuration from MSSQL to PGSQL

1. Select the DB : Select Bundled PGSQL as DB.
2. Click OK
3. The files will be updated and a message will be displayed stating "Database server details updated successfully. Please restart Applications Manager".