Before enabling BAM or the Data Mart, you must create their
respective databases. You can use Process Administrator to either create the
database directly, or to generate an SQL script for execution by a database
administrator.
Before you can create a BAM or Data Mart database, you should have
added the external resource for it. See
Adding the BAM or Data Mart Database External Resource.
The following instructions assume you are logged in to Process
Administrator. You must perform these steps for each service you will use (BAM
and Data Mart).
To create a BAM or Data Mart database:
- Click on
Process Monitoring.
The
Process Monitoring page appears.
- Select the BAM or Data Mart tab.
- In the
Advanced Properties section, click
Manage Database.
The
Manage Database page appears.
- Select the
Create the database and
Create the data structure options.
- If you have administrator access to the database, enter the
database administrator user and password, and click
OK.
If Process Administrator reports that the database has been
created successfully, you are done. The instructions below are for users
without administrator access to the database.
- If you do not have administrator access, click
Show SQL Statements.
Your web browser will ask you if you want to save the
sql.txt file.
- Save the file to any location, and send it to the database
administrator, who will run the SQL statements in the file, creating the
database.