Create an Archive Database Business End Point

To create an archive database service endpoint:

1. In the left pane of Process Administrator, select Service Endpoints.

2. On the Service Endpoints page, click Add.

3. On the Service Endpoints | Add Service Endpoint page, enter a Name for the archive database, such as ArchiveDB.

4. For the Type, select SQL Database.

5. For the Subtype, select the appropriate database type.

6. Click Next.

7. On the Service Endpoints | Add Service Endpoint | Edit Service Endpoint  'service endpoint name' page, enter the Properties for the archive database service endpoint.

8. On the Service Endpoints | Add Service Endpoint | Edit Service Endpoint  'service endpoint name' page, configure the following Runtime options for the process execution engine or accept the defaults:

1. Maximum Pool Size - Enter the maximum number of connections that the pool can allocate. The pool will never create more connections than this limit imposes. The default is 10.

2. Connection Idle Time (Mins) - Enter the amount of time the database connection can remain idle before the connection will be dropped. The default is 5 minutes.

3. Maximum Opened Cursors - Enter the maximum number of opened cursors allowed on the database. The default is 50. This value is related to the maximum pool size. The number of cursors is divided in between the number of maximum pool size and each connection will manage that number of cursors. For example, if you have 500 maximum opened cursors and the maximum pool size is 50, each connection can have a maximum of 10 opened cursors.

9. Click Save.

Related Topics:

• Before Using the Archive Viewer

• Set the Process Execution Engine to Archive Processes