In-DB connection on app published to Gallery

hello. I have what I hope is a simple question. I have built a very simple app that uses some In-DB tools that work great on my desktop computer.

however when I try to publish the app to our analytic gallery, i get the error "Unable to find connection 'MYCONNECT'.

MYCONNECT is the name of the connect that I set up using the drop down option "manage connections" from the Connect in-DB tool, and then I set up the connections in the tool that pops up.... I used a sql server connection and simply followed the prompts...

Do i need to somehow set up the same connection on the server in order for this functionality to work?

Thank you!

Publish

Gallery

Settings

Error Message

In Database

Database Connection

In-Database

Accepted answers

PeterS

Hi @bsharbo, I'll reach out to via a private message with a few thoughts.

All comments

PeterS

Hello @bsharbo,

You are correct, in order for your In-Database connection to work in your company’s Alteryx Gallery, there will also need to be a connection on the server named MYCONNECT that is configured exactly as you have the connection configured on your machine. You’ll also need to ensure that both your connection and the server connection are configured as a System DSN.

Hope this helps!

bsharbo

I apologize for the dumb question, but would I simply log into the Server and set up this connection through AlterYX that is installed on the server?

Is there a guide anywhere that would show how to do this is my assumption is incorrect? :-)

kurirjne

@bsharbo, i want to question to you..

how to connect database with alteryx, i want to sent image...

SophiaF

@kurirjne the best course would be to create a new thread in the Designer section so that the community can best assist. Please include a screenshot and the database you are connecting to.

Thanks!

davidhenington

so every user that leverages in-db will have to have their specific connection configured on the server for every in-db connection? This seems cumbersome?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703