Oracle Integration Cloud Service (OICS) – Part 1
With the rising demand for Oracle Integration Cloud (OIC), we’re excited to share key insights to help learners stay ahead. At Apps2Fusion, we believe in the power of knowledge sharing, providing industry expertise and best practices to ensure an enriched learning experience.
Oracle Integration Cloud Service (ICS)
Oracle Integration Cloud is a robust yet user-friendly integration solution designed to enhance the value of your SaaS and on-premise applications. This intuitive platform simplifies the process of developing, deploying, executing, managing, and monitoring integrations. Oracle offers a well-defined cloud ecosystem with distinct categories: PaaS, SaaS, and IaaS, catering to diverse business needs.
Key Features of Oracle Integration Cloud
- User-Friendly – Web-based, point-and-click integration for a seamless experience.
- Pre-Configured – Comes with built-in compatibility for your existing Oracle SaaS subscriptions.
- Version Compatibility – Automatically adapts to new Oracle application versions without manual updates.
- Enhanced Security – Utilises Oracle’s built-in security framework for robust protection.
- Real-Time Monitoring – Provides clear visibility into business operations with intuitive dashboards.
- Proactive Error Handling – Advanced monitoring and error management to detect and resolve issues efficiently.
- Flexible Lifecycle Management – Supports both on-premise and cloud-based lifecycle tools.
- Fully Managed – Oracle handles backups, patches, and upgrades, ensuring a hassle-free experience.
Benefits of Oracle Integration Cloud
- Seamless Integration – Pre-linked with SaaS and PaaS for effortless connectivity.
- Pre-Built Integrations – Easily customise and activate as per your needs.
- Extensive Connectivity – Supports both cloud and on-premise applications with diverse connectors.
- Quick Deployment – Fully automated setup for faster implementation.
Prerequisites for this Tutorial
- Download and install the SOAPUI client from the link below (any version will work):
https://www.soapui.org/downloads/latest-release.html - SOAPUI is a widely used open-source tool for functional testing, primarily focused on API testing.
- It supports multiple protocols, including SOAP, REST, HTTP, JMS, AMF, and JDBC.
- With SOAPUI, you can quickly design automated functional tests and execute performance tests efficiently.
Take your expertise to the next level with our
Oracle Integration Cloud Service (OICS) Training
Objectives of Oracle Integration Cloud
This tutorial walks you through the steps to build your first cloud integration. Integrations leverage the connections established with your applications to facilitate seamless data exchange. You’ll learn how to create, import, modify, and delete integrations, set up message publishing and subscription, and manage request and response enrichment triggers. Additionally, this guide provides an overview of the ICS user interface and its key functionalities.
1. Build a Basic Integration Flow
Integrating services within Oracle Integration Cloud involves two key steps: establishing connections and then integrating them. First, you define connections by adding a contact, configuring connectivity using a WSDL URL, and securing access with credentials. Next, you create the integration by setting up both the source and target systems and mapping business objects between them.
2. Connecting with SOAP-Based Web Services
Connections store essential details about the specific instances of applications you are integrating. Oracle Integration Cloud provides a range of prebuilt adapters for applications like Oracle Sales Cloud, Oracle Eloqua Cloud, and Oracle RightNow Cloud. Each connection is built on an adapter and requires additional configuration, such as metadata or connection details.
For instance, when connecting to Oracle RightNow Cloud, you would select the RightNow adapter, specify the WSDL URL, define the security policy, and enter authentication credentials.
The SOAP Adapter facilitates connectivity with SOAP-based web services, allowing you to expose an integration as a SOAP service or call external SOAP services. To configure a SOAP connection, you can either upload a WSDL file or provide a URL. The system then reads the file, displaying the available port types, operations, and services. If a single service is defined, it is automatically selected; otherwise, you can choose from multiple available options.
3. Mapping Elements Between Source and Target
Once the integration flow is set up, the next step is to map the elements between the initiating (trigger/source) and receiving (invoke/target) applications. This ensures seamless data transfer and accurate communication between systems.
4. Activating and Testing the Integration
The integration follows a straightforward request/response pattern. The source application sends a request to retrieve data from the target application through Oracle Integration Cloud, receiving a response almost instantly. Once the integration is configured, it must be activated and tested to confirm smooth functionality.
Setting Up a Hello World Integration Flow
1. Navigate to the Designer section in the Oracle Integration Cloud (OIC) console.
2. Select Connections from the menu.
3. Click Create New Connection and choose the SOAP Adapter.
4. Fill in the required details in the New Integration Information dialog box.
| Field | Action |
| Connection Name | Give a proper Connection name. In may case I am giving Greetings_A2f_96_138 |
| Identifier | Nothing to enter.Automatically generated from the connection name: |
| Connection Role | Trigger and Invoke |
| Description | Leave it blank |
5. Enter the preferred email address, such as support@apps2fusion.com.
6. Under Connection Properties, click Configure Connectivity and input the following WSDL URL:
Click OK to confirm the settings. Your configuration section should look something like below:
7. Navigate to the Security section and select Configure Security. Choose No Security Policy and confirm by clicking OK.
8. Click Test in the top right corner. Upon successful testing, the connection status will display 100% complete, along with a confirmation message stating, “The connection test was successful.”
9. Select Save, then click Exit Connection to finalise the setup.
10. Go to the Designer section, located at the top right of the ICS console.
11. Click on Integrations link to proceed
12. Select Create New Integration, then choose the Map My Data option from the available choices.
13. Provide the required details in the New Integration Information dialog box.
| Field | Action |
| Integration Name | Give a proper Integration name. In may case I am giving Hello_World_A2f_96_138 |
| Identifier | Nothing to enter.Automatically generated from the connection name: |
| Version | Nothing to enter. Use the default value of 01.00.0000. |
| Package Name | Leave it blank |
| Description | Leave it blank |
14. Click Create to proceed.
15. Drag the Greetings_A2f_96_138 SOAP connection icon into the trigger/source section.
16. Enter the necessary details in the Configure SOAP Endpoint wizard.
| Field | Enter |
| What do you want to call your connection? | Greetings |
17. Click Next. As only one Port Type and Operation exist, they will be auto-selected at this step.
18. Click Next to proceed. The Summary page will display all the configurations made so far in the wizard.
19. Review the details, then click Done. Save your progress by selecting the Save icon. Exit to continue with the next steps.
The model you’ve just created acts as the web service interface for the integration flow, enabling external applications to invoke it via HTTP. Ensure you save and exit the integration flow.
20. Navigate to the Designer section in the ICS console by clicking on the link at the top right corner.
21. Select the Connections tab.
22. Click on Create New Connection, then choose the SOAP Adapter option.
23. Fill in the required details in the New Integration Information dialog box.
| Field | Entry |
| Connection Name | SayHello_A2f_49_138 |
| Identifier | Will be automatically generated based on connection name |
24. Provide your preferred email address, such as support@apps2fusion.com.
25. Under the Connection Properties section, click Configure Connectivity, enter the following WSDL URL, and then click OK.
Your configuration settings should now reflect the entered details.
26. Navigate to the Security section, select Configure Security, choose No Security Policy, and click OK to proceed.
27. Click Test in the top right corner. Once the connection test is successful, the completion status will display 100%, along with a confirmation message stating, “The connection test was successful.”
Click Save, then select Exit Connection to finalise.
28. Navigate to Integrations and open the Hello_World_A2f_96_138 integration flow.
29. In the Connections palette, locate SayHello_A2f_49_138. Drag and drop this connection onto the invoke/target section of the integration flow.
30. Enter “SayHelloApps2Fusion” as the value for “What do you want to call your endpoint?”
31. Click Next and choose the “SayHello” operation.
32. Click Next to view the summary page.
33. Click Done to complete the configuration. Once SOAP connections are set up on both the trigger/source and invoke/target sides, the integration flow should resemble the following structure.
The invoke/target SOAP service functions as a web service endpoint, commonly used to integrate with SaaS or on-premises applications.
34. Now, map the incoming message from the trigger/source to a format compatible with the invoke/target web service. This process is accomplished using data mapping. Click on the Request Mapping button to open the mapper tool.
35. Align the relevant trigger/source fields with their corresponding invoke/target fields.
| Trigger/Source Field | Invoke/Target Field |
| GreetRequest/FirstName | sayHello/name |
36. Drag and drop the trigger/source field onto the invoke/target field, ensuring that the field names match correctly. Once mapped successfully, the UI will display the connections accordingly.
37. Save the mapping and exit the mapper.
38. Now, map the response message by clicking on the Response Mapping button to launch the mapper.
39. Connect the designated trigger/source fields to their respective invoke/target fields
| Trigger/Source Field | Invoke/Target Field |
| sayHelloResponse/sayHelloReturn | GreetResponse/Greeting |
40. Drag the trigger/source field onto the invoke/target field, ensuring the field names align properly. Once mapped correctly, the UI will reflect the updates.
41. Save the mapping and close the mapper.
42. After completing the object mappings, the integration flow should now be structured as shown below.
43. Store the Integration configuration by clicking Save.
44. Set up the Business Identifier to monitor your message by selecting the Tracking icon.
45. Drag and drop FirstName into the Tracking Field column as demonstrated below.
46. Assign a name to the Tracking Field and click Done.
47. The Flow Progress Indicator should now display 100% completion, confirming that the integration setup is complete.
48. Click Save and exit the Integration setup.
49. The integration status will now appear as “Activate,” indicating that the workflow is ready for activation.
50. Click Activate to initiate the integration.
51. Check the box for “Enable tracing, including payload in Activity Stream” to capture detailed logs.
52. The integration status will update to “Active.”
53. Click the Info icon to confirm that the Generic Web Service inbound SOAP endpoint is operational. The endpoint URL displayed may vary from the example shown. Copy this URL for testing the ICS endpoint using SOAP UI.
Steps for Testing with SOAP UI
1. Open SOAP UI and create a new project using the endpoint URL of the ICS service.
2. Launch the SOAP UI tool and start a new SOAP project.
3. Enter a project name and paste the endpoint URL you have copied in the previous step. Click OK to generate a SOAP client project.
Endpoint URL: https://ics21-usoracle72468.integration.us2.oraclecloud.com/integration/flowsvc/soap/HELLO_WORLD_A2F_96_138/v01/?wsdl
4. Expand Greeting > Request1
Update the value for FirstName.
5. Next, configure basic authentication by entering your credentials. Navigate to the Auth tab in the Request1 window and choose Add New Authorisation.
6. In the pop-up dialog box, select Basic Authentication and confirm by clicking OK.
7. Enter the ICS authentication credentials in the respective Username and Password fields.
8. In the request payload area, right-click and choose “Add WSS Username Token”. Then, select “Specify Password Type” to Password Text.
This action will add the WSS security header to the SOAP request, displaying it as shown below.
9. Again, in the request payload area, right-click and select “Add WS-Timestamp”. Enter a value, such as 10000.
10. To test the service, click the execute button to send the request. If successful, you should receive a response similar to the one shown below.
Conclusion
This tutorial provided a step-by-step guide to building your first integration using the ICS user interface. You learned how to design a simple integration flow, connect with SOAP-based web services, and map data between trigger and target components. Additionally, you explored how to activate, test, and enhance the Hello World integration flow. With these foundational skills, you are now equipped to streamline integrations and optimise workflows effectively.
