Friday, 13 June 2014

How to configure and read/write data to SAP server using InfoSphere InformationServer Pack for SAPBW

InformationServer Pack for SAPBW is used to integrate non-SAP data into SAP business warehouse. Using SAPBW Pack one can migrate data from legacy SAP systems and non-SAP systems to new SAP servers efficiently and accurately.This blog covers the advantages of SAPBW pack and overview of how to populate and extract data to/from SAPBW server using SAPBW pack with sample load and extract jobs.

Advantages of SAPBW

  • Loads SAP warehouse with data from any source system: Enterprise data warehouses, complex flat files, mainframe legacy systems, customer systems, and supplier systems.
  • Extracts information from SAP BW for use in other data marts, data warehouses, reporting applications, and targets
  • SAP BW Pack does not require pre-work in SAP BW before you can set up integration jobs.
  • Provides direct access to, and creation of, SAP BW metadata from the InfoSphere DataStage® user interface


SAPBW Pack comes as a bundle that need to be installed on top of InformationServer . These are the steps to configure SAPBW Pack
  1. Install InformationServer
  2. Create an account on the SAP servers you need to load /extract from.
  3. Install SAP Netweaver to connect to SAP server using SAPGUI. Here is the link that helps you with instructions
Once the SAPBW Pack is installed you will see two stages in the Datastage palette.
  1. SAPBW Load
  2. SAPBW Extract

Connection to SAP

1 - Before any of these stages can be used, a connection to SAP must be established. This will need to be done for each DataStage server that is used.

a – Open either the BW Load or Extract stage and navigate to the Input or Output tab depending on which stage you use
b – Navigate to the General tab.
To create new SAP connection:
c – Click on the Name down arrow and Select New…

The Connection Properties window will be invoked
On the Connection and Logon Details tab, fill in the:
a – Application Server – this is the SAP instance you are going to use for testing
b – System Number
c – User Name – this is the user name that you use to log into this SAP instance (for example BW_TESTER1)
d – Password – this is the password that you use to log into this SAP instance
e – Client Number – this is 800
f – Language – this is EN: 

The fields on the BW RFC Server Settings tab will be automatically populated:

Source System

All SAP BW stages require a Source System.
a – On a BW Load stage, navigate to the Input tab
b – Navigate to the Transfer Structure tab and click on the Source System down arrow
c – Select New… 

The Source System Properties dialog displays
a – On the RFC Server Configuration tab, enter a unique Source System name and then accept the defaults.


Click on the InfoPackage Options tab
a – enter the User Name – this is your DataStage user name
b – enter the Password – this is your DataStage password
All other fields should have been automatically populated for you
Click the OK button to save your information
Note – the “Domain” and “Server” will change with the platform that you are using.

SAPBW Load Job

The following figure shows a sample job which can populate SAPBW with non-SAP data using SAPBW Load Stage.

Double click on the BW Load Stage and navigate to “Input” tab

Select the SAP connection created above.

Navigate to Transfer Structure tab and select the Source System created above.

Select the InfoSource that need to be populated and link it to the Source System

Navigate to the Columns tab and then click on the Validate Columns button

If the validation is successful, you will see this:
If the validation is not successful, select the InfoSource again.

Create an InfoPackage to stream data to SAP.

There are 3 types of SAP BW Load jobs that can be used
a – PUSH
b – FILE
c – PULL

In this example PUSH InfoPackage is used.

Then click on the New… button:

Enter the name of the new InfoPackage into the Create InfoPackage dialog and click OK:
Click OK on the next two dialogs:

At this point you can compile and run the job.

SAPBW Extract Stage

The following figure shows a sample job which can extracts data from SAPBW using SAPBW Extract Stage.

Double click on the BW Open Hub Extract Stage, navigate to Output tab
Select the SAP Connection

Navigate to ProcessChain tab, select the Source System and the ProcessChain