How to force users to use encrypted connection when creating a new SQL Server data source using Information Designer

Created
October 08, 2021 23:14

Date Posted: 2020-06-02
Product: TIBCO Spotfire®

Problem:

Solution:

This article explains a way to enforce encryption, that is when users create a new SQL data source using “Information Designer”.

We can enforce this encrypted connection via "Data Source Template" configuration for SQL data source template.

Note: It is applicable to SQL Server Native driver only. You can achieve this by adding below connection properties as part of SQL data source template:

<connection-properties>
    <connection-property>
      <key>encrypt</key>
      <value>true</value>
    </connection-property>
    <connection-property>
      <key>trustServerCertificate</key>
      <value>true</value>
    </connection-property>
  </connection-properties>

You can read more about properties "encrypt" and "trustServerCertificate" on below Microsoft link:

https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15