2 Database Setup
In this section you are going to setup database related configuration for Oracle Banking Origination Installation.
It is recommended to create different schema for each application. Below setup is designed to work with separate schema for each application.
Prerequisite
In this section, you are going to setup database related configuration for Oracle Banking Origination Installation. Before you proceed, ensure pre-installation setup is done. The pre-installation setup includes the configuration of database, setting up the setUserOverrides.sh. 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 ensure the creation of tables and availability of static data required for the execution of services. These are compiled automatically using flyway.
Database Setup
To setup DB for Oracle Banking Origination schema’s to be created:
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 | No (uses the plato 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) |