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

How to Collect Generic Output Data from Databases

This task describes how to collect 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 Generic output > 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 input data properties to custom fields.

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

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

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