Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
How to force users to use encrypted connection when creating a new SQL Server data source using Information Designer
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
Comments
0 comments
Article is closed for comments.