How to connect to SSL enabled SQL Server from TIBCO ActiveMatrix BusinessWorks™

How to connect to SSL enabled SQL Server from TIBCO ActiveMatrix BusinessWorks™

book

Article ID: KB0078713

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks 5.13,5.14

Description

This article lists the steps for configuring TIBCO ActiveMatrix BusinessWorks™ (BW) to connect to SQL Server 2016 over SSL using TIBCO Database Drivers Supplement Software.

Issue/Introduction

How to connect to SSL enabled SQL Server from TIBCO ActiveMatrix BusinessWorks™

Environment

1) TIBCO ActiveMatrix BusinessWorks™ 5.13 and above 2) Microsoft SQL Server 2016

Resolution

Pre-Requisites

  • TIBCO Database Drivers Supplement Software (2.0.6 and above)
 

Configuration

  1. Import SQL Server's certificates into a new keystore (Say C:\tmp\sqltrust)
  2. Configure 'JDBC Connection' shared resource as follows:
  • Set JDBC Driver to  tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
  • Set 'Database URL to jdbc:tibcosoftwareinc:sqlserver://serverhost:port;databaseName=dbname;authenticationMethod=ntlmjava;Domain=addomain;EncryptionMethod=requestSSL;ValidateServerCertificate=true;CryptoProtocolVersion=TLSv1.1,TLSv1.2;TrustStore=C:\tmp\sqltrust
Note:  
a) Above URL is one example. Options can change based on what is required by server.

b) EncryptionMethod requestSSL means login and data are encrypted (provided SQL Server requires encryption).

c) ValidateServerCertificate would verify server certificate. Set this to false to impicitly trust server certificates (TrustStore is not required in this case)

d) CryptoProtocolVersion is a list of protocols that server accepts.
 
  • Provide Active Directory User and Password
 
Powered by Wolken Software