MicroStrategy ONE

Connect to SAP ECC from Web or Workstation

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

Upon successful connection, you can begin importing data.

How to Authenticate

The SAP ECC 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 ECC connector.

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

    The Data Source dialog appears when there are no new database roles or connections.

  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 ECC.

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

  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.

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

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

  3. Click on the newly created connection and select from any of the displayed tables.

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