4 Data Sources Creation
In this section you are going to setup the data source creation for Oracle Banking Origination installation.
Prerequisite
Database setup for Oracle Banking Origination has to be performed prior to the deployment setup. The data sources for the respective micro-services must be created first before the application deployment. Each of the data source target to their corresponding servers on which the application will be deployed. The following sections explain the list of data sources required to be created for Oracle Banking Origination services and the steps to configure them in the server.
Data Source List
The table below lists the data sources to be created on each domain prior to deployment of applications onto managed servers.
Table 4-1 Data Source List
| Service Name | Data Source Name | Data Source JNDI | Targets |
|---|---|---|---|
| obremo-rpm-maintenance-services | RPMMAINTENANCE | jdbc/OBREMOMAINTCE | Oracle Banking Origination Managed Server |
| obremo-rpm-process-driver-services | RPMProcessDriver | jdbc/RPMPROCESSDRIVER | Oracle Banking Origination Managed Server |
| obremo-rpm-businessprocess-services | RPMBusinessProcess | jdbc/OBREMOBUSSPRC | Oracle Banking Origination Managed Server |
| obremo-rpm-businessproductdetails-services | RPMBusinessProduct | jdbc/OBREMOBPDETAILS | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-applicantservices | RPMCmnApplicant | jdbc/CMNAPPLICANT | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-hostservices | RPMHostService | jdbc/RPMHOST | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-scorecardservices | RPMScorecard | jdbc/CMNSCORECARD | Oracle Banking Origination Managed Server |
| obremo-rpm-lo-loanapplications | RPMLoan | jdbc/LOANAPP | Oracle Banking Origination Managed Server |
| obremo-rpm-term-deposit-service | RPMTD | Jdbc/TDACC | Oracle Banking Origination Managed Server |
| obremo-rpm-projection-services | RPMPROJECTION | jdbc/RPMPROJECTION | Oracle Banking Origination Managed Server |
| obremo-rpm-sav-account-service | RPMSaving | jdbc/SAVACC | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-ipaservices | RPMIPA | jdbc/IPA | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-collateralservices | RPMCOLLATTERAL | jdbc/OBREMOCOLLATERAL | Oracle Banking Origination Managed Server |
| obremo-rpm-creditcardapplication | RPMCREDITCARD | jdbc/CCAPP | Oracle Banking Origination Managed Server |
| obremo-rpm-cmn-mlservice | RPMML | jdbc/OBREMOML | Oracle Banking Origination Managed Server, CMC Managed Server |
| Appshell UI | None | None | Appshell Server |
| cmc-component-server | None | None | Appshell Server |
| moc-component-server | None | None | Appshell Server |
| sms-component-server | None | None | Appshell Server |
| oboflo-component-server | None | None | Appshell Server |
Steps to Create Datasource
For creating data source, refer to How to Create Datasource section in ANNEXURE-1
Additional Datasource Mapping
As part of Oracle Banking Origination, flyway jndi changes are incorporated. In order to deploy the services successfully, map the following data source to all the newly created managed servers for Oracle Banking Origination.
Table 4-2 List of Additional Datasource
| Data Source Name | Data Source JNDI | Targets |
|---|---|---|
| PLATO | jdbc/PLATO | Oracle Banking Origination Managed Server |
| PLATO_UI_CONFIG | jdbc/PLATO_UI_CONFIG | Oracle Banking Origination Managed Server |
| SMS | jdbc/sms | Oracle Banking Origination Managed Server |
| PLATOBATCH | jdbc/PLATOBATCH | Oracle Banking Origination Managed Server |
| PLATORULE | jdbc/PLATORULE | Oracle Banking Origination Managed Server |
| COMMON CORE | jdbc/CMNCORE | Oracle Banking Origination Managed Server |
User Grants
The following grants are provided to the user in the Projection schema which is required for Machine Learning use cases.
- GRANT CREATE MINING MODEL TO <RPMML SCHEMA>;
- GRANT CREATE ANY MINING MODEL TO <RPMML SCHEMA>;
- GRANT ALTER ANY MINING MODEL TO <RPMML SCHEMA>;
- GRANT DROP ANY MINING MODEL TO <RPMML SCHEMA>;
- GRANT SELECT ANY MINING MODEL TO <RPMML SCHEMA>;
- GRANT COMMENT ANY MINING MODEL TO <RPMML SCHEMA>;
- GRANT EXECUTE ON DBMS_DATA_MINING to <RPMML SCHEMA>;
- GRANT CREATE TABLE TO <RPMML SCHEMA>;
- GRANT DROP ANY TABLE TO < RPMML SCHEMA>;
- GRANT CREATE JOB TO <PRODUCT PROJECTION SCHEMA>;