Understanding Saviynt IGA Database Relationships – A Developer’s Guide
Saviynt Identity Governance & Administration (IGA) is a powerful platform, but one of the trickiest parts for developers is navigating its relational database schema. If you’re writing analytics queries, building custom reports, or troubleshooting provisioning issues, knowing the relationships between users, accounts, entitlements, roles, and endpoints is essential. 1. Core Building Blocks Saviynt’s IGA schema revolves around these main entities: Table Purpose Key Columns users Identity repository for people in Saviynt USERKEY, USERNAME, EMAIL, FIRSTNAME, LASTNAME, MANAGER accounts Technical/system accounts across applications/endpoints ACCOUNTKEY, ACCOUNTID, NAME, ENDPOINTKEY user_accounts Mapping table that links identities to accounts USERKEY, ACCOUNTKEY ...