topic Re: Connect In-DB vs Input Data in Alteryx Server in Alteryx Server Discussions

Connect In-DB vs Input Data in Alteryx Server

DrydenChicago — Fri, 12 Feb 2021 22:57:50 GMT

Hi all,

While in Alteryx designer, I find that it's very flexible and quicker to use the "Connect In-DB" tool to connect to datamarts than the "Input Data" tool. Now that we have Alteryx Server available, I was only able to use the "Input Data" tool to run in Alteryx Server but not for "Connect In-DB" tool. Is anybody able to use "Connect In-DB" tool in Alteryx Server? if so, what were the steps needed or there is a documentation on it somewhere I overlooked in Alteryx Community.

Sincerely,

Andy

Re: Connect In-DB vs Input Data in Alteryx Server

AkimasaKajitani — Sat, 13 Feb 2021 11:08:07 GMT

Hi @DrydenChicago

Please check this help.

https://help.alteryx.com/current/designer/database-overview

To run workflows on Alteryx Server, the ODBC driver must be configured as a System DSN. For in-database processing, the Connection Type must be "System" in addition to the ODBC connection being configured as a System DSN.

Re: Connect In-DB vs Input Data in Alteryx Server

JoeL — Tue, 16 Feb 2021 04:14:45 GMT

Hi @DrydenChicago

What you want to do is use the File option for configuring In-DB connections that you want to use on Server.

First off, configure your In-DB to have a file that describes the connection parameters, instead of User/System

Then, when saving your workflow to gallery, make sure this connection parameter file is selected to upload with your workflow to the server when saving:

That's all there is to it.

Re: Connect In-DB vs Input Data in Alteryx Server

DrydenChicago — Tue, 16 Feb 2021 13:38:24 GMT

Thanks for the note and suggestion. The only connection type I have is "File" and "User", not "System". Not sure why but the other suggestion from Joel works.

Re: Connect In-DB vs Input Data in Alteryx Server

DrydenChicago — Tue, 16 Feb 2021 13:40:28 GMT

Thanks JoeL!! That was helpful!

Re: Connect In-DB vs Input Data in Alteryx Server

helpfultoaster — Thu, 24 Feb 2022 20:53:49 GMT

You may need to run Designer as Administrator to get the System option to show in the dropdown

Re: Connect In-DB vs Input Data in Alteryx Server

Watermark — Fri, 13 May 2022 16:19:41 GMT

Does that system DSN exist in older/all versions? Or was that something added at some point?

Re: Connect In-DB vs Input Data in Alteryx Server

Watermark — Fri, 13 May 2022 17:03:20 GMT

Also, is it enough to have the admin version, or must you be running it 'as admin' ?

Re: Connect In-DB vs Input Data in Alteryx Server

caltang — Fri, 29 Sep 2023 00:15:58 GMT

I’d like to revive this thread. Can anyone confirm if this helps in 2023?

Re: Connect In-DB vs Input Data in Alteryx Server

Mjohnce — Wed, 20 Dec 2023 01:02:00 GMT

Yes, I have interest with my user community to see if using some sort of INDB connection could help alleviate the modules with the longer run times that query from a cloud database.