SAP-HANA
SAP HANA Flat File Upload Tutorial: CSV, XLS & XLSX
SAP HANA support uploading data from a file without ETL tools (SLT, BODS, and DXC). It is a new...
DATA Provisioning is a process of creating, preparing, and enabling a network to provide data to its user. Data needs to be loaded to SAP HANA before data reaches to the user via a front-end tool.
All these processes are referred as ETL (Extract, Transform, and Load), and detail is as below-
SAP HANA supports two type of Provisioning tool –
At present, there are main methods of data provisioning for SAP HANA, these are –
Methods of Data Provisioning | |
---|---|
SLT | SLT ("SAP Landscape Transformation Replication Server") running on the SAP Net Weaver Platform. SLT is an ideal solution for Real-Time and Schedule time replication for SAP and non-SAP source system. |
SAP DATA Services | SAP DATA Services is a platform for designing of ETL processes with a graphical user interface. |
DXC | DXC stand for Direct Extractor Connect is a batch driven ETL tool. |
Flat File Upload | This option used to Upload data (.csv, .xls, .xlsx) to SAP HANA. |
SAP HANA SLT Road Map is as below – DATA Provisioning through SLT require RFC/DB connection to SAP/Non-SAP Source System and a DB connection for SAP HANA database. On SAP SLT server we define Mapping and Transformation. Below is a roadmap for data provisioning through SLT.
SAP HANA support uploading data from a file without ETL tools (SLT, BODS, and DXC). It is a new...
What is Sap Hana Security? SAP HANA Security is protecting important data from unauthorized access...
What is SAP HANA Information composer? SAP HANA Information composer is a web application that...
A procedure is a unit/module that perform a specific task. This procedure can be combined to form...
What are Attributes? Attribute view acts like a dimension. It join multiple tables and act as...
We have till now loaded data from SAP Source, Non-SAP, and Flat file through SAP SLT, SAP BODS and...