Decrypt, Unzip and Transfer files using Oracle MFT

Oracle MFT 12.2.1.3.0 Use Case

Those familiar to MFT will find it easier to understand this post. Oracle Managed File Transfer (MFT) is a high performance, standards-based, end-to-end managed file gateway.

Use case – Inbound Transfer of an encrypted zip containing multiple files using Oracle MFT 12.2.1.3

Oracle MFT provides the easiest way to do a file transfer which needs encryption and compression of multiple files. The following diagram will explain how to achieve this - 

Flow 1 – Decrypt and Unzip the source file into a temporary location -

1.       Have PGP key installed in MFT server needed to be decrypted

2.       Create Source, In Advanced Properties Specify Regular Expression as (?i)\b(INCOMING.*zip.pgp) if the file format is INCOMING.zip.pgp

3.       Create Target with Temp folder location. Temp folder location is the place where the file will get unzipped.

4.       Create MFT transfer and keep the following –

Flow 2 – Move the unzipped files to the vendor location

1.       The incoming zip format should always be the same.

2.       Create Source with the same location as Flow 1, Step 3

3.       Create target with Vendor location.

4.       Create transfer with above created Source and Target