Details on SAP BW Connection

Note: The SAP BW Data Connector is not included in the general Spotfire Professional distribution and needs to be deployed separately on the server.

This dialog is used to set up a connection to a SAP BW cube or BEx query, where you can analyze data from the cube or query without bringing it into your analysis. Note that the 32 bit SAP BW ODBO provider (included in SAP GUI for Windows) and for 64 bit machines also the 64 bit SAP BW OLE DB for OLAP provider (standalone installation package) must be installed on the machine running the SAP BW connector. See the system requirements at http://support.spotfire.com/sr.asp for details.

Note: The 32 bit SAP BW OLE DB for OLAP provider must be installed before the 64 bit driver is installed, for 64 bit machines.

To add a new SAP BW connection to the library:

Select Tools > Manage Data Connections.
Click Add New > Data Connection and select SAP BW.

To add a new SAP BW connection to an analysis:

Select File > Add Data Tables....
Click Add.
Select Connection To > SAP BW.

Option	Description
Server	The name of the server where your data is located. The server can be identified either 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) or by name in the domain (for example, my-sap-bw.mycompany.com).
Client	The SAP BW client number.
System number	The SAP BW system number.
SNC partner name	The Secure Network Communication (SNC) partner name which is required when using single sign-on.
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, e.g., Kerberos, 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. Domain credentials are not stored in the analysis file. SAP BW authentication With database authentication the authentication is done using a database user. Database credentials can be stored, unencrypted, as part of the analysis file, using a setting in the Data Source Settings dialog. If credentials are found in the analysis file they will be used to automatically authenticate against the database. If no credentials or credentials profiles are found in the analysis file all who open the file will be prompted for database credentials. Note that there will be no prompting for credentials if the credentials embedded in the analysis file fail.
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. Note: BEx queries with variables are not supported and will not show up in the list.