[SAP HANA Academy] Live3: Identify & Set Application Schema

[Former Member]

[Update: April 5th, 2016 -  The Live3 on HCP tutorial series was created using the SAP HANA Cloud Platform free developer trial landscape in January 2015. The HCP landscape has significantly evolved over the past year. Therefore one may encounter many issues while following along with the series using the most recent version of the free developer trail edition of HCP.]

philip.mugglestone from the SAP HANA Academy details how to identify the schema name that will hold the artifacts used throughout the Live3 course. Watch Philip's video below.

(0:30 – 2:15) Accessing the Live3 Course’s Code Repository

Visit https://github.com/saphanaacademy/Live3HCP to view the snippets of code that will be used in the Live3 course. You can always access the Live3 code repository on Github by viewing the Live3 playlist on the SAP HANA Academy’s Youtube page, expanding the description and then clicking on the link.

On the Live3 Github page click the Download ZIP button. Extract the folder so that now you will have ready access to all of the course’s code.

(2:15 – 4:20) How to Set the Schema

Open up the scripts folder from the code repository and then choose Edit with Notepad++ on the selected file called 01 setupSchema.sql. Copy the code from notepad and head into Eclipse. In Eclipse highlight your system name and click on the blue SQL button to open a SQL console. Then paste in the code.

The first line of the code identifies the schema name. Highlight that line of code and click the green execute button to run it. The results will display the name of your schema starting with NEO. Select the cell containing the schema name and copy it.

Paste the schema name into line 11 of the code so it reads SET Schema NEO_123456789. Then highlight the line of code and run it. Now all subsequent code will run in that schema.

(4:20 – 5:00) How to Identify the SAP HANA User

Highlight line 5 SELECT CURRENT_USER FROM DUMMY; and run it. It will return a SAP HANA user name that begins with DEV_. This user name will be used later when we connect to SAP HANA.

(5:00 – 5:55)  How to Verify the Predictive Analysis Library Is Available

Highlight line 8 SELECT * FROM SYS.AFL_FUNCTIONS WHERE PACKAGE_NAME=‘PAL’; and run it. Successfully executing the syntax means that all of the predictive algorithms we will be using have been installed and correctly configured. The list of algorithms varies depending on which version of SAP HANA you’re using and isn’t always installed by default.

Follow along with the Live3 course here.

SAP HANA Academy over 900 free tutorial videos on using SAP HANA and SAP HANA Cloud Platform.

Follow @saphanaacademy