How to Create Oracle Database and SOA-MDS Connections

To create Oracle database and SOA-MDS connections:

  1. Create a SOA composite application. For information, see Creating a SOA Application.

  2. Create a BPEL process in the SOA Composite Editor (for this example, a synchronous BPEL process is created). For information, see How to Add a BPEL Process Service Component.

  3. Double-click the BPEL process in the SOA Composite Editor.

    Oracle BPEL Designer is displayed.

  4. Create an Oracle database connection. This is required for querying Oracle Enterprise Scheduler jobs.

    1. From the File main menu, select New > Application.

    2. From the Categories list, select Connection.

    3. Select Database Connection.

      The Create Database Connection wizard is displayed.

    4. Complete the dialogs of the Create Database Connection wizard to create the connection to the Scheduler Oracle Metadata Services Repository database for the runtime server where Oracle Enterprise Scheduler is deployed, and click Finish.

  5. Create a SOA-MDS connection. A database-based MDS Repository is used for retrieving the jobs to select.

    1. From the File main menu, select New > Application.

    2. From the Categories list, select Connection.

    3. Select SOA-MDS Connection.

      The Create SOA-MDS Connection dialog is displayed.

    4. From the Connection Type list, select DB Based MDS.

    5. From the Connection list, ensure that the database connection created in Step 4 is displayed.

    6. From the Select MDS partition list, select the partition that includes Oracle Enterprise Scheduler jobs. For jobs defined in the Oracle Enterprise Scheduler predeployed native hosting application, the MDS partition name is essUserMetadata.

    7. Complete the remaining fields of the dialog to create the SOA-MDS connection, and click OK.