how to share Alteryx app when using 'Connect in-DB'

[katesun]

I have created an Alteryx app by using 'Connect in-DB'. But when I share the app to other people, they got an error message that they cannot connect to the server (LockInInput (2): Error finding connection 'LONDON11'). My teammate said the app users need to change the connection on their side or log in to the server, and then to use the app. I don't have any problem to share the app when the input is a file. Is there any setup I should do?

[apathetichell · Accepted solution]

To share an IN-DB app your user MUST have the ODBC 64 driver, the Alteryx manage in-db set up --- and permissions on the database server (or service accounts/whatever)

I recommend using dynamic input-in-db vs connect in-db because then the database name can be changed cross system (example --- you call it Snowflake--- your friend calls it mySnowflake) --- via changing a text input tool.

[katesun]

I have shared it with my team. They have the same setup and permission to the server, but they may name the server's name differently. Is it the reason they cannot connect to the server?

[apathetichell]

yup - if their in-db connection name is different a workflow using that connection name in connect in-db will not run.

back to dynamic input-in-db. it takes two fields, a query and a connection name... you can keep the query you use in connect-indb in one field/row and then change the name of your connection in another --- it allows for more easier migration.