Set up Database

1 Set up Database

You need to set up the database-related configuration for the installation of the Oracle Banking Branch. It is recommended to create a different schema for each application.

The prerequisites for setting up the database are as follows:

Make sure that the pre-installation setup is completed. The pre-installation setup includes the configuration of the database and setting up the setUserOverrides.sh file.
After creating the schema for each of the required microservices, compile the DDLs and INCs of each microservice in the respective schemas. The DDLs and INCs ensure the creation of tables and the availability of static data required to execute services. These are compiled automatically using flyway.
Configure the placeholders in the setUserOverrides.sh file for Oracle Banking Branch installation. For the values of keys and placeholders, refer to Keys and Placeholders.

Note:
To update the placeholders for Oracle Banking Microservices Architecture services, refer to Placeholder Update for Oracle Banking Microservices Architecture Services section in Configuration and Deployment Guide.

The setup is designed to work with a separate schema for each application. For information on database best practices, refer to FLEXCUBE UBS Database Practices in the FLEXCUBE Universal Banking documentation library.

To set up the database for Oracle Banking Branch:

Create the Oracle Banking Branch schemas. For information on schemas to be created, refer to the table below:

Table 1-1 Database Setup

Service Name	Schema Required
`obremo-srv-bcn-branchcommon-services`	Yes (`obremo-srv-bcn-branchcommon-services` schema)
`obremo-srv-adp-adapter-services`	Yes (`obremo-srv-adp-adapter-services` schema)
`obremo-srv-cas-cash-services`	Yes (`obremo-srv-cas-cash-services` schema)
`obremo-srv-cmn-ml-processing`	No (`obremo-srv-bcn-branchcommon-services` schema)
`obremo-srv-cmn-transaction-services`	Yes (`obremo-srv-cmn-transaction-services` schema)
`obremo-srv-cus-customer-services`	Yes (`obremo-srv-cus-customer-services` schema)
`obremo-srv-pay-payment-services`	Yes (`obremo-srv-pay-payment-services` schema)
`obremo-srv-prj-projection-services`	Yes (`obremo-srv-prj-projection-services` schema)
`obremo-srv-tds-term-deposit-services`	Yes (`obremo-srv-tds-term-deposit-services` schema)
`obremo-srv-cmn-utils-services`	No (`obremo-srv-bcn-branchcommon-services` schema)
`obbrn-srv-biz-businessprocess-services`	Yes (`obbrn-srv-biz-businessprocess-services` schema)
`obbrn-cmn-businessproductdetails-services`	Yes (CMNBUSPROD schema)
`obbrn-cmn-process-driver-services`	Yes (CMNPRODRV schema)
`obremo-csr-cus-customer-services`	Yes (CSRCASA schema)
`obbrn-cmn-branchservicing-services`	Yes (CMNSCRV schema)
`obbrn-csr-casa-details-services`	No (CSRCASA schema)
`obremo-dsr-tds-term-deposit-services`	Yes (New schema to be created for `obremo-dsr-tds-term-deposit-services` - DSRDEPOSIT)
`obremo-dsr-tds-term-deposit-inquiry-services`	No (`obremo-dsr-tds-term-deposit-services` schema)
`obremo-lsr-loan-services`	Yes (LSRLOAN schema)
`obbrn-cmn-accountlimit-services`	No (CMNSCRV) schema

Create the user grants. For more information on creating user grants, refer to Create User Grants.

Keys and Placeholders
The values of the keys and their respective placeholders need to be configured in the setUserOverrides.sh file for installation of the Oracle Banking Branch.
Create User Grants
You need to create the user grants in the necessary schemas to set up the database-related configuration for Oracle Banking Branch.