In-DB tool and Gallery Data Connection

[ShrikantAlteryx]

Hello All,

just wanted to quickly confirm if we can use Gallery data connection in the In_DB tool? or creating ODBC DSN on User's machine as well as on the Server is the only option. We have few users who use In-DB tool in their workflows. Now we are migrating from the Data Source to Cloud and do not want to share the data source credentials with users. What options do we have?

Thanks,

Shrikant

[Thableaus · Accepted solution]

Hi @ShrikantAlteryx 

Gallery Data Connections don't support In-DB connections so far.

There's a workaround using file connections

https://community.alteryx.com/t5/Alteryx-Designer/How-To-Create-an-Alteryx-In-DB-Connection-File/ta-...

You can share those files with the users.

Cheers,

[ShrikantAlteryx]

Hi @Thableaus thank you for quick response. I am not really clear on how I can create and share the indbc files. Dont users need to create the ODBC DSN locally?

[ShrikantAlteryx]

Thanks @Thableaus  creating indbc file and sharing it with users worked. Main challenge I was having was not to create DSN which would require end users to create the DSN as well, I was able to create a indbc connection file using DSN less connection string. Thanks.