Settings for SAP BW Connection

Use this dialog to connect to SAP BW.

Note:

The SAP BW connector supports both a BAPI and and an ODBO driver. In the title of this dialog, appended inside parentheses, you can see information about which type of driver (either BAPI or ODBO) that the SAP BW connector is using.

Table 1.
Option	Description
Connection type	Select the type of SAP BW connection you want to create. Application server Connect directly to an SAP BW application server. Group/server selection Connect to the data source using a logon group, via a message server.
Application server	[Only available for connection type 'Application server'.] The name of the server where your data is located. The server can be identified in the following ways: By IP address. For example: 192.0.2.1 By IP address, but including a SAProuter string. For example: /H/198.51.100.1/S/3299/H/203.0.113.1/H/CPCB701 By name in the domain. For example: my-sap-bw.mycompany.com
Message server	[Only available for connection type 'Group/Server selection'.] The name of the message server in the SAP BW system you want to connect to.
Group/Server	[Only available for connection type 'Group/Server selection'.] The name of the SAP logon group.
Client	The SAP BW client number.
System number	[Only available for connection type 'Application server'.] The SAP BW system number.
System ID	[Only available for connection type 'Group/Server selection'.] The SAP BW system ID.
SNC partner name	The Secure Network Communication (SNC) partner name which is required when using single sign-on.
Language	Use this field to specify the language used in your data. Refer to official SAP documentation for a complete list of supported language codes.
Authentication method	The authentication method to use when logging into the database. Choose from Windows authentication and SAP BW authentication. Windows authentication When using Windows authentication the access token of the logged in user will be used. Users that have been given the appropriate access rights to SAP BW will be able to connect and read data. For more information about using single sign-on with the SAP BW connector, see Single Sign-On with the Spotfire® SAP Business Warehouse Connector on the Community. Domain credentials are not stored in the analysis file. SAP BW authentication Authenticate using a database user. Users who open the connection, or an analysis using the connection, will be prompted to enter database credentials to connect to the data source. Note: You can save database credentials, unencrypted, as part of an analysis file, using a setting in the Data Source Settings dialog. If credentials are embedded in your analysis, it means that users will not be prompted to enter credentials to connect to the data source. Note that it can be a security risk to embed database credentials in an analysis file.
Username	The username you wish to use when logging into the SAP BW cube or query.
Password	The password for the specified username.
Connect	Connects you to the specified server and populates the lists of available catalogs and cubes below.
Catalog	Select the catalog of interest from the drop-down list. You can choose among (All cubes) and cubes containing BEx queries.
Cube or query	Select the cube or BEx query of interest from the drop-down list. If the catalog selected is (All cubes), only cube names are shown here; if the catalog selected is a cube, only its BEx queries and the cube itself will be included here. If a name is preceded by a dollar sign ($) in the drop-down list, it is a cube, otherwise it is a BEx query.

Table 2.
Option	Description
Operation timeout (minutes)	Specifies the maximum time, in minutes, allowed for a command to be executed.