Integrating Data With BSM Connector > Database Policies > How to Collect Event Data from Databases

How to Collect Event Data from Databases

This task describes how to collect event data from databases.

  1. Prerequisite: Make sure the following applies:

    1. Your BSM Connector is configured to work with OMi by using the bsmc-conf tool.

    2. The certificate request is approved on the OMi side.

    3. Your BSM Connector is set up as a connected server in OMi.

  2. In the BSM Connector user interface, click Create in the toolbar. Then click Event > DDatabase Database.

    Alternatively, double-click an existing policy to edit it.

  3. In the Properties page, define information that is related to the policy itself (for example, the name and description of the policy).

    For details, see Configuring Database Policy Properties.

  4. In the Source page, define the connection to the database and the columns that the policy accesses.

    For details, see Configuring the Data Source in Database Policies.

  5. In the Mappings page, configure the default mappings of table columns to custom variables.

    For details, see Configuring Mappings in Database Policies (Events and Metrics Only).

  6. Optional. In the Defaults page, configure the default settings for all events generated by the policy (for example, default event correlation settings).

    For details, see Configuring Event Defaults in Database Policies.

  7. In the Rules page, define what the policy should do in response to a specific type of event.

    For details, see Configuring Event Rules in Database Policies.

  8. In the Options page, configure several policy behaviors (for example, pattern matching options).

    For details, see Configuring Options in Database Policies.

  9. Click Save and Close to save the policy and close the editor.

  10. Optional. If the list of policies does not refresh automatically in the BSM Connector user interface, click Refresh in the toolbar.