12 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:

1. 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.
2. Update the jdbc url in agent.properties.
3. 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>"
4. Start the agent.