An Oracle application needs integration with various resources. This blog will cover a brief introduction to Oracle Integration Cloud (OIC) Connections with a step by step process to create a basic Oracle REST Cloud and Oracle SOAP Cloud connection. The following topics are covered in this blog.
- Oracle Integration Cloud (OIC)
- What are Oracle Connections?
- Create OIC Connection
- Oracle Connection Manager
- Conclusion
Oracle Integration Cloud (OIC)
Various resources in a cloud need to be connected or integrated with other resources for a continuous flow of information within a cloud. OIC or Oracle Integration Cloud service allows integration of various resources like applications, storage and database for automating the process and creating advanced visual applications. It also allows connecting an application with Oracle adapters and third-party adapters. In Oracle Integration Cloud, adapter and connection play a crucial role, but this blog will focus only on Oracle Connections.
See More: Oracle Integration Cloud
What are Oracle Connections?
OIC Connection defines information about the instances of each configuration that is integrated. A Connection is based on an Adapter that allows Oracle Integration to interact with Oracle application instances. For every application instance that participates in integration, a connection is required. In simple words, it is a connector that is utilized for communicating with various external applications. It is done with conventional systems like FTP or social media applications like Linkedin, Facebook, Twitter, etc.
For example, to create a connection to a specific Oracle Service Cloud application instance, we need to select the Oracle Service Cloud (RightNow) adapter and specify the security policy, security credentials and WSDL URL to connect to it.
See Also: Oracle Integration Cloud Adapters
Create OIC Connection
With some simple steps, you can create an oracle connection using Oracle Adapters. We will see the procedure of creating Oracle REST Cloud and Oracle SOAP Cloud connections.
After signing in to your Oracle Cloud account, open the menu and visit the integrations page as highlighted in the image above. Now, open the menu and select ‘Connections‘ as shown in the image below. To start creating connections in Oracle, click on the ‘Create‘ button.
Check Out: Our blog post on Oracle Integration Cloud Insight.
Oracle REST Connection
Step 1) In the next window, you will see various adapters. Click on the Search field and search for REST Adapter as shown in the below image. Now, tap the adapter and click on the ‘Select‘ button.
Step 2) Fill in the required details in the next window. Type the name that you want to assign to this connection. Select the role of the connection as ‘Trigger‘ and click on the ‘Create‘ button.
Step 3) The REST connection is now ready. To test your connection, you can click on the Test button or else save it by clicking on the ‘Save‘ button.
Oracle SOAP Connection
Step 1) Click on the Search field and search for SOAP Adapter as shown in the below image. Now, tap the adapter and click on the ‘Select‘ button.
Step 2) Enter the details in the Create Connection window as shown in the below image. Assign the name that you want to use for this connection and select ‘Invoke‘ as the connection role. Finally, click on the ‘Create‘ button when you are done with changes.
Step 3) In the next window, you will need to fill in additional details for your connection like login credentials and WSDL Url. The login credentials are the username and password that you received in the Oracle cloud application subscription. The URL under connection properties is the location of the WSDL File. For Example, https://example.com/fndAppCoreServices/ServiceCatalogService?wsdl
After you are done with the filling details, you can check your connection by clicking on the ‘Test‘ button. Remember your WSDL Url, and the credentials should be correct to pass this test. Finally, save your connection by clicking on the ‘Save‘ button.
Oracle Connection Manager
Oracle Connection Manager is a proxy server that forwards connection requests to other proxy servers. OCM operates on the session level and resides on the computer separate from the client computers and database server. The primary function of Oracle Connection Manager is access control and session multiplexing.
- Access Control – Rule-based configuration to filter out user-specified client requests and accept others.
- Session Multiplexing – It funnels multiple client sessions via a network connection to the shared server destination. Shared Server is a database server configured to allow user processes to share very few server processes to support the maximum number of users.
Conclusion
Oracle Integration Cloud (OIC) connections allow communication with various applications. This blog covered an introduction to Oracle, Oracle Integration Cloud Connections and Oracle Connection Manager. Also, the steps to create a basic Oracle REST Cloud and Oracle SOAP Cloud connection.
References
- Oracle Integration Cloud (OIC) For Beginners Overview
- Introduction to Oracle Integration Cloud (OIC) Adapters
- 1Z0-1042-21 Oracle Cloud Platform Application Integration 2021 Specialist
- OIC Step By Step Activity Guides/Hands-On Lab Exercise
- Oracle Integration Cloud (ICS, PCS, VBCS) Console Walkthrough
- Create OIC Instance: Step-by-Step
- OIC vs SOA CS
- SOAP vs REST API’s
- Process large files in OIC
Next Task For You
Do you want to learn more about Oracle and confuse where to start or which certification is right for you? Then, click on the register now button below to register for a Free Masterclass on Oracle [1Z0-1042] Certified Cloud Integration Expert, which will help you better understand and choose the right path and clear the certification exam.
Ramanath Gorala says
I want to Connect Oracle Primavera Cloud(OPC) in OIC, do you know how to create connection for this OPC.
My requirment is need to get data from OPC and send to Azure Sql Server. please suggest me how to create connection for this OPC.
Surbhi Sharma says
Hello Ramanath,
There is no out-of-the-box connector of OPC in OIC.. You can try to consume OPC rest or soap APIs
Please find the links below that can be helpful for you
https://docs.oracle.com/cd/E80480_01/English/integration/primavera_cloud_integration_overview/primavera_cloud_integration_overview.pdf
–> (Doc ID 2407270.1)
Regards,
Surbhi
Team K21