Try OpenEdge Now
skip to main content
Configuring Multi-tenancy
Managing multi-tenant databases : Managing a multi-tenant database : Loading database contents : Loading group contents to a database
Loading group contents to a database
The Database Administration console uses the .d files to load group contents from the sub-directory for groups you specify.
To load group contents:
1. In the management console menu, do one of the following:
*Select Database Administration > Load > Group Contents (.d files).
*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 Data Administration section, click Load group contents (.d file).
The Load Group Contents page for the selected database connection appears.
2. In the Database connection field, enter a database connection name that contains the database into which you want to load the table contents. By default, the last used database connection name appears in the Database connection field.
You can select another database connection by entering a database name 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 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.
Note: When you select a database connection name, the Database connection field displays the selected database connection name. Most of the other fields get auto-populated with the default values, based on the selected database connection name.
3. In the Load root directory field, specify a file path of the groups sub-directory which contains the contents (.d) file. By default, this field displays the work directory C:\OpenEdge\WRK.
4. Select Include LOB to enable importing of large database objects, such as images. By default, this check box is selected.
5. In the LOB sub-directory field, specify a sub-directory name that contains the large database objects that you want to load. By default, this field displays lobs and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
6. In the Acceptable error percentage field, specify an acceptable error percentage. The default value is 0.
7. In the Group sub-directory field, specify a sub-directory name which contains group contents in .d files. By default, this field displays groups and this sub-directory is contained in the default work directory C:\OpenEdge\WRK.
8. Select the Skip secured tables check box, if you do not want to load secured tables.
9. Select the Skip missing directories check box, to skip validating the missing sub-directories mentioned under the root directory when loading table contents.
10. Select one of the following options for Groups:
All 1
Load contents to all groups. By default, this option is selected.
Load content either to one or many groups. Selecting this option displays the Selected Groups section.

1 Databases that are not enabled for multi-tenancy do not have groups.

In the Selected Groups section, do the following:
a. In the Group name field, enter a group name. You can specify a keyword, use the wildcard operator *, or a combination of both.
b. Click Apply Filter. Based on your search criteria, the Selected Groups section lists the group names and displays the following columns:
Column name
Group name
Displays the name of groups in an ascending alphabetical order.
Displays whether the schema associated with the database table is public or user-defined. The default value is PUB which indicates that the default public schema is assigned to the OpenEdge database.
Displays the table in the database with which the group is associated.
Is allocated
Displays true if space is allocated for objects in the group.
Displays details associated with the group name. This column is optional. To view this column, click any of the column's drop-down and select Columns > Description check box.
11. Click Load. A confirmation dialog appears for table data load displaying the number of groups that will be loaded.
12. Do one of the following:
*Click Commit to load contents of the selected groups. You can view status of such a task in the Database Administration Tasks page by selecting Database Administration > View > Database Tasks.
*Click Commit & Monitor to load contents of the selected groups, and view the task page. This page lists the details of the load activity performed.
*Click Cancel to exit the dumping process.
When this operation is successful, the contents from the .d file in the groups sub-directory of the load directory you specify, (in this case, the work directory C:\OpenEdge\WRK) are imported into the database groups.