Creating SAP BW Database Connections

Before beginning, you must know the host name of your server or IP address, router string, client number, system number, language, catalogue, and cube, and have log on credentials.

  To create a document using the document creation wizard:

  1. Perform one:

    • Select File, then New, then Database Connection, then SAP BW

    • Click New icon, and select Database Connection, then SAP BW.

      The Process bar is displayed the steps for creating an SAP BW database connection: Server, and Database. The content area displays the Server page.

  2. In SAP BW Server, enter the host name or IP address of the server.

  3. In Router String, enter the SAP BW server router string.

  4. Enter a user ID, password, client number, system number, and language.

    The current user ID and password are entered, in case known server credentials are used.

  5. Optional: To save these credentials, select Save User ID and Password.

  6. Click Next.

    Clicking Next queries the data source for catalogue and cube information. The content area displays the Database page.

  7. From Available Databases, select a cube.

    Cubes are listed by catalogue. When you select the cube, the catalogue and cube name are loaded into the text area on the left.

    To search for an InfoProvider:

    1. Under Enter search criteria, enter the criteria by which to search.

    2. Under Search by label, select whether to search for the InfoProvider based on the technical name, the description, or both.

    3. Click Search.

    4. Based on the search criteria entered, Web Analysis displays the technical name of the InfoProvider, the description of the InfoProvider, or both under Available Databases.

  8. Select Finish.