To create a query layer that references data in a spatial database, 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 database management systems 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 need to 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 use 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. Informix databases must be registered with Informix Spatial DataBlade. Contact your GIS administrator or database administrator if you are not sure whether the database you connect to is enabled for ST_Geometry.
- 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.