Because a super-tenant user can access data for multiple regular tenants of a multi-tenant database, the first thing they often need to do is to identify the tenants of a connected database. Or they might need to identify the tenancy of specific data that they query across multiple tenants of the database, perhaps in order to identify the effective tenancy setting to more conveniently process the data for a given tenant.
OpenEdge identifies tenancy by:
Tenant name — A name you assign when you configure the tenant in a multi-tenant database, or "Default" for the name of the permanently configured default tenant in every multi-tenant database.
Tenant ID — A database-unique, integer ID that OpenEdge assigns when you first create the tenant in a database. The values for tenant IDs have standard ranges, depending on the type of tenant:
Default (regular) tenant ID — Always zero (0)
All other regular-tenant IDs — Positive integers
All super-tenant IDs — Negative integers
Testing on this value allows you to select on multiple tenants by their tenant type.
The following sections describe various tools available for identifying tenancy for various contexts.
Tenant name — A name you assign when you configure the tenant in a multi-tenant database, or "Default" for the name of the permanently configured default tenant in every multi-tenant database.
