Creating databases

The Database Utility enables you to create databases on the database server to be used with Process Manager. You can create several databases, but only one will be connected to Process Manager at a time. Only system administrators have rights to create databases.

Note: Process Manager requires Microsoft SQL as the native database for Process Manager. However, you can use any ODBC-compliant database with your workflows and database listeners.

To create a Process Manager database
  1. Start the Database Utility and enter the authorized user name and password.
  2. Enter the server name and the name of the database you want to create.
  3. Click Test connection.
  4. When the Build database? prompt appears, click Yes to build the database.
  5. Enter the authorized user name, password, and server name.
  6. Select Create new Process Manager database, then click OK to close the administrator required message box.
  7. Click Execute.
  8. When the Success message box appears, click OK.
  9. Click Close.
  10. Enter the name of the outgoing SMTP e-mail server.
  11. Enter the e-mail address you want to use for messages sent from Process Manager.
  12. Click Users/Groups and set up local or domain connections for your users. See "Configuring users and groups".
  13. When you have finished setting up users and groups, click OK.
  14. Click OK to dismiss the Success message box.
  15. Click Close.