Administer > Policies > 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 Operations 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 Operations Connector is set up as a connected server in OMi.

  2. In the Operations 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 Policy Properties topic.

  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 topic.

  5. In the Mappings page, configure the default mappings of input data properties to custom fields.

    For details, see Configuring Mappings in Policies topic.

  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 Operations Connector user interface, click Refresh in the toolbar.

Related topics

Configuring Database Policy Properties

Configuring Database Policy Properties

Configuring Mappings in Database Policies (Events and Metrics Only)