We have three types of Replication methods. They are:
For ETL-based Replication, we will use SAP DATA services tools (DS)
DS tool is an ETL tool to transfer data from one database to another database
This tool is the easiest one, to transfer database from any database to HANA
ETL – Extraction – Transformation – Load CETL) based data replication uses SAP BODS to load the relevant business data from the source system, SAP ERP, and replicate it to the target, SAP HANA database
Creating data stores for the source system:
We have three types of sources
Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training |
Creating data stores for SAP ERP (SAP ECC6)
Log on to data services to
Go to the local object library
Select data stores (tab)
Right-click on it & select New
Provide
We will get extractors function modules,
Creating Datastores for SAP warehouse (SAP BI)
Provide the following
We will get an open hub, tables, idocs
Creating Datastore for Traditional Database (Ms-SQL)
Provide the following
Click OK
We will get Table ((Templets), (Permanent) )
File Format
Here we can provide the following file types for the file format
Select file format (tab)
Click OK
NOTE: We need to provide the head name, type, headers,
We will get a price view while creating a file format
Checkout our Blog on SAP HANA Tutorial |
Log on to data services to
Go to local objects library
Select data services (tab)
Right-click on it & select new
Provide: Name
Datastore types: DATABASE
Database type: HANA
DATA base version: HANA I.X
Data source : (ODBC connection for HANA DB)
User name
Password
Click OK
We will get tables (Temporary, templates)
Note
To transfer data from SAP BI HANA we need t create an RFC connection for SAP (BI & DS)
Log on to the administrator
Click on to administrator
Select SAP connection under that
SAP service instance
Go to RFC servicer instance configuration (tab)
Click on add provide RFC prog
Go to RFC server interface status (tab)
Select our connection
Click on start
Note
After creating the RFC connection, we need to create data services source system in BI for the 4.0 version SAP has released a standard connection for (BI & DS)
Log on to BI
Provide URSA 1 (F code)
Go to the source system (tab)
Right click on DS(folder) & provide
(a) Logical system name: _____________
(b) source system name: ____________
(c) Type and Release: _______________
Then we will get a screen,
And provide to program ID: RFC connection in DS and
Activate
Text
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox