Try OpenEdge Now
skip to main content
Configuring Multi-tenancy
Working with tenants : Creating a new tenant for a multi-tenant database : Creating a new tenant or tenant program
 

Creating a new tenant or tenant program

You can create a new tenant or create a tenant based on an existing tenant. You can also generate a reusable tenant ABL program for an online multi-tenant database. Before you begin, you must select a database connection, and the database server must be running, as described in Setting up the connection.
You can also create a tenant from a tenant template. For more information, see Using tenant templates.
To create a new tenant or tenant program:
1. In the management console menu, choose one of the following:
*Select Database Administration > New > Tenant.
*On the management console menu, select Database Administration > Go to Database Administration. The Database Administration page appears.
Filter or search for, and select the required database connection. The database connection home page appears.
In the Security Summary section, click Create tenant.
The New Tenant page appears.
2. Provide the following information:
*Tenant name — The name of the new tenant, which must be unique within the database. Do not use spaces or special characters such as an asterisk (*), ampersand (&), or period ( . ) in this field. You can include the underscore (_).
*Description — An optional description of the tenant.
*External ID — An optional ID. If you provide an external ID, you can later refer to the ID when you view the progress of transactions being committed.
3. Select the tenant type: Regular or Super. For more information about each tenant type, see Common terminology.
4. To enable access to the tenant's data, select the Enable data access option. If you do not select the option, data access is disabled for any user other than the super-tenant. For more information, see Enabling or disabling access to tenant data.
5. In the Database connection name, enter a database connection name to which you want to add the new tenant. By default, the last used database connection name appears in the Database connection field.
Note: If you type the name of the database connection, follow the format used by OpenEdge Management/OpenEdge Explorer to define a connection: AdminServer-name.database-name. A database server must be running for you to connect to the database.
You can also click the Search icon to choose a database for which you are creating the tenant from the Connection Selection dialog.
The Connection Selection dialog displays the connections details in a grid. You can perform the following:
*Filter the connections in the grid by a Connection name, AdminServer, and/or Category.
*Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the connections to appear in the grid.
6. If you are creating a super-tenant, go to Step 9 .
If you are creating a regular tenant, type the name of each of the following areas, and then continue with Step 7 :
*Default data area — The default storage location for the tenant's tables
*Default index area — The default storage location for the tenant's indexes
*Default LOB area — The default storage area for the tenant's LOB fields
For each for the areas, you can either enter the storage area name in the default area field or click the Search icon to choose the storage area name from the Area Selection dialog.
The Area Selection dialog displays the storage area names in a grid. You can perform the following:
*Filter the storage area name in the grid by Area name, Records per block, and/or Cluster size.
*Move forward or backward a page, or specify a particular page, in the list of domains by using the Page feature at the bottom of the list.
*Select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the area names to appear in the grid.
7. Choose one of the following object allocation rules for the regular tenant:
*Set new objects not to allocate space — Allocate no space for the tenant's objects.
*Set new objects to allocate space on tenant creation — Allocate storage space immediately.
*Set new objects to delay space allocation — Do not yet allocate storage space. (You can allocate space later when you are ready to do so.)
8. If you selected either Set new objects not to allocate space or Set new objects to delay space allocation in Step 7, select one of the these options:
*Do not use template — Select this option if you are creating a new tenant without using a template.
*Tenant — Select this option if you are creating a tenant by using an existing tenant. You can type the tenant name in the field, or you can click the Search icon to open the Tenant Selection dialog.
The Tenant Selection dialog displays the tenant details in a grid. You can filter the tenants in the grid by Tenant name and/or External ID.
You can also move forward or backward the page, or specify a particular page, in the list of tenants by using the Page feature at the bottom of the grid.
You can select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the tenants to appear in the grid.
*Template — Select this option if you are creating a tenant by using an existing template. You can enter a template name in the field, or you can click the Search icon to open the Template Selection dialog. For more information about working with tenant templates, see Using tenant templates.
9. Choose one:
*To create the tenant immediately, click Create tenant.
If you are creating a regular tenant, the tenant home page appears. Click Edit tenant in the Manage Tenant section to see a set of vertical tabs consisting of the following selections in the left pane: General, Partitions, Groups, Users, and Domains.
OpenEdge Management console submits an asynchronous task to the OpenEdge servers when you create a tenant in a database. You can view status of such a task in the Database Administration Tasks page by selecting Database Administration > View > Database Tasks.
If you are creating a super-tenant, the tenant home page appears. Click Edit Tenant to see a set of vertical tabs consisting of the following selections in the left pane: General, Users, and Domains.
*To create a tenant configuration script, click Generate tenant program. Select a location to save the create_tenant.p file.