2 Setup Database
This topic provides detailed information about database related configuration for Oracle Banking Origination Installation.
It is recommended to create 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 database and setting up the
setUserOverrides.shfile. - After creating the schema for each of the required micro services, DDLs and INCs of each micro-service to be compiled in the respective schemas. The DDLs and INCs make sure that the creation of tables and availability of static data required for the execution of services. These are compiled automatically using flyway.
To set up a database for the creation of Oracle Banking Origination schema:
Table 2-1 Database Setup
| Service Name | Schema Required |
|---|---|
| obremo-rpm-maintenance-services | Yes (obremo-rpm-maintenance-services schema) |
| obremo-rpm-process-driver-services | Yes (obremo-rpm-process-driver-services schema |
| obremo-rpm-businessprocess-services | Yes (obremo-rpm-businessprocess-services schema) |
| obremo-rpm-businessproductdetails-services | Yes (obremo-rpm-businessproductdetails-services schema) |
| obremo-rpm-cmn-applicantservices | Yes (obremo-rpm-cmn-applicantservices schema) |
| obremo-rpm-cmn-hostservices | Yes (obremo-rpm-cmn-hostservices schema) |
| obremo-rpm-cmn-scorecardservices | Yes (obremo-rpm-cmn-scorecardservices schema) |
| obremo-rpm-lo-loanapplications | Yes (obremo-rpm-lo-loanapplications schema) |
| obremo-rpm-sav-account-service | Yes (obremo-rpm-sav-account-service schema) |
| obremo-rpm-term-deposit-service | Yes (obremo-rpm-term-deposit-service schema) |
| obremo-rpm-projection-services | Yes (obremo-rpm-projection-services schema) |
| obremo-rpm-batch-services | Yes (obremo-rpm-batch-server schema) |
| obremo-rpm-cmn-ipaservices | Yes (obremo-rpm-cmn-ipaservices schema) |
| obremo-rpm-cmn-collateralservices | Yes (obremo-rpm-cmn-collateralservices schema) |
| obremo-rpm-creditcardapplication | Yes (obremo-rpm-creditcardapplication schema) |
| obremo-rpm-cmn-mlservice | Yes (obremo-rpm-cmn-mlservice schema) |
| obremo-rpm-rule-configurationservice | No (Plato rule schema) |