terewbo.blogg.se - Sap hana studio introduction

SAP HANA STUDIO INTRODUCTION HOW TO
SAP HANA STUDIO INTRODUCTION DRIVERS
SAP HANA STUDIO INTRODUCTION PASSWORD

Bob searches for Live2 and selects the schema.

Next, Bob opens the object privileges tab and clicks on the green plus sign.

Bob names the user and creates a password.

Bob opens the security folder and right clicks on users and selects new.

SAP HANA STUDIO INTRODUCTION HOW TO

Bob gets the syntax for the tables from the HANA Live2! Project Overview.īobs wants to create a user that has read only access rights and shows how to in 6 steps. More information about creating table can be found by entering SAP HANA tables into a search engine and at the SAP HANA Academy.īob enters the SQL for three additional tables (connects, tweets, and timewindows) and clicks execute to add the tables to his schema.

Bob clicks execute to create his table in the live2 schema.

Bob highlights the table folder in the Live2 schema and opens a SQL window.ģ.

Bob then right clicks on catalog and chooses refresh to see his created schema.īob wants to create a new table in his empty schema and shows how to in 3 steps.

In the SQL window Bob enters create schema live2 and clicks the green execute button.

On the left hand side above HDB System Bob clicks on the SQL button to open a SQL window.

SAP HANA STUDIO INTRODUCTION PASSWORD

Next, Bob chooses the authentication by database user option, enters system as the user name and the password he created in the SAP HANA One management console and clicks on store user name and password in secure storage before clicking finish to establish the connection.īob wants to create a new schema and shows how to in 4 steps.Back in SAP HANA Studio Bob enters hana as the host name and 00 as the instance number before clicking next.At the bottom of the notepad Bob writes in the IP address of the Linux box that contains the SAP HANA One instance followed by the word hana and then clicks save.

SAP HANA STUDIO INTRODUCTION DRIVERS

Next, Bob goes to his folders and clicks on computer, then the C Drive, then the Windows folder, then the System 32 folder, then the drivers folder, then the etc folder, before finally right clicking and opening the hosts file in notepad.On the left hand side Bob right clicks and selects add system.Bob chooses to leave the default SAP HANA Administration Console perspective. In SAP HANA Studio Bob clicks on the double windows in the top left corner to open a perspective.To view all of the content and links for the course please visit the HAHA Live2! Project Overview.īob wants to connect SAP HANA Studio to the SAP HANA Once server and shows how to in 6 steps. Note that SAP HANA SPS7 is required for the HANA Live2! course. SAP HANA Academy’s Tahir Hussain “Bob” Babar provides a basic overview of SAP HANA Studio.