Configuring Replicate to automatically replace the user-entered password
To prevent illicit database activity by unauthorized third-parties, Replicate can be configured to automatically replace the user-entered password with a strong random password.
This feature is currently supported with the following endpoint types:
- Microsoft SQL Server
- Google SQL for SQL Server
- Microsoft Azure SQL Database
- Oracle
This feature cannot be used when the user name is "sa".
Clicking the "Test Connection" button will verify the connection using the original password. The password will be automatically changed the first time the task runs.
To utilize this feature, the password must be defined both in the Replicate endpoint settings and on the actual database, in the following format:
replace:
your_password
Example:
replace:k$RJdg7!S&ib
Defining multiple endpoints to use the same automatically changed password
In Qlik Replicate, more than one endpoint may be configured to connect to the same database server.
To allow multiple endpoints to use the same (automatically changed) credentials, the password in one of the endpoints needs to defined. Then, each of the other endpoint connections needs to be configured to reference that endpoint.
The following rules apply:
-
A source endpoint cannot reference a target endpoint, only another source endpoint.
-
A target endpoint cannot reference a source endpoint, only another target endpoint.
-
An endpoint cannot reference another endpoint that uses a different database server.
To configure an endpoint to use the automatically changed credentials of another endpoint:
-
In the User name field, enter the user name in the following format:
ref:endpoint_name
Where
endpoint_name
is the name of the endpoint connection whose password was automatically changed. -
In the Password field, specify the password before it was automatically changed and without the "
replace
" prefix.Example:
If the original password is:
replace:54lakrfgnier3!
Specify:
54lakrfgnier3!