Adding the BAM or Data Mart Database External Resource

To configure a BAM or Data Mart, you must first add the corresponding database external resource.

To add the BAM or Data Mart database external resource:

  1. In the navigator, click External Resources ().
  2. In the External Resources pane, click on the Add button. The Add External Resource pane will appear.
  3. In the Name field, enter a name for the data mart database, such as ALBPMDataMart.
  4. In the Type drop-down list, select SQL Database.
  5. In the Subtype drop-down list, select the database driver appropriate for your database. When configuring an external resource for BAM and Data Mart data, 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. Review all fields and click Next. The Edit External Resource pane will appear.
  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. Set runtime and connection pool properties in their respective sections. Unless you have a specific requirement, you can leave the defaults.
  9. If you must specify any additional connection properties, click Add and enter the property name and value. To remove an unneeded property, select the property's checkbox and click Delete.
  10. Click Save. The external resource is created.

You have added the external resource, but this step only makes ALBPM aware of the database properties. It does not create the database. You must create the database in a separate step. See Creating the BAM or Data Mart Database.

Parent topic: BAM and Data Mart Configuration