Python tool database server connection visible

adampolcz

hi Experts,

We have a service account which serves for a server connection under python tool as well as a long SQL query after which works fine but the user and password is visible in the python script so i need to change this solution.

It looks like this in the python tool before the query starts:

conn = pymssql.connect('nameofserver','username','password',"XXX_DataProjects")

What I did is a replacement #1 for the username and #2 for password coming from text boxes and action tools, so that the user enters the service account username and password and they replaced to #1 and #2 into the python tool described above, but does not work.

Please note that the Python tool will not be replaced to in db connectors or something similar, it has to remain.

The question is how to pass the entered username and password to python tool.

Any idea?

OTrieger

@adampolcz

You can leave username and password, what you should do prior to this line do:
username = #1 or whatever the field name for username
password = #2 or whatever the field name for password

Now Python knows that you assigned these variables to username and password.

One more thing, kind of coding best practice,

conn = pymssql.connect('nameofserver','username','password',"XXX_DataProjects")

If you are using apostrophe (') keep using apostrophe and do not mix with quote marks (").