Secured JDBC call from PI

[Former Member]

Hi,

Please let me know the possibilities of secured JDBC call from PI. In JDBC adapter configuration, is it possible to achieve secured connection to Database server?

I saw few similar threads in Forums but did not get much information.

Thanks,

Geetha

[baskar_gopalakrishnan2]

?Please let me know the possibilities of secured JDBC call from PI. In JDBC adapter configuration, is it possible to achieve secured connection to Database server?

Yes, it is absolutely possible to secure the jdbc connection to database server. You might have to do few things...

Please follow this link

http://wiki.sdn.sap.com/wiki/display/XI/EncryptioninscenariosinvolvingJDBCAdapterwithOracleDatabase

You can encrypt all the connection parameters including user name and password between jdbc adapter and database server. Use advance tab and do the recommended changes given in the above link.Similarly on the database server you have to do the same. You might have to take help from dba to set the similar settings on the database level too.

[former_member472138]

You have an user authentication only with the protocol JBDC 2.0.

Regards

Pothana

[rajasekhar_reddy14]

What exactly mean Secured JDBC cal? you want to use SSL??

JDBC sender channel operates using basic authentication mode(user name and password).

Regards,

Raj

[former_member207622]

Please go through this discussion , I see their is no direct way of achieving this , it can be through encryption

http://www.idssoftware.com/jdbchttps.html

thanks

Ninad