Link Dashboard to SDE database

225
4
Jump to solution
01-05-2022 12:44 AM
Abdullah_AlFazari
Occasional Contributor

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?

0 Kudos
1 Solution

Accepted Solutions
JohannesLindner
MVP Regular Contributor

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

Have a great day!
Johannes

View solution in original post

4 Replies
JohannesLindner
MVP Regular Contributor

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

Have a great day!
Johannes
Abdullah_AlFazari
Occasional Contributor

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?  

0 Kudos
JohannesLindner
MVP Regular Contributor

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.


Have a great day!
Johannes
0 Kudos
Abdullah_AlFazari
Occasional Contributor

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

Will try to apply what you suggested.

0 Kudos