Ask user to provide credentials to database on Gallery

[Reddy4]

Hi,

My company doesn't allow gallery connections for IN-DB tools. We generally use regular Input tools but I have a workflow which extracts millions of data and it takes lot of time to execute with Input tools. 
I would like to know if there is way to deploy a workflow with IN-DB tools and ask user to provide credentials manually (as parameters)

If not, can I know alternatives please.

Thank you for your help!

[fmvizcaino · Accepted solution]

Hi @Reddy4 ,

Only so you are aware, It is not possible to use Gallery Data Connections with in-db tools.

When using in-db, you have two options:

• in-db files: A file with an encrypted password placed in a shared folder for the users. It works similarly to a gallery data connection if you think about
  • https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-To-Create-an-Alteryx-In...
• DCM: The user can create the connection and use his own user and password in it. The Gallery data connections are curator-managed whereas the DCM connections are artisan-managed.
  • https://help.alteryx.com/20231/designer/dcm-supported-connectors-and-tools
  • https://community.alteryx.com/t5/Engine-Works/What-is-Alteryx-Data-Connection-Manager/ba-p/983826

Best,

Fernando Vizcaino