Creating the Worklist Manager Database
The
Worklist Manager database stores task assignment data, such as the type, priority,
and status of the task, as well as who a task is currently assigned to. Before
beginning this task, be sure you have database instance created where you
can install the Worklist Manager tables.
To create the Worklist Manager database
-
From the Project Explorer, expand BPM, and then expand WorkListViewer.
-
Right-click
WorklistViewer, and then click Checkout.
-
On the dialog box, click Check Out.
-
Right-click Database Scripts, and then click Properties.
The Database Script Properties dialog box appears.
Figure 1 Worklist Manager Database Properties
-
Configure the database properties to connect to your database,
and then click OK.
See Figure 1 for
more information about the values for these properties.
Note –
The user whose login information you enter must have DBA privileges
to create the new Worklist Manager user.
-
For Oracle databases only:
-
In the Project Explorer, right-click the install script file appropriate
for your database, and then click Open.
-
Modify the location of the tablespace data file to the location
where you want the file to reside.
-
Right-click inside the file, and then click Save.
-
In the Project Explorer, right-click the install script file appropriate
for your database, and then click Run.
Property
|
Description
|
Database Type
|
The database vendor and version you are using.
|
JDBC URL
|
The URL to connect with the database. Enter one of the following:
-
For Oracle: jdbc:SeeBeyond:oracle://<host>:<port>;SID=<SID>
-
For Sybase: jdbc:SeeBeyond:sybase://<host>:<port>
-
For SQL Server: jdbc:SeeBeyond:sqlserver://<host>:<port>;DatabaseName= <dbname>
-
For DB2: jdbc:SeeBeyond:db2://<host>:<port>;DatabaseName=<SID>;collectionId=JDBCPKG;packageName=JDBCPKG;embedded=true;createDefaultPackage=FALSE
where <host> is the machine on which
the database resides, <port> is the port number on which the database is
listening, and <SID> and <dbname>
are the name of the database.
|
User
|
The login ID of a database administrator. This user must be able to
create users and assign permissions, as well as create and drop tables.
|
Password
|
The password for the administrator user.
|