How to connect to other data sources from alteryx private studio

[sai11]

Hello team,

I have made a app on alteryx designer ,which can take any file on local system, and it can also connect to odbc like i tested ms access using odbc driver.

Now when i save this to company gallery, and run , it only allows me to browse from my local system, it doesnot give option to connect to odbc or other?

Can someone plesase guide me on how to resolve this.

[gabrielvilella]

Since there isn't an interface tool that helps you set up an ODBC connection, you need to create your own using, let's say, a dropdown. You will need two separate input data tools, each one inside it's own container. One for regular files and another for ODBC, giving the user a list of possible ODBC connections. All of those connections must exist on the Server machine or in the Gallery connections. For the interface you can use radio buttons so the user can select either file or database, and those buttons will enable/disable containers on your workflow.

[sai11]

thank you, how do i have to create connections in gallery

[gabrielvilella]

You need to contact the Gallery admin to do that.

[sai11]

Hi gabriel,i will contact admin

I have addded pictures for reference

I have added pictures of my error, on alteryx designer.

My requirement is to browse from alteryx server to odbc connection