In this Article, We will learn

  1. Export
  2. Import

How to Export Data From SAP HANA?

STEP 1) Go To File Menu->Choose Export.

A Pop-Up for Export will be displayed – There are two Export options for SAP HANA Object will be displayed –

SAP HANA

Catalog Objects: Used for export catalog objects (table, view, procedure, etc.). Landscape: Used for an export landscape from one system to another.

SAP HANA Content

Change and Transport System (CTS): Used for export information view with ABAP program. Delivery Unit: Delivery Unit is a single unit. This option is used to export multiple package which is mapped to single delivery unit. Developer Mode: This option can be used to export individual objects to a location in the local system. SAP Support Mode: This can be used to export the objects with the data for SAP support purposes.

How to Import Data From SAP HANA?

STEP 1) Go To File Menu->Choose Import.

A pop-up for Import Option will be displayed – There are two Import option for SAP HANA Object will be displayed –

SAP HANA

Catalog Objects: Used for import catalog objects (table, view, Procedure, etc.). ESRI Shape files: Environmental System Research Institute, Inc. (ESRI) shape file format are used to store geometry data and attribute information for the spatial features in a data set. Landscape: Used for import landscape from one system to another.

SAP HANA Content

Data from Local file: Used for import data from .csv, .xls, .xlsx file in table. Delivery Unit: Delivery Unit is a single unit. This option is used to import multiple package which is mapped to single delivery unit. Developer Mode: This option can be used to import individual objects to a location in the local system. Mass Import of Metadata: This can be used to import the Metadata of Mass objects. SAP Net weaver BW models: This can be used to import BW Models into SAP HANA. Selective Import of Metadata: This can be used to import the Metadata of Single objects into SAP HANA.