Creation of Repository, Datastore and Replication of ECC Data using BODS with SQL DB Part I

[former_member223578]

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

Choose Next to continue

Choose Next to continue

Choose Next to continue

Choose the License agreement

Assign the product key and choose Next

Choose Next to continue

Select the language and choose next

Provide the CMC Details

Choose Yes

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.

Choose Next to continue

Choose Skip Configuration and proceed

Provide the OS credentials

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

The Data Services Installation started, Choose Next to continue

The below features will get installed

Data Services Installation got Finished Successfully

2) Data Services to ECC Configuration :

Logon to SAP ECC System that you to replicate Data

Create a TCP / IP RFC Connection

Assign any Program Id Ex : SAPDS_CLIENT

After providing the details,Save the RFC Connection

Open Data Services Management Console and login

Choose -  Administrator Tab

Choose RFC Server Interface in SAP Connections and click on ADD

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

The RFC is working fine from DS

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

Login to Data Services Designer

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

3) Process of Creating Repository :

Login into MS SQL Server Manager and create a New Database

Created DB : DS_REPO

Create a User for the DB : DS_REPO

Username : XXXXXX

Password : XXXXXX

Assign Permissions

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

After creating the Repository choose close

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..