topic Re: Link Dashboard to SDE database in ArcGIS Dashboards Questions

Link Dashboard to SDE database

Abdullah_AlFazari — Wed, 05 Jan 2022 08:44:52 GMT

Dears,

I'm in the process of creating a dashboard using Portal, and I'm wondering if there is a way to link Portal to our SDE database, because now I'm just creating Web Maps using the published layers (which there source is FGDB). And since the dashboard would have many indicators, then I need these indicators to update directly once we update our SDE.

Ant thoughts?

Re: Link Dashboard to SDE database

JohannesLindner — Wed, 05 Jan 2022 13:29:28 GMT

You can publish layers from your SDE, too.

So either

publish new layers from your SDE and use them in the dashboard, or
go to the project from where you published the existing layers, change all data sources to the SDE and overwrite the published layers

Re: Link Dashboard to SDE database

Abdullah_AlFazari — Wed, 05 Jan 2022 17:26:53 GMT

Many thanks @JohannesLindner for your response.

I'll give it a try and will see. If the layers are published directly through the SDE to a Web Map as well, is there are any risk for the data?

Re: Link Dashboard to SDE database

JohannesLindner — Thu, 06 Jan 2022 06:16:16 GMT

Some other people will be more qualified to answer that in detail.

My tips:

make sure you hide sensitive information
publish from a connection with only read access
if there is sensitive data left, don't share publicly

The first two points can be achieved by defining database views (CreateDatabaseView) and sharing those instead of the raw tables. Views can only be read, not written to, and you can hide sensitive or unnneccesary fields.

Re: Link Dashboard to SDE database

Abdullah_AlFazari — Thu, 06 Jan 2022 10:32:21 GMT

Many thanks, @JohannesLindner for your valuable response. I do highly appreciate your continued support.

Will try to apply what you suggested.