Configuring the Adapter for SAP BW

In this section:

x

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.


Top of page

x
Declaring Connection Attributes

How to:

Reference:

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 Web Console or the Data Management Console. 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.



x
Procedure: How to Declare Connection Attributes

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console menu bar, click Adapters.

    or

    From the Data Management Console, expand the Adapters folder.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. 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 connection attributes reference.
  6. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.


x
Reference: 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 check box 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 iWay server must match the codepage of the SAP BW server. For example, if the iWay 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 iWay 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 How to Configure the Adapter on IBM Systems Using EBCIDC Character Sets.



x
Procedure: How to 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:

  1. Create two conversion tables as described in 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.


WebFOCUS