Data Vault Administrator Guide

6.5
- 6.5.1
- 6.5 HotFix 1
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

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>:<Data Vault port number>?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.

Alternatively, you can pass the trust store details within the JDBC URL, using the following format:

jdbc:infafas://<server hostname with fully qualified domain name>:<Data Vault server port number>?SSL=1&TrustStore=<jks file with absolute file name>&TrustStorePassword=<trustorepassword>&TrustStoreType=jks

For example: jdbc:infafas://irs11ilm02:8564/adm?SSL=1&TrustStore=D:/filename.jks&TrustStorePassword=password&TrustStoreType=jks

These parameters are optional. The .jks file path must contain a forward slash ("/) , regardless of the operating system.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Making JDBC Connections

Making JDBC Connections