I am pulling 4 tables from a SQL database and publishing to the Enterprise Portal to use in Experience Builder. The issue is that I need the tables to be related. I cannot create a relationship class because of the database type, but I also cannot join the two tables, because I need the data to be real-time and refresh automatically (pulled directly from the database connection).
I have the tables related in Pro, but when I publish the tables to Portal, only one of the relationships is maintained (and sometimes none are). I cannot seem to figure out what was different with the relate that worked.
The end goal is to be able to set up the feature layer widget to display both the original table fields and the related table fields for each point. Any suggestions?
