Skip to Content

When Rodrigo and I were looking for a nice how to guide to be able to load data from a non-SAP source, via SAP Data Services into SAP NetWeaver BW 7.3 although we were able to find several examples, however it seems most of then were missing one step or two. So we have decided to put together a how to guide that we understand is complete: from setting up SAP Data Services to get the data into SAP NetWeaver BW.

Anyway, if you see something missing, please, let us know so we can enhance the document.

Step by step guide:

1.       Enter on SAP Data Services Management Console.

2.       Logon and choose the Administrator option.

/wp-content/uploads/2013/08/2_266460.jpg

3.       Select SAP Connections <RFC Server Interface> RFC Server Interface Configuration.

4.       Then press the “Add” button.

/wp-content/uploads/2013/08/3_266461.jpg  

5.       Fill the information as showed below.

DS1.jpg

Where:

     RFC program ID has to be the same you are going to use later on in T-code SM59

     Username refers to a userid with connection priveleges

6.       Now, enter in SAP Netweaver BW system.

7.       Call the Transaction code RSA1.

8.       In Modeling menu, select Source System.

9.       Chose Data Service, and then right click à “Create”.

DS2.jpg

10.   The Create Source System window will appear.

11.   Insert the Logical System Name and Source System Name. Then, continue (it is not necessary to provide the “release type”).

DS3.jpg

12.   The RFC Destination will appear.

13.   On Technical Settings tab, insert the Program ID created on Data Service (Step 5).

14.   Verify if the connection is Unicode or No-Unicode. As default, connection is created as No-Unicode. If needs to change the settings, use the Unicode tab.

15.   Then, press “Connection Test” button.

/wp-content/uploads/2013/08/figura1_267178.jpg

16.   Save and will show “Attributes of BO Data Services System” window.

17.   Insert the repository, job server and source data service.

/wp-content/uploads/2013/08/figura2_267284.jpg

  • HINT:

If occurs this error:

/wp-content/uploads/2013/08/figura3_267285.jpg

Check if you are logged in client system to make these steps (this could not work over VPN or other remote connection type). Then, try again.

18. 

18.   Now, we created the Data Service source system.

/wp-content/uploads/2013/08/figura4_267286.jpg

19.   In Modelling menu, select DataSource.

20.   Select SAP Data Service, and select the created logical system.

/wp-content/uploads/2013/08/figura5_268113.jpg

21.   In any InfoArea, right click and choose “Create DataSource”.

/wp-content/uploads/2013/08/figura6_268114.jpg

22.   Insert the DataSource name and DataSource Type. Then, continue.

/wp-content/uploads/2013/08/figura7_267289.jpg

23.   Insert a description to the DataSource.

/wp-content/uploads/2013/08/figura8_267292.jpg

24.  On Extraction tab, inform the tables that will be extract the information.

/wp-content/uploads/2013/08/figura9_267291.jpg

/wp-content/uploads/2013/08/figura10_267293.jpg

/wp-content/uploads/2013/08/figura11_267294.jpg

25.   On Proposal tab, press Request Structure Information.

26.   Verify if all fields, types and lengths are correct.

/wp-content/uploads/2013/08/figura12_267295.jpg

27.   Activate this DataSource.

28.   Return to DataSource window. Right click on the new DataSource and select “Create InfoPackage”.

29.   Write a name and Save.

/wp-content/uploads/2013/08/figura13_267296.jpg

/wp-content/uploads/2013/08/figura14_267297.jpg

/wp-content/uploads/2013/08/figura15_267298.jpg

30.   On Schedule tab, select Start.

/wp-content/uploads/2013/08/figura16_267299.jpg

31.   Select the Job Monitor and check if was loaded successfully.

/wp-content/uploads/2013/08/figura19_267300.jpg

It’s possible to see the same job running in Data Service monitor.

In Data Service Designer,  double click in Transactional Master Structures -> Transaction Infosources, select the InfoPackage created and then Import.

/wp-content/uploads/2013/08/figura17_267301.jpg

After import, replace the existent Data Flow to the newest flow imported. Then, save the job.

/wp-content/uploads/2013/08/figura18_267302.jpg

After this, it will be possible to see the same process on SAP Netweaver BW.

We hope you find this useful!

Best regards

Rodrigo & Eduardo

To report this post you need to login first.

10 Comments

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

      1. Shanthi Bhaskar

        Hello,

        Good Document.

        I was trying this approach but i have don’t option to select My DS table through extraction tab in the Datasource, What needs to done to get this. Please guide me I have BW 7.3 and BODS 4.0.

        Thanks in advance.

        Shanthi Bhaskar.

        (0) 
        1. Eduardo Rodrigues Post author

          Hi Shanthi

          That is one of the last things you will be able to do. Did you perform all the other steps? Do you get any error when trying to browser your DS table?

          best regards

          Eduardo

          (0) 
        2. Rodrigo Takai

          Hello,

          Thank you for the feedback.

          Could you please check if the table was created on the select repository ?

          After that, check if the table has authorizations to be accessed.

          Regards,

          Rodrigo Takai.

          (0) 
  1. Chuan Wang

    Hi Eduardo,

    Thanks for sharing this info. We are facing the exact error message you mentioned in Step 17 above. We did not use VPN or remote connection to make the steps. But still see the error message…Is there any other hints which can help resolve the issue? Thanks for your help!!

    (0) 

Leave a Reply