Link Dashboard to SDE database

[Abdullah_AlFazari]

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?

[JohannesLindner · Accepted solution]

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

[Abdullah_AlFazari]

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?  

[JohannesLindner]

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.

[Abdullah_AlFazari]

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

Will try to apply what you suggested.