Tip:
Highlight text to annotate it
X
Welcome to CD162 exercise one
logon and project set up
will begin by creating a connection to the HANA server
Launch the SAP HANA studio and choose add system
we will input the host name
and instance number
as well as easy to remember description
next will input username and password as provided in the workshop materials
we now have a successful system connection
the next step is to create a repository connection as well
go to the SAP HANA repository. Create new repository workspace
Give the workspace and named HANA connected to work on a system connection that we created in the previous step. Now all
objects will automatically be connected to our HANA system
Next we will create a package for our group and our initial project contents
soto do this will use a new feature
in the HANA application lifecycle manager
it has both the ability to create packages and
manage delivery units as well as it has an application creation wizard
It is a web based application so we've launched a web browser
we put in our database username and password
of the same that we used in the system connection
will go to the products and then the packages and this shows is all the current packages that are in on a repository
you see that we have a package for session
and then there are multiple group packages this way all of our individual content of each
student is kept separate
so will create a new package for our group. We are using group 30
description
and the package hierarchy is refreshed
We go back drill into session X in the Group 30
so we have a package that will create all of our development objects in. We will run the create application wizard will create initial schema and
our role the grants access to the schema, the xsaccess file as well as a project that we can use in the HANA Studio
to create
and we see
everything has been created successfully
I'll go back to the HANA Studio will see the artifacts and has been created and will be on the checkout that project
so will go through the same package heirarchy
will find our package group 30
and there you see the objects were created by the wizard
and will say check out an import projects: this will copy the project contents down to our local PC
and add the project to our project explorer in HANA studio
We can now go to the project explorer
the project has been added and shared with the HANA repositoryand are ready to do development
Before doing too much development we need to grant that role that was created by the wizard to our user
so will open the SQL console
and will type the SQL Command that will grant that role. Now many of the
code snippets have been prepared for us in a template web site
We go to the
web site for our workshop and CD162
and here he is the template command
to grant the role to our user
We now return to the SQL console
all input is copied, we just need to adjust the grant for my session/group. role created by the wizard and to my user ID
and execute a command and see that was just successful so now I know that I have the
access they need to continue doing development
Next we edit the xsaccess file which was created for us by the wizard
the xsaccess file controls the access methods
to all our developing artifacts
and by default is going to try to open in notepad. So will say open with text editors and opens in place
We want to change the authentication mechanism from form based authentication to basic authentication and make it a little easier
during the development time to do some troubleshooting
Save the artifact and the change is stored locally is in the process of being committed to the server. It is now inactive on the server; you
see the little
icon changed and that we can activate the file that makes the new version the executable version on the server
and the activation is successful
and
our changes have been made
Now we create a little hello world HTML page
in the project so we can test to make sure all the access is is setup and were ready to get
you develop. We could do all this from Studio but I also want to show you that we have a browser based
IDE - integrated development environmen - we see the same contents all the folders that
exist on the server the ability to directly edit files
we also have the ability to execute project wizards and there's a little hello world project
wizard makes it very easy to create a hello world xsaccess
a server side JavaScript and HTML for quick testing so we'll go and create this in our
package will create a a new folder called hello world
contents will be generated into it
the hierarchy refreshes
and once it's refreshed
we have new artifacts - an HTML page and access to the server side JavaScript
we can also executed directly from here in opens a new browser window and only call the
service returns are our user id. This test just ensures that everything is set up correctly
and to our access works in and were ready to keep doing development
Now those artifacts are created outside the studio they exist on the server if we want to sync them to our local project we have to do
team check out and it will bring all the latest version of the development objects down
from the server