Developing Integration Flows with Oracle Integration Cloud Service

1. Start Oracle Integration Cloud Service.
2. On the Home page, click Create Connections.
   
   

   

   
   
3. Click New Connection.
   
   

   

   
   
4. Type "right" in the Select Adapter Search field and then select the Oracle RightNow adapter.
   
   





5. Enter the following connection information in the New Connection - Information dialog.

5. Click Create.
5. In the Email Address field of the Connection Administrator section, enter your email address.
6. Click Configure Connectivity to configure the WSDL URL. Enter the URL to your Oracle RightNow WSDL file.
7. Click Configure Security. Enter the username and password required to access your Oracle RightNow application. Note that the Username Password Token option is automatically selected in the Security Policy list. This is the only selection available.
8. Click Save.
   
9. Click Test to verity the connection.
   
   

   

   
   If the test is successful, you see the following message at the top of the window. 

   

   If the test is not successful, verify that the WSDL URL and credentials that you entered are correct.

10. Click Exit Connection.

The new connection is added to the top of the connections list.

Creating an Oracle Sales Cloud connection is very similar to creating the Oracle RightNow connection.

1. Click New Connection.
2. Type "sales cloud" in the Select Adapter Search field and then select the Oracle Sales Cloud adapter.
   
   

   

   
   
3. Enter the following connection information in the New Connection - Information dialog:

4. Click Create.
5. In the Email Address field of the Connection Administrator section, enter your email address.
6. Click Configure Connectivity to configure the WSDL URL. Enter the URL to your Oracle Sales Cloud WSDL file in the OSC Services Catalog WSDL URL field.
7. Click Configure Security.  Enter the username and password required to access the Oracle Sales Cloud application. Note that the Username Password Token option is automatically selected in the Security Policy list. This is the only selection available.
8. Save the connection.
9. Click Test to verity the connection.
   





10. If the test is successful, you see the following message at the top of the window. 
    
    

    

    
    

    If the test is not successful, verify that the WSDL URL and credentials that you entered are correct.

11. Click Exit Connection.

The new connection is added to the top of the connections list.

To create a new integration, perform the following steps:

1. Click Designer at the top right corner of the Integration Cloud Service Home page.

     

2. Click the Integrations icon.

   

3. Click New Integration.

    

4. In the Create an Integration - Select a Style/Pattern dialog, select Basic Map Data.
5. Enter the following integration information in the Create New Integration dialog:

5. Click Create.

1. Drag your Oracle RightNow connection to the Trigger area. This invokes the configuration wizard.
   
   
   
   
2. Fill in the wizard Basic Info page with the following information:
   

3. Click Next to advance to the Request page.
4. Scroll down the list of business objects and select Organization from the list.

   

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

   
   
   

5. Click Next.
6. Click Done.
7. Click Save on the main canvas to save your work.
   

   

1. 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:

3. Click Next to advance to the Operations page.
4. Select Services from the Browse by dropdown menu.
5. Select AccountService from the scrolling list of business services.
6. Select createAccount from the dropdown menu beneath the scrolling list.
   
   
   
   
7. Click Next.
8. Click Done.
9. Click Save on the main canvas to save your work.
   

One of the key tasks in creating an integration is defining how data is transferred, or mapped, between two applications. In this tutorial, you map the fields of the  Oracle RightNow Organization object (trigger) to the fields of the Oracle Sales Cloud AccountService (invoke). The Oracle Integration Cloud Service 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.

To map data for this integration, perform the following steps:

1. Click the mapping icon between the trigger and the invoke icons.
   
   
   
   
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 above, the green checkmark icon and the line connecting them indicate that these fields have been mapped.
   
   

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, type MyIntegration.
   
   
   
   
6. Click Save, then click Close.
7. Click Save, then click Exit Mapper.
 


8. Save the Integration.

9. Click Exit Integration.

Perform the following steps to enable the tracking of payload fields.

1. Click MyIntegration in the Integrations list..
   
2. Click Tracking above the integration.

3. 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.
4. Click Done.
5. Note that Flow Progress Indicator shows that the integration is 100% complete.
   
6. Click Save.
7. Click Exit Integration.

To activate your integration, perform the following steps:

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.
   
   
   
   

1. Launch the Oracle RightNow console.  Note: The RightNow console only runs in the Internet Explorer web browser.
2. Click the Install Oracle Service Cloud button.
   
   
   
   
3. Log in to the console using the credentials you specified when you created the Oracle RightNow connection.
   
   
   
   
4. The console user interface appears.
   
   
   
   
5. Click the arrow at the bottom left of the console window.
   
   
   
   
6. Select Configuration and then expand the Site Configuration item.
   
   
   
   
7. Double-click Process Designer.
   
   
   
   
8. After the process designer opens, select New. The new object event handler window appears.
   
   
   
   
9. Click the Browse icon and select the file that contains your PHP script.
   
10. Select Execute Asynchronously.
11. Click Save.
12. Click Test.
    
    
    
    The Good URL dialog confirms that the connection is made.  If the connection fails, check the URLs in your PHP script.

1. Select Deploy.
2. Add the email address used when you set up your connection in Integration Cloud Service.
3. Select Organization in the tree.
   
   
   
4. Select createOrganization.
5. Select Can Suppress.
6. Click Save.
7. Click Deploy.
8. Click OK.

1. Launch Oracle Sales Cloud.
2. Click the Accounts icon.
3. Verify your account appears in the list.

Use the following links to find more information about the prerequisites mentioned in the "Prerequisites" section of this tutorial:

• Get an Oracle Integration Cloud Service subscription or trial subscription.
• Get an Oracle RightNow Cloud Service subscription or trial subscription. Note: In some documentation and user interfaces, the Oracle RightNow Cloud Service is referred to as Oracle Service Cloud.
• Get an Oracle Sales Cloud subscription or trial subscription.

The following resources complement this tutorial:

• eBooks
• User Guide
• Community Forum
• Videos