Skip to Content

Start Using SAP HANA 2.0, express edition (Binary Installer Method)

Previous

Start Using SAP HANA 2.0, express edition (Binary Installer Method)

By JCurrie27

Explore how to connect to the SAP Web IDE for SAP HANA, Express Edition to start developing your project.

You will learn

How to configure the binary install of SAP HANA, express edition.

Details

For troubleshooting information, see SAP HANA, express edition Troubleshooting.

Info: The SAP HANA, express edition License

Installing SAP HANA 2.0, express edition installs a permanent 32 GB license automatically. No license configuration is required.

Step 1: Test Your Server Installation
  1. In a terminal, log in as the <sid>adm user:

    sudo su -l <sid>adm

  2. Enter HDB info. The following services must be running:

    • hdbnameserver
    • hdbcompileserver
    • hdbpreprocessor
    • hdbwebdispatcher
    • hdbdiserver (if XSA is installed)
  3. If any services are not running, enter HDB start. When the prompt returns, the system is started.

Step 2: Test XSC and XSA (Applications Package Only)

If you installed the Applications package (hxexsa.tgz), test your XS installations.

  1. Check that the XSEngine is running. Open a browser and enter:

    http://<hostname>:80<instance-number>  
    

    A success page displays:

    XSEngine Success Page
  2. As the <sid>adm user, log in to XSA services:

    xs login -u xsa_admin -p "<password>"
    
  3. View the list of XSA applications. Enter:

    xs apps
    

    Note: When you run the xs apps command for the first time, it may take 1-2 minutes for the system to return the list of XSA applications.

  4. Check that the application cockpit-admin-web-app shows STARTED with 1/1 instances in the list of XSA applications.

    Note Normally it only takes a few minutes for XSA services to start. However. depending on your machine, it can take over 30 minutes for XSA services to begin. If the service doesn’t show STARTED and doesn’t show 1/1 instances, keep waiting until the service is enabled.

    Make a note of the URL for cockpit-admin-web-app.

    XSA apps
  5. Enter the URL for cockpit-admin-web-app in a browser. The address is the one that displays in your xs apps command output.

    Example: https://my.hostname:51043

  6. Log in using the XSA_ADMIN user.

  7. If your site uses a proxy for connecting to HTTP and HTTPS servers, select Cockpit Settings > Proxy, then enable Http(s) Proxy and set the host, port, and non-proxy hosts.

    Tip: To find your proxy server information, in a terminal, enter env | grep PROXY

Step 3: Test Web IDE (Applications Package Only)
  1. As the <sid>adm user, log in to XSA services:

    xs login -u xsa_admin -p "<password>"
    

  2. View the status of the webide application. Enter:

    xs apps | grep webide
    
  3. Check that the application webide shows STARTED with 1/1 instances in the list of XSA applications.

    Make a note of the URL for webide.

  4. Test your Web IDE connection. Enter the URL for webide in a browser. The address is the one that displays in your xs apps command output.

    Example: https://my.hostname:53075

  5. Log on to Web IDE using the XSA_DEV user.

Best Practice: Deactivate the SYSTEM user

SYSTEM is the database superuser and is not intended for day-to-day activities in production systems. For better security, you can create other database users with only the privileges that they require for their tasks (for example, user administration), then deactivate the SYSTEM user.

  1. In a terminal, log in as the <sid>adm user:

    sudo su -l <sid>adm

  2. Create a new admin user with the USER ADMIN system privilege:

    /usr/sap/<SID>/HDB<instance-number>/exe/hdbsql -i <instance-number> -d SystemDB -u SYSTEM -p "<SYSTEM-password>" "CREATE USER <admin-username> PASSWORD <admin-password> NO FORCE_FIRST_PASSWORD_CHANGE;"
    /usr/sap/<SID>/HDB<instance-number>/exe/hdbsql -i <instance-number> -d SystemDB -u SYSTEM -p "<SYSTEM-password>" "GRANT USER ADMIN TO <admin-username> WITH ADMIN OPTION;"

  3. Use the new admin user to deactivate the SYSTEM user:

    /usr/sap/<SID>/HDB<instance-number>/exe/hdbsql -i <instance-number> -d SystemDB -u <admin-username> -p "<admin-password>" "ALTER USER SYSTEM DEACTIVATE USER NOW;"

Best Practice: Backups

Make regular data backups to save your work.

For information on data backup, recovery, and log file growth, see the SAP HANA 2.0 Administration Guide.

Step 4: Optional Configuration

(Optional) Test your Installation using the HANA Eclipse Plugin

Download and install the HANA Eclipse Plugin on a client machine and connect to SAP HANA, express edition.

  1. Download Eclipse IDE for Java EE Developers from http://www.eclipse.org/neon/ to your local file system.

  2. Follow the eclipse installer prompts.

  3. Launch when prompted, or go to the eclipse folder (example: C:\Users\<path>\eclipse\jee-neon) and run the eclipse executable file.

  4. Follow the tutorial How to download and install the HANA Eclipse plugin.

(Optional) Install SAP Enterprise Architecture Designer (Applications Package Only)

Note: Installing additional features requires greater system resources and may impact performance.

If you downloaded the Applications package (hxexsa.tgz), the installation file for SAP Enterprise Architecture Designer (SAP EA Designer) is located at <extracted_path>/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/.

SAP EA Designer lets you capture, analyze, and present your organization’s landscapes, strategies, requirements, processes, data, and other artifacts in a shared environment. Using industry-standard notations and techniques, organizations can leverage rich metadata and use models and diagrams to drive understanding and promote shared outcomes in creating innovative systems, information sets, and processes to support goals and capabilities.

Install SAP EA Designer in your SAP HANA 2.0, express edition system using the xs command line tool.

  1. Log in as <sid>adm.

    sudo su -l <sid>adm
    
  2. Create a temporary password file and change the password. This password change is mandatory.

    • Navigate to <extracted_path>/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10/

    • Locate the mtaext file XSAC_HANA_EADESIGNER-1.0.05-mtaext.mtaext. Make a copy of the file and edit the ADMIN_PASSWORD.

    Note: We recommend that your temporary password should contain 8 or more characters including a mix of numbers and uppercase and lowercase letters.

  3. Login to the XSA environment with the following command and enter your credentials when prompted:

    xs login -a https://<HOST>:3<instance-number>30
    
  4. Install the SAP EA Designer package using the following command:

    xs install XSACHANAEAD00P_1.ZIP -e <edited_mtaext_file>
    

    Note: If you do not specify the <edited_mtaext_file> temporary password file in your installation command, the installation will proceed normally, but you will not be able to log into SAP EA Designer.

  5. When the installation is complete enter the following command to confirm the status of SAP EA Designer:

    xs apps
    

    The output will include all the applications of your organization and space. You should see:

    • eadesigner - The SAP EA Designer application

    • eadesigner-service - The SAP EA Designer Node application

    • eadesigner-backend - The SAP EA Designer Java application

    • eadesigner-db - The SAP EA Designer database creation application. This application will have a state of stopped when the installation is complete.

  6. Note the URL for eadesigner and enter it in your web browser address bar to go to the SAP EA Designer login screen.

  7. Enter the following credentials:

    • User Name - ADMIN

    Note: Account names managed by SAP EA Designer are case-sensitive.

    • Password - Enter the temporary administrator password (<tempPwd>) you specified in firstTime.mtaext.

    You are prompted to change the password. You are logged in as administrator of SAP EA Designer.

  8. Delete <edited_mtaext_file>.

(Optional) Install SAP HANA Interactive Education (SHINE)

SAP HANA Interactive Education (SHINE) makes it easy to learn how to build applications on SAP HANA Extended Application Services Advanced Model.

Install SHINE for XSC

Installation files for SHINE for XSC are located at:

<extracted_path>/HANA_EXPRESS_20/DATA_UNITS/HCO_HANA_SHINE

To install SHINE for XSC, see the SAP HANA Interactive Education (SHINE) guide.

Note: The HANA JDBC port number for SAP HANA, express edition is different than the default port number 30015 mentioned in the SHINE guide. You need to update the port parameter for the resources CrossSchemaSys and CrossSchemaSysBi in the mtaext file to 3<instance-number>13.

Install SHINE for XSA

If you downloaded the Applications (hxexsa.tgz) package, installation files for SHINE for XSA are located at:

<extracted_path>/HANA_EXPRESS_20/DATA_UNITS/XSA_CONTENT_10

To install SHINE for XSA, run:

<extracted_path>/HANA_EXPRESS_20/install_shine.sh

(Optional) Install Text Analysis Files

If you are using SAP HANA 2.0, express edition in a language other than English or German, you can download the Text analysis files for additional languages package in the Download Manager. This package contains the text analysis files for the HANA Text Analysis feature for languages other than English or German.

Prerequisite: You downloaded the package Text analysis files for additional languages using Download Manager.

  1. Log in as <sid>adm.

  2. Navigate to /hana/shared/<SID>/global/hdb/custom/config/lexicon.

  3. Extract the contents of additional_lang.tgz to this directory:

    tar -xvzf <download_path>/additional_lang.tgz
    

Next Steps

Updated 03/24/2017

Time to Complete

20 Min.

Beginner

Tags

Prerequisites

Next Steps

Next
Back to top