Hi All,

Here, we will discuss how to execute and schedule BODS jobs from BW. There are two types of data processing available in BODS for BW. Those are below and will discuss one by one.

1. Data Loading into BW

2. Data moving out from BW

Prerequisite:RFC between BW and Dataservice should be running status.

1. Data Loading into BW:

  • Create New Datastore for BW.  Datastore type as “SAP BW Target”

     a.PNG

  • Double click on transfer structure and Import BW data source(PSA) from the list.

     1a.PNG

  • Same way create datastore for source system and import table.
  • Create new batch job and add dataflow into it.

     1c.PNG

  • Open a dataflow and track and drop source and target table. Create logical flow between source and target as per business requirement.

     2.PNG

     3.PNG

  • Validate and save the batch job.
  • Goto BW, create infopackage for respective datasource and fill the “3rd party selection” details as below.

        Repository    : BODS repository name

        JobServer     : BODS running jobserver name

        JobName     : BODS job name 

     4.PNG

  • Save and Execute infopackage.It will trigger BODS job which will load the data into BW datasource.

     5.PNG

  • Add this infopackage into process chain and schedule it.

     6.PNG

2. Data moving out from BW

  • Create New Datastore for BW.  Datastore type as “SAP BW Source”.

     7.PNG

  • Right click on datastore and click “import by name” from context menu.

     7a.PNG

     8.PNG

  • Create new batch job and dataflow. Open dataflow and create logical flow between source and target table as like below

     9.PNG

     10.PNG

  • Validate, save and execute it. data will be loaded into target table.
  • You can also execute these batch job from BW Process Chain.
  • Add new process chain variant “Start job in SAP BusinessObject Data Service” into Process Chain.

         10a.PNG 

  • Fill the source system details and  job name as like below,save and close it.

     0.PNG

  • Variant  added in Process Chain

     12.PNG

  • Save and Execute the Process Chain. Process Chain will trigger the BODS Job and that will load the data from BW to target table.
To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. S Kiran

    Hi Ramesh,

    very nice document.

    Further, is this also applicable when I want to load data into/from HANA instead of BW? Or else, what is the possibility in this case?

    Thanks.

    (0) 
  2. surya patro

    Hi Ramesh,

    I am not able to find the option in the Infopackage section for 3rd party selection.

    Could you please advise on this .

    Thanks

    (0) 

Leave a Reply