Alteryx Server/Gallery In-DB Connections

[leannedayao]

Hi, Can we setup In-DB connections on the server?

I'm using Data Stream In to create a temporary table and join it with other tables in Snowflake.

I need to upload the app to Gallery so our non-Alteryx designer users can use it.

[TimN]

Yes, it works the same way as on designer desktop.  Just make sure the database is supported by Alteryx for InDB.

https://help.alteryx.com/current/en/designer/data-sources.html#idm46038063589040

[fmvizcaino · Accepted solution]

Hi @leannedayao ,

The Gallery data connections are not available for in-DB. The best practice is to create an in-DB connection file and place it in a shared folder so it is easily manageable.

https://knowledge.alteryx.com/index/s/article/How-To-Create-an-Alteryx-In-DB-Connection-File-1583459...

Best,

Fernando Vizcaino

[leannedayao]

@fmvizcaino If I convert it to a file, can I use it in Gallery?

[leannedayao]

Hi, @TimN. I'm using Snowflake and it's supported by Alteryx for InDB. But when I try to save the workflow to Gallery, it throws an error "Error finding connection "<Connection-Name>""

[TimN]

Hi,

I'm on release 2021.4 and we create in-db connections for a variety of databases.  We don't currently use Snowflake but an Oracle connection can be set up the same way as you do on designer desktop.  Not sure if there is anything special needed specific to snowflake but it appears as a choice when setting up indb connection.  I defer to @fmvizcaino re: best practices.

[TimN]

Oh, and to state the obvious the connection should exist before you upload a workflow or app.

[fmvizcaino]

The file is only a best practice. It is not mandatory; it is good to have.

Your issue is related to the connection name. The same DSN has to be created on the Server machine, as @TimN mentioned.

Best,

Fernando

[leannedayao]

Hi, @fmvizcaino @TimN. I'm using the same DSN created on the server, not sure why it still doesn't work.
I tried converting the in-DB connection to a file, now my app is working in Gallery.

Thank you both!