Testing an SSL Database Connection

After creating an endpoint for a database, you must import the CA certificate for the database into Studio and then test the SSL connection to the database. Perform the following procedure to import the database's CA certificate and then test the SSL connection to the database:

Procedure

  1. Open a command window.
  2. Navigate to the database server, and locate the certificate file ca-cert stored in the server.
  3. Copy this file and then navigate to the workstation where Studio is installed.
  4. Using the command window, paste the ca-cert copy in the home directory of Studio: C:\Program Files\IBM\WebSphere Cast Iron Studio x.x.x
  5. Navigate to the security directory of Studio: C:\Program Files\IBM\WebSphere Cast Iron Studio x.x.x\security
  6. Run the following command to import the ca-cert file into Studio: ..\jre\bin\keytool.exe -import -v -keystore cacerts -storepass changeit -file ..\castiron_ca_cert.pem -alias alias_name Where alias is the alias of the database CA certificate.
  7. When you are prompted for a yes or no, type yes (Y) and press Enter.
  8. Exit the command window.
  9. Open the endpoint for the database server.
  10. Verify the following login credentials for the database connection: database server, Port, User, and Password.
  11. Click Test Connection
  12. If the connection is successful, use this endpoint in Studio orchestrations, then use the Verify tab features to evaluate the orchestration.