How to encrypt user credentials when using JDBC in PI?

[gopalkrishna_baliga]

Hi Experts,

    I have a scenario where PI calling MS SQL 2008 server DB stored procedure.

    ECC (Proxy) --> PI --> (JDBC receiver channel) --> DB

    I want to encrypt the user credentials that we pass in our JDBC connection parameter.

    In JDBC receiver channel. the password in actually hidden (shown as XXXX). When this is sent from PI will JDBC internally encrypts it by default?

    If not then how can I encrypt the user credentials?

    What do i need to setup in JDBC receiver channel? What do I have to do in DB server side?

    Please note I just want to encrypt the user credentials and not the actual data that is exchanged.

    Please help.

Thanks

Gopal

[suman_saha]

Hi,

Are you sending any password as data in the message or you are just worried about the password you are giving in receiver JDBC channel to create connection.

If you are talking about only the connection password,then need not to be worried. It won't be shown in monitoring.

Suman