Input Data Tool: Sharing & distributing DB Connections

[SeanAdams]

Hi all,

there was a post by @TonyM recently that talked about aliases 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Database-Connections-Creating-an-alias-and-t...

With Alteryx 11, this has been changed to be Database Connections.

Question for the community is whether there's any learning material or training (yes, I'm looking at you @JoeM ) on how to:

- Share a DB connection among team-mates (both the regular kind and the in-DB kind) so that we all use the same connection to the DB (to support each other during vacations etc)

- how to then publish this connection with the canvas to the gallery server (do we need to do anything)?   Are there variants based on SQL Native vs. OleDB vs. ODBC DSN and are there variants across regular full-fat DB connections vs. In-DB connections?

- And then as a central administrator, how do I create a DB connection centrally, and push this down to my user base to keep central control of a shared data asset (e.g. give people read-access without exposing the password etc).

cc: @MPistone @ydmuley @MarvinPinto

Apologies if this is already well covered somewhere - please feel free to direct me to the appropriate spot.

Cheers

Sean

[AndrewL · Accepted solution]

There are no official training videos that I'm aware of but below is a variety of Knowledge base articles and the help file pages for Data Connections for your reference:

https://help.alteryx.com/server/11.0/admin/index.htm#Administration/DataConnections.htm

https://help.alteryx.com/11.0/index.htm#ManageInDBConnections.htm?Highlight=data%20connection%20mana...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Guide-to-Setting-up-Consistent-DSN-s-Alias-M...

https://community.alteryx.com/t5/Product-Resources/NEW-Data-Connection-Manager-Alteryx-11-0/ta-p/448...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Database-Connection-Share-Through-Gallery-Ad...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Manage-Data-Connections-Alteryx-11-0/ta-p/45...

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Alteryx-In-DB-Connection-File/ta-p/17574

Thanks,

Andrew

[SeanAdams]

Thank you Andrew, this is very helpful and gives me some good weekend reading.