1. Common Core Services Installation Guide
  2. Data Sources Creation

3 Data Sources Creation

This topic describes about the data sources creation for Common Core services.

Prerequisites

Database and application setup for Oracle Banking Microservices Architecture must be performed before the deployment setup.

The data sources for the respective micro-services must be created before the application deployment. Each data source targets the corresponding server on which the application will be deployed.

The following sections describes the list of data sources required to be created for Common Core services and the steps to configure them in the server.

Figure 3-1 Data Source Creation


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

Data Sources List

The below list of the data sources must be created for each domain before the deployment of applications onto the managed servers.

Table 3-1 Data Sources List

Data Source Name Data Source JNDI Targets
PLATO jdbc/PLATO Common Core Managed Server
CMNCORE jdbc/CMNCORE Common Core Managed Server, API Gateway Server
PLATOBATCH jdbc/PLATOBATCH Common Core Managed Server
SMS jdbc/sms Common Core Managed Server
PLATOUI jdbc/PLATO_UI_CONFIG Common Core Managed Server
PLATOFEED jdbc/PLATOFEED Common Core Managed Server
PLATOSECURITY jdbc/PLATO_SECURITY Common Core Managed Server
<PRODUCT PROJECTION SCHEMA> (Required for Machine Learning framework) jdbc/<PRODUCT PROJECTION SCHEMA> Common Core Managed Server

Note:

Steps to create data source in WebLogic is same for all the above except for the connection details and names.
Common Core Services using Plato-Feed

The below listed common core services requires the data source to be created for plato-feeds on each domain prior to deployment of applications onto managed servers.

Table 3-2 List of Services using Plato-Feed

Service Name Data Source Name Data Source JNDI Targets
cmc-account-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
cmc-base-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
cmc-branch-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
cmc-settlement-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
cmc-currency-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
cmc-customer-services PLATOFEED jdbc/PLATOFEED Common Core Managed Server
Database Grant Privileges
The below listed user privileges are required for Machine Learning Framework:
  • GRANT CREATE MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT CREATE ANY MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT ALTER ANY MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT DROP ANY MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT SELECT ANY MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT COMMENT ANY MINING MODEL TO <PRODUCT PROJECTION SCHEMA>;
  • GRANT EXECUTE ON DBMS_DATA_MINING to <PRODUCT PROJECTION SCHEMA>;
  • GRANT CREATE JOB TO <PRODUCT PROJECTION SCHEMA>;

Steps to create Data Source

For creating data sources in managed server, refer to Create Data Sources section in Configuration and Deployment Guide.