Publishing Joined Data from 2 Different Databases?

Question

We have data in two different databases (both in sql) that we need to join and publish to Portal. I believe that currently, ESRI does not support a relationship class where the feature layer is in one database and the table is in a different one. We are trying to avoid using a linked database in sql so I was wondering if anyone else has had this problem and what they did for a workaround.

Thanks!

AdamBakiera · Answer

Update: We decided to go with the linked database. The issue we have now is we can't register the view from the other database.

I've also read that non-spatial views can't participate in relationship classes. Is this true?

George_Thompson · Answer

Depending on how often the tabular data is updated, you could create a duplicate table in the SQL Enterprise geodatabase with the feature layer and just have a script scheduled to update the table data as needed. That would put it in a single EGDB and make your workflow easier.

AdamBakiera · Answer

The biggest reason is that when we upgrade servers every couple of years or so, we have to rebuild everything so we want to avoid doing that.