Using the SAP DSO Connector

Birst Connect supports an SAP DSO Connector. The Birst SAP DSO Connector provides access to DataStore Objects (DSOs) in SAP which are the core components of BW cubes. For an overview of the different methods you can use to extract SAP data see SAP Connectors.

Implementation and Usage Notes

Up to 10,000,000 rows can be extracted using the SAP DSO Connector.

Prerequisites

The Birst Connect and Birst SAP DSO Connector products must be installed. See Checking Which Products Are Installed.

Before beginning these steps, you need to configure Birst Connect to run from the command line and download the SAP library files.

To create an extraction task using DSOs

1. Launch Birst Connect from the command line (run cmdUI.bat from the \commandline folder). The Birst Connect Java application opens.

2. Click Add Task to create a new task. Give the task a name in the Properties tab.
3. From the Sources tab, click the Add SAP DSO(s) button to define data extracts from SAP business objects.  
4. Enter your SAP account credentials then click Get DSOs.
5. Click the check box next to an object in the list. The SAP Datastore Object Detail dialog opens and shows the list of columns and default mappings for the object.
6. Optionally, change the DSO Label. By default it is the long description of the DSO object. This is the label that will be used in Birst.
7. Delete any columns you do not need, and their corresponding mappings.
8. Optionally, change any mapping labels. The name on the left will be used as the label in the Birst subject area. Do not change the name on the right as it is the technical name of the column in the DSO object.
9. In the Selection Criteria panel, specify the filter. You can change the column name, operator, range of values, and Inclusion Type.
Important: The column or columns here must also exist in the Columns list.
Tip: The Low and High Values can use Birst variables.
10. Optionally, update the ORDER BY clause with one or more column names.
Important: The column or columns here must also exist in the Columns list.
11. Optionally, update the Max Rows. If no positive number is provided, Birst retrieves all the rows.
12. Optionally, click Add Criteria to add additional items as Selection Criteria.

Tip: Click Get All Columns to reset the dialog to the original list of columns.
13. Click Validate to test the settings.
14. Click Save.
15. If you would like to schedule extractions in Birst Connect, click the Schedule tab and fill it out, then click OK. See Scheduling Birst Connect Tasks Using an External Scheduler.
16. Click File - Save Settings in the main Birst Connect window.
17. To extract the objects you selected immediately, select the task you created and click Run Tasks Now.

See Also
Using the SAP BAPI Connector
Using the SAP Query Connector
Using the SAP XML/A Connector
Overview of Extracting Data from SAP ERP and BW
Running Birst Connect from the Command Line