|
| 1 | +--- |
| 2 | +title: SAP CodeJam Getting Started with SAP HANA, express edition |
| 3 | +description: Links, tips, tricks and more for getting started with the SAP HANA, express edition |
| 4 | +primary_tag: products>sap-hana\,-express-edition |
| 5 | +tags: [ tutorial>how-to, tutorial>beginner, tutorial>intermediate, products>sap-hana, products>sap-hana\,-express-edition ] |
| 6 | +--- |
| 7 | +## Prerequisites |
| 8 | + - **Systems used:** SAP HANA 1.00 SPS12, SAP HANA 2.00 SPS00, SAP HANA 2.00 SPS01, SAP HANA 2 SPS02 - SAP HANA, express edition |
| 9 | + |
| 10 | +## Next Steps |
| 11 | + - [View all How-Tos](http://www.sap.com/developer/tutorial-navigator.how-to.html) |
| 12 | + |
| 13 | + |
| 14 | +## How-To Details |
| 15 | +The following will document links, tips and tricks and more related to the SAP CodeJam Getting Started with SAP HANA, express edition event. |
| 16 | + |
| 17 | + |
| 18 | +### Time to Complete |
| 19 | +**5 to 6 Hours**. |
| 20 | + |
| 21 | +--- |
| 22 | + |
| 23 | +[ACCORDION-BEGIN [Step 1: ](First steps after registering to attend the event)] |
| 24 | + |
| 25 | +Now that you have registered for the [SAP CodeJam](https://www.sap.com/developer/events.html) event you will need to follow a few steps here to prepare yourself for the event. |
| 26 | + |
| 27 | +The first step is of course to sign up and register for [SAP.com](http://developers.sap.com) this will enable your user and make future steps much easier. |
| 28 | + |
| 29 | + |
| 30 | + |
| 31 | +Now proceed to [SAP HANA, express edition](https://www.sap.com/developer/topics/sap-hana-express.html) product page where you will see the steps listed as well as more information on what exactly SAP HANA, express edition is. |
| 32 | + |
| 33 | + |
| 34 | + |
| 35 | +> Remember you will need a laptop or machine with at least **8 GB** of RAM for server-only or **16GB** of RAM for XS Advanced applications. You can also choose a cloud provider but please note those require a credit card to sign up even if they offer free initial credits. |
| 36 | +
|
| 37 | +[ACCORDION-END] |
| 38 | + |
| 39 | +[ACCORDION-BEGIN [Step 2:](Get your version of HXE)] |
| 40 | + |
| 41 | +Depending on your choice and your available resources, you can install SAP HANA, express edition, as a Virtual Machine on your computer or on a cloud provider. |
| 42 | + |
| 43 | +**You will move into other tutorials and always back to this one**. It is advisable that you keep this open in one tab. |
| 44 | + |
| 45 | +_Google Cloud Platform Launcher_ |
| 46 | +If you are looking for the server-only version and would like to use Google Cloud Platform, there is a `one-click` setup option that is [explained in this guide](https://www.sap.com/developer/tutorials/hxe-gcp-getting-started-launcher.html). |
| 47 | + |
| 48 | +_Virtual Machine or Binary manual Installation_ |
| 49 | +In order to get your copy of the download, either the virtual machine or the binaries to install on your own Linux installation you will need to [register](https://www.sap.com/cmp/ft/crm-xu16-dat-hddedft/index.html). |
| 50 | + |
| 51 | + |
| 52 | + |
| 53 | +Once you have registered, proceed to setup you SAP HANA, express edition, using the right tutorial series depending on your choice: |
| 54 | +- Virtual Machine method: https://www.sap.com/developer/groups/hxe-install-vm.html |
| 55 | +- Binary Installer method: https://www.sap.com/developer/groups/hxe-install-binary.html |
| 56 | + |
| 57 | +_Manual binary installations with alternative free operating systems_ |
| 58 | +- Only for SPS01 and earlier - Google Cloud platform and Ubuntu: https://blogs.sap.com/2017/02/07/hana-express-edition-on-google-cloud-platform-and-ubuntu/ |
| 59 | +- `openSUSE` on MS Azure: https://blogs.sap.com/2017/05/22/setting-up-your-free-sap-hana-express-edition-on-ms-azure-on-opensuse/ |
| 60 | + |
| 61 | +[ACCORDION-END] |
| 62 | + |
| 63 | + |
| 64 | + |
| 65 | +[ACCORDION-BEGIN [------------------------------OPTIONS-------------------------------](Choose between OPTION A: HANA Studio, OPTION B: Server-only and external access or OPTION C: XS Advanced Development )] |
| 66 | + |
| 67 | +You are now presented with three paths. None is a dependency of the other and you can follow the three of them, however, if you have installed XS Advanced, it makes sense to go only for that option. |
| 68 | + |
| 69 | +**Option A, HANA Studio with XS Classic**, requires one additional installation step with versions SPS12, SPS00 and SPS01. **It is not available with SPS02.** |
| 70 | + |
| 71 | +**Option B, server-only and external tools**, does not require the additional XS Classic installation and uses other tools available in the market. |
| 72 | + |
| 73 | +**Option C, XS Advanced development** does not require any additional setup and is only available if you have XS Advanced installed. |
| 74 | + |
| 75 | +[ACCORDION-END] |
| 76 | + |
| 77 | +[ACCORDION-BEGIN [OPTION A:](Install XS Classic)] |
| 78 | + |
| 79 | +SAP HANA XS stands for `Extended Application Services`. These components are necessary to execute steps from option **A**. |
| 80 | + |
| 81 | +From the an operating system console, switch to the root user with command: |
| 82 | + |
| 83 | +``` |
| 84 | +sudo su - |
| 85 | +``` |
| 86 | +As root, execute the following commands, replacing `HXE_SID` with the System ID that you chose during setup. This is, most likely, **HXE**. |
| 87 | + |
| 88 | +``` |
| 89 | +/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content |
| 90 | +/hana/shared/<<HXE_SID>>/global/hdb/install/bin/hdbupdrep --content_directory=/hana/shared/<<HXE_SID>>/global/hdb/auto_content/systemdb |
| 91 | +``` |
| 92 | + |
| 93 | +For each command, the installer will ask for user SYSTEM and its password, which needs to update the installation. In this example, the system ID was set to `HXE` during setup: |
| 94 | + |
| 95 | + |
| 96 | + |
| 97 | +Second command: |
| 98 | + |
| 99 | + |
| 100 | + |
| 101 | +Finally, log in to the database using command `hdbsql` to enable the statistics server. Replace **XX** with the instance number below: |
| 102 | + |
| 103 | +``` |
| 104 | +sudo su - hxeadm |
| 105 | +hdbsql -i XX -n localhost:3XX13 -u SYSTEM -p <SYSTEM user password> "alter system alter configuration('nameserver.ini','SYSTEM') SET ('statisticsserver','active') = 'true' with reconfigure" |
| 106 | +
|
| 107 | +``` |
| 108 | + |
| 109 | +If you are having trouble with the password, you can also log in first and execute the command later: |
| 110 | + |
| 111 | + |
| 112 | + |
| 113 | +Then cast the last set of commands: |
| 114 | + |
| 115 | +``` |
| 116 | +CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','SYSTEM'); |
| 117 | +CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','SYSTEM'); |
| 118 | +CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::SecurityAdmin','SYSTEM'); |
| 119 | +CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::TraceViewer','SYSTEM'); |
| 120 | +ALTER SYSTEM ALTER CONFIGURATION ('webdispatcher.ini', 'system') SET('profile', 'wdisp/system_auto_configuration') = 'true' WITH RECONFIGURE; |
| 121 | +
|
| 122 | +``` |
| 123 | + |
| 124 | + |
| 125 | + |
| 126 | +Type `quit` to exit the SQL console. |
| 127 | + |
| 128 | +You can check the installation by opening URL `http://<<hostname>>:80XX/sap/hana/ide/` and logging in with user SYSTEM: |
| 129 | + |
| 130 | + |
| 131 | + |
| 132 | +[ACCORDION-END] |
| 133 | + |
| 134 | +[ACCORDION-BEGIN [**A: Step `A.1`: ]( Coding with SAP HANA Studio)] |
| 135 | + |
| 136 | +You will need to download a copy of the Eclipse software which will allow you to add the appropriate plugins to connect to your new SAP HANA, express edition, server. |
| 137 | + |
| 138 | +We recommend [Eclipse Neon](http://www.eclipse.org/downloads/packages/), the Java EE version in case you later want to explore the SAP Cloud Platform. |
| 139 | + |
| 140 | +Now that Eclipse has been installed you will need to add the appropriate plugins. The following guide will take your though [those steps](https://www.sap.com/developer/how-tos/2016/09/hxe-howto-eclipse.html). |
| 141 | + |
| 142 | +Finally you are connected to your SAP HANA, express edition, system. |
| 143 | + |
| 144 | +Now that you are connected and have your new users created it is time to actually do a little coding. The following tutorials will walk you through your first project with the Eclipse software and your HXE server. |
| 145 | + |
| 146 | +- [SAP HANA Studio, Setup a new project](https://www.sap.com/developer/tutorials/studio-new-project.html) |
| 147 | +- [SAP HANA Studio, Deploy Project](https://www.sap.com/developer/tutorials/studio-deploy-project.html) |
| 148 | +- [SAP HANA Studio, Import Data](https://www.sap.com/developer/tutorials/studio-import-data.html) |
| 149 | +- [SAP HANA Studio, Display your Application](https://www.sap.com/developer/tutorials/studio-display-project.html) |
| 150 | + |
| 151 | + |
| 152 | +[ACCORDION-END] |
| 153 | + |
| 154 | +[ACCORDION-BEGIN [**A: Step `A.2`:](Advanced System Settings)] |
| 155 | + |
| 156 | +If you are so inclined you can also enhance your current server installation and add in the browser based tooling to forgo the using of Eclipse for working with the server as well. |
| 157 | + |
| 158 | +This [blog post](https://blogs.sap.com/2016/10/28/enhancing-hxe-server-image/) walks you through the whole process of installing the browser based tools. |
| 159 | + |
| 160 | +[ACCORDION-END] |
| 161 | + |
| 162 | +[ACCORDION-BEGIN [**A: Step `A.3`:](Coding from the browser)] |
| 163 | + |
| 164 | +If you choose to install the browser based tools in Step `A.2` then you can move on to the following tutorials for creating your first project via that environment. |
| 165 | + |
| 166 | +- [Develop your first SAP HANA XSC Application](https://www.sap.com/developer/tutorials/hana-web-development-workbench.html) |
| 167 | +- [Access your first data in a SAP HANA XSC Application](https://www.sap.com/developer/tutorials/hana-data-access-authorizations.html) |
| 168 | +- [Enable XSODATA in your SAP HANA XSC Application](https://www.sap.com/developer/tutorials/hana-xsodata.html) |
| 169 | +- [Consume XSODATA in your SAP HANA XSC Application](https://www.sap.com/developer/tutorials/hana-consume-xsodata.html) |
| 170 | + |
| 171 | +[ACCORDION-END] |
| 172 | + |
| 173 | +[ACCORDION-BEGIN [**A: Step `A.4`:](Personalize HXE)] |
| 174 | + |
| 175 | +The following tutorials and blogs are just some optional items to help you understand your SAP HANA, express edition install and personalize it a bit to suit you. |
| 176 | + |
| 177 | +- [Custom Login Screen](https://blogs.sap.com/2016/10/31/customize-my-hxe/) |
| 178 | +- [`Changing the Default landing page`](https://blogs.sap.com/2016/11/22/hxe-customizing-the-landing-page/) |
| 179 | +- [`Enhance the new landing page`](https://blogs.sap.com/2016/11/22/hxe-enhancing-your-custom-landing-page/) |
| 180 | + |
| 181 | +[ACCORDION-END] |
| 182 | + |
| 183 | +[ACCORDION-BEGIN [**A: Step `A.5`:](Advanced Topics)] |
| 184 | + |
| 185 | +The following items are meant for further exploration of the SAP HANA, express edition server and things that are possible with it. |
| 186 | + |
| 187 | +- [Raspberry Pi](https://blogs.sap.com/2017/01/26/tbt-sap-hana-and-raspberry-pi/) |
| 188 | +- [Fuzzy Search](https://blogs.sap.com/2016/10/26/hxe-fuzzy-search/) |
| 189 | +- [Creating and accessing a Calculation View from MS Excel using MDX](https://www.sap.com/developer/tutorials/studio-view-data-calculation-mdx.html) or [using anonymous OData services](https://blogs.sap.com/2017/05/02/sap-hana-on-a-whim-a-bing-map-in-my-ms-excel-from-an-anonymous-odata-service/) |
| 190 | +- [Setting up the Google App Engine](https://www.sap.com/developer/tutorials/gae-setup.html) and [Installing `HDB` library for Node.js](https://www.sap.com/developer/tutorials/gae-nodehdb.html) |
| 191 | +- [Fuzzy search on the Google App Engine with `Node.js`](https://blogs.sap.com/2017/03/08/google-app-engine-meets-sap-hana-express-edition/) |
| 192 | + |
| 193 | +[ACCORDION-END] |
| 194 | + |
| 195 | + |
| 196 | +[ACCORDION-BEGIN [OPTION B:](Install DBeaver and Connect)] |
| 197 | + |
| 198 | +The following tutorial explains how to install a SQL client, in this case, `DBeaver`, and connect to SAP HANA, express edition, using the JDBC driver. |
| 199 | + |
| 200 | +Access the tutorial to [Install `DBeaver`](https://www.sap.com/developer/tutorials/hxe-cj1-download-sql-client.html) |
| 201 | + |
| 202 | +[ACCORDION-END] |
| 203 | + |
| 204 | +[ACCORDION-BEGIN [**B: Step `B.1`:](Create a Schema and Add Data into your tables)] |
| 205 | + |
| 206 | +The following tutorial explains how to create a table and insert data manually or using the **Import** SQL command to upload from a CSV file in the database server. |
| 207 | + |
| 208 | +Continue to [Upload and Import](https://www.sap.com/developer/tutorials/hxe-cj1-create-table-upload-data.html) data. |
| 209 | + |
| 210 | +[ACCORDION-END] |
| 211 | + |
| 212 | +[ACCORDION-BEGIN [**B: Step `B.2`:](Connect using node.js)] |
| 213 | + |
| 214 | +The following tutorial explains how to setup your local environment to use Node.js to connect to HXE. |
| 215 | + |
| 216 | +[Setup Node.js](https://www.sap.com/developer/tutorials/hxe-nodejs-setup.html) |
| 217 | + |
| 218 | +[ACCORDION-END] |
| 219 | + |
| 220 | + |
| 221 | +[ACCORDION-BEGIN [**B: Step `B.3`:](Access the database using node.js)] |
| 222 | + |
| 223 | +The following tutorial shows how to use Node.js to get data from HXE. |
| 224 | + |
| 225 | +[Connect using Node.js](https://www.sap.com/developer/tutorials/hxe-nodejs-connect.html) |
| 226 | + |
| 227 | +[ACCORDION-END] |
| 228 | + |
| 229 | +[ACCORDION-BEGIN [**B: Step `B.4`:](Coming soon - Parse your table data and display it)] |
| 230 | + |
| 231 | +[ACCORDION-END] |
| 232 | + |
| 233 | +[ACCORDION-BEGIN [OPTION C:](Development with XS Advanced)] |
| 234 | + |
| 235 | +You can start exploring the XS Advanced Cockpit here: |
| 236 | + |
| 237 | +https://www.sap.com/developer/tutorials/xsa-explore-basics.html |
| 238 | + |
| 239 | +You can get started with XS Advanced development following this tutorial series: |
| 240 | + |
| 241 | +https://www.sap.com/developer/groups/hana-xsa-get-started.html |
| 242 | + |
| 243 | +And here is how to integrate data from a database schema into your application: |
| 244 | + |
| 245 | +https://www.sap.com/developer/tutorials/xsa-create-user-provided-anonymous-service.html |
| 246 | + |
| 247 | + |
| 248 | +[ACCORDION-END] |
| 249 | + |
| 250 | +## Next Steps |
| 251 | + - [View all How-Tos](http://www.sap.com/developer/tutorial-navigator.how-to.html) |
0 commit comments