Skip to Content
Previous

Check your environment (Forecast SQL)

By Abdel DADOUCHE

Check your environment before starting the Forecast tutorial series for SAP HANA, express edition

Details

You will learn

  • Which flavor and version of SAP HANA, express edition is needed to complete this tutorial series
  • Complete a series of required post-installation task
  • Enable the Script Server to allow the execution of AFLs functions
Step 1: Which SAP HANA flavor and version?

In order to complete this tutorial series, you need to use as a minimum version:

  • SAP HANA, express edition 2.0 SPS03

This version will allow you to complete all the steps described in the series. And thanks to the availability of the SAP HANA Automated Predictive Library (APL), you will be able to use and compare different predictive libraries.

As you may already know, SAP HANA, express edition comes in two different flavors. In this series, you will be running series of SQL statements.

Therefore, the Server only is the minimum required.

However, if you have a Server + Apps instance, you can use it too.

You can check the SAP HANA, express edition installation flowchart to find all the installation details.

If you don’t have an instance up and running, be aware that you don’t need to complete the installation of all the optional packages (this will be described when needed in the series).

Please log in to access this content.
Step 2: Prepare your System

In order to complete this series, you will first need to prepare your instance to execute Machine Learning algorithms.

Complete the following group:

As you will mostly execute SQL commands during this series, you will need to setup a SQL query tool for SAP HANA, express edition.

The following tutorial group describes a series of option you can pick one from (you don’t need to setup all of them, but one is enough):

Off course you can use any tool of your choice!

Also, looking at raw data is not always easy when you want to evaluate them. Therefore, it is recommended to visualize them graphically.

Therefore you can setup a tool like Jupyter (as described in the following tutorial: Use Jupyter Notebook with SAP HANA, express edition) which will allow you to run both your SQL and to use Python libraries to visualize your data in graphs.

In the following tutorials, you will be provided a series of Python code snippets to run in your Jupyter Notebooks in order to visualize the data.

But first, you will need to add the below code snippet in your first cell which will initialize the connection to your HXE instance:

import sqlalchemy, os
from sqlalchemy import create_engine

import pandas as pd
import matplotlib
import matplotlib.pyplot as plt

%matplotlib inline

%reload_ext sql
%config SqlMagic.displaylimit = 5
%config SqlMagic.feedback = False
%config SqlMagic.autopandas = True

hxe_connection = 'hana://ML_USER:Welcome18@hxehost:39015';

%sql $hxe_connection

pd.options.display.max_rows = 1000
pd.options.display.max_colwidth = 1000

Make sure to update the hxe_connection to match your current environment.

Please log in to access this content.
Step 3: Check the installation

Connect to the HXE tenant using the SYSTEM user credentials and execute the following SQL statement:

SELECT SERVICE_NAME, PORT, ACTIVE_STATUS FROM SYS.M_SERVICES ORDER BY 1;

The result should return a list of service names, their associated port numbers and their statuses including an entry for the scriptserver.

Provide an answer to the question below then click on Validate.

What port number is used by the nameserver?
×
Next
Back to top