Skip to Content

Hello All,

In this blog i am going to explain how to Create Repository, Data store and Replication of ECC Data into BODS in Two Parts.

In my First Part i will explain :

1) How to Install Data Services

2) Data Services to SAP ECC Configuration

3) Repository Creation

Prerequisites :


1) Need to Install BO Server / Information Platform Services for Central Configuration Manager.

In my case,I have installed BO Server for Central Configuration Manager.

Environment :

This tutorial has been written with the following environment:

OS          : Microsoft Windows Server 2008

SAP BO  : SAP BusinessObjects BI Platform 4.1 SP06

Database : MS Sql 2008

1) Data Services Installation Process :

You can find the media at : http://service.sap.com/support >Software Downloads > Installations and Upgrades > A – Z Index > D > SAP Data Services > SAP Data Services 4.2

Extract the media and start the Installation

Run Setup.exe

1.PNG

Choose Next to continue

2.PNG

Choose Next to continue

3.PNG

Choose Next to continue

4.PNG

Choose the License agreement

5.PNG

Assign the product key and choose Next

6.PNG

Choose Next to continue

7.PNG

Select the language and choose next

8.PNG

Provide the CMC Details

9.PNG

Choose Yes

10.PNG

If you choose option with default configuration the Data Services repository will be created with chosen database.

Here in my case i choose Install without Configuration and continue, so that i can create repository later.

11.PNG

Choose Next to continue

12.PNG

Choose Skip Configuration and proceed

13.PNG

Provide the OS credentials

14.PNG

If you want to integrate with Solution Manger choose it.

In my case i dont want to Integrate DS with Solution Manger, So i choose not to Integrate

15.PNG

The Data Services Installation started, Choose Next to continue

16.PNG

The below features will get installed

17.PNG

Data Services Installation got Finished Successfully

18.PNG

2) Data Services to ECC Configuration :


Logon to SAP ECC System that you to replicate Data


Create a TCP / IP RFC Connection

19.PNG


Assign any Program Id Ex : SAPDS_CLIENT

20.PNG

After providing the details,Save the RFC Connection

21.PNG

Open Data Services Management Console and login

22.PNG

Choose –  Administrator Tab

23.PNG

Choose RFC Server Interface in SAP Connections and click on ADD

24.PNG

Provide the TCP/IP RFC ID,ECC details and choose Apply

25.PNG

The RFC is working fine from DS

26.PNG

After creating the RFC in Data Services Management Console, check the RFC from SAP ECC in Tx–>SM59

27.PNG

Login to Data Services Designer

28.PNG

I am unable to login as there is no Repository created. So create a Repository

29.PNG


3) Process of Creating Repository :


Login into MS SQL Server Manager and create a New Database

30.PNG

Created DB : DS_REPO

31.PNG

Create a User for the DB : DS_REPO

Username : XXXXXX

Password : XXXXXX

32.PNG

Assign Permissions

33.PNG

Open Data services Repository Manager and Provide the details of DS_REPO Database and choose Create

34.PNG

After creating the Repository choose close

35.PNG

The Repository has been Created.

Check for the Repository Configuration,Data store Creation and Replication of SAP ECC data in Part II.

Hope this is Helpful…

Thanks..


To report this post you need to login first.

1 Comment

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

  1. D. de Vries

    Hi M Krishna,

    Thanks for the blog!

    In my current BO installation I do not see the  RFC Server Interface in SAP Connections,

    Do you have any idea of the cause of this? Did we miss a part of the installtion, can it be a License problem?

    Kind regards,

    Dirk de Vries

    (0) 

Leave a Reply