Hello All,

This is continuous for my First Part

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

In this blog i am going to explain


1) Repository Configuration

2) Data store Creation

3) Replication of SAP ECC data.


1) Process of Configuring Repository :


Login to Central Management Console

36.PNG

Choose Data Services

37.PNG

Goto Manage tab –> Choose Configure Repository

38.PNG

Provide the DS_REPO details

39.PNG

The DS_REPO has been confiugured in CMC

40.PNG

Right click and choose User Security

42.PNG

Choose Administrator

43.PNG

Choose required Access Levels and select “ > ” symbol

44.PNG

Choose Advanced tab

advanced tab.PNG

Click on Add/Remove Rights

45.PNG

Assign required authorizations as per your requirement

46.PNG

Choose Data Services Repository, assign required Authorizations and Choose Apply and click on OK

47.PNG

Now we will be able to view the Repository and login to Data Services

41.PNG

2) Process of Data Store Creation :


After logging into Data Services Choose Create Datastore

48.PNG

Here provide the details of SAP ECC system

49.PNG

But here in the down i have faced an issue related to Job Server. To resolve that need to create Job server

50.PNG

Login to Data Services Server Manager and Choose configuration Editor

51.PNG

Choose Add

52.PNG

Provide the required details and choose OK

53.PNG

The Job Server has been created

54.PNG

Able to view the Job Server.

55.PNG

Choose Access Server tab

56.PNG

Create an empty folder for BODS_SHARE and browse that path

57.PNG

Choose Close and restart

close and restart.PNG

Data server job is done, now in the down tab we are able to see Job Server.

Next Choose Create Datastore

58.PNG

Provide the ECC details and BODS_SHARE path

59.PNG

The Data Store SAP_EH6 has been created.


3) Replication of SAP ECC data :

To Import the tables from EH6 –> Right click on Table –>Choose Import by Name

60.PNG

Give any table name, Eg. Mara

61.PNG

The table has been imported successfully.

62.PNG

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.

Leave a Reply