Register Login

Data Provisioning Overview

Updated May 18, 2018

Data Provisioning Tools

What is Data Provisioning?

Data provisioning is the way to get DATA from SAP sources such as SAP ERP, SAP BW or non-SAP source such as Microsoft Excel to the HANA Database.

It is a process of creating, preparing, and enabling a network in order to provide data to its user through HANA Database.

These two types of Provisioning tool come with further classifications such as

SAP HANA Built-In Provisioning Tool

i. Flat File

ii. Remote data

iii. Smart Data Streaming

iv. Smart Data Access (SDA)

v. Enterprise Information Management (EIM)

External tool supported by SAP HANA

i. Sybase Replication Server

ii. SAP Landscape Transformation

iii. SAP Direct Extractor Connection

iv. SAP Business Objects Data Services

Process of SAP HANA Data Provisioning

There is a 3 step process involved performing the transfer of data from source to SAP HANA Database know as ETL (Extract, Transform, and Load)

1) Extract – it is the first phase pf ETL where the data is extracted from the different source system.

2) Transform – In this second phase of ETL, a series of functions are defined for the data extracted from the source system in order to transfer the data into the target system.

3) Load – In this last phase pe ETL the data gets loaded in the target system.

SAP HANA Data Provisioning Methods

There is various data provisioning method in order to move the data from source to SAP HANA Database:

  • Uploading Data from Files
  • SAP DATA Services
  • SAP LT Replication
  • SAP Direct Extractor Connection(DXC).

Uploading Data from Files

From a file, without ETL tools (SLT, BODS, and DXC) SAP HANA support uploading data. HANA Studio Revision 28 (SPS04) new feature is this.

The following type of files is supported by SAP HANA which will be available on client system as below –

  • .CSV (Comma Separated value files)
  • .XLS
  • .XLSX

The user needs to create control file (.CTL file) prior to this option. To exist in SAP HANA and to upload data in SAP HANA Database, the table is needed. records will be appended at the end of the table if the table exists but if the table is absent then table need to be created.

SAP DATA Services

  • SAP Data Services which is also called as SAP Business Object data services is a single enterprise level ETL tool
  • SAP Data Service tool allow us to load data from any source to any target either in real-time or in a batch process.
  • It is a one the certified ETL tool from SAP to perform Batch loading into SAP HANA.

SAP LT Replication

  • LT Replication Server leverages proven System Landscape Optimization Technologies (SLO).
  • System Landscape Optimization Technologies is used to consolidate and unite the system landscape.
  • It a key offering foster SAP's Application Management Lifecycle.

SAP Direct Extractor Connection(DXC)

  • SAP HANA Direct Extractor Connection(DXC) is an additional data acquisition technique which has been added to the existing SAP HANA  data acquisition techniques.
  • DXC is a batch-acquisition technique which is considered as a for of ETL
  • DXC provides out-of-box foundational data models to SAP HANA which are based on SAP Business Suite Entities.
  • SAP Business Content DataSouce are available to deliver data directly to SAP HANA.