To be able to extract OLTP Datasources from SAP ERP, you first of all have to activate the relevant DataSources in the SAP OLTP system. After activating the DataSources you can extract data from all the active DataSources using the DeltaQ component.

Thoses steps have to be carried out in the SAP ERP system (OLTP). No SAP BW system is required.

Transferring Application Component Hierarchy
You use this function to install and activate the application component hierarchy.

Run transaction RSA9 in the OLTP system (or alternatively SBIW).
Go to transaction SBIW, and choose Business Content DataSources and Transfer Application Component Hierarchy. Alternatively, you may also use transaction RSA5. The procedure is the same.

Confirm the security check: Do you want the content application Transfer Component Hierarchy? with YES.
If a dialog box appears requesting the user to enter a package, enter a package in the customer’s namespace and choose Save or choose Local object.

Activating DataSources
You use this function to activate DataSources in SAP OLTP systems.

Go to transaction SBIW, and choose Business Content DataSources and Transfer Business Content DataSources. Alternatively, you may also use transaction RSA5. The procedure is the same.

The overview tree is structured in accordance with the application components assigned to you.

Activate a Datasource
To activate a DataSource from the delivery version to the active version, select it in the overview tree and choose Activate DataSources.

Activate a Node
In the application component hierarchy, select the nodes for which you want to install DataSources in the active version. To do this, position the cursor on the node and choose Activate DataSources. The DataSources and subtrees below the node are activated.

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.