How to Upload Excel File in Sap

SAP HANA support uploading data from a file without ETL tools (SLT, BODS, and DXC). It is a new characteristic of HANA Studio Revision 28 (SPS04).

SAP HANA Support following blazon of files which will exist available on client system as below –

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

Prior to this option, the user needs to create control file (.CTL file). To upload information in SAP HANA, table need to exist in SAP HANA. If table exits, records will be appended at the finish of the table, if table not present then tabular array need to exist created.

This application suggests column name and data type for the new tables.

Steps for upload information from flat file to SAP HANA is as below-

• Create the tabular array in SAP HANA
• Create file with data in our local system
• Select the file
• Manage the mappings
• Load the data

Create the table in SAP HANA

If table are not present in SAP HANA, so nosotros can create a table by SQL Script or by this process by selecting "NEW" option.

We volition use "NEW" pick for creating a new tabular array.

Create file with data in our local System

Nosotros are going to upload Sales Organization primary data. Then create a .csv file and .xls file for it on local system.

We are going to upload SalesOrg.xlsx file into SAP HANA, then we have created a file SalesOrg.xlsx in the local system.

SalesOrg	Proper noun	Currency	CoCode	Accost	Country	Ref_Sorg
1000	ABC Pvt. Ltd.	USD	1000	NEW YORK	USA	one thousand
2000	ABC Enterprises	INR	2000	Republic of india	INDIA	2000

Select the file

Step 1) Open up modeler perspective ? 'Chief Bill of fare' ? 'Help' ? 'Quick View' equally shown below.

A Quick View screen appears as beneath-

Select 'Import' choice from Quick View. A pop-up for import choice will be displayed.

A Pop-Up for import screen is displayed. Become to SAP HANA Content? 'Data from Local File'.

Click Next.

A pop-up for File selection volition be displayed, follow below steps for the select file.

1. Select SalesOrg.xls file.
2. Click on "Open" button.

A screen for file option for import will exist displayed ,in which we tin select a file for loading data from local organization to SAP HANA database.

Available options can exist categorized into 3 main areas, they are

• Source File Department
• File Details Section
• Target Table

Step 2) In this step we take to enter following particular –

1. Select File – Selected file path will be displayed here.
2. Header Row Exits – If SalesOrg.xls file has a header (column Proper name). Then, nosotros have ticked information technology.
3. Import All Data – Tick this option if you want to import all data from a file, otherwise mention Get-go Line and End line for specific data load from file.
4. Ignore leading and trailing white space Tick this option for ignoring leading and abaft white space in the file.
5. Target Tabular array – In this section two option –

   New – If the table is non nowadays in SAP HANA, then cull this choice, and provide Exiting schema proper noun and tabular array proper name to be created.

   Exiting – If the table exist in SAP HANA, then choose this pick. Select Schema proper name and Table. Information will be appended to end of the table.

6. Click on "Next" button

Manage the Mappings

A mapping screen will be used for performing the mapping between source and target columns.

In that location are ii different types of mapping available.When nosotros click on nosotros get two option equally below –

• One to 1: By using this choice, we tin can map column to cavalcade based on the sequence. This option can be used if we know all the columns are in sequence.
• Map by Name: By using this option, we tin map the source and target columns based on the name. This can be used if we know that the columns names are same.

Mapping of Source to Target – Nosotros volition map hither Source File cavalcade to Target Table, and also, we can modify target table definition.

1. Proposed Table structure from Source File- Tabular array cavalcade Name is supposed from Excel file Cavalcade Name (Header).
2. Target Table Construction: Target Table store type is selected as column store past default.
3. Click File proper name and drag to target field, File will exist mapped. The field can be mapped automatically past one to one or map By Proper noun option. nosotros can manually exercise the mapping using drag and drop option If our cavalcade name could non be mapped with the to a higher place options.
4. In the File data section of the aforementioned screen, we can besides see how the data looks in the source file for all the columns.File data department displays data of SalesOrg file.
5. Click on "Next" file.

A window for import data from the local file will appear.

Load the data

Information technology is concluding screen earlier we start the loading process. Past this screen data that already be in the tabular array will display and also the information well-nigh the schema and tabular array to which we are going to load the data will display.

1. Detail Sections: In this section Selected Source File name, Target Table Name, and Target Schema Name detail will exist displayed.
2. Data from File: It will display data extracted from the file.
3. If displayed data in Data from file department has been verified, click 'Finish' to Start loading the data to the tabular array.

• After successful import choice completing, we should see the entry in the chore log view with condition 'Completed Successfully.'

• Once the data importing job is successful,
  1. We can see the data in tabular array of past selecting the tabular array of respective schema and right click on Table ? 'Data Preview' as shown below.
  2. Information of tabular array will display in Data preview screen as beneath-

  

woodsthock1999.blogspot.com

Source: https://www.guru99.com/flat-file-upload-to-sap-hana.html

Share this post