You should never do that, why:
1) because you will need to change the pass when your landscape will change (from DEV to QAT to PRD)
2) because everyone who will be able to open your mapping will be able to see the password if you store it in plain text
3) because you may need to change the password from time to time
So is there any alternative ? Maybe a standard one?
Secure Storage Service is one of the possibilities. It’s a place where you can put your passwords.
Import necessary libraries as External Archives into your Integration Repository:
which can be found in: \j2ee\cluster\server0\bin\services\tc~sec~securestorage~service
which can be found in: \j2ee\cluster\server0\bin\system
Create a user defined funtion in your Message Mapping with the code as shown below:
Make sure you will those libraries into import section of your UDF:
If you create the object in Secure Storage you will see it it there directly after creation:
And when you execute your function you will that the value was successfuly restored.