How to Import & Export Data from HANA Studio Tutorial

By : Mason Garcia Mason Garcia
Hours Updated

Import and Export option of SAP HANA Provide features to move tables, Information View, landscape to other or on the same system.

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.

Export Data From SAP HANA

A Pop-Up for Export will be displayed –

There are two Export options for SAP HANA Object will be displayed –

  1. SAP HANA
  • Catalog Objects: Used for export catalog objects (table, view, procedure, etc.).
  • Landscape: Used for an export landscape from one system to another.
  1. 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.

Export Data From SAP HANA

How to Import Data From SAP HANA?

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

Import Data From SAP HANA

A pop-up for Import Option will be displayed –

There are two Import option for SAP HANA Object will be displayed –

  1. 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.
  2. 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.

Import Data From SAP HANA

You Might Like: