https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536958#M15664 <P>Thanks- I upgraded ArcGIS Pro to 3.3 and now the option to share as a reference is available. Thank you!</P> Tue, 10 Sep 2024 17:06:49 GMT StefanCoe1 2024-09-10T17:06:49Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536700#M15658 <P>We have an MS SQL Server Database registered as a Data Store in our Portal. The database is not an Enterprise Geodatabase. When trying to publish tables/views to Portal using ArcGIS Pro,&nbsp; the only option seems to be as a hosted table. Is it possible to reference the data instead of copying it (hosted)? Thanks!</P> Mon, 09 Sep 2024 23:49:46 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536700#M15658 StefanCoe1 2024-09-09T23:49:46Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536770#M15659 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/622970">@StefanCoe1</a>&nbsp;what version of Portal and Pro are you using?&nbsp; I don't believe this was an option in earlier releases, but should work at 11.1 and forward.</P> Tue, 10 Sep 2024 11:22:25 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536770#M15659 JakeSkinner 2024-09-10T11:22:25Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536816#M15660 <P>Publishing referenced stand-alone tables by themselves is possible in ArcGIS Pro 3.3+.&nbsp; In previous versions of Pro, you had to publish a geometry layer alongside the table (common workflow was to add a "dummy" layer to enable publishing the referenced table).&nbsp; Both of these methods work in Enterprise 11.1 or greater, but I am not sure past that.</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm" target="_blank" rel="noopener">https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm</A></P><UL><LI>You can share<SPAN>&nbsp;</SPAN><A href="https://pro.arcgis.com/en/pro-app/3.3/help/sharing/overview/share-standalone-table.htm" target="_blank" rel="noopener">stand-alone tables</A><SPAN>&nbsp;</SPAN>as map image layers and map services that reference registered data without having to include data layers in the map.</LI></UL> Tue, 10 Sep 2024 13:21:49 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536816#M15660 Marshal 2024-09-10T13:21:49Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536928#M15663 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/622970">@StefanCoe1</a>&nbsp;- You can use ArcGIS Pro &amp; Query Layers to create your map document and then publish as an ArcGIS Server Service, read more in the link below.</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm" target="_blank" rel="noopener">Query layers—ArcGIS Pro | Documentation</A></P> Tue, 10 Sep 2024 16:15:52 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536928#M15663 MarceloMarques 2024-09-10T16:15:52Z https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536958#M15664 <P>Thanks- I upgraded ArcGIS Pro to 3.3 and now the option to share as a reference is available. Thank you!</P> Tue, 10 Sep 2024 17:06:49 GMT https://community.esri.com/t5/arcgis-enterprise-portal-questions/reference-table-from-sql-database-that-is-not-an/m-p/1536958#M15664 StefanCoe1 2024-09-10T17:06:49Z