Database Administration Console

As part of OpenEdge Management and OpenEdge Explorer, the Database Administration Console provides a browser-based interface for managing all aspects of your multi-tenant database.

The Database Administration console user interface provides efficient and easy-to-use navigation for managing tenants and multi-tenant data. From the management console, you can:

Convert a non-multi-tenant database to one configured for multi-tenancy — You can quickly enable multi-tenancy for a database.

Establish connections to multi-tenant databases — You can set up local and remote connections to managed databases or scripted databases. These databases are listed automatically in the list of database resources in the management console.

You can also set up unmanaged local or remote database connections. Depending on the type of connection you define, you can also edit, copy, and/or delete it.

Create new database tenants, delete tenants, or generate a tenant creation program — You can create two types of tenants: a regular tenant or a super tenant. You can also delete a tenant. Alternatively, you can generate a tenant program based on preferred settings for either an existing tenant or a new tenant. You can use the resultant generated program to later create a tenant quickly, without needing to resupply the settings saved in the program. You can also create a tenant from an existing tenant.

Enable a table for multi-tenancy — You can enable one or more tables for multi-tenancy and then allocate the table's partitions.

Create a tenant template — You can create, view, and edit a template that includes tenant-specific details, such as default storage areas and per-object tenant mapping, so you can reuse the template to create another tenant.

Create a tenant group — You can create, view, and edit a tenant group, and add one or more tenants to it. A group has a partition for a table and partitions for any of the LOB fields and indexes in the table. Each tenant in the group has shared access to the partition and its data.

You can also generate a group creation program based on preferred settings, and later use the program to create a group quickly or that you can use to transfer a group from one database to another database.

Work with existing tenants and multi-tenant database objects — You can work easily with existing tenants to accomplish various tasks related to multi-tenancy configuration, such as:

View a tenant's layout, including the database object schema, tenant object areas, and object properties. Color coding in the partition layout allows you to see easily each object's allocation state.

You can also view tenant partition details and choose how the data is displayed: within area panels or by columns in a grid format. The grid format allows you to choose the information you want to see (partition name, area, allocation state, and/or object type) and sort the information in ascending or descending alphabetical order.

Specify storage area assignments for a tenant's data (tables, indexes, and LOB fields). If you choose not to allocate storage space immediately when you create a tenant, you can reorganize the layout of the multi-tenant database objects, such as moving a table from one area to another area.

Filter the tenant list so you can focus on specific tenants. For example, you can set up the list so that you see only regular tenants or tenants categorized by allocation rule.

Select which of a tenant's areas you want to see when you look at the tenant's area layout. By choosing the areas you want to see, known as the area working set, you can focus only on areas of current interest to you.

Load and preview a data definition file — You can upload a data definition file (.df) and preview its contents (tables, LOB fields, indexes, and sequences) before you commit the changes.

Load database contents — You can load table and group contents into an active database. The database must have table definitions before you can load table or group contents. The console uses the .d files to load table contents from a directory you specify or to load group contents from the subdirectory for groups you specify.

Dump database contents — You can dump table or group data in a text format from the console. The console creates a text file that contains the dump data of each table or group you specify. This file has a .d extension and is stored in the work directory you specify. You can dump data either from a shared table, a multi-tenant table, or both. You can also dump data from a group of tenants sharing a table. You can use these .d files to load data into a database. The console creates a separate contents file for each table or group you dump.

Commit and monitor database updates — You can commit updates to the database, either from an uploaded data definition file or as a result of other changes you make.

As changes are being saved to the database, the My Dashboard page opens to allow you to monitor the updates' progress. The page presents a task viewlet that shows the activity as the updates are being applied.

Filter database connections by AdminServer — You can view all database connections for all AdminServers, or you can choose which AdminServer's connections you want to view.

Manage domains — You can create and modify a domain for each tenant.

Manage authentication systems — You can view, create, or delete authentication systems.

Establish and manage user and table security settings — While you can create and work with users for a particular tenant, you can also create, edit, and delete users at the database level. You can define and review table and field security for the database users, and you can review a summary that provides details about the database's security. You can also configure one or more security administrators who have control over authentication and authorization.

Manage sequence definitions and values — You can manage sequences and sequence values by:

Viewing a list of all sequences in a database. This includes both the sequences enabled for multi-tenancy and those sequences not enabled for multi-tenancy.

Full access to a tenant's sequences functionality requires a database connection for a user associated with either a super tenant or that specific tenant.

Improve database performance — The performance of a multi-tenant database may be improved by using multi-tenant governors: Login Governor (-nGovernor) and Lock Governor (-LGovernor). These governors limit the amount of each individual tenant's allocation of shared database resources, so that one tenant does not fully control these resources at the expense of all of the other tenants. These governors apply to the default and regular tenants in a multi-tenant database. They do not apply to super-tenants. For more information on managing these governors, see OpenEdge Management and OpenEdge Explorer: Configuring Multi-tenancy.