MicroStrategy ONE

SAP Datasphere

SAP Datasphere is a comprehensive data service and the next generation of SAP Data Warehouse Cloud. Starting in MicroStrategy ONE Update 11, you can use an ODBC connector to connect to SAP Datasphere as a data source and import data on Web and Workstation.

SAP Datasphere Prerequisites

Perform the following prerequisites in SAP Datasphere:

  • Add your IP address to the SAP Datasphere IP allowlist.
    • Go to System > Configuration > IP Allowlist
  • Configure your entities in Data Builder to enable Expose for Consumption.

  • Note your SAP Datasphere instance host name and log in information.
    • Go to Space Management > Your Namespace > Database Users

Connect in MicroStrategy

  • Workstation
  • Web
  1. Open the Workstation window.
  2. Connect to an environment.
  3. In the Navigation pane, click , next to Data Sources.
  4. Search and select SAP Datasphere in the data source list.
  5. In the Default Database Connection drop-down, click Add New Database Connection.

  6. Enter a Name, Server, and Default Database Login.

  7. Click Save.
  8. In the Add Data Source window, enter a Name, Database Version, and optionally choose Projects for further data manipulation.

  9. Click Save.
  10. In the Navigation pane, click , next to Datasets.
  11. Choose a Project and select Data Import Cube.

  12. Click OK.
  13. Find and select SAP Datasphere in the data source list.
  14. In the Select Import Options dialog, select Type Query or Build Query and click Next.
  15. Click the data source to connect to SAP Datasphere.

  16. Click Prepare Data or Finish.

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

  2. Find and select SAP Datasphere in the data source list.
  3. In the Select Import Options dialog, select Type Query or Build Query and click Next

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

  5. Enter values in the Connections window based on your connection type:
    1. DSN-less connection: Select DSN-less Data Sources and enter a Name, Server, User, and Password.

    2. DSN connection: Select DSN Data Sources and choose a DSN from the drop-down. Enter a Name, Server, User, and Password.

      3. See via DSN (Driver) for more information.

  6. Click Save.