Showing posts with label ICS AGENT. Show all posts
Showing posts with label ICS AGENT. Show all posts

Thursday, May 7, 2020

OIC Integration using FTP Adapter created locally in WINDOWS 10, Local Machine

In this POST, I will provide detailed steps on how to use a FTP adapter in OIC using local FTP created in WINDOWS 10 machine  

Steps to create a scheduled integration in OIC using FTP adapter using local WINDOWS FTP. You can go through these links. 

Create FTP server using WINDOWS 10 locally: here  
Why is an ICS Agent needed: here 

  •             Login to OIC àIntegrationàDesigneràAgentsàCreate Agent Group (Give below New Agent Group -Information)

Agent Group Name

DhireshWinLocalAgentGroup

Agent Type

Connectivity Agent

Description

POC purpose


  • Download Connectivity Agent. Save it to C:\OIC\oicAgent\

C:\Windows\system32>cd C:\OIC\oicAgent\oic_connectivity_agent
C:\OIC\oicAgent\oic_connectivity_agent>java -jar C:\OIC\oicAgent\oic_connectivity_agent\connectivityagent.jar
Enter your OIC username : OICUserName
Enter password for username : OICPassword
No Proxy Configuration Detected
Checking for trusted certificates ...
Making call to check OIC Version ...
Making call to check Agent group availability ...
Updating Agent with configuration details ...
Making call to register new agent instance ...
Making call for getting agent app id & keys...
Done with Agent installation & configuration... Starting Agent for message processing.
Agent started successfully...Now available for new messages...

  •            Ensure that the agent is running - OIC àIntegrationàMonitoringàAgentsàMonitor Agents


  •          Create a FTP Connection : OIC HomeàIntegrationàDesigneràConnectionàCreate New ConnectionàSelect Adapter FTP and select create -

Name

DHIRESH_LOCAL_FTP

Role

Trigger and Invoke

Description

POC purpose

Once Connection is created. Provide the below details –

FTP Server Host Address

Local IPv4 address identified from Ipconfig

FTP Server Port

21

SFTP Connection

No

Security Policy

FTP Server Access Policy

User Name

Windows Login Id (usually Hotmail id)

Password

Windows password

Agent Group

DhireshWinLocalAgentGroup (as created in step1)

            Save and test the connection.

  •         Create a new Scheduled Integration—OIC HomeàIntegrationàDesigneràIntegrationàCreate àScheduled Orchestration. I gave the integration name as DHIRESH_LOCAL_FTP
                 Edit the schedule parameters and add below parameter name and ensure these two directories are present in local ftp

fileName

test.txt

inputDirectory

/ftpLocalOIC/readDirectory

outputDirectory

/ftpLocalOIC/moveDirectory

 

 

            Drag the FTP adapter created above over + sign
            Details for Configuring the FTP Adapter

What do you want to call the endpoint

Move File

Select Operation

Move a File

Directory Path

/ftpLocalOIC/readDirectory

File Name

test.txt

Target Directory Path

/ftpLocalOIC/moveDirectory

Target File Name

newtest.txt

       

            Save and then ad the 3 variables. Save the integration. Add filename for tracking. Finally Activate the integration

             Activate the integration. Before Submitting the integration -

      

           Submit the integration. 

       

       

        

           You can  see after submitting the scheduled integration the file has moved from one Windows directory to another locally om your machine. 


 


Monday, January 27, 2020

Oracle ICS Agent - When do we need it and how to create


Why do we need an Oracle ICS Agent? 

Often the question arises, what is the need of using an agent when ICS has so many adapters. Cloud based adapters are mostly API based which may or may not need needs firewall or VPN settings.

The on-premises connectivity agent enables you to create integrations between on-premises applications (example On-premise database) and Oracle Integration Cloud Service (ICS)

The below STEPS  are required to create the connectivity - 

Step1: Create an Agent Group in ICS. Save the configuration.
Step2: Open the agent and download the agent to the Linux environment of On Prem.
Step3: Execute the On-Premise Agent installer and on-premise Linux machine, the result will be a lightweight WebLogic server instance that will be running on port 7001.
Step4: Verify the agent count change from O to 1.


Detailed example can found here 

FBDI Introduction

FBDI  stands for File Based Data Import. It is a pattern provided by Oracle to have the data loaded into Oracle ERP Cloud. Its usually u...