When it comes to develop HANA artifacts, there are several tools provided by SAP.
1) SAP HANA studio
HANA Studio is published together with HANA as a traditional C/S tool which is extended from open-sourced Eclipse.
It's a very user friendly workbench and support lots of fetures for development, administration and monitoring, etc.
Even now, there are quite a large number of HANA studio users not only for HANA development but also BW and ABAP development.
However the disadvantage is obvious, you have to install and upgrade HANA Studio locally, and ADT and BWMT plugins
are also needed to be installed manually.
2) SAP HANA Web-based Development Workbench
I always mix it up with Web IDE, but Web-based Devlopment workbench is just a simplified but web-based HANA studio
webapps which is running in XS engine ever since in HANA 1.0 SPS05.
3) SAP Cloud Platform, Web IDE
It's a cloud based service for developing online and is independent on your HANA instance.
4) SAP Web IDE Personal Edition
It's the local offline version for SAP Cloud Platform, Web IDE, you can download from https://tools.hana.ondemand.com/#sapui5
5) SAP Cloud Platform, Web IDE Full Stack
It's a enhanced version based on SAP Cloud Platform, Web IDE with full-fetured, and it is the only envisioned and recommended developoment platform.
6) SAP Web IDE for SAP HANA
When HANA comes to 1.0 SPS11, XS Advanced is introduced in order to replace XS Classic engine.
SAP Web IDE for SAP HANA is exactly an full-featured development platform application running in XSA.
It best fits for HANA development within your local HANA and no need Cloud service.
I'm going to roughly walk trough a quick guide on Web IDE for SAP HANA
deploying in official HANA expression edition with Google Cloud Platform.
1. build a virtual machine instance for SAP HANA, expression edition(server+applications) from Marketplace
2. configure pychical resources
3. stage to the OS command after deployment finished
4. switch to hana admin( hxe is the instance name, 90 is the instance no)
5. post processing after deployment
6. HANA DB is started automatically:
7. change your local hosts file machine for HANA DNS adressing
8. login to XSA Portal: https://hxehost:39030/
9. step into xsa-cockpit,user the XSA admin user and intial pasword previously
10. cretae a new tenant database
11. enable the tenant database instance YCL
12. create a new orgnization
13. create a new space