Database Administrator for xPert Web User Guide

Overview

The mTuitive Database Utility is designed for managing mTuitive Report Templates in both the Sandbox and Production areas when using mTuitive’s report templates.  Management functions include publishing templates, deleting templates and unlocking cases.  The basic premise is this:

1. Reports get into the Sandbox via mTuitive or by the Agile Author.
2. Server Report Groups get associated with different databases by an administrator using this utility.
3. Reports get published from the Sandbox to the production or test system by an administrator using this utility.
4. Report metadata gets placed into the appropriate database by an administrator using this utility.
5. Reports get deleted from the production Reports by an administrator using this utility.
6. If a case record is inadvertently locked by a user, the locked may be cleared by an administrator using this utility.

Managing reports on the server

Open the IIS Management Services on the web server.

Select the xPert Web site in the left Connections panel.

Select Browse xPert Web on port 443 on the right Actions panel.

Log into the mTuitive Database Utility using your assigned credentials.

Then, eFRM will open the mTuitive Database Utility.

Select the Cloud Server Template set to publish from as instructed by mTuitive.

The Database Utility will attach to the Cloud Server and display available templates in the ‘Sandbox’ in the left window pane.

Select the group on the right panel where you would like to publish to, usually TEST or LIVE.

Select the Template Set you wish to publish to.

Previously published report templates will be highlighted in green in the right window pane. Templates that are not highlighted have not been published at this point.

Select the report(s) in the left panel to be published, either by clicking the "Select All" button or by selecting reports

Next click on the Deploy button in the middle.

Once all of the templates are published and up to date, the entire list on the left panel will be highlighted in green.

To exit the application, select the user name in the upper right and then click log out and close the browser.