Overview of Configure Replication Methods in SAP HANA

Replication Method

ETL Based Replication Installation and integration with SAP BW/R3 In this, we will do Installation of Data Services on either SAP or NON-SAP (Database) Landscape a) Data Services Software Installation b) Creation of repositories (System DB to store systems information) Repository creation  Create 3 Blank database for local, central and profile repositories in MS SQL server. Assign security for 3 databases Go to DS repository manager and create 3 repositories by providing repository type. DB type Server name User Name Password Configure Access Server   Log on DS Management Console

       ↓

Provide username & passwordHHhhhh

     ↓

Click on Administrator

     ↓

Go to Access Server under Management

     ↓

Provide malice name  Communication port

     ↓

Ping

Inclined to build a profession as SAP HANA Developer? Then here is the blog post on "SAP HANA Training"

Configure Job Server Log on DS Server Manager

   ↓

Click on Edit Job Server Configuration

   ↓

Click on Add

Give Job Server name & Job Server port

   ↓

Click on Add

   ↓

Give default of local, profile repository

   ↓

Click on ok & Restart-Job server

   ↓

Log on to server Mgnt console to register local, profits job servers in Admin console

   ↓

Provide user-id & password

   ↓

Go to Administrator

   ↓

Go to repositories under the name

   ↓

Click on Add   Provide repository name, database type, module name  DP port, DB name, username & password of local and profile repositions Integration of DS with SAP BW/R3/SAP presided Transport files, co files,   data files a) Copy co files (Start with “R”) & Data Files (Starts with “K”) into SAP installed driver paths D:/use/sap/trans/files/k900086.R63 D:/use/sap/trans/data/k900086.R63   log on to SAP B1 / R3

   ↓

Provide T code STMS

   ↓

Clue at import overview

   ↓

Import Queues

   ↓

Display

   ↓

Extras

   ↓

Other requests

   ↓

Add Provide Transport Request (R63K900086)

   ↓

  Click on report Request    Screenshot_36 Symbol  

   ↓

Provide Target click (bent 800)  0immrfisyr

   ↓

  Refresh request till status is ok

Learn more about SAP HANA Interview Questions in this blog post.

Connecting SAP BI and SAP DS Creating RFC Connection in DS admin Console Log on DS admin console Provide user Id & Password Click on RFC Cn under

  ↓

SAP connection Click on Add Provide RFC program id, Username, password,  Application Server Name, Client no, System no, Gateway hostname (server name) SAP Gateway Service name (SAP GWXX) System name

   ↓

  Apply

   ↓

  Go to RFC Server later face status (tab)

   ↓

  Select our RFC Server interface  

   ↓

Click on Start  

Configuration Management

In this phase, we have to create either a data store or file format for a given source within DS Environment as below   Screenshot_37  

DS Server can understand source to be target systems in Two ways Note:- WE create flat format when the data is in the format of xls, lobol, XML, DTD, flat file. Apart from the above sources it will treat as data store   SAP R3   Screenshot_24   HANA BW         Screenshot_24 HANA FE         Screenshot_24 HANA DB         Screenshot_24  HANA For an In-depth knowledge on SAP HANA, click on below