How to Connect On-premises Applications and Systems to OIC
How to Connect On-premises Applications and Systems to OIC
Abstract
In today's rapidly evolving digital landscape, organizations
are increasingly leveraging cloud-based solutions to enhance agility,
scalability, and innovation. However, many enterprises continue to rely on
critical on-premises applications and systems that form the backbone of their
operations. The challenge lies in seamlessly integrating these legacy systems
with modern cloud-based platforms like Oracle Integration Cloud (OIC) to enable
a unified, cohesive, and efficient IT ecosystem.
This blog provides a comprehensive guide on how to
connect on-premises applications and systems to Oracle Integration Cloud (OIC).
It outlines the key considerations, best practices, and architectural
approaches for establishing a secure, reliable, and high-performance
integration framework.
By the end of this blog, readers will gain a clear
understanding of how to effectively integrate their on-premises applications
with OIC, thereby enabling greater business agility, reducing operational
costs, and driving digital transformation.
Introduction
As organizations navigate the complexities of digital
transformation, the integration of on-premises applications with cloud-based
platforms has become a critical focus. Many enterprises continue to rely on
legacy systems that are essential for daily operations, yet they also seek to
leverage the benefits of cloud computing to enhance flexibility, scalability,
and cost-efficiency. Oracle Integration Cloud (OIC) emerges as a powerful
solution to bridge this gap, providing the tools and capabilities necessary to
connect on-premises systems with the cloud in a seamless, secure, and efficient
manner.
This blog addresses the growing need for businesses
to integrate their existing on-premises applications with OIC. Whether it's
connecting legacy ERP systems, CRM applications, or custom-built software, the
process of integration poses several challenges, including data consistency,
security concerns, and the need for real-time communication between disparate
systems.
The purpose of this blog is to guide IT leaders,
architects, and developers through the intricacies of establishing a robust
integration framework between on-premises applications and Oracle Integration
Cloud. We will explore the key architectural considerations, best practices,
and tools available within OIC that facilitate this connection. Additionally,
we will delve into common integration scenarios and offer practical solutions
to ensure that your on-premises systems can effectively communicate with
cloud-based applications, thereby enabling a unified and streamlined IT
environment.
By understanding and implementing the strategies discussed
in this blog, organizations can overcome the challenges associated with
hybrid IT environments, maximize their existing investments in on-premises
infrastructure, and fully embrace the advantages of cloud integration. The
insights provided here will empower businesses to achieve greater operational
efficiency, faster time-to-market, and a more agile response to changing
business needs.
Steps Followed
a.
Integration to read the data from On-Premises
Database where a flag is checked for “NEW” values and the same flag is updated
as “PROCESSED” after reading the data.
b.
Integration to run BIP report and fetch data
from Oracle ERP and insert the same in Oracle Database.
c.
Integration to read data from Excel/CSV file and
insert in Database.
d.
Integration to read data from Database and
create a file from the same.
Install Oracle Database 19c on On-Premises System.
·
Download the Installable from Oracle website. https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html
·
Extract the Installable zip file.
·
You need to run the setup.exe file as
administrator and start the installation and follow the instructions as per the
Installation Guide provided by Oracle.
·
You can also install SQL Developer and create
connection to make use of the user-friendly UI it provides as shown below.
·
This completes the Oracle DB 19c installation
and Setup of SQL Developer.
OIC Gen2 Connectivity Agent
·
Login to OIC
·
From Homepage Navigate to Integrations and then
select Agents.
·
Click on Create Agent Group
·
Click Create
·
Click on Download and then Click on Connectivity
Agent.
·
oic_conn_agent_installer.zip file gets
downloaded. This has to be extracted and contains below files.
·
Edit the InstallerProfile.cfg file to add
details as shown below
·
Run the Connectivity Agent as shown below. (Make
sure you have JDK installed)
OIC Connection for Oracle Database
·
Login to OIC
·
From Homepage Navigate to Integrations and then
select Connections.
·
Click on Create and search for Oracle Database.
·
Select Oracle Database Adapter.
·
Click on Create
·
Provide details for Connection Properties like
Host, Port, Service name.
·
Provide Security details Username and Password.
·
Select Configure Agents in Agent Group section
and select the Connectivity Agent Group which was created earlier.
·
Test and save.
OIC Integration Use Case 1
Create an App Driven OIC Integration to poll for new or
changed records in Oracle DB Table based on a flag and then update the flag as
Processed.
·
Login to OIC
·
From Homepage Navigate to Integrations and then
select Integrations and click on Create and provide details as shown below.
·
Using the Connection created for Oracle DB On-Premises,
add the table XX_EMPLOYEE
·
Add a logger to show the employee’s name.
·
Add Business Identifier for Tracking and click
Save.
·
Click Save to save the Integration.
·
Activate the Integration with Enable Tracing and
Include Payload checked.
·
Test by creating a new record in XX_EMPLOYEE as
shown below.
·
Commit once new record is added.
·
Integration is triggered as the db connection is
polling for New and changed records on XX_EMPLOYEE table.
·
Integration updates the ISNEW column of the
newly created record to PROCESSED as shown below.
OIC Integration Use Case 2
Create a Scheduled Orchestration OIC Integration to insert
records into Oracle DB table by calling a BI Report from Fusion instance.
·
Create a Data Model in Fusion
·
Create a Report for this Data Model
·
Login into OIC
· From
Homepage Navigate to Integrations and then create integration
·
Use ERP instance Soap connection to run a BI
Report
·
In the mapper provide ReportAbsolute path and sizeOfDataChunkDownload
·
Call Stage file to write the data.
·
In the Mapper, map as follows
·
Call Stage file to read this data.
·
For Loop to iterate over the records
·
Inserting into Database by using DB Connection
·
Mapping the fields
·
Add Business Identifier for Tracking
and click Save.
·
Click Save to save the Integration.
·
Activate the Integration with Enable
Tracing and Include Payload checked.
·
Test the Integration
OIC Integration Use Case 3
Create a Scheduled Orchestration type OIC Integration to list
files in FTP Server and identify the specific file with filename and type, read
the file data and insert the same in Oracle DB Table.
·
Login to OIC
·
From Homepage Navigate to Integrations and then
select Integrations and then click Create and provide the details as shown
below.
·
Use the FTP Connection already created to list the
files from FTP Server.
·
If there are any files matching the criteria,
then loop through the files else send add a log accordingly.
·
Loop through the files and read the file data.
·
Insert the data from file into Database.
·
Integration looks as shown below.
·
Run the Integration and check the results as per
the requirement.
·
File Data
·
Data Inserted into DB
OIC Integration Use Case 4
Create a Scheduled Orchestration OIC Integration to fetch
records from Oracle DB table
· From
Homepage Navigate to Integrations and then create integration
· Fetching data
from Database by using DB Connection
·
Use Stage File to write the data in csv
format
·
Providing following details in the
mapper
·
Using FTP Adapter to send the csv file
into SFTP
·
Provide Directory, Filename inside the mapper
·
Using Email Notification to send this
attachment
·
Add Business Identifier for Tracking
and click Save
·
Click Save to save the Integration.
·
Activate the Integration with Enable
Tracing and Include Payload checked.
·
Test the Integration
OIC Gen3 Connectivity Agent Creation and Setup
·
Login to OIC
·
From Homepage navigate to Design and then select
Agents.
·
Click on Create and provide Name for the Agent.
·
Click Create. Then click Download and click
Connectivity Agent.
·
oic_conn_agent_installer.zip file gets
downloaded. This has to be extracted and contains below files.
·
Click on the 3 dots and then click on Download
config.
·
InstallerProfile.cfg file will be downloaded,
replace the InstallerProfile.cfg in the oic_conn_agent_installer folder.
·
InstallerProfile.cfg file to has the details
already added as shown below
·
Run the Connectivity Agent as shown below. (Make
sure you have JDK 17 installed and JAVA_HOME is set.)
OIC Gen3 Connection for Oracle Database
·
Login to OIC
·
From Homepage navigate to Design and then select
Connections.
·
Click on Create and search for Oracle Database.
·
Select Oracle Database Adapter. Enter Name,
select Role as Trigger and invoke and click Create.
·
Provide details for Connection Properties like
Host, Port, Service name.
·
Provide Security details Username and Password.
·
Select Configure Agents in Agent Group section
and select the Connectivity Agent Group which was created earlier.
·
Test and Save.
Comments
Post a Comment