Database Management (Admin)

Use the database manager to manage the database and set database security.


Use the server tree on the left to find and select the database you wish to manage. You can use the drop down to filter the data source type and quick search to find items by name.

Once selected the general tab will show:

  • Import: click to import an exported data model into the selected database.
  • Delete: click to delete the database.
  • De-recognize: de-recognize the database in the Pyramid repository.
  • Audit Trail - will show a history of general activities on the database.

The Created Date, Disk Size, and Memory Size will also be displayed if viewing settings for In-Memory Databases.


For a given database, select the Security tab to manage access to this database by role.

  • Select the roles that should be assigned to the database.
    • Read: users will be able to query the database (subject to model specific access)
    • Model Only: users will have access to existing semantic models only; this enables users with restricted data permissions to build data models without having access to the underlying data source.
    • Write: user will be able to write back into the specific database using the data modeling tools
  • You can assign the same role permissions for all of the subordinate models within the server by clicking Propagate Roles button.
    • Use the role-specific propagate button to propagate a single role at a time.
    • Click the "Add Role" button to add a new role to the list. By definition, this will propagate UPWARDS to the server level as well.

Click Apply to save your selections.


Click the Models tab to see the list of data models attached to the database. For each data model, you’ll see:

  • Actions:
    • Delete: delete the data model.
    • Copy to Model: copy the data model to a different database.
    • Move Model: move the data model to a different database.
    • Export: export the data model to a "pie" file.
    • Edit: go to the data model’s General tab. This is a shortcut button.
    • Security: go to the data model’s Security tab. This is a shortcut button.
  • Model Name: the name of the data model.
  • Created On: the date and time that the model was created.
  • Created By: the user who created the model.
  • Last Processed Date: the date and time the data model was last processed.

Macro Actions

Users can use the checkboxes in the list to perform bulk actions. Not all actions are available on every database type.

  • Delete: delete all the selected models
  • Export: export all the selected models
  • Import: import a new model definition and attach to this database