Connecting Oracle GoldenGate Veridata to SSL-Enabled SQL Server Database

7.7 Connecting Oracle GoldenGate Veridata to SSL-Enabled SQL Server Database

SSL SYNTAX: database.url=jdbc:sqlserver://<host>:<port>;databaseName=<dbName>;encrypt=false;trustServerCertificate=false;

Example URL: :database.url=jdbc:sqlserver://phoenix007.dev3sub2phx.databasede3phx.oraclevcn.com:1433;databaseName=atssrc;encrpt=false;trustServerCertificate=false;

To connect Oracle GoldenGate Veridata to SSL-EnabledSQL Server:

Import the mssql crt file to the truststore: keytool -importcert -alias ms_sql -keystore $JAVA_HOME/jre/lib/security/cacerts -storepass changeit -file <path>/mssql.pem.
Update the jdbc url in agent.properties.
Set the path of truststore and truststore password in $JAVA_OPTS variable export JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.trustStore=<path_to_truststore_file> -Djavax.net.ssl.trustStorePassword=<your_truststore_password>"
Start the agent.

Parent topic: Secure