Import Data Connection to an SAP BW or SAP BW/4HANA System

How to create a connection that allows you to import models from an SAP Business Warehouse (BW) system.

Prerequisites

  • You are connecting to an SAP BW system, version 7.3x or higher, an SAP BW/4HANA 1.0 system, SP4 or higher, or an SAP BW/4HANA 2.0 system, SP0 or higher.
  • You have completed ONE of the following setup options:
  • You've assigned the required SAP BW authorizations.

    R/3 Role Maintenance - PFCG

    • Select role (or create a new one)
    • Authorizations tab - Display/Change Authorization Data
    • The following authorizations are needed for BW connections. The first table summarizes the RFC authorizations, while the second table focuses on the R/3 authorization objects required for BW.
    Authorization Object Activity Name of RFC Object Type of RFC Object Comments
    S_RFC Execute
    RFCPING
    Function Module
    • Required for creating a connection - Function module RFCPING is called to verify that the connection exists.
    • Error message: Proper error message is shown.
    S_RFC Execute
    BICS_CONS_SET_GET_SESSION_PROP
    DDIF_FIELDINFO_GET
    RFC_GET_FUNCTION_INTERFACE
    RSBOLAP_BICS_STATISTIC_INFO
    RSOBJS_GET_NODES
    RSOBJS_GET_SUPPORTED_TYPES RSOBJS_INIT
    Function Module
    • Required for searching queries.
    • An empty list is returned when the user is not authorized to access these function modules.
    • Error message: No error message is shown.
    S_RFC Execute
    RSBOLAP_BICS_PROVIDER
    RSBOLAP_BICS_PROVIDER_VAR
    Function Group
    • Required for executing a query/reading the metadata and data.
    Authorization Object Authorizations Value Comments
    S_RS_AUTH
    BIAUTH
    MU_BW_3
    • Name of the BW authorization object defined in transaction RSECADMIN.
    • Required for executing the query/reading the data.
    • Not required for searching the queries.
    S_RS_COMP
    ACTVT
    RSINFOAREA
    RSINFOCUBE
    RSZCOMPID
    RSZCOMPTP
    Display,Execute
    BUSINESSOBJECTS_QA
    Z_BOBJ
    QRY_VAR_H_MDT_HNM_MDT
    Query
    • Activity Display is required for searching the BW objects.
    • Activities Display and Execute are required for executing a query/reading query data - Restriction to specific info areas, cubes, or queries possible. Example: only query QRY_VAR_H_MDT_HNM_MDT on cube Z_SAP is visible.
    S_RS_COMP1
    ACTVT
    RSZCOMPID
    RSZCOMPTP
    RSZOWNER
    Display, Execute
    QRY_VAR_H_MDT_HNM_MDT
    Query
    *
    • Activity Display is required for searching for BW objects.
    • Activities Display and Execute are required for executing a query/reading the query data - Restriction to specific queries and/or owners possible.

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source dialog will appear.
  2. Expand Acquire Data and select SAP BW.
  3. In the New BW Connection dialog, enter the following information:
    1. In the Connection Information section, add a Connection Name and Description.
    2. In the Data Source Configuration section, select the Location of your Cloud Connector from the list.
    3. Enter the Application Server, System Number, Client ID, and Language.
    4. Enter the User ID and the Password for your SAP BW system.
      Note
      If you want to share the credential details, select the option Share these credentials when sharing this connection. Otherwise, users will need to enter their own credentials in order to use the connection. If you don't share your credentials, users will be able to edit their credentials at any time without having to start a data acquisition process.
    Note

    Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories.

    Note

    To export data back to an SAP BW or SAP BW/4HANA System, see the OData Services procedure in Export Models and Data.

  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.