Configuring a Secondary RPS Database for Azure

The [JadeRPS] section of the Jade initialization files can contain the following parameters to configure a secondary RPS database for Azure.

UseAzureSQLDatabase, which specifies whether the RPS database is an Azure SQL database.
AzureAuthenticationMethod, which specifies what authentication method should be used in the generated Bulk Copy Program (BCP) scripts.
DSNName, which specifies the name of the Data Source Name (DSN).
AzureBcpMaxErrors, which specifies the value to use for the -m flag in the BCP script.

The initialization file parameters in the following example generate BCP scripts that use Azure Active Directory (AD) authentication (that is, -G), set the max row level errors to 5, and output a bcp_errors.log file.

[JadeRPS]
UseAzureSQLDatabase=true
AzureAuthenticationMethod=ActiveDirectoryIntegrated
AzureBcpMaxErrors=5

The initialization file parameters in the following example generate BCP scripts that use the authentication method defined in the DSN (that is, -D), set the max row level errors to zero (0), and output a bcp_errors.log file.

[JadeRPS]
UseAzureSQLDatabase=true
AzureAuthenticationMethod=DSNDefined
DSNName=SystemDSN

The bcp_errors.log file is output if the conditions specified above are met. If there are no errors, the file is still output, but is zero (0) bytes in size.

The documentation for the flags that have been added to the BCP scripts (that is, -D, -e, and -m), can be found at the following URL.

https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver17&tabs=windows

The BCP flags are set only if the UseAzureSQLDatabase initialization file parameter has been set to true.

2022.0.05 and higher