Encrypting connection between Gridserver and MS SQL

Encrypting connection between Gridserver and MS SQL

book

Article ID: KB0073199

calendar_today

Updated On:

Products Versions
TIBCO DataSynapse GridServer 5.x, 6.x, 7.x

Description

1. By default, the connection between TIBCO DataSynapse GridServer and MS SQL is not encrypted. However, it is possible to use encrypted connection by using MS SQL driver properties in the DB URL to achieve it.

2. One can use properties like "encrypt=true;trustServerCertificate=true" in Database URL specified in GS Admin > Admin > Manager Configuration > Database > Reporting Database Connection > URL.

3. Suppose the URL is "jdbc:sqlserver://mysqlserverhost:1433;DatabaseName=grid_db;SelectMethod =cursor", we need to append those properties like                "jdbc:sqlserver://mysqlserverhost:1433;DatabaseName=grid_db;SelectMethod=cursor;encrypt=true;trustServerCertificate=true". This is just an example. Customers need to consult their DBA for more information.

Environment

Windows, MS SQL(2012)

Issue/Introduction

This article is intended to provide steps to make encrypted connection between TIBCO DataSynapse GridServer and MS SQL.

Additional Information

1. MS SQL Guide - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15

2. TIBCO DataSynapse GridServer Installation Guide - https://docs.tibco.com/products/tibco-datasynapse-gridserver-manager-7-0-0
Powered by Wolken Software