Configure a trust store to authenticate the server certificate - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

Close Connect CDC Director if it is already open.

Copy the signed server certificate to the local Java trust store path.

Open a command console session and navigate to the Connect CDC kernel directory on the client machine, which by default is

<Precisely_Connect_Install>\ConnectCDCV57\kernel

Extract the MSSS2005.properties file from Omni.jar to the kernel folder using the Java jar utility. Type the following commands at the command prompt:

run 'jar xf Omni.jar omnienterprise/gdbc/MSSS2005.properties'
mv omnienterprise/gdbc/MSSS2005.properties .

Using a text editor, open MSSS2005.properties for editing and change the value of the URL parameter to the server jdbc.sqlserver URL with TLS encryption parameters, similar to the following:

url=jdbc:sqlserver://%HOST:%PORT;SelectMethod=cursor;
encrypt=true;trustServerCertificate=true;
trustStore={path to java trust store};trustStorePassword={trust store password};
hostNameInCertificate={subject property of server certificate}

For example,

url=jdbc:sqlserver://%HOST:%PORT;
					SelectMethod=cursor;encrypt=true;trustServerCertificate=false;
					trustStore=c:/dev/ConnectCDC/certs/preciselyTrust.jks;
					trustStorePassword=precisely;hostNameInCertificate=US-DD-USER.us.precisely.com

Save the file and exit the text editor.

Open Connect CDC Director. From the context menu of the server, select Test Connection to test the connection to SQL Server.