In this section: |
Configuring the Adapter for SAP consists of specifying connection and authentication information for each of the connections you want to establish.
In addition, you must install SAP components and, for SAP running on z/OS, you must install the SAP Code Page on the SAP server.
Custom adapter configuration for accessing SAP BW Master Data tables. Many organizations require analysis of Master Data in conjunction with Transactional Data in SAP BW.
Since this complex analysis is predicated upon access to the Master Data, you must be able to make the Master Data tables accessible within the SAP BW environment. You can accomplish this by completing a simple configuration procedure using the table-based Adapter for SAP ECC. For details, see How to Configure the Adapter for SAP ECC to Enable Access to SAP BW Master Data Tables.
How to:
Reference: |
In order to connect to the SAP 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 the Web or Data Management console. The command is added to the profile you select: the global server profile (edasprof.prf), a user profile (user.prf), or a group profile (if supported on your platform). The global profile, edasprof.prf, is the default.
After configuring the adapter, you must install the static function modules in the SAP data dictionary to complete the configuration. For details, see How to Install SAP Components.
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 adapter is under the ERP group folder.
The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.
User Authentication Parameters
The major work of the adapter is to translate user requests into code that can be understood by SAP. For this purpose, an SAP user ID, with a given set of privileges, is required. In the following list, this user ID is referred to as IBI_USER.
Name of the connection; maximum 12 characters.
Package Parameters
Function group where the Adapter for SAP static function modules can be cataloged. This is the function group created in Preparing the SAP Environment.
Reserved for Information Builders use.
Reserved for Information Builders use.
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. SAP 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 two-digit numeric value. Obtain this value from the SAP Administrator.
For SAP ECC 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 ECC non Unicode to Configuration pane, select the language you wish to use to connect to SAP ECC.
Note:
Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.
If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).
Store the connection attributes in the server profile (edasprof).
General User Login Parameters
There are two methods by which a user can be authenticated when connecting to a database server:
SAP Client for the user logon, maximum 3 characters.
SAP user ID for the user logon.
SAP password for the user logon, maximum 8 characters.
Select the following check boxes, as required to:
SNC 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'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
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
Indicates the level of protection.
Indicates the SNC name of the initiator, as in own_snc_name.
Note about 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
Parameters for Mixed Character Code Sets
The following section applies only when the server platform and the SAP instance platform do not use the same character code set (ASCII or EBCDIC).
To configure the adapter on IBM systems using the EBCIDC character set, the following code pages must be installed on the SAP 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 and export the variables SAP_CODEPAGE and PATH_TO_CODEPAGE.
Prerequisite: The Adapters for SAP ECC and SAP BW must be installed. In addition, the Adapter for SAP BW must be properly configured and the Adapter for SAP ECC must be available for configuration as described below.
Tip: If the Adapter for SAP ECC has already been configured and appears in the list of Adapters in the navigation pane, and you can customize the configuration by clicking the current system connection and choosing Properties. The Change Connection Parameters pane opens, displaying the same parameters you would see on the Add to Configuration pane.
Enter a descriptive name of up to 12 characters to specify the connection to the SAP BW system.
Enter the host name of the server on the SAP BW system.
Important: This value, along with those for GWHOST and SYSNR, must match the corresponding values on the SAP GUI under System Entry Properties for SAP BW.
Enter the host name of the server where the SAP gateway process is running (in this case, the SAP BW system).
Generally, the entries for HOST and GWHOST are identical.
SAP system number. This is a two-digit numeric value.
In this case, the TABLE will be an SAP BW Master Data Table, made accessible and usable by your entries in step 3.
When prompted, enter the name of an SAP BW Master Data table, or select one from the list of tables, and click Create Synonym.
How to: |
The SET AUTODISCONNECT command controls the persistence of connections when using the adapter for each of the connections you want to establish. This setting enables you to control when the rfc api communications layer will be closed.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
ENGINE SQLSAP SET AUTODISCONNECT ON {FIN|COMMAND|COMMIT}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Disconnects automatically only after the session has been terminated. FIN is the default value.
Disconnects automatically after each request. Depending on how often the event occurs, the SET AUTODISCONNECT command may result in considerable overhead. Almost all of this overhead is not related to the server. It is related to the operating system and the data source.
Disconnects automatically only after COMMIT or ROLLBACK is issued as a native SQL command.
How to: |
The AUTOCOMMIT command controls when a COMMIT request is sent to SAP ECC.
Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.
ENGINE SQLSAP SET AUTOCOMMIT ON {FIN|COMMAND}
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Sends the COMMIT request to SAP only after the session has been terminated.
Sends a COMMIT request to SAP each time the command is issued. COMMAND is the default value.
How to: |
After declaring connection attributes for SAP, to complete the configuration you must install and verify the SAP components.
To install SAP components:
The Change SAP System Connect Parameters pane opens. The Install SAP Components button is located at the bottom of the pane.
If no error occurred, leave this box unchecked and proceed to step 6.
A list of the function modules that have been installed is displayed.
To confirm that all necessary function modules have been successfully installed, as described in How to Install SAP Components, complete the following steps:
Folders named Function Modules and Includes should be under the Function Group name.
ZIBI_REP_CREATE ZIBI_REP_GET_B_D ZIBI_REP_ABORT_B ZIBI_REP_DELETE ZIBI_REP_RUN ZIBI_TEST_REVERSE ZIBI_DYNAMIC_RUN ZIBI_GET_APPL_TREE ZIBI_LDB_GET ZIBI_SE80 ZIBI_REP_RUN_IN_B ZIBI_REP_GET_B_S ZIBI_DXOBJ_INFO ZIBI_DD_FKEYS_GET
Note: Z*** represents the name of the Function Group. If the Development Class and Function Group name is ZIBI, then the Function Module name begins with ZIBI.
WebFOCUS |