¿Cómo puedo hacer que la salida de Make Query Layer sea una capa de entidades?

Question

<\/HEAD>Hola<\/P> <\/P> He creado una conexión a la base de datos Oracle desde ArcGIS Pro,<\/P> He utilizado la herramienta "Make Query Layer" de las herramientas de Geoprocesamiento, después de ejecutar la herramienta la salida fue una tabla independiente, ¿qué debo hacer para obtener una capa de entidades en lugar de una tabla independiente?,<\/P> sabiendo que al ingresar los parámetros en el formulario Make Query Layer el parámetro tipo de forma desaparece, necesito saber la razón. (vea el archivo adjunto por favor)<\/P> <\/P> Gracias de antemano<\/P><\/BODY><\/HTML>

Robert LeClair · Answer

Michael - I test this using a DB View in AGP and attempted to share as a hosted feature layer using the Share Web Layer command.  If I did not enable editing on the feature layer, it published successfully to AGOL.  However, if I enabled editing on the hosted feature layer, it threw an error saying "editable feature services cannot contain database views.  'riverside.gisadmin.Test1DBV is a database view."  Interesting...

mvolz47 · Answer

Can the database view, from a logical view not a materialized view, be used for feature access capability?  I ask because in ArcMap I tried to publish a mapservice with feature access so there would also be a feature layer, but I received High errors stating that virtual columns are not allowed to be used.  I have no problem using the same data source in a standard mapservice.

Robert LeClair · Answer

Here's a link on how to create a Database View in ArcGIS Pro - it acts like a feature class but it's a view of tables with only the attribute columns you want to see in the view.  As an added bonus, it's read-only so no one can edit the data and you can assign privileges on db views too!