Configuring the Adapter for SAP BW

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.

In addition, for SAP BW running on z/OS, you must install the SAP Code Page on the BW application server.

Declaring Connection Attributes

In order to connect to the SAP BW Application Server, the adapter requires connection and authentication information, which is supplied using the SET CONNECTION_ATTRIBUTES command.

You can enter connection and authentication information on the Configuration pane of either the WebFOCUS Reporting Server browser interface or ibi Data Migrator desktop interface. The global server profile (edasprof.prf), a user profile (user.prf), or a group profile will be updated with the adapter connection attributes.

You can declare connections to more than one SAP BW data source by including multiple connections. The actual connection to SAP BW takes place when the first query that references the connection is issued. If more than one connection is declared, the adapter uses the attributes specified in the last connection.

Configuring an Adapter

    Procedure
  1. From the WebFOCUS Reporting Server browser interface Applications page, click Get Data.

    or

    From the ibi Data Migrator desktop interface, expand the Adapters folder.

    In the WebFOCUS Reporting Server browser interface, the Get Data page opens showing your configured adapters. In the ibi Data Migrator desktop interface, the Adapters folder opens.

  2. In the WebFOCUS Reporting Server browser interface, click the (+) button, and find the adapter on the page or, in the ibi Data Migrator desktop interface, exapnd the Available folder if it is not already expanded.

    In the WebFOCUS Reporting Server browser interface, you can select a category of adapter from the drop-down list or use the search option (magnifying glass) to search for specific characters.

  3. In the ibi Data Migrator desktop interface, expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the chapter for the specific adapter you want to configure.
  6. Click Configure. The configured adapter is added to the Configured list in the WebFOCUS Reporting Server browser interface or in the Adapters list in the ibi Data Migrator desktop interface resources tree.

    In the WebFOCUS Reporting Server browser interface, the adapter remains on the Available Adapters list with an asterisk to indicate that at least one connection has been configured. You can configure additional connections from either the Configured or Available list by right-clicking the adapter and clicking Add Connection.

Connection Attributes for SAP BW

The SAP BW adapter is under the OLAP group folder.

The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.

The major work of the query adapter is to translate the user request into code that can be understood by SAP BW.

System

Name of the connection; maximum 12 characters.

Connection Parameters

The Load Balancing checkbox determines which of the following options is exposed.

GROUP

Name of the application group. An application group defines a list of application servers on which an RFC application can be running. R/3 transaction SMLG can be used to view or modify application groups.

Note that the entries are case-sensitive and blank spaces are significant.

Appears only when Load Balancing is checked.

MSGHOST

Host name of the SAP system (message server).

Appears only when Load Balancing is checked.

R3NAME

System ID of the SAP system.

Appears only when Load Balancing is checked.

HOST

Host name of the SAP application server.

GWHOST

Host name of the machine where the SAP gateway process is running. In the case where there is only one SAP application server, gwhost and host is the same.

SYSNR

SAP system number. This is a 2-digit numeric value. Obtain this value from the SAP Administrator.

CONNECTION LANGUAGE

For SAP BW Unicode configurations, you can select a language that is different from the language you use when logging on to the server (as determined by your NLS configuration).

From the CONNECTION LANGUAGE drop-down list on the Add SAP BW non Unicode to Configuration pane, select the language you wish to use to connect to SAP BW.

Note:
  • When the CONNECTION LANGUAGE option is used to specify a language other than the one used for logging in to the server, the Create Synonym Multilanguage option is not available.
  • For this option to work, the codepage of the WebFOCUS Reporting Server must match the codepage of the SAP BW server. For example, if the WebFOCUS Reporting Server is configured FOR codepage 942 (SJIS), the SAP server must be configured for codepage 8000.
  • There is no way to check if the requested connection language can be used by either the WebFOCUS Reporting Server code page (either in terms of display or number of bytes) or the SAP BW server.

SAP Security Mode

When SNC is checked, you must specify values for the following additional parameters:

SNC_LIB

SNC_LIB contains the path to the external security product library. The external security product's library, external library, SNC_LIB, or gssapi library contains the functions provided by the external security product certified by SAP.

Set the environment variable SNC_LIB to contain the path to the security product library:

<drive>:\path\to\your\snclib.dll
SNC_ PARTNERNAME

Is the external name of the SAP system. This is an extended version of the external name called the SNC name. You create the SNC name by providing a prefix with the external user name that designates the name type entered as follows: 

<SNC-name_of_SAP_AppServer>

For example:

p/secude:CN=miller,
OU=ADMIN, O=SAP, C=DE
p/krb5:miller@WDF.SAP-AG.DE
SNC_QOP

Indicates the level of protection.

SNC_MYNAME

Indicates the SNC name of the initiator, as in own_snc_name.

Note: SNC with load-balancing. Load-balancing, or group-logon, dynamically retrieves the target SNC-Name from the message server. When using SNC with load balancing, you must specify the following additional parameters: 

SNC_PARTNERNAME=p:unused
SNC_LIB=<drive>:\path\to\your\snclib.dll

Click Configure.

The next step is adding a connection. Click Next to continue.

General User Login Parameters

Security

There are three methods by which a user can be authenticated when connecting to an SAP BW instance:

  • Explicit. The user ID and password are specified for each connection and passed to SAP BW for authentication and request execution. (When you select Explicit, the USER and PASSWORD options are displayed.)
  • Password Passthru. The user ID and password received from the client application are passed to SAP BW for authentication and to execute the user request.
  • Trusted. Is set automatically when SNC is selected.
CLIENT

SAP BW Client for the user logon; maximum three characters.

USER

SAP BW user ID for the user logon.

PASSWORD

SAP BW password for the user logon; maximum 40 characters.

For more information, see Preparing the SAP BW Environment.

Note: If the SAP BW system is running in a z/OS (USS) environment, see Configure the Adapter on IBM Systems Using EBCIDC Character Sets.

Configure the Adapter on IBM Systems Using EBCIDC Character Sets

To configure the adapter on IBM systems using the EBCIDC character set, the following code pages must be installed on the BW application server:

  • In a z/OS environment, SAP code page 0126.
  • For iSeries, SAP code page 0123.
    Procedure
  1. Create two conversion tables as described in SAP BW Adapter Supporting Mixed Code Page Environments, and transfer the tables to the $EDACONF/etc directory.

    For example, if the Server environment uses the code page 1100, then two conversion tables, 11000126.CDP and 01261100.CDP, should be created and transferred to the $EDACONF/etc directory.

  2. The following environment variables are required at run time: 
    export SAP_CODEPAGE=0126
export PATH_TO_CODEPAGE=$EDACONF/etc/
    Note: Make sure to include the trailing "/" for the value of the PATH_TO_CODEPAGE parameter.