Wednesday, May 3, 2017

Mulesoft pattern 1 : File(PGP Encrypted) to Database

Requirements:

Schedule
Read file from SFTP
Delimited
PGP Encrypted
Insert to database

Scheduler:
https://docs.mulesoft.com/mule-user-guide/v/3.7/poll-schedulers
Publickey based SFTP:
https://forums.mulesoft.com/questions/38463/sftp-connector-not-work-for-publickey-setting.html
Delimited, File:
https://technicalmumbojumbo.wordpress.com/2014/02/01/mule-tutorial-series-file-endpoint-csvtomaps-java-component/
Encrypted
https://docs.mulesoft.com/mule-user-guide/v/3.6/pgp-encrypter#decrypting
Insert to Database
https://forums.mulesoft.com/questions/4986/how_to_insert_dynamically_into_database_newbie_to_mule.html
https://docs.mulesoft.com/mule-user-guide/v/3.6/database-connector-examples

No comments:

Post a Comment