3 Using the CustomerDataTutorial

This chapter describes how to use and modify the CustomerData tutorial. It contains the following topics:

Introduction
Using the Tutorial

Introduction

This tutorial teaches you how to use Oracle JDeveloper ESB Designer and ESB Control Console to deploy and test the CustomerData tutorial. In addition, you will also modify the CustomerData tutorial by creating a new inbound file adapter service.

The CustomerData tutorial consists of following steps:

Legacy customer files are picked up from a directory by an inbound adapter service named CustIn.
The CustIn adapter service sends the file data to a routing service named CustIn_RS.
The CustIn_RS routing service converts the file data to a canonical data structure and sends the file data to the CustOut_RS routing service.

By converting the data structure to a canonical data structure, the data can be moved across the Oracle Enterprise Service Bus as a single message format. When the message is ready to be delivered to an external target, the message format can be converted to the format required by that target.
The CustOut_RS routing service:
- Sends the message in the canonical format to the CRMOut adapter service for delivery to the Customer Relationship Management Application.
- Transforms the message to the structure required by the Customer Information Database, applies a filter to determine if payload contains a customer address that is in the United States.
  - If the customer address is in the United States, then the message is sent to the CustDBOut adapter service for delivery to the Customer Information Database.
  - If the customer address is not in the United States, then the message is not delivered to the Customer Information Database.

Using the Tutorial

In this section, you will run the ESB CustomerData tutorial. Perform the following steps to run the tutorial:

From the desktop Start button, select All Programs, Oracle – Oracle-Home, Oracle Process Manager, Start Oracle Process Manager to start opmn and all managed processes. The Start Oracle Process Manager window appears and then closes.
Download the CustomerSample.zip file and unzip to the folder C:\Customer.
From the desktop Start button, select All Programs, Oracle – Oracle-Home, Oracle ESB 10.1.3, Developer Prompt. The Developer Prompt window is displayed.

On the prompt, type the following commands:

cd <ORACLE_HOME>\integration\esb\olite\bin
sql_olite.bat @C:\Customer\create_customer.sql

Open a new prompt window and type the following commands:
```
cd <ORACLE_HOME>\integration\esb\bin
import C:\Customer\CustomerData.zip
```
The CustomerData metadata gets imported.
Open the ESB Control Console window, login with your username and password, and then click the Refresh button in the ESB Control Console window to view the updated services.

Note:
Refer to "Starting and Stopping Oracle Enterprise Service Bus Components" to open the ESB Control Console.

This section contains the following topics:

"Viewing the Services in the ESB Control Console"
"Step-By-Step Instructions for Running the Tutorial"

Viewing the Services in the ESB Control Console

View the Oracle Enterprise Service Bus configuration in the Oracle Enterprise Service Bus Control Console, as follows:
- If the Oracle Enterprise Service Bus Control Console is currently open:
  
  Click the Services button, the Oracle Enterprise Service Bus Control Console Services window is displayed. Click the Refresh button and then click CustOut_RS.
- If the Oracle Enterprise Service Bus Control Console is not open:
  
  Open the Oracle Enterprise Service Bus Control Console, as described in "Starting and Stopping Oracle Enterprise Service Bus Components") and then click CustOut_RS.
  
  The Diagram tab appears as shown in Figure 3-1.
Click the Routing Rules tab to view the defined routing rules.

Note:
The Routing Rules tab enables you to add, delete, or update the routing rules for each operation. It also enables you to map the customer data information.

Step-By-Step Instructions for Running the Tutorial

You can run the CustomerData tutorial by following these steps:

Copy the LegacyCustomer.xml file from the C:\Customer directory to the C:\Customer\In directory, for the CustIn adapter service to read into enterprise service bus configuration.
In the ESB Control Console, click the Instances tab.
Click CustOut_RS to view the execution path.

The diagram in the ESB Control Console indicates that the filter expression you added to the CustOut_RS routing service evaluated to TRUE because the message content was for a customer located in the US. Also, you can view in the ESB Control Console that the message was successfully sent to the CRMOut JMS adapter service.
Copy the C:\Customer\LegacyCustomerCanada.xml file to the C:\Customer\In directory.
In the ESB Control Console, click the Instances icon shown highlighted in the following graphic:

Description of the illustration instanceicon.gif
Click CustOut_RS.

Figure 3-1 indicates that the filter expression you added to the CustOut_RS routing service evaluated to FALSE because the message content was not for a customer located in the US. Also, you can view in the ESB Control Console that no additional record was added to the Database due to the filter expression.

Figure 3-1 ESB Control Console

Description of "Figure 3-1 ESB Control Console"