Skip to Content
Author's profile photo Former Member

SAP BODS – SAP ECC Connection Setup & Datastore Creation in Data Services

Hi Friends

The below content explains step by step procedure of establishing connection between SAP ECC and SAP Data Services.

followed by creating datastore from SAP Dataservices which connects SAP ECC.

Steps to Connect BODS and SAP:

Go to the below directory in the Dataservices Application Server.

D:\Program Files (x86)\Business Objects\BusinessObjects Data Services\Admin\R3_Functions\transport

(We require the below files to get connected to SAP ECC and view the metadata of SAP ECC from SAP Dataservices)

Go to transaction STMS.

Press F5 or click on Truck icon under Transport management system.


     Go to Extras in the toolbar—>other requests—>Add.

    You will see a popup window as Add Transport Request to Import Queue.

     Press F4.

     You will see popup window with a single tab Restrictions, under this tab you should notice our co-file R63K900086.

     Click on Tick mark

     Click Yes.

     Select Queue tab then select Start Import at upper left corner or simply press Ctrl+F9.


Observe tick mark under St(status)



Click on Test/Execute or press F8.





there, fill the following details:

                                    Data Store Name: SAP_DS (some meaning full name)

                                    Data Store Type: SAP Applications

                                    Application Server: XXXXX (ECC app server details, we should get from basis/customer)

                                    User name: XXXXX  (we should get from basis/customer)

                                    Password: XXXX  (we should get from basis/customer)



Thanks

Narayana Murthy

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Useful document.

      Author's profile photo Former Member
      Former Member

      TQ

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Dear Narayana,

      Awesome article.... Nice post "   ". This is a brilliant way to go.

      Thank you

      Author's profile photo shiva sahu
      shiva sahu

      the  Best Document ever i saw in SCN 🙂

      Very Much Appreciated 🙂

      Regards,

      Shiva Sahu

      Author's profile photo vinodh seemakurthi
      vinodh seemakurthi

      Dear Narayana,

      I am new to SAP BODS 😳 ,

      This document is very useful for me 🙂 .

      Thanks & Regards,

      Vinodh Seemakurthi

      Author's profile photo Trevor Cowan
      Trevor Cowan

      Hi,

      when I follow the steps above and leave the program name blank the function module returns the exception PROGRAM_DOES_NOT_EXIST.

      The ABAP in the FM raises the exception when no entry is found in table D010SINF.

      Please advise.

      Regards,

      Trevor.

      Author's profile photo Former Member
      Former Member

      Hi Trevor,

      Hope you are doing good.

      I am facing the same issue now, could you please suggest how to trouble shoot this issue?

      Thanks,

      Abhinav

      Author's profile photo Former Member
      Former Member

      Hi Narayana,

      These steps are needed when SAP ECC is source for BODS?

      - Do we need any RFC connections(SM59)

      - Any transport import has to performed at source SAP ECC system as well?

      Awaiting for your inputs and Thanks in advance !!

      Best Regards,

      MIshra

      Author's profile photo Former Member
      Former Member

      Hi Aks,

      in the above example, as data transfer method is shared directory, RFC connection is not required . RFA is among one of the data transfer method, if this is used then RFC connection has to be established at SAP server(SM59) and BODS(management console).

      Hope that helps

      Thanks

      Shashi

      Author's profile photo Prasad D
      Prasad D

      Useful Document thank you 🙂

      Author's profile photo `hemanth P
      `hemanth P

      Hi,

       

      Usefull Document, can i do the same for CRM system also are there any other TR need to be imported from BODS.

      Author's profile photo Mohammed Aarif
      Mohammed Aarif

      Dear All.

      When i am go to Goto /nSE37.

      Unable to find Program Module  "Z_AW_ABAP_RUN".

       

      Best Regrads,

       

      Author's profile photo Dirk Venken
      Dirk Venken

      This is a very old blog, completely outdated.

      The necessary program modules should exist by default in your current ECC environment, by now. Check out the SAP Data Services Supplement for SAP guide for details.

      Author's profile photo Mohammed Aarif
      Mohammed Aarif

      Dear Dirk,

       

      Thank you for information.

       

       

       

      Best Regards,