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 Currie

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
    • hdbwebdispatcher
    • hdbdiserver (if XSA is installed)
  3. If any services are not running, enter HDB start. When the prompt returns, the system is started.

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

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

    A success page displays:

    XSEngine Success Page
Step 2: Test XSA (Applications Package Only)

If you installed the Applications package (hxexsa.tgz), test your XSA installation.

  1. As the <sid>adm user, log in to XSA services:

    xs login -u xsa_admin -p "<password>"
    
  2. 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.

  3. 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
  4. 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

  5. Log in using the XSA_ADMIN user.

  6. 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

    Note: If you are using HANA Cockpit to register a resource, both HANA Cockpit and the SAP HANA, express edition need to be from the same release. SAP does not recommend using a newer HANA Cockpit to register an older version of SAP HANA, express edition.

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.

Best Practice: Set the Global Memory Allocation Limit

Set how much memory SAP HANA, express edition utilizes by modifying the global_allocation_limit parameter in the global.ini file.

The unit for global_allocation_limit is MB. The default value is 0, which sets the maximum memory to the minimum of your machine limit and license limit. If the machine size is less than 16 GB, the maximum memory is set to 16 GB.

If you set global_allocation_limit to a non-zero value, SAP HANA, express edition will use that value as maximum memory.

Note: Do not set global_allocation_limit to a value above the limit of your license. This can cause the database to lock down.

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.

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

Follow the eclipse installer prompts.

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

Follow the tutorial How to download and install the HANA Eclipse plugin to connect to your SAP HANA, express edition client machine.

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), and the SAP Enterprise Architecture Designer (SAP EA Designer) package (eadesigner.tgz), the installation file for SAP EA Designer is located at <extracted_path>/HANA_EXPRESS_20/install_eadesigner.sh/.

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 install_eadesigner.sh install script.

  1. Log in as <sid>adm.
    sudo su -l <sid>adm
    
  2. Run the following to install SAP EA Designer:
    <extracted_path>/HANA_EXPRESS_20/install_eadesigner.sh
    
  3. 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.

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

  5. Enter the following credentials:

    • User Name - ADMIN

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

    • Password - Enter the password you created when you installed SAP EA Designer.

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

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.

SHINE is provided as an optional component for SAP HANA, express edition. Download the SHINE installation file, shine.tgz, from the SAP HANA, express edition Download Manager. This download includes installation files for installing SHINE on XSC and XSA.

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

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 the following as <sid>adm:

<extracted_path>/HANA_EXPRESS_20/install_shine.sh
Optional: Installing SAP HANA External Machine Learning Library

The SAP HANA External Machine Learning Library is an application function library (AFL) supporting the integration of Google TensorFlow, as an external machine learning framework, with SAP HANA, express edition.

  1. Use the Download Manager to download HANA External Machine Learning AFL, eml.tgz.

  2. Extract eml.tgz.

  3. As <sid>adm, run:

    <extracted_path>/HANA_EXPRESS_20/install_eml.sh
    

    For more information on the SAP HANA External Machine Learning Library, see the SAP HANA documentation collection.

Optional: Installing SAP HANA Smart Data Integration

Install the SAP HANA client package and SAP HANA smart data integration on an SAP HANA, express edition system.

You need to run a script and an installer executable to complete the necessary steps to install SAP HANA smart data integration. The script enables the Data Provisioning Server on SAP HANA, express edition, as well as deploys the data provisioning delivery unit that enables monitoring and other capabilities. The installer executable that you run installs the Data Provisioning Agent that provides connectivity between SAP HANA, express edition and your remote data sources.

Note: The current version of SAP HANA, express edition supports only one Data Provisioning Agent per machine.

  1. Use the Download Manager to download the SAP HANA smart data integration installation package, sdi.tgz.

  2. Extract the contents of sdi.tgz and dpagent_linux_x86_64.tgz to a temporary directory.

  3. Run HANA_EXPRESS_20/install_sdi.sh as hxeadm.

    This enables the DP Server on HANA and deploys the monitoring delivery unit.

  4. To install the Data Provisioning Agent, run:

    <extract_directory>/HANA_EXPRESS_20/DATA_UNITS/HANA_DP_AGENT_20_LIN_X86_64/hdbinst
    

    You are prompted to supply the following information (default values are given):

    • Installation path [/usr/sap/dataprovagent]

    • Enter User name for Agent service (user must exist)

    • Enter Agent Listener Port [5050]

    • Enter Agent Administration Port [5051]

    • Enter Shared directory for Agent Group (optional)

    • Enter Custom JRE directory (to use bundled JRE, leave it blank)

  5. The SAP JVM is bundled with the Data Provisioning Agent and used as the default Java Runtime Environment. You can choose to update the version of the SAP JVM used by an installed agent, or replace it with a custom Java Runtime Environment.

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 12/12/2017

Time to Complete

20 Min.

Beginner

Tags

Prerequisites

Next Steps

Next
Back to top