File Transfer Integration

 File Transfer Integration

 File Transfer Integration

[App A (WMS System) -> generating files -> SFTP Server 1 (Src) (rbstg.files.com) ] => With in Client network

Build a File Transfer Service to transfer files from SFTP Server 1 to SFTP Server 2

[SFTP Server 2 (Target) (rbstg.exavault.com) -> App B (Third Party System)] => outside of client network

MFT - Managed File Transfer

1) List the files in SFTP Server 1 (src)

2) Loop thru the files

for-each loop

3) Read the file from SFTP Server 1 - Source

4) Write the file to SFTP Server 2  - Target - items1.csv - PGP Encrypt - items1.csv + .pgp 

5) Move (Archive) the file in SFTP Server 1 - Source

End loop

SFTP client/tool - Winscp (DONT USE), Filezilla etc.

Key Name   - a2cf58pgpkey

Passphrase - a2cf58pgpkey

SFTP: Only use FileZilla (no WINSCP)

----

Host: 130.35.100.211

Port: 5022

User: oic.user1

pwd: ZsjK40LGe4j1

/home/users/a2cfoic.user1/a2cf/a2cf57/filetransferservice/input

items*.csv

MFT - Managed File Transfer - No longer supported by Oracle

FTP/SFTP -> FTP Adapter

a2cf24pgpkey

items*.csv

for i in (select item_number, from items)

loop

i.item_number

end loop

txt

csv

dat

05th - 5:15 AM, 10:15 AM, 3:15 PM, 8:15 PM

15th - 5:15 AM, 10:15 AM, 3:15 PM, 8:15 PM

23rd - 5:15 AM, 10:15 AM, 3:15 PM, 8:15 PM

FREQ=MONTHLY;BYMONTHDAY=5,15,23;BYHOUR=5,10,15,20;BYMINUTE=15;

FREQ=MONTHLY;BYMONTHDAY=5,15,23;BYHOUR=5,10,15,20;BYMINUTE=15;

FREQ=MINUTELY;INTERVAL=5;