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

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?

App Builder

Accepted answers

apathetichell

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.

All comments

apathetichell

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)

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703