Show TOC

Object documentationCreating and Changing Data Sources Locate this document in the navigation structure

 

A data source is a set of fields that provides the information for Continuous Monitoring. From a technical viewpoint, the data source is a set of logically-related fields that retrieve a flat structure from a system, such as an ERP system, that is monitored.

 

Data sources supply the metadata description of source data. They extract the data description (including name, type, and a source path from a source system). They are the foundation to create a Continuous Monitoring business rule.

  • Data source — records what is monitored, and where and how to load the information.

  • Business rule — contains information about how to filter the data and detect deficiencies.

The subscenarios of the data source are the following:

  • ABAP Report

  • SoD Integration

  • BW Query

  • Configurable

  • Event

  • External Partner

  • Process Integration

  • Programmed

  • SAP Query

  • HANA

Integration

To perform this function, you must be assigned to the Data Source Specialist role. Different subscenarios require different prerequisites.

Subscenario

Create and Register Connection

Other Prerequisites

ABAP Report

X

Qualified and Register reports by transaction code /n/GRCPI/OVERVIEW in ERP system

SoD Integration

No connector required.

SAP Access Control has been activated

BW Query

X

The BW query exists with the following rules:

  • The BI characteristics must be arranged in rows area.

  • The BI key figure must be arranged in columns area.

  • Only Single Value and Selection Option Filters are supported.

  • Filter has to be set to optional.

  • There are no aggregation rows in the query output.

Configurable

X

GRC plug-in (RTA) is installed on the ERP system.

Note Note

SAP ERP 4.6 C and below are not supported. These connectors are not shown in the list.

End of the note.

Event

No connector required. You are receiving the event from another system.

Define the event definition in the Customizing activities.

External Partner

X

For external partners who implement Web service based on Web Service Definition Language (WDSL) provided by SAP. Create a logical port.

Process Integration

No connector required

Process Integration development is done. The proxy must contain both import and export parameter.

Programmed

X

GRC10.0 plug-in is installed in ERP

SAP Query

X

SAP query (not implemented by logical database). Use transaction code SQ01 to choose a valid query.

HANA

X

HANA DB is ready. The connection between GRC system to HANA DB need to be established. See SAP Note 1597627 for details. This subscenario can only consume Calculation View stored in HANA DB. These views should be prepared already.

  1. Choose   Rule Setup   Continuous Monitoring   Data Sources  . The Data Source List screen displays.

  2. Choose one of the following options:

    • Create — Use this option to create a data source.

    • Open — Use this option to view or edit an existing data source. You cannot change a data source that a business rule is using.

    • Delete — Use this option to delimit a data source. You cannot delete a data source a business rule is using.

    • Copy — Use this option to copy an existing data source and change it.

  3. On the General tab, enter or edit the parameters as shown in the following table:

    Parameter

    Instructions

    Data Source (required)

    Name the data source.

    Description

    Enter the description or purpose of the data source.

    Valid From (required)

    Enter the start date for the validity period of the data source.

    Valid To (required)

    Enter the end date for the validity period of the data source.

    Note Note

    The Valid To date must be later than the Valid From date.

    End of the note.

    Status

    Select the data source status from the dropdown menu. You can select one of the following options:

    • New – The data source is a draft. From this status, you can only change it to In Review.

    • In Review – The data source is in review. From this status, you can only change it to Active.

    • Active - Once a data source is Active, you can assign it to a business rule. You can set the status to In Review to make any changes. From this status, you can change it to Inactive or In Review.

    • Inactive - The data source is no longer in use. From this status, you can only change it to In Review.

    Note Note

    A data source must be Active before you can assign a business rule to it.

    End of the note.

    Search Term

    Enter a term to search for a data source.

    Example Example

    You can search for data sources that are classified with search terms, such as SOX or FDA.

    End of the example.

  4. On the Object fields tab, enter or edit the parameters as shown below:

    Parameter

    Instructions

    Subscenario

    Name the subscenario and connection type of the data source. The connection type is automatically entered if there is only one connection type.

    Parameters

    Different subscenarios contain different parameters. The parameters search for the specific query, tables, or proxy.

    Fields

    List the fields of the data source, such as their type, amount or quantity, description, and so on. You can change the field descriptions to make them more useful for your business needs.

  5. On the Connector tab, maintain additional connectors. By default, the main connector retrieves the backend metadata such as query fields and field descriptions.

    Note Note

    On the Ad Hoc Query tab (only applicable to the Configurable subscenario), you ensure the tables and joins used retrieve the expected data.

    End of the note.

  6. On the Attachments and Links tab, attach a file or link to the rule.

  7. Select Save. The system displays a message to confirm that all data was saved.