Showing posts with label FTP. Show all posts
Showing posts with label FTP. 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. 


 


Tuesday, May 5, 2020

Creating FTP locally using WINDOWS 10

In this post, I will explain how to create a local FTP server which we can use for creating future OIC FTP adapters - 

Step1: Type cPanel in Search tab. Then Browse Control Panel\All Control Panel Items\Programs and Features. Click Turn Windows Features on or off as below:


Select FTP and IIS Management Console and click Close.

Step2: Type cPanel in Search tab. Then Browse Control Panel\All Control Panel Items\Administrative Tools. Right Click on Internet Information Services (IIS) Manager and Run as Administrator. You will see a similar console – 



Step3 : Under Sites à Create New FTP option


Step4: No SSL. Select basic Authentication. Allow access to Specified Users with Read , Write permissions. Use PORT 21

Step5: Browse Control Panel\All Control Panel Items\Windows Defender Firewall\Allowed apps. Select FTP. Click OK

Step6: Run cmd as Administrator, Type ipconfig and Enter. Copy the IPv4 address and Default Gateway IP

Step7: Login to your router by typing Default gateway in the browser. Usually the user id password should be admin and password

Step8: Go to Port forwarding option. Select this computer and provide IPv4 address

 

Download WinSCP or any other FTP software. Create new session with below details - 

Protocol : FTP
 Encryption : No Encryption
 Hostname : IPv4 address
 Port Number : 21
Username : Windows User Id (usually the Hotmail Id)
Password : Windows Password

Note - This is my personal recommendation. Since we have allowed the firewall to use this FTP server, the best would be to use this only for POC, development purpose locally and once objective is achieved, you should use WINDOWS to disable the FTP feature. 

 


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...