SAP HANA Express Getting Started

This page contains some how tos around the Web IDE and the Database Explorer in SAP HANA Express Server

Database Explorer

Add System Database

• Login to SAP HANA Cockpit at https://hxehost:39030/go/hana-cockpit or https://hxehost:51045/cockpit#Shell-home (Use XSA_ADMIN)
• Go to: Resource Directory -> SystemDB@HXE
• Look at tile "Overall Database Status" and note server name and instance number
• Login to SAP Web IDE (Use XSA_DEV)
• Go to Database Explorer and click on "+"
• Select Database Type SAP HANA Database
• Enter values as follows:
  • Host -> server name noted above
  • Identifier -> Instance number -> instance number noted above
  • User -> System
  • Passwort -> Master Password
• Click on OK

Install SFLIGHT

• Download https://github.com/SAP/hana-xsa-opensap-hana7/raw/snippets_2.3.2/ex2/sflight_hana.tar.gz
• Open Web IDE
• Go to Database Explorer
• Open System Database
• Right-Click on Catalog and select Import Catalog Objects
• Enter values as follows:
  • Import objects from -> local computer
  • Local archive (*.tar.gz) -> Select file downloaded above
  • Activate Include dependencies and Include table data
  • Number of parallel threads -> 2
• Click on OK

Source: https://blogs.sap.com/2018/12/18/howto-import-sflight-sample-data-into-sap-hana-from-a-local-computer/