Adding an Archive External Resource

To enable archiving, you must add an External Resource which references the archive database.

1. In the Navigator pane, click External Resources ().

   The External Resources pane will appear. Any existing external resources will be listed.

2. On the External Resources pane, click Add.

   The Add External Resource pane will appear.

3. Enter a name for the archive database external resource, such as "ALBPMArchive", in the Name field.
4. Select SQL Database in the Type drop-down list.
5. In the Subtype drop-down list, select the database driver appropriate for your database. When configuring an external resource for archiving, you may only choose one of the following database drivers:
   
   • BEA's DB2 Driver Versions: 8.x, 9.x
   • BEA's MS SQL Server Driver Versions: 2005
   • BEA's Oracle Driver Versions: 9.2, 10
6. Click Next. The Edit External Resource pane appears.
7. Specify the database properties in the Properties section. Most properties are common to all the supported databases, but some are database specific. The following table describes each property:

   Property Name	Description
   Host	Name or IP address of the host (real or virtual machine), where the database resides.
   Port	Port number to connect to the database.
   Schema	Enter the name of the database schema, for example, you could name the Data Mart database schema ALBPMDataMart. Required for IBM DB2 and Oracle.
   Database	Enter the name of the database, for example, you could name the Data Mart database ALBPMDataMart. Required for Microsoft SQL Server. Optional for Oracle.
   SID	System Identifier. Required for Oracle only.
   User	Enter a user name to be used by the updater service to connect to the database.
   Password	Password for the user described above.

   If you are setting properties to connect to an Oracle data base, an Advanced section appears. In this section, you can specify the Tablespace, Temporary Tablespace, and Profile properties.
8. Click Save.