sqlserver-datasource-update-script

Use this command to run a scan of all Information Services data sources that use the JDBC Driver for Microsoft SQL Server, to identify ones that are not configured with either of the settings encrypt=true or trustServerCertificate=true. The scan helps you find data sources that might have stopped working due to changes to encryption, which were introduced in the version of the JDBC Driver for Microsoft SQL Server included in Spotfire 12.3 and later.

sqlserver-datasource-update-script 
[-b value | --bootstrap-config=value] 
[-t value | --tool-password=value] 
[-p <true|false> | --probe-datasources=<true|false>]

Overview

Generates a script file, SQLServerDatasourceUpgradeScript.txt, that you can use to update the data sources, adding the connection property trustServerCertificate=true.

To run the script file, use the following command:

config run --fail-on-undefined-variable -Vtoolpassword=<config_tool_password> -VlibraryAdmin=<library_admin_user> -Vvalidate=true/false SQLServerDatasourceUpgradeScript.txt

Before you update your data sources, make sure you understand the implications of using the setting trustServerCertificate in connections to Microsoft SQL Server.

For more information, see the following topic:

Upgrading to 12.3 and later: Fixing Microsoft SQL Server JDBC driver-related issues

Options


Option	Optional or Required	Default Value	Description
`-b value --bootstrap-config=value`	Optional	none	The path to the bootstrap configuration file. See Bootstrap.xml file for more information about this file.
`-t value --tool-password=value`	Optional	none	The configuration tool password used to decrypt the database password in the file bootstrap.xml. If the tool password is omitted, the command prompts the user for it in the console. See Bootstrap.xml file.
`-p value --probe-datasources=value`	Optional	false	Determines whether to additionally run a test connection against all data sources identified in the scan. When true, only data sources to which the connection fails due to encryption-related issues will be included in the script file. This can slow down the generation of the script file significantly, depending on the number of data sources.