topic Re: Dynamic In DB connection on the Alteryx company gallery in Alteryx Server Discussions

Dynamic In DB connection on the Alteryx company gallery

kpiyush88 — Tue, 02 Jun 2020 14:11:57 GMT

Hi All,

i have a workflow which uses a dynamic input In-DB tool to accept the query and the connection supplied to to it. I am making a dynamic query in a formula tool and that works perfectly. The connection that I am supplying to it also works perfectly on my laptop. This connection was created in accordance with the instructions supplied here. I save the indbc file on my laptop, give the file path to the formula tool which eventually feeds the dynamic input In-DB tool and everything works. The issue comes when:

I try to generalise the in-db connection path. eg. make it something like "File:\in_db_connection.indbc" or various versions of that as instructed here.

This is when in-db tool gives up.

It is very important for me to generalize it as I want to publish on the gallery where I don't really know the path where the indbc file will be saved.

are there any alternatives to this approach?

Re: Dynamic In DB connection on the Alteryx company gallery

kpiyush88 — Thu, 04 Jun 2020 09:32:02 GMT

I have resolved it myself by using the "connection name" instead of the connection path. Alias with the same connection name is now set up in the server and the workflow works well!

Re: Dynamic In DB connection on the Alteryx company gallery

kc20 — Thu, 05 Aug 2021 21:17:34 GMT

I'm having this same issue where my workflow is working fine if i run it from laptop but when i publish it to gallery its not able to find the connection. I'm using gallery connection that was created by admin on the gallery. i'm connecting to Redshift database.

@kpiyush88 can you share the screenshots of your solution?