Connecting to SAP BW servers - Microstrategy

This section discusses how to connect to SAP BW servers in the Windows and the Unix environment.

Windows

Important note from SAP:

Starting with JCo 2.1.4 and JCo 2.0.11, you are required to install the new Visual Studio .NET C/C++ run-time libraries on Windows platforms. Please see SAP Note 684106 for details on how to install them.

Take the following steps to connect to SAP BW servers in Windows:

  1. Open the SAP Service Marketplace and download the SAP Java Connector.

    Note the following:

    • The SAP Java Connector can be downloaded from SAP Service Marketplace
    • MicroStrategy certifies version 2.1.3 and supports more recent versions
  2. Install the Java Connector.
  3. Place the following files in a directory that is indicated in the Path environment variable:
    • Librfc32.dll
    • Sapjcorfc.dll
  4. Place the Sapjco.jar in the Common Files MicroStrategy folder, for example, C:Program filesCommon filesMicroStrategy.
  5. Create a database instance that points to SAP BW by selecting SAP BW as the Warehouse Type and providing the following information as required:
    • Application Server: name of the SAP BW Server or IP address
    • SAP Router String, if you use an SAP Router
    • System Number from the SAP BW system
    • Client Number from the SAP BW system
    • Language: the language code provided by your SAP administrator, for example, EN for English.

Note the following:

  • You may get the above information from your SAP Logon.
  • Create a database login with the user and password that you want to use to connect to SAP BW.

UNIX

Take the following steps to connect to SAP BW servers in Unix:

  1. Open the SAP Service Marketplace and download the SAP Java Connector.

    Note the following:

    • The SAP Java Connector can be downloaded from SAP Service Marketplace:
    • MicroStrategy certifies version 2.1.3 and supports more recent versions.
  2. Select the zip file for the platform you want to use and unzip it, for example, gunzip or gzip [file name].
  3. Search for the files listed in the following table, copy them onto your machine, and create a new directory for them. For example,
    • for AIX: /home/dsmith/SAP/AIX
    • for SUN: /home/dsmith/SAP/SUN
  4. UNIX
  5. Edit the SAP.sh file in the installation directory.../env/SAP.sh by doing the following:
    1. Add the Write and Execute privileges to this file. The default is Read Only. You can type in the command “chmod+wx file name” in the Unix console.
    2. Open the SAP.sh file and enter the information for XXXX_SAP_LIBRARY_PATH=’’. This information indicates where the server needs to point in order to use the downloaded files.

      For example, for AIX:

    3. Save the file.
  6. Add sapjco.jar to the installation directory:/install/jar.Make sure that you have the Write privilege to this directory.
  7. Restart the server to get the latest updates.
  8. Create a database instance pointing to the SAP BW server of your choice, providing the following information, as required:
    • Application Server: name of the SAP BW Server or IP address
    • SAP Router String, if you use an SAP Router
    • System Number from the SAP BW system
    • Client Number from the SAP BW system
    • Language: the language code provided by your SAP administrator, for example, EN for English.

You can use either the Database Instances Editor or the Database Instance Wizard to create a database instance for SAP BW.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microstrategy Topics