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