Configuring On Premise Database in OIC Instance.

By -

Oracle Integration Cloud services provide different types of connectors to establish a connection with external applications, there will be certain scenarios where connectors or REST APIs are not available in OIC for a certain application, in that case, there will be the only option left is to connect DB of the particular application. 


In this article, we will emphasize how we can configure an On-Premise database connection in OIC  and what are the perquisites  needed

To Configure the On-Premise Database connection, we must ensure connectivity agents have been installed in OIC or not.  Without a connectivity agent, connecting to an On-Premise database instance is not possible.

As shown in the below block diagram, On-Prem Database sending handshake signal to OIC services through Agents 



Now lets gets started in configuring On-Premise Database Instance 


Go to the Integration Console and Click on Connections








Select Oracle Database




Fill the mandatory fields like Name , Identifier  and Role as Invoke















Click on Create and fill the connection properties  with Host Name , Port and SID











Provide Database User Name and Password as shown in the below screenshot  and click on Configure Agents 





Select the already created Agent 




Click on Test to Validate. it will the result as Success , in case of any failure do check whether Agents are up or down 













Pranay is a versatile Oracle Technical consultant. Adept in Oracle ERP development, SDLC management, design, and architecture. He has 11 years of extensive experience in Oracle Apps implementation engaged in technical development areas of Oracle Applications 11i/R12 E-Business Suite. He possesses sound knowledge in technologies like OAF, ADF, J2EE, MSCA, Oracle PaaS Cloud, Java Cloud services, ADF & XML Publisher. Currently, he is working for BirlaSoft Inc. USA. Being a Consistent solution provider in Oracle Developer Community forums earned him the title of "Technology Master”, Currently he holds 3rd position globally for providing a solution in Oracle Developer Community for the OAF Workspace. He has also authored several articles on ADF Technology, Fusion Financials, OAF & PaaS Cloud. He successfully presented the case study in Oracle Collaborate event forum on "How optimizing the Oracle Mobile App Solution Helped in Boosting the Productivity of a Warehouse."

Comments

Post a Comment

Popular posts from this blog

REST integration built-in OIC to read Large files with size more than 10MB

By -
Image
Processing large files in any integration requires a lot of effort and complex coding. Every integration platform has a limit size to read a file, similarly, the OIC service provides a limit of 10MB to read the file, if the size exceeds, then the below error will be encountered  Error Reason: Translation Error. Translation Error. Error while translating message to native format. Please make sure that the payload for the outbound interaction conforms to the schema and payload size does not exceed threshold. Error occured as File size exceeds maximum threshold size of 10 MB : Application Error Error Summary: ICS runtime execution error  In this article, we will learn how to read the big-size file in OIC.  Note only XML and CSV formats are supported for larger file read operations.  Here we will build an integration with a source FTP connector to read files containing sizes more than 10 MB  &  read them through the "Read File in Chunks" features and create multiple files  at
Read more

Basic Concepts of OAF (Oracle Applications FrameWork )

By -
Image
OAF stands for Oracle Applications Framework. This particular technology will be used to  develop Application pages , all pages will be of Web base. In Previous versions of Oracle Ebiz , Oracle Forms has been widely used to develop transactions forms , but due to its heavy nature & Time consuming Performance ,it becomes very  difficult to carry out Business operations. To improve the Performance , Oracle has introduced OAF. Oracle Application Framework (OAF) is an architecture for creating web based pages with in Oracle EBS platform.  OAF functionality can be achieved using JDEVELOPER Tool. OAF follows MVC architecute. MVC stands for Module View Controller Architecture  Schematic representation of MVC Architecture  Model (bc4j Component) Model contains the BC4J Components or objects which handles data directly from Database. It Includes Business Components for Java (BC4J Objects) which mainly are: • Entity Object • View Object • Application Module
Read more