By Sabrine Ghouili
To connect Oracle Integration Cloud with UIPath, you have to create a Process in UiPath Studio and start a Job in the UIpath Orchestrator.
Click here to find all the steps to Create and run a Process using Uipath Studio and Orchestrator.
Creating a queue in the UIPath Orchestrator platform:
1- Within the UIPath Orchestrator platform, Click QUEUES
2- Click to create the queue
3- Name the Queue and check Yes in the Unique Reference as shown below:
4- Then Click ADD
5- You have to add an activity <<Get Transaction Item>> in the UIPath Studio that allow you to get an item from the queue to start the transaction. Drag and drop the activity from the Activity Panel. Then add the Queue Name in the Property Panel as shown below:
6/ To Create the transaction Item in the Property Panel, click in the corresponding field and click CTRL + K. Then enter a name for the item
Creating Connection in Oracle Integration Cloud :
Now you have to create two connections: the first for the Rest API and the second one for the UIPath Orchestrator. So, you have to connect to the Oracle Integration Cloud.
7- After connecting, Click Connections then click Create to create the first connection
8- Search for the Rest Adapter and click Select
9- Enter a Name for the connection and choose Trigger and Invoke role
10- Then Click Create
11- Click Configure Connectivity to specify information to connect to your application/endpoint and process requests. Then fill the fields as shown below and Click Ok
12- Click Configure Security to Specify the login credentials to access to UIPath Orchestrator. Then enter the Username and the Password corresponding to your account in the UIPath Orchestrator platform.
13- Click Ok then click Test to see how the connection will be tested successfully
14- Click Save then Close
15- Now you have to create the second connection for the UIPath Orchestrator and you have to search for the RPA adapter. Then Click Select
16- Enter a name for the new connection and choose the Invoke role
17- Then Click Create
18- Click Configure Connectivity and Enter the Tenant name
19- Click Configure Security to specify the login to the UIPath Orchestrator and click Ok
20- Click Test and click Save then Close
Creating and activating the integration :
21- In the Oracle Cloud Integration page, click Integration
22- Click Create to create the integration
23- Choose the Basic App to App Routing with Data Mapping style
24- Name the integration
25- Click Create
The Source will be the first connection that was created with the REST adapter, and the target will be the second.
Drag and drop the source and complete all the necessary parameters.
26- Now you have to configure the target connection, drag and drop the second connection that have been created. Then Enter the Name and the Description
27- Click Next
28- Choose the Process that has been created in the Orchestrator, choose the Robot that will run the process, select Wait for response, choose the Queue, enter the Input arguments that will be sent to the QUEUE in the Orchestrator, enter the output arguments that will be extracted from the QUEUE, click Next
29- Click Done
30- To map the data of the request, click then click Edit
31- Drag and drop the parameter that you want to map it from the source to the target
32- Click Validate then click Close
33- To map the data of the response, click then click Edit
34- Drag and drop the parameter that you want to map it from the source to the target
35- Click Validate then Close
36- The integration now is ready to be used, click Save then click Close
37- Click Activate and start using your APIse