Go to primary content
Oracle® Retail Bulk Data Integration Installation Guide
Release 16.0.2
E99802-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

6 BDI Batch Scheduler Installation

Installation Prerequisites

The BDI Batch Scheduler supports the same tech stack and platform specifications as given in prior section in this installation guide. The following infrastructure is required for Scheduler application installation.

Preparing for Installation

  • Before starting the installation, make sure a database schema has been created for the Scheduler application.

  • Ensure that the WebLogic server where the scheduler application will be deployed is up and running.

  • Download the BDI scheduler installer archive: BdiScheduler16.0.0ForAll16.x.xApps_eng_ga.zip

  • Unzip/extract the archive to a target directory to run the installer. The bdi-scheduler-home directory will be created under the target directory with the artifacts.

  • The following is part of the directory structure and artifacts that are extracted from the archive (not the complete list shown below).

    Surrounding text describes unzip4.png.

Note:

Any seed data schedule definition can be edited if required using the seed_data.sql file. To add a new schedule at the time of deployment, edit seed_data.sql to include an insert statement for the new schedule definition and add the corresponding <ScheduleName>_Action.sch file in the /setup-data/dsl directory. For more details, refer to the Oracle Retail Bulk Data Integration Implementation Guide.

Deploying Scheduler Application

  1. Edit bdi-scheduler-admin-deployment-env-info.json (in bdi-scheduler-home/conf directory) with corresponding values matching the target deployment environment. Update the values of the following configuration properties.

    Configuration Property Description

    DataSourceDef -> SchedulerAdminDataSource -> jdbcUrl

    JDBC URL of the scheduler database schema

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainName

    Name of the WebLogic domain where the scheduler application is deployed.

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainHome

    WebLogic Domain home directory.

    MiddlewareServerDef->SchedulerAdminAppServer->weblogicDomainAdminServerProtocol

    By default the protocol is t3 and if configured to SSL then update to t3s.

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainAdminServerUrl

    WebLogic Admin server URL. Example: t3://<serverHostName>:8001

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainAdminServerHost

    Host name of WebLogic Admin server.

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainAdminServerPort

    WebLogic Admin server port.

    MiddlewareServerDef -> SchedulerAdminAppServer -> weblogicDomainTargetManagedServerName

    Managed Server name where the Scheduler application is deployed.

    MiddlewareServerDef -> SchedulerAdminAppServer -> schedulerAdminUiUrl

    Scheduler Admin app URL.

    http://<serverHostName>:<managed server port>/bdi-scheduler

    MiddlewareServerDef -> ProcessFlowAdminAppServer -> processFlowAdminUiUrl

    BDI Process Flow app base URL. This URL will be used by the scheduler to connect to the process flow app to call process flows.

    Example: http://<serverHostName>:8001/bdi-process-flow


  2. Run the deployer script from the bdi-scheduler-home/bin directory. Use the -setup-credentials option to setup necessary credentials for the application and deploy.

    bdi-scheduler-admin-deployer.sh -setup-credentials -deploy-scheduler-admin-app
    

    The deployer will prompt credentials for the following user aliases to be configured. Enter the corresponding username and password as required for each alias.

    Alias Name Description

    bdiAppServerAdminServerUserAlias

    WebLogic admin server credentials

    bdiSchedulerAdminUiUserAlias

    Credentials for the user with Admin Role for Scheduler Admin app

    bdiSchedulerOperatorUiUserAlias

    Credentials for the user with Operator Role for Scheduler Admin app

    bdiSchedulerMonitorUiUserAlias

    Credentials for the user with Monitor Role for Scheduler Admin app

    bdiSchedulerAdminDataSourceUserAlias

    Datasource credentials to connect to the Scheduler database schema

    processFlowAdminBaseUrlUserAlias

    Credentials of the process flow admin app


  3. If you have already configured the credentials and can use the same credentials (typically when redeploying the app), you can run the deployer with the -use-existing-credentials option as follows, and you will not be prompted for the credentials again for the deployment.

    bdi-scheduler-admin-deployer.sh -use-existing-credentials -deploy-scheduler-admin-app
    
  4. Restrict access to the bdi-scheduler-home folder:

    cd bdi-scheduler-home
    chmod -R 700 . 
    

Verifying Installation

Perform the following procedure to verify the BDI Batch Scheduler installation:

  1. Verify that the deployer script has run successfully with no error. The scheduler application would have been deployed to the target environment.

  2. Launch the Scheduler admin app via the URL - http://<host>:<port>/bdi-scheduler/

  3. Verify you are able to access the URL by logging in using the admin or operator role.

  4. Verify that the list of schedules (created from seed data) is displayed in 'Manage Schedules' page of the app.

  5. Ensure that all the schedules are in 'Active' status.

  6. A schedule can be in 'Disabled' status if no schedule action is loaded for the corresponding schedule or if the schedule action contains any forbidden keyword. The user needs to correct the schedule action and enable the schedule. For more details on this, please refer to the Oracle Retail Bulk Data Integration Implementation Guide.

    Surrounding text describes batchsch-console.png.

Enabling Email Notification Alerts

Scheduler can send email alerts upon success or failure of schedule executions as specified in the schedule definitions. The following configuration is required for Scheduler email notification.

Mail Session configuration in WebLogic, for scheduler email notification:

  1. Go to the WebLogic Admin console of the environment where the scheduler app is deployed.

  2. Navigate to Services -> Mail Sessions.

  3. Select 'New' to create a new mail session.

  4. Enter the following details:

    Name: BdiSchedulerMailSession

    JNDI name: mail/BdiSchedulerMailSession

    Session Username: A valid email id, preferably email-id of an administrator.

    Session password: The password for the above email id.

  5. Enter the following in the JavaMail properties:

    mail.smtp.ssl.enable=true

    mail.smtp.auth=true

    mail.smtp.ssl.trust=<company's smtp mail server host name>

    mail.smtp.port=<mail server smtps port, typically is 465>

    mail.transport.protocol=smtps

    mail.smtp.host=<company's smtp mail server host name>

    mail.from=<A valid email-id for 'from email address' when email is sent>

  6. Click Next. In the Mail Session Targets, select the managed server where the scheduler application is deployed.

  7. Finish creating the mail session.


    Note:

    For more information on configuring Mail sessions on WebLogic, see the Oracle® WebLogic Administrator's Guide 12c Release.