topic Re: Publishing Joined Data from 2 Different Databases? in Geodatabase Questions

Publishing Joined Data from 2 Different Databases?

AdamBakiera — Wed, 21 Aug 2019 22:49:57 GMT

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!

Re: Publishing Joined Data from 2 Different Databases?

MichaelVolz — Wed, 21 Aug 2019 23:31:25 GMT

Just out of curiosity, why are you trying to avoid a linked database? This provides a live connection so you won't need to have some type of update script if you had to pull data from database to another.

Re: Publishing Joined Data from 2 Different Databases?

AdamBakiera — Thu, 22 Aug 2019 12:50:15 GMT

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.

Re: Publishing Joined Data from 2 Different Databases?

George_Thompson — Thu, 22 Aug 2019 14:39:35 GMT

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.

Re: Publishing Joined Data from 2 Different Databases?

AdamBakiera — Fri, 06 Sep 2019 15:26:56 GMT

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?