Configuring TIBCO ActiveMatrix BusinessWorks™ 5 to connect to Microsoft SQL Server database over TLS

This article explains how to configure JDBC Connection shared resource in TIBCO ActiveMatrix BusinessWorks™ 5 to connect to Microsoft SQL Server database over TLS.

Microsoft JDBC Driver for SQL Server - mssql-jdbc-x.x.x.jrex.jar

JDBC Driver

Select the following driver from the Select driver dropdown.

com.microsoft.sqlserver.jdbc.SQLServerDriver

Database URL

To enable TLS with server certificate validation, specify the URL as follows -

jdbc:sqlserver://host:port;databaseName=database;encrypt=true;trustStore=path_to_trust_store;trustStorePassword=password

For example, jdbc:sqlserver://dbserver:1433;databaseName=bwdb;encrypt=true;trustStore=D:\wa\PKI\trust.jks;trustStorePassword=password

• encrypt - Set this property to true to enable TLS
• trustStore - Full path to the trust store containing the DB server certificate 
• trustStorePassword - Trust store password

TIBCO Database Driver Supplement Software (TDDS)  - TIsqlserver.jar

JDBC Driver

Select the following driver from the Select driver dropdown.

tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver

Database URL

To enable TLS with server certificate validation, specify the URL as follows -

jdbc:tibcosoftwareinc:sqlserver://host:port;;databaseName=database;EncryptionMethod=SSL;TrustStore=path_to_trust_store;TrustStorePassword=password;ValidateServerCertificate=true

For example, jdbc:tibcosoftwareinc:sqlserver://na1devspekk301:1433;databaseName=bwdb;EncryptionMethod=SSL;TrustStore=D:\wa\PKI\trust.jks;TrustStorePassword=password;ValidateServerCertificate=true

• EncryptionMethod - Set this property to true to enable TLS
• ValidateServerCertificate -  Set this property to true to validate the server certificate
• TrustStore - Full path to the trust store containing the DB server certificate
• TrustStorePassword -Trust store password

References -

Microsoft JDBC Driver for SQL Server - TLS configuration and properties

https://learn.microsoft.com/en-us/sql/connect/jdbc/using-ssl-encryption?view=sql-server-2016

TDDS driver - TLS configuration and properties

https://docs.progress.com/bundle/datadirect-microsoft-sql-server-jdbc-60/page/Data-encryption.html