In this section: |
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.
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.
You can configure the adapter from either the Web Console or the Data Management Console.
or
From the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add Adapter to Configuration pane opens.
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.
Name of the connection; maximum 12 characters.
Connection Parameters
The Load Balancing check box determines which of the following options is exposed.
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.
Host name of the SAP system (message server).
Appears only when Load Balancing is checked.
System ID of the SAP system.
Appears only when Load Balancing is checked.
Host name of the SAP application server.
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.
SAP system number. This is a 2-digit numeric value. Obtain this value from the SAP Administrator.
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:
SAP Security Mode
When SNC is checked, you must specify values for the following additional parameters:
SNC_LIB contains the path to the external security product library. The external security product 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
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
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
There are three methods by which a user can be authenticated when connecting to an SAP BW instance:
SAP BW Client for the user logon; maximum three characters.
SAP BW user ID for the user logon.
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.
To configure the adapter on IBM systems using the EBCIDC character set, the following code pages must be installed on the BW application server:
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.
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.
iWay Software |