Creation of Repository, Datastore and Replication of ECC Data using BODS with SQL DB Part II
This is continuous for my First Part
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
Choose Data Services
Goto Manage tab –> Choose Configure Repository
Provide the DS_REPO details
The DS_REPO has been confiugured in CMC
Right click and choose User Security
Choose required Access Levels and select “ > ” symbol
Choose Advanced tab
Click on Add/Remove Rights
Assign required authorizations as per your requirement
Choose Data Services Repository, assign required Authorizations and Choose Apply and click on OK
Now we will be able to view the Repository and login to Data Services
2) Process of Data Store Creation :
After logging into Data Services Choose Create Datastore
Here provide the details of SAP ECC system
But here in the down i have faced an issue related to Job Server. To resolve that need to create Job server
Login to Data Services Server Manager and Choose configuration Editor
Provide the required details and choose OK
The Job Server has been created
Able to view the Job Server.
Choose Access Server tab
Create an empty folder for BODS_SHARE and browse that path
Choose Close and restart
Data server job is done, now in the down tab we are able to see Job Server.
Next Choose Create Datastore
Provide the ECC details and BODS_SHARE path
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
Give any table name, Eg. Mara
The table has been imported successfully.
Hope this is Helpful…