To create a query layer that references data in a spatial database or data warehouse, you must complete the following tasks to ensure the query layer works with ArcGIS:
- Use a release of the database management system that is supported by the ArcGIS version you are using. Use the links in Supported databases and cloud data warehouses to check for supported databases and versions.
- The query layer definition must include a unique, not-null column or combination of columns that can be used as the object ID in the query layer to use the query layer in a desktop app. To publish, you must ensure the query layer contains a single, unique, not null, autoincrementing integer column to be used as an object ID. If the data you want to publish does not have such a column, you must add one. See Unique identifier fields for more information.
- Your database must contain an SQL spatial type. Depending on the type of database management system you use, you may need to configure the spatial type. For example, a spatial type is included with Dameng, but you must initialize it to use it.
- In most cases, you must install and configure database management system clients on each of the client computers from which you will create query layer connections. Contact your information systems department to set up your computer for query layer connections if your login is not a member of the Windows Administrator group on your computer.