Document toolboxDocument toolbox

Hardcoded DB Credentials

Rule name

Hardcoded DB Credentials

Parallel Job

Yes

Server Job

Yes

Job Sequence

-

Description

Ensures that all Database Connectors and Stages must use variables for location and credentials

Description

Developers occasionally hard code database credentials into their jobs. These will cause job failures when deploying to a different project or server.

Note that a number of Stages have the password fields commented out. This is because there is no way of selecting the parameter through the UI, leaving the user to type a parameter name which is then encrypted. Because the ISX merely contains the encrypted string, the rule would always report a failure, even if the user has entered a valid parameter.

Actions

Parameterise the identified hard-coded values.

© 2015-2024 Data Migrators Pty Ltd.