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


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

  1. Name:________________________
  2. Data Store type: SAP BW source
  3. Application server: _______________
  4. Username: _________________
  5. Password: _________________
  6. client Number:______________
  7. system number:_______________
  8. Working directory on SAP server: D:\use\sap\trans
  9. Application path to should directory: D:\usr\sap\trans
  10. 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

  1. XML
  2. DTD
  3. CSX
  4. 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)


To transfer data from SAP BI    Untitled  HANA    Untitled  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

  1. RFC program ID : ____________
  2. user name : _____________
  3. Password :_______________
  4. SAP Application server name : _________
  5. client number : ____________
  6. system number : ___________
  7. SAP gateway host name : _________
  8. SAP gateway service name : ________
  9. OK

Go to RFC server interface status (tab)

Select our connection

Click on start


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



For an Indepth knowledge on SAP HANA, click on below