Search: Advanced search

SDE Layer

Article ID: 302

Last updated: 21 Aug, 2018

Revision: 7

Export to PDF

Email to friend

The SDE Layer monitoring point checks the privileges to the database and checks to see if the individual layers are active/loaded. During SDE data updates, the privileges may not be applied properly. Using a non-data owner username and password allows the SDE Layer check to verify if privileges have been applied properly.

The parameters that are unique to the SDE Layer include:

Server Name	Server name where SDE GeoDB is located
SDE Port#	Enter the type of RDBMS being checked. Ex. SQL, ORACLE, ORACLE12C or POSTGRES If an additional parameter of ’:Empty’ is included, a FC/table that is empty/Zero/Null is allowed *Example:* SQL:Empty or ORACLE12C:Empty
Database	SDE Database name for MSSQL and Postgres Connection info for Oracle: ex. VOracle12c:1521/orclpdb.vestra.ad VOracle11g:1521/vector
Layer Name w/Ow	SDE layer name with data owner ex. GIS.roads
userID	User ID with access to the Feature Class. If using Windows AD authentication, enter Domain\UserID *Note:* userID should be entered as encrypted information
userPW	User PW for access to the Feature Class *Note:* userPW should be entered as encrypted information

Note: This check is backward compatible with previous SDE Layer Check versions

Prev		Next
RSS Feed		SDE Replication MSSQL