Integrating with Other Products › CA Business Service Insight Integration › View CA BSI Information in CA SDM › Import the Service Level Reports into CA BSI

Previous Topic: View CA BSI Information in CA SDM

Next Topic: Create the CA BSI MDR

Import the Service Level Reports into CA BSI

CA BSI provides the Service Level Compliance report by default. The BSI Service tab appears on CI detail pages in CA SDM and displays Exceeds and Violations counts. You import the Modified Service Level by Metrics vs Target and Modified Service Level by Contract vs Target reports into CA BSI.

Follow these steps:

  1. Copy the $NX_ROOT/samples/BSI/bsireports.sql file to the CA BSI database server.

    This Oracle script contains the report definitions that are required for the integration between CA BSI and CA SDM.

  2. Connect to the CA BSI Oracle instance with a user that has the SYSDBA role, or connect as the database owner.

    Important! This user must have update rights to the database. Confirm if you have these privileges with your Oracle Database Administrator.

  3. Execute the bsireports.sql script and verify that no errors occur.

    The reports are available for the CA SDM integration.