Credential dialogue pop up when running custom tool in ArcGIS Pro

Question

Software: ArcGIS Pro 3.2.2, Python 3.9

Hello,

I am developing a tool to be accessed via an ArcGIS Pro toolbox GUI. The script pulls data from 3 databases: 1 Postgres, 2 Oracle DBs. We are using .ini files to store credentials, but give the user the option to manually enter credentials if they prefer (username and password parameters are optional within the tool properties). There are a few quirks about developing in the esri world, one that is really annoying me is that when running the tool, credential dialogue boxes keep popping up, asking the user to log in several times to each database. The user can cancel out of each dialogue and the tool is able to log into to the DBs, so it isn't an issue with credentials.

KevindeSouza · Answer

That isn't a great solution due to our organization's policies around data privacy & protection

AlfredBaldenweck · Answer

Could you just store the credentials in the SDE file?

KevindeSouza · Answer

I think I figured it out. I had to add my sde connections to my favorites within my template project, and then sign in to each DB before running the tool. Would be nice if there was a solution to this that wasn't as redundant as logging in to the same DB multiple times.