Data Provisioning in SAP HANA
We have three types of Replication methods. They are
ETL based
Trigger based
Log based
ETL Based
For ETL based Replication we will use SAP DATA services tools (DS)
DS tool is a ETL tool to transfer data from one data base to another data base
This tool is easiest one, to transfer data base 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 source system:-
We have three types of sources
(a) SAP source (ERP, & data Were house)
(b) Non-SAP (ERP & Non ERP)
(c) File format
Interested in mastering SAP HANA Certification? Enroll now for FREE demo on SAP HANA Training Course.
(a) SAP sources
Creating data stores for SAP ERP (SAP ECC6)
Log on to data services to
Go to local object library
Select data stores (tab)
Right click on it & select New
Provide
1) Name______________
2) Data Store type –SAP applications
3) Application server_______________
4) Username:_________________
5) Password:________________
6) Client No:______________
7) System No:______________
8) working directory on SAP Server : D:\usr\sap\trans
9) Application path to should directory: D:\usr\sap\trans
10) Generated ABAP directory: \P business object \ data services
11) Security Profile:
12) Number of connection betties : 3
13) OK
We will get extractors function modules,
(Q) Creating Data stores for SAP warehouse (SAP BI)
Provide the following
- Name:________________________
- Data Store type: SAP BW source
- Application server: _______________
- Username: _________________
- Password: _________________
- client Number:______________
- system number:_______________
- Working directory on SAP server: D:\use\sap\trans
- Application path to should directory: D:\usr\sap\trans
- Generated ABAP directory /p sap business objects \ data services
We will get open hub, tables, idocs
(b)Non-SAP sources
Creating Data store for Traditional Data base (Ms-SQL)
Provide the following
Name : ____________________
Data store Type: DATA base
Data base type : HANA
Data base server name : __________
Data base name: ________________
User ID : _____________________
Password : _____________________
Click OK
We will get Table ((Templets), (Permanent) )
File Format
Here we can provide following file types for file format
- XML
- DTD
- CSX
- XLS
Select file format (tab)
Create New :_____________
Provide Name :___________
Directory: _____________
Path: __________
Skip header : Yes
Data formats: ___________
Click OK
NOTE: We need provide head name, type, headers,
We will get price view while creating file format
Creating data store for HANA
Log on to data services to
Go to local objects library
Select data services (tab)
Right click on it & select new
Provide:- Name :_________________
Data store types :DATA BASE
Data base 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 RFC connection for SAP (BI & DS)
Procedure to create RFC connection
Log on to 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
- RFC program ID : ____________
- user name : _____________
- Password :_______________
- SAP Application server name : _________
- client number : ____________
- system number : ___________
- SAP gateway host name : _________
- SAP gateway service name : ________
- OK
Go to RFC server interface status (tab)
Select our connection
Click on start
Note
After creating RFC connection, we need to create data services source system in BI for 4.0 version SAP has released standard connection for (BI & DS)
Procedure to create Data services Source system in BIs
Log on to BI
Provide URSA 1 (F code)
Go to 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 screen,
And provide to program ID : RFC connection in DS and
Activate
Text
For an Indepth knowledge on SAP HANA, click on below