Data Vault Administrator Guide

Back Next

Making JDBC Connections

In order to make JDBC connections, you must create a trust store. The trust store is used to store certificates from trusted certificate authorities.

Verify that the JDBC URL has SSL=1 appended to the URL:

jdbc:infafas://<server hostname with fully qualified domain name>:<Port num>?SSL=1

For example:

jdbc:infafas://invrlx62ilm29.informatica.com:7507?SSL=1

Use the following OpenSSL command to create the export .der file:

openssl x509 -outform der -in <certificate>.pem -out <export file>.der

Use the following command to create a key store:

keytool -import -alias your-alias -keystore <keystore name>.jks -file <export 	file>.der

For 3rd party JDBC tools, for example Squirrel, add the trust store in the batch file to start the tool, as shown in the following example:

-Djavax.net.ssl.trustStore=E:/QA/SSL_Tests/TestCaInfa2/TestCaInfa/TestCA/demo10.jks -Djavax.net.ssl.keyStorePassword='password'

For a simple java program, add .JKS file as a connection property in the Java code.