Creating a Join thru Portal that Shows Live Data Updates - NOT Hosted?

[ChristopherBowering]

I have a point feature class with a 1:M related table.  I would like to create a join in Portal where data updates to either the feature class or table are live within the join.  The sources are NOT hosted feature layers; they are published feature layers via federated SDE server.  So far, the only join I can do is static and needs to be recreated when there are source data updates.  Is there a way to accomplish this?

[sxw_eaglegis]

To create a feature layer view in portal, the feature layers will need to be hosted.

For non-hosted data, I would suggest creating a spatial view in the database and publishing that as a map service/feature service.