How to Extract SAP R/3 Data to Oracle using Business Objects Data Services
This document specifies technically, How to Extract Transform and Load the SAP R/3 Data to Oracle Using Business Objects Data Services.
2. Data Services Supplement for SAP Connect:
Data Services has four SAP interfaces:
• SAP ERP and R/3 ABAP
• SAP ERP and R/3 BAPI
• SAP ERP and R/3 IDoc
• SAP BI/BW
Each interface is a license-controlled feature that can be purchased separately and installed with Data Services. When you purchase the SAP ERP and R/3 ABAP interface, you can use an additional type of data flow called an ERP and R/3 data flow.
3. How to Create SAP R/3 Data Store :
An SAP ERP or R/3 data store includes the following information for working in an SAP ERP or R/3 environment:
• Connection information, including the ERP or R/3 application server name, the language used by the ERP or R/3 client application, and the client and system numbers. You supply these values based on your installation of SAP ERP or R/3.
• Data transport method used to exchange information between Data Services and SAP ERP or R/3.
You select the method and supply the appropriate information based on decisions you make about running Data Services jobs. This section describes a data transport method that is ideal for a development environment.
To define an SAP ERP or R/3 datastore
- In the object library, go to the Datastores tab.
- Right-click inside the object library window and choose New.
- The datastore editor opens.
- Enter a new, unique name for the datastore in the Name box. The name can contain alpha-numeric characters and underscores (_). It cannot contain spaces.
- Choose R/3 in the Application type box.
- Enter the appropriate Username and Password information.
As a development option, you can connect to an application server from your GUI using a routing string using the specified syntax in the ERP or R/3 application server field to ensure connection.
The syntax for using an SAP routing string is:
/H/IP Address of local SAP router/H/IP Address of target SAP
router/H/IP Address of target application server
Your SAP routing string (local and target) is /H/10.10.1.7/H/18.104.22.168 Your application server IP address is 22.214.171.124 Therefore, your routing string would look like this: /H/10.10.1.7/H/126.96.36.199/H/188.8.131.52
To add more information click Advanced button
To add more configurations for QA/Production, click Edit and Create New Configuration
Click Apply and Ok to Save the datastore.
4. To Retrieve metadata for source schéma
Either double click on the Datastore, and select External metadata to see the list of object from the specified server as shown below or Right click on the Tables from Object library window and ‘Import by name’
5. To Create R/3 Data flow
- Create a New Batch Job.
- Click on the Dataflow tab on the local object library window.
- Right click on the R/3 Data flows and select New
- Goto the Options tab and give the appropriate informations like Datastore, Generated ABAP file name etc., as shown below.
5. Goto General Tab and specify the name of the R/3 Dataflow
6. Now, double click on the R/3 Dataflow from local object library window. Drag and Drop the Source table from the datastore window.
7. Place Query Transform and apply the conditions wherever necesssary. (Eg : Where clause VBAK.PERNR=’00001516’)
8. Select Data Transport Transform and connect with Query Transform as shown below.
9. Double click on the Data Transport Transform and specify the File name for ABAP Code generation.
Eg : VBAK.dat
6. To Create Data flow
- Right click on the Data flows tab on the local object library window. Create a new data flow. Drag and drop the corresponding R/3 Data flow (VBAK_DATA_EXTRACTION) on the working pane.
2. Create a Template table or select the Target table from Datastore tab in local object library window and connect with R/3 Component.
Save the Job and Execute it.