Implementing Replication Job from ECC to HANA:

Step 1 : Create project and assign the Repository.

• Click on start ->click on all programs -> click on data services workbench.

• Enter the User Name and password.
• Click on logon.

• Click on Create -> Project.

• Enter the Project Name.

• Select the Data Service repository.

• Click on Finish.

• Project looks like,

Step 2: Create data store , for SAP-ECC and SAP-HANA. Data store nothing but connection.

DataStore for SAP-ECC

• Right click on Project -> New -> Click on DataStore.

• Enter the Datastore name , Description.
• Click on Next.

• Select Datastore type as SAP Application.

• Go to SAP-ECC properties.
• Copy the Application Server and Instance Number.

• Enter the Configuration parameters .
• Enter Application server , User name , Password , Client Number , System Number.

• Click on Test Connection.

• Pop-up will appear.
• Connection test succeeded!.
• Click on close.
• Click on Finish.

Datastore for SAP-HANA.

• Right click on project -> New -> Datastore.

• Enter the Datastore Name and Description.
• Click on Next.

• Select Datastore Type as Database.
• Database Type as SAP-HANA.

• Go to SAP-HANA Studio.
• Right click on System -> Properties -> Additional properties.
• Copy the Host name and Port Number.

• Go back to Data Services work-bench.
• Select Use Data Source ( ODBC ) as No.
• Enter Database Server Name , Port Number , User Name and Password.
• Click on Test Connection.

• Pop-up will appear.
• Connection test succeeded!.
• Click on close.
• Click on Finish.

Step 3: Using data store ( ECC )  import the metadata from SAP-ECC to Data Service repository.

• Double click on SAP-ECC Datastore .
• Click on Tables.

• Pop-up will appear.
• Enter the table name and click on Finish.

• To import more tables , click on Import object by Name.

• Also we can import  using import objects.

• Select required tables and click on import.
• Click on Close.

• Click on SAVE.

Step 4 : Create a replication job , to export the metadata from Data Services  repository to SAP-HANA  using Data Store  ( HANA ).

• Right click on Project -> New -> Replication Job.

• Enter the Name, Description and click on Finish.

 

• Expand SAPECC datastore.
• Expand Tables.
• Select the tables.

• Selected tables drag and drop into Replication job.

• Browse the Target Datastore.

• Pop-up will appear.
• Select the Datastore and click on Ok.

• Automatically Target Owner , Replication behavior pulls-up.

 

• Click on Validate.

• Pop-up will appear.
• Validation successful.
• Click on Close.

• Click on Save.
• Click on execute.

• Pop-up will appear.
• Click on Finish.

• In Data Services work-bench output looks like,

Output:

• Go to SAP-HANA Studio.
• Expand Catalog.
• Select the Schema.
• Select any table ( Ex: KNA1 ).
• Check the Number of records in Schema and SAP-ECC.