topic Re: Data Gateways without server admin in Product Forum

Data Gateways without server admin

JakobSørensen1 — Mon, 26 Apr 2021 11:30:56 GMT

I am looking into Blue Prisms Data Gateway functionality. I would like to use a SQL Server as data gateway, but according to this guide, you pretty much need to be server admin to configure it correctly. In my organization, as well as most other larger organizations, getting server admin permissions is not possible.

Is there a way to configure data gateways (using SQL) where you only need something like database owner on a single database?

Re: Data Gateways without server admin

chris.mcgowan — Mon, 26 Apr 2021 14:09:33 GMT

Hi Jakob,

Data Gateways does not need sysadmin permissions on the SQL Server only membership in the BPA_DataGatewaysEngine database role in the Blue Prism database and if using a Database destination write access to any Data Gateway database destination table (this cannot exist in the Blue Prism database). See the "User Guide - Data Gateways" on the portal for more information.

Regards

Chris

Re: Data Gateways without server admin

JakobSørensen1 — Tue, 27 Apr 2021 05:47:01 GMT

@chris.mcgowan do you by any chance have a link to the user guide that you are referring to?

Re: Data Gateways without server admin

chris.mcgowan — Tue, 27 Apr 2021 09:48:19 GMT

Hi Jakob,

The documentation can be found on the portal, link to the particular document below;

https://bpdocs.blueprism.com/bp-6-10/en-us/Guides/data-gateways/dg-introduction.htm?tocpath=Guides%7CData%20Gateways%7C_____0

Regards

Chris