4 Create Data Sources

This topic provides systematic instruction to create the data source for Oracle Banking Origination installation.

The prerequisites are as follows:

  • Make sure that database setup for Oracle Banking Origination is completed before deployment setup.
  • The data sources for the respective microservices 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 diagram represents the process of creating data sources.

Figure 4-1 Data Source Creation


Description of Figure 4-1 follows
Description of "Figure 4-1 Data Source Creation"

To create the data sources:

  1. Create the data sources on each domain.

    Note:

    For more information on data source creation, refer to the Datasource Creation topic in the Configuration and Deployment Guide.

    The table below are the list of 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
    obremo-rpm-batch-services RPMBATCH Jdbc/RPMBATCH Oracle Banking Origination 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
    pmu-component-server None None Appshell Server
  2. Map the following data sources to all the newly created managed servers for Oracle Banking Origination.

    Note:

    As part of Oracle Banking Origination, the flyway JNDI changes are incorporated. To deploy the services successfully, the data sources need to be mapped.

    Table 4-2 Additional Data Sources

    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
    PMU jdbc/PMU Oracle Banking Origination Managed Server
  3. Provide the following grants to the user in the Projection schema 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>;