Can I join tables to a hosted feature layer (or feature layer from a registered database) in Portal for ArcGIS?

[AdamMcKay3]

We have a whole lot of data that sits in an Oracle database which we query with SAS products to produce output tables.  Oftentimes, we join these SAS output tables to our spatial boundary files (e.g., Census subdivisions) for mapping purposes in the ArcPro/ArcGIS for Desktop platforms.  Is it possible to publish our standard boundary files to Portal for ArcGIS as a hosted feature layer, map image layer, or feature layer (from registered database) and then join tables (which are produced in the SAS environment) to that published layer?  

Our group of analysts operate primarily on request (i.e., somebody asks us to query some data and we produce the output tables).  We query the data and then oftentimes we map them.  It seems more efficient to publish the boundary file (e.g., Census Subdivision) one time and then join a number of subsequent output tables to the boundary file, but I don't know if that it possible in the Portal for ArcGIS platform.  The alternative is to publish the boundary file multiple times with each new request/data query.  The latter method seems inefficient, but maybe that is the only way to do it?  I am open to suggestion.

Thanks

[MarleyGeddes · Accepted solution]

Hi Adam, 

If you are using ArcGIS Enterprise version 10.5 or later, then you should be able to use the Join Features standard analysis tool in Portal for ArcGIS to perform this task. This tool was introduced with the 10.5 release.

See the help document on this tool for more details: Join Features—Portal for ArcGIS | ArcGIS Enterprise 

Hope this helps!

[AdamMcKay3]

Hi Marley,

Thanks for the suggestion.  We are currently using version 10.4.1 and are scheduled to be upgraded in the next year or so.  I'll keep an eye out for the tool when we have the upgrade.

Thanks again!