Use the SAP ECC Connector to Import Data

Once you've authenticated and connected to SAP ECC, you can import data from a SAP ECC CDS View into MicroStrategy.

The SAP ECC connector does not support live connect mode.

1. Under Data Sources, click on a connection.

   The tables of your selected connection are displayed under Entities.

   

2. Use the Service Catalog to select from a list of services. Learn how to access the Service Catalog.

3. In the Entities search box, type in a table name to search for a specific table.

   Entity sets are treated as tables and appear in the Entities pane.

   

4. Select a table.

   When a table is selected, all of its columns are selected by default.

5. Under Available Columns, use the search box to search for a specific column.

6. Select the checkbox next to the column you want to import. You can select multiple columns.

   

   If you select a different data source or table, the connector throws the following warning and your selections are cleared.

   .

7. You can add filters by clicking Add New Qualification. Learn how to create a filter qualification.

8. You can add multiple tables to your data import.

   1. Click Prepare Data.
   2. In the Preview dialog, click Add a new table.

   3. Select a data source. For example, the SAP ECC connector.

   4. Select a table, columns, and add filters and click Add. You can see the added data in the Preview dialog.

   
   

9. Click Finish.
10. In the Save As dialog, select a location and enter a name.

11. Click Save.

You can use your published cube to create a dashboard, document, or report.