MicroStrategy ONE

Connect to SAP BW from Web or Workstation

Learn how to connect to SAP BW via the Data Source dialog and handle your connection.

Upon successful connection, you can begin importing data.

How to Authenticate

The SAP BW connector does not support live connect mode.

  1. In MicroStrategy Web, click the Create button > Add External Data.

    In MicroStrategy Workstation, click Create a new dataset and choose a project.

  1. Select the SAP BW connector.

  2. Next to Data Sources, click New Data Source to add a new connection.

  3. Enter your connection credentials in the Data Source dialog.

    • Data Source Name:A unique connection name is required.

      If you enter an existing name, the following error is returned: The database connection name already exists.

    • SAP Gateway URL: The Service URL for the ODATA service.

      For details on URL formats supported by the connector, see URL Handling.

    • Username: The username of a valid user account in SAP BW.

    • Password: The password of a valid user account in SAP BW.

      To create credentials for SAP BW, refer to the SAP Help Portal.

  4. Click Save.

Data Source Handling

Administrators can delete database connections created via MicroStrategy Web by going to Developer Administration > Configuration Managers > Database instances.

  1. Under Data Sources, hover over your connection and click the more icon .

  2. Select one of the following options:

    • Edit: Modify the fields in the Data Source dialog.
    • Delete: Remove your connection from Data Sources.
    • Rename: Rename your connection.

    • Share: Share your connection and grant controlled access to other users.

    • Duplicate: Create a duplicate connection.

      By default, the duplicated connection's name begins with Copy of , followed by the original connection name. You can rename the duplicated connection.

      The duplicated connection is populated with the hardcoded string, PWDHIDDEN123!@#, for security reasons. Clicking on the connection, without changing the password, returns the following error message: Your credentials and/or authentication mode are incorrect.

Once a connection is established, you can get started with the data importing process.