Setting Database Connection Options

Line 9 contains the settings that iProcess Engine uses to connect to the database. (The following example is for a TIBCO iProcess Engine for Windows).

3\swpro\swuser\swpro\\sw-servers\0

Individual entries are separated by a backslash character (\). The following table describes the meaning of each entry.

Setting Database Connection Options in the staffpms File

Position

Example

Description

Notes

1

3

iProcess Engine type

This field must always be 3 for a database version.

2

swpro

iProcess Engine database background user

The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that iProcess Engine uses for background access to the iProcess Engine database schema.

Note: This login/account must be the same login/account as the iProcess Engine database schema owner (specified in position 4).

3

swuser

iProcess Engine database user

The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that iProcess Engine uses for other access to the iProcess Engine database schema.

4

swpro

iProcess Engine database schema owner

The name of the database login (for SQL Server or Oracle) or UNIX account (for DB2) that owns the iProcess Engine database schema.

5

null

Oracle database TNS identifier

The Oracle TNS identifier that iProcess Engine uses to connect to the Oracle instance holding the iProcess Engine database tables. This is the appropriate SERVICE_NAME entry in the tnsnames.ora file, which is located in the ORACLE_HOME\network\admin directory).

If a TNS identifier is not defined, iProcess Engine will attempt to connect to the local Oracle instance, and Oracle Transparent Application Failover (TAF) will not be supported.

Note: This entry is only used if iProcess Engine uses an Oracle database.

6

sw-servers

ODBC Data Source (SQL)

or

Database Alias (DB2)

The name of the ODBC data source (for SQL Server) or Database Alias (for DB2) that iProcess Engine uses to connect to the database.

Note: This entry is not used if iProcess Engine uses an Oracle database.

7

0

Reserved

This field is reserved for future use by iProcess Engine.

Note 

For more information about connecting to databases, see the appropriate iProcess Engine installation guide.

Changing Database Connection Passwords

If you need to change the passwords that the iProcess Engine database schema owner or iProcess Engine database user use to connect to the database, follow this procedure:

1. Log in to iProcess Engine as an Administrator.
2. Stop iProcess Engine.
3. Enter the following command: 
SWDIR\util\swconfig -u

The following prompt is displayed:

=================================================================
TIBCO(R) iProcess Suite  - Configuration Utility 
Copyright (c) 2001-2012, TIBCO Software Inc.
=================================================================
Please enter a new Background User Password, ('Q' to quit)
4. Enter the new password for the iProcess Engine database schema owner (the login/account defined in position 4 of line 9 of the staffpms file).

The following prompt is displayed.

Please enter a new Foreground User Password, ('Q' to quit) :
5. Enter the new password for the iProcess Engine database user (the login/account defined in position 3 of line 9 of the staffpms file).

The swconfig utility terminates and displays the following message.

Now log onto the Database and change the passwords
6. Change the corresponding passwords for these users in the database (for Oracle or SQL Server) or UNIX (for DB2). See your database/UNIX documentation for more information about how to do this.
7. Restart iProcess Engine.