Creating a New Integration in Oracle Integration

Before You Begin

This 15-minute tutorial shows how to integrate the Oracle Service Cloud (RightNow) and Oracle Sales Cloud connections and map data so that data can flow from Oracle Service Cloud (RightNow) to Oracle Sales Cloud.

In this series, you learn how to create an integration using Oracle Integration. This is the second tutorial in the Creating an End-to-End Integration series. Read the tutorials sequentially.

• Creating Connections
• Creating a New Integration in Oracle Integration
  
• Verifying Your Integration

Scenario

In this series of  tutorials, you will create an integration flow that synchronizes customer information between Oracle Service Cloud (RightNow) and Oracle Sales Cloud in real time - that is, whenever an Organization is created in Oracle Service Cloud (RightNow), an AccountService is created in Oracle Sales Cloud in real time.

The following figure illustrates the scenario.

Background

Now that you've created connections, you need to integrate the connections so that data can flow from one (the trigger) to the other (the invoke). In this tutorial the Oracle Service Cloud (RightNow) application is the trigger and the Oracle Sales Cloud application is the invoke.

Watch "Create Integrations in Integration" to see it before you do it.

What Do You Need?

Completion of the tutorial Creating Connections in Oracle Integration.

Create the Integration

1. In the Designer pane on the left of the Integration page, select Integrations.

   

2. On the Integrations page, click Create.

   

3. In the Create Integration - Select a Style/Pattern dialog, select App Driven Orchestration.

   

4. Enter the following integration information in the Create New Integration dialog:

   Field	Enter
   What do you want to call your integration?	MyIntegration
   Identifier	MYINTEGRATION (Note: The default value is entered for you automatically.)
   Version	Nothing to enter. Use the default value of 01.00.0000.
   What does this integration do?	Syncs Service Cloud (RightNow) Organization objects with OSC AccountService.
   Which package does this integration belong to?	MyPackage (Note: Packages enable you to group integrations into a single structure that makes them easy to import and export.)

   

5. Click Create.

Configure the Oracle Service Cloud (RightNow) Connection (Trigger)

1. On the integration canvas page, click Triggers to expand the panel.

   

2. Drag your Oracle Service Cloud (RightNow) connection to the Trigger area. This invokes the configuration wizard.

   

3. Fill in the wizard Basic Info page with the following information:

   Field	Enter
   What do you want to call your endpoint?	SyncOrganization
   What does this endpoint do?	Receives request from Oracle Service Cloud (RightNow) to create Account in Oracle Sales Cloud

   

4. Click Next to advance to the Request page.
5. Select Event Subscription and select Organization created from the list. Alternatively, you can type Organization in the the Select Event text box to filter the event.
   

   

6. Click Next to advance to the Response page.
7. Because this is a one-way process, there is no response. Select the None response type.

   

8. Click Next.
9. Verify the details in the Summary page and click Done. The Oracle Service Cloud (RightNow) connection appears on the integration canvas.

   

10. Click Save on the integration canvas to save your work.

Configure Oracle Sales Cloud Connection (Invoke)

1. On the integration canvas page, click Invokes to expand the panel and drag your Oracle Sales Cloud connection to the Invoke area. This invokes the configuration wizard.

   

2. Fill in the wizard Basic Info page with the following information:

   Field	Enter
   What do you want to call your endpoint?	CreateAccount
   What does this endpoint do?	Create Account in Oracle Sales Cloud

   

3. Click Next to advance to the Operations page.
4. Select Services from the Browse by drop-down menu.
5. Select AccountService from the scrolling list of business services. Alternatively, you can type AccountService in the the Filter By object name text box to filter the object.
6. Select createAccount from the drop-down menu beneath the scrolling list.

   

7. Click Next.
8. Verify the details in the Summary page and click Done. The Oracle Sales Cloud connection appears on the integration canvas.

   

9. Click Save on the integration canvas to save your work.

Map the Data

One of the key tasks in creating an integration is defining how data is transferred, or mapped, between two applications. You will now map the fields of the Oracle Service Cloud (RightNow) Organization object (trigger) to the fields of the Oracle Sales Cloud AccountService (invoke). The Oracle Integration visual mapper enables you to map fields between applications by dragging trigger fields onto invoke fields. When you open the mapper for a request or response message in an integration, the data structures are automatically populated with the information pulled from the trigger and invoke connections.

Watch "Map Data in Oracle Integration" to see it before you do it.

1. Click the mapping icon between the trigger and the invoke icons and click the Edit icon.

   

2. Click the Create icon when prompted. This opens the mapper.

   

   The source data structure is on the left of the mapper and the target data structure is on the right. Collapse the top-level nodes to make it easier to see the fields with which you want to work.
3. Drag the source to the target, as listed in the table. Drop the source in the empty field next to the target. As shown in the image, the green check mark icon and the line connecting them indicate that these fields have been mapped. You can use the search option to find the source and target objects.
   

   Source	Target
   process / Organization / Name	createAccount / account / OrganizationName
   process / Organization / NumberOfEmployees	createAccount / account / EmployeesTotal
   process / Organization / SalesSettings / TotalRevenue / Currency / Name	createAccount / account / CurrencyCode

   

4. After you have mapped the three items in the table, on the target side, search for the CreatedByModule field and then click it to invoke the Build Mappings page.

   

5. In the Drag and Drop or Type here text box, enter the identifier that was associated with this integration when it was created. Type MyIntegration.

   

6. Click Save, then click Close.

   

7. Click Validate to validate the mapping, then click Close.

   

Add Business Identifiers for Tracking

1. On the integration canvas page, click Actions, then select Tracking from the Actions menu.

   

2. Drag the LookupName field from the Source section into the Tracking Field column. This lets you track the status of that payload field during runtime.

   

3. Click Save.
4. Note that the mapping icon turns green and the Flow Progress Indicator shows that the integration is 100% complete.

   

5. Click Save.
6. Click Close to exit the canvas.

Activate the Integration

1. Find MyIntegration in the Integrations list and click the Activate slider.

   

2. Click Activate when prompted to confirm. Note: Do not select Enable tracing.

   

3. Verify that the integration is Active.

   

4. Click Details icon to view integration information.

   

Next Tutorial

Verifying Your Integration