KNOWLEDGE BASE

SAP BW Connection is Blank or is Missing Expected Connection Entries


Published: 21 Jul 2015
Last Modified Date: 20 Jun 2017

Issue

When connecting to SAP BW from Tableau Desktop, connection entries present in the saplogon.ini file do not display or are missing in the SAP BW connection dialog box in Tableau Desktop.

Environment

  • Tableau Desktop
  • SAP NetWeaver Business Warehouse

Resolution

Option 1

This issue can occur when Tableau is unable to determine the correct location of the saplogon.ini file. To resolve this issue, add or verify a system environment variable on the machine running Tableau called SAPLOGON_INI_FILE that points to the correct location of the file. Alternatively, you can copy the saplogon.ini file to the C:\Windows directory.

Option 2

Review the formatting of the saplogon.ini file. Under the [Description] section, check for blank/missing entries. Remove any blank entries (ie: 'Item1=') and ensure that the remaining Item entries are numerically sequential, renaming the connections to start at 'Item1' (ie, 'Item1=SAP BW Development System').

Option 3

For older versions of the product, upgrade to Tableau Desktop 9.0.4. For more information, see Upgrade Tableau Desktop

Cause

Tableau Desktop stops importing the SAP BW connection entries upon hitting the blank entry. This can result in either blank or incomplete SAP BW connection information in Tableau Desktop.
Did this article resolve the issue?