cancel
Showing results for 
Search instead for 
Did you mean: 

Flat File to Flat File Scenario using File Adapter

Former Member
0 Kudos

Hi Experts,

In my scenario, requirement is Flat File to Flat file through File Adapter in PI. At sender end, we would need to use Sender File Adapter (NFS) and receiver end we would need to use Receiver File Adapter (FTP). File would be coming as a encrypted format, and the file needs to be sent in encrypted format.

Any idea how to proceed with this requirement would be helpful.

Thanks and Regards

Soumya

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Soumya,

We have option of sending/receiving the data in secured way through FTP based communication channel only. You would need to use the "Connection Security" option as "FTPS for control and data connection". In this case both the connection and data would be transported in encrypted format via TLS(Transport layer security).

Regards,

Vishnu.

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi Soumya,

If you want to copy from one directory to other directory (if there is no maping) using PI,we can achieve this one using only Integration Directory,no need to create ESR stuff.

Use sender file communication channel with NFS Details,the same way create receiver communication channel with the FTP details.

Regards,

Raj

Former Member
0 Kudos

Hi Raj,

In the receiver File format, there are certain conditions, that means it requires mapping in ESR. In that case, what's your idea, how to proceed further?

//BR

Soumya

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi,

Then you need to develop ESR mapping stuff,use file content conversion in seder side and as well as in Receiver side,

Sender FCC for to conver Flat file in to XML format,Receiver FCC for convert XML to text format.

Cheers,

Raj

Former Member
0 Kudos

Hi Soumya,

The encryption matters only at the adapter level. The remaining usual configuraiton and design would be same as the usual devlopment of interfaces in PI. Yo would need to configure the ecryption parameters in the communication channel.

Regards,

Vishnu.

Former Member
0 Kudos

Hi Vishnu,

Would be helpful if you could share stuffs to configure the ecryption parameters in the communication channel.

//BR

Soumya

Former Member
0 Kudos

Hi Soumya,

You need to choose the FTP in the "transport protocol" option. Then in the FTP connection parameters choose the option Connection Security and assign the value "FTPS for control and Data Connection". Then the "Command Order" will show up below that option and you could leave the default value itself. If you are using Public private key certificates of X.509 then you could choose the option "Use x.509 certificate for client authentication" and assign the values to the "keystore" and "certificate & private key" fields.

Note: To use the FTP with SSL you need to add the CA certificate to the TrustedCAs keystore view.

Regards,

Vishnu.

Former Member
0 Kudos

Hi All,

Thanks a lot for your valuable responses. I will try those in my scenario and will come with a new thread if having any problem. Hence closing his thread. Thanks again for your help.

Regards

Soumya

Former Member
0 Kudos

Thanks.

Regards

Soumya