topic Re: SQl Server Connection in Alteryx Server Discussions

SQl Server Connection

AltAddict26 — Thu, 30 Jan 2020 14:15:27 GMT

Hi All!

I'm trying to get a clear picture of the security process for Alteryx Gallery and its publishing capabilities to SQL Server. Does anyone know if its possible to keep the Alteryx security (such as who is able to view/run a workflow in a collection) when publishing to a SQL Server database? This may be something only the DBAs on our project can do but I wanted to reach out and see if anyone has any experience with this or knows of any articles I can look at (I've been having trouble finding documentation on this process.)

We are very security conscious and are looking for the best way to restrict access to certain data views/tables in Sql. We are in the early stages of adapting Alteryx so any other suggestions would be much appreciated as well!

Thank you!

Re: SQl Server Connection

mchamps — Thu, 30 Jan 2020 21:55:06 GMT

Cool use case! Although I don't think Alteryx Server alone supports your use case. Row level security and/or permissions to DB/Tables would need to be set up by your DBA on MS SQL Server.

SQL Server 2016 supports row level security https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

Then at runtime you would need to make run-as credentials required to run the workflow https://help.alteryx.com/current/server/set-required-run-user-permissions

Re: SQl Server Connection

AltAddict26 — Thu, 30 Jan 2020 23:21:14 GMT

Thank you these links are very helpful! Do you happen to also know anything about how companies handle security through the Alteryx Service accounts? Again I haven't been able to find too much information on security at a higher level. Thanks!