Creating an Archive Database

To enable archiving, you must create an archive database.

Before you can enable archiving, you should have added the external resource reference so that the process engine knows where it is. See Adding the Archive Database External Resource.

The following instructions assume you are logged in to Process Administrator

To create an archive database:

  1. Click on Engines. The Engines page appears.
  2. Click on the name of the engine you want to create an archiving database for. The Edit Engine page appears.
  3. In the Advanced Properties section, click Manage Database. The Manage Database page appears.
  4. Select the Create the database and Create the data structure options.
  5. 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.
  6. 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.
  7. 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.