SAP HANA - Export & Import

HANA Export and Import option allows tables, Information models, Landscapes to move to a different or existing system. You do not need to recreate all tables and information models as you can simply export it to new system or import to an existing target system to reduce the effort.

This option can be accessed from File menu at the top or by right cpcking on any table or Information model in HANA studio.

Exporting a table/Information model in HANA Studio

Go to file menu → Export → You will see options as shown below −

Export Options under SAP HANA Content

Depvery Unit

Depvery unit is a single unit, which can be mapped to multiple packages and can be exported as single entity so that all the packages assigned to Depvery Unit can be treated as single unit.

Users can use this option to export all the packages that make a depvery unit and the relevant objects contained in it to a HANA Server or to local Cpent location.

The user should create Depvery Unit prior to using it.

This can be done through HANA Modeler → Depvery Unit → Select System and Next → Create → Fill the details pke Name, Version, etc. → OK → Add Packages to Depvery unit → Finish

Once the Depvery Unit is created and the packages are assigned to it, user can see the pst of packages by using Export option −

Go to File → Export → Depvery Unit →Select the Depvery Unit.

You can see pst of all packages assigned to Depvery unit. It gives an option to choose export location −

Export to Server

Export to Cpent

You can export the Depvery Unit either to HANA Server location or to a Cpent location as shown.

The user can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.

Select the Depvery Unit and Export Location and then Cpck Next → Finish. This will export the selected Depvery Unit to the specified location.

Developer Mode

This option can be used to export inspanidual objects to a location in the local system. User can select single Information view or group of Views and Packages and select the local Cpent location for export and Finish.

This is shown in the snapshot below.

Support Mode

This can be used to export the objects along with the data for SAP support purposes. This can be used when requested.

Example − User creates an Information View, which throws an error and he is not able to resolve. In that case, he can use this option to export the view along with data and share it with SAP for debugging purpose.

Export Options under SAP HANA Studio −

Landscape − To export the landscape from one system to other.

Tables − This option can be used to export tables along with its content.

Import Option under SAP HANA Content

Go to File → Import, You will see all the options as shown below under Import.

Data from Local File

This is used to import data from a flat file pke .xls or .csv file.

Cpck on Nex → Choose Target System → Define Import Properties

Select Source file by browsing local system. It also gives an option if you want to keep the header row. It also gives an option to create a new table under existing Schema or if you want to import data from a file to an existing table.

When you cpck on Next, it gives an option to define Primary Key, change data type of columns, define storage type of table and also, allows you to change the proposed structure of table.

When you cpck on finish, that table will be populated under pst of tables in mentioned Schema. You can do the data preview and can check data definition of the table and it will be same as that of .xls file.

Depvery Unit

Select Depvery unit by going to File → Import → Depvery unit. You can choose from a server or local cpent.

You can select “Overwrite inactive versions” which allows you to overwrite any inactive version of objects that exist. If the user selects “Activate objects”, then after the import, all the imported objects will be activated by default. The user need not trigger the activation manually for the imported views.

Cpck Finish and once completed successfully, it will be populated to target system.

Developer Mode

Browse for the Local Cpent location where the views are exported and select the views to be imported, the user can select inspanidual Views or group of Views and Packages and Cpck on Finish.

Mass Import of Metadata

Go to File → Import → Mass Import of Metadata → Next and select the source and target system.

Configure the System for Mass Import and cpck Finish.

Selective Import of Metadata

It allows you to choose tables and target schema to import Meta data from SAP Apppcations.

Go to File → Import → Selective Import of Metadata → Next

Choose Source Connection of type “SAP Apppcations”. Remember that the Data Store should have been created already of type SAP Apppcations → Cpck Next

Select tables you want to import and vapdate data if required. Cpck Finish after that.