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