topic Re: How can I make the output of Make Query Layer be feature layer in Esri Training Questions

How can I make the output of Make Query Layer be feature layer

HusseinHammoud — Thu, 03 Oct 2019 08:34:53 GMT

Hello

I have created a connection to oracle database from ArcGIS Pro,

I have used the tool "Make Query Layer" from the Geoprocessing tools , after I had run the tool the output was standalone table what should I do to get a feature layer instead of standalone table,

knowing that while entering the parameters in Make Query Layer form the parameter shape type disappear, I need to know the reason . (see the attach please)

Thanks in advance

Re: How can I make the output of Make Query Layer be feature layer

JoshuaBixby — Wed, 09 Oct 2019 00:08:07 GMT

From the screenshots, it looks like you are querying a view. What are the data types involved in the view?

Re: How can I make the output of Make Query Layer be feature layer

George_Thompson — Wed, 09 Oct 2019 10:29:59 GMT

To add what Josh said, why do you not just bring the view in from Oracle directly?

Are there multiple shape types in the view or source table?

To get something like a feature layer and not a query, you will need to export and create a new feature class with the query data.

Re: How can I make the output of Make Query Layer be feature layer

Robert_LeClair — Wed, 09 Oct 2019 18:29:11 GMT

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!

Re: How can I make the output of Make Query Layer be feature layer

MichaelVolz — Wed, 09 Oct 2019 18:35:53 GMT

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.

Re: How can I make the output of Make Query Layer be feature layer

Robert_LeClair — Wed, 09 Oct 2019 18:55:36 GMT

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...