I need to have a scheduled agent to retrieve data from SQL DB, and can’t have user ID and password as clear text displayed in source code or any profile. Any idea how to make it work? Thanks.
Iris
Subject: Password security
2 approaches:
-
Store a doc/profile doc with id/password for lookup. Use reader fields or encryption per your preference.
-
Hard code the id/pw into the agent. Hide the design of the database.
The first sounds better to me.
Subject: example code === Password security
Set profile = db.GetProfileDocument(“AdminProfile”)username = profile.VTUserName(0)
password = profile.VTPassword(0)
If getConnection(con, datasource, username, password, qry, results) Then
…
Subject: Password security
Thanks, Doug, for your responses. Just post alternative solution by using Public Encrytion Key on both user ID and password field on the profile. Below is the link to my original question and my solution.
Iris