Hi All,

These days, BODS is playing a very important role in SAP system landscape.

Many customers use BODS to pull data from Non-SAP systems and load to SAP BW.

These documents are primarily intended for BW Consultants who would like to know more about integration, modelling, and transport mechanism related to BODS.

In part 1, we have gone through integration between BW and BODS using RFC Functionality.(http://scn.sap.com/docs/DOC-48917)

In part 2, we have gone through BODS modelling especially when we have SAP BW as a data target. (http://scn.sap.com/docs/DOC-52550)

In this part 3 document, we will try to understand the transport mechanism within BODS.

Please note that this is not the best practise that SAP recommends. This approach would be useful only in case where there is some hardware limitation and in projects where limited people are working in the tool. The best practise is to have a Central and Local repository and work based on check-in and Check-out concept.

1) Log into the BODS Development server

/wp-content/uploads/2014/03/1_400249.png

2) Go to Tools Menu –> Export Option.

/wp-content/uploads/2014/03/2_400304.png

3)  Navigate to the flow which you wants to transport.

In this case, I want to transport the Financier job and the included objects to the Production system.

/wp-content/uploads/2014/03/3_400305.png

4) Drag the required job to ‘Objects to Export’ Pane:

/wp-content/uploads/2014/03/4_400313.png

5) After step 4, the datastores included in the job will automatically get collected in the ‘Datastores to export’ pane.

In my case, the source datastore is the Oracle CRM and target datastore is BW target.

Also, I have already transported the above 2 datastores previously. So I will exclude both the datastores in this transport.

/wp-content/uploads/2014/03/5_400306.png

6) Excluded datastores will be shown in Red cross mark

/wp-content/uploads/2014/03/6_400314.png

7) Now Right click on the selected job and click ‘Export to XML file’ option.

Export to ATL file is another option to transport, but it is not in scope of this document.

/wp-content/uploads/2014/03/7_400315.png

8) Save the xml file in a convenient folder, In this case I am saving it in my Desktop,

/wp-content/uploads/2014/03/8_400322.png

9) System will prompt you to enter a password. This will be required in later stage.

/wp-content/uploads/2014/03/9_400338.png

10) You get will get the status of Export.

/wp-content/uploads/2014/03/10_400339.png

11) Now open the file which you saved in step 8.

(Using open with  –> Notepad option)

/wp-content/uploads/2014/03/11_400343.png

12) Open the notepad and find the source CRM Dev connection name and replace(all) it with oracle CRM Prod connection name.

Source — APPS

Target — CRMTST1

/wp-content/uploads/2014/03/13_400351.png

13) Similarly do the same for BODS Connections aswell.

Dev – SAPBODSDEV

Prod – BODSPB1

/wp-content/uploads/2014/03/12_400345.png

14) Enter the BODS designer and give the Production Credentials.

/wp-content/uploads/2014/03/14_400394.png

15) Goto Tools –> Import from file.

/wp-content/uploads/2014/03/15_400395.png

16) Select the XML file from the saved folder(in my case, it’s desktop)

/wp-content/uploads/2014/03/16_400396.png

17) System will prompt you for a password.

Give the same password entered in step 9.

/wp-content/uploads/2014/03/17_400397.png

18) Now you will see the exported job and the related objects in the Production environment.

/wp-content/uploads/2014/03/18_400398.png

19) Remember to change the source system names in BW aswell.

BW –> RSA1 –> Tools Menu –> Conversion of Logical Systems Name.

/wp-content/uploads/2014/03/19_400399.png

Hope you got a basic understanding on the transport/Export mechanism in BODS.

Regards,

Prabhith

To report this post you need to login first.

6 Comments

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

  1. Santhosh Kumar

    Hi Prabhith,

    Yeah… thsnks for your infirmative one… Very usefull. Is ATL and XML both are same while in transport? i mean can we go for any one to transport OR any specific reason to choose the particulate option?

    (0) 
  2. Subhash Chandra Kilari

    Hi Prabhith,

    Thanks a lot. Really helpful.

     

    Is this the only way to transport the objects or can we also transport using Data Services Management Console?

     

    Thank You.

    Subhash.

    (0) 

Leave a Reply