SAP-HANA
SAP HANA SQL: Learn in 10 Minutes
Most RDBMS database uses SQL as database language, the reason of being popular is – it is...
SAP HANA support uploading data from a file without ETL tools (SLT, BODS, and DXC). It is a new feature of HANA Studio Revision 28 (SPS04).
SAP HANA Support following type of files which will be available on client system as below –
Prior to this option, the user needs to create control file (.CTL file). To upload data in SAP HANA, table need to exist in SAP HANA. If table exits, records will be appended at the end of the table, if table not present then table need to be created.
This application suggests column name and data type for the new tables.
Steps for upload data from flat file to SAP HANA is as below-
If table are not present in SAP HANA, then we can create a table by SQL Script or by this process by selecting "NEW" option.
We will use "NEW" option for creating a new table.
We are going to upload Sales Organization master data. So create a .csv file and .xls file for it on local system.
We are going to upload SalesOrg.xlsx file into SAP HANA, so we have created a file SalesOrg.xlsx in the local system.
SalesOrg | Name | Currency | CoCode | Address | Country | Ref_Sorg |
---|---|---|---|---|---|---|
1000 | ABC Pvt. Ltd. | USD | 1000 | NEW YORK | USA | 1000 |
2000 | ABC Enterprises | INR | 2000 | INDIA | INDIA | 2000 |
Step 1) Open modeler perspective ? 'Main Menu' ? 'Help' ? 'Quick View' as shown below.
A Quick View screen appears as below-
Select 'Import' option from Quick View. A pop-up for import option will be displayed.
A Pop-Up for import screen is displayed. Go to SAP HANA Content? 'Data from Local File'.
Click Next.
A pop-up for File selection will be displayed, follow below steps for the select file.
A screen for file selection for import will be displayed ,in which we can select a file for loading data from local system to SAP HANA database.
Available options can be categorized into three main areas, they are
Step 2) In this step we have to enter following detail -
New – If the table is not present in SAP HANA, then choose this option, and provide Exiting schema name and table name to be created.
Exiting – If the table exist in SAP HANA, then choose this option. Select Schema name and Table. Data will be appended to end of the table.
A mapping screen will be used for performing the mapping between source and target columns.
There are two different types of mapping available.When we click on we get two option as below -
Mapping of Source to Target – We will map here Source File column to Target Table, and also, we can change target table definition.
A window for import data from the local file will appear.
It is final screen before we start the loading process. By this screen data that already exist in the table will display and also the information about the schema and table to which we are going to load the data will display.
Most RDBMS database uses SQL as database language, the reason of being popular is – it is...
What is Calculation View? SAP HANA Calculation view is a powerful information view. SAP HANA...
What is SLT (SAP Landscape Transformation Replication)? SLT is the an ETL tool that allows you to...
Import and Export option of SAP HANA Provide features to move tables, Information View, landscape...
What is SAP Data services? SAP Data services is an ETL tool which gives a single enterprises level...
We have till now loaded data from SAP Source, Non-SAP, and Flat file through SAP SLT, SAP BODS and...