How to Install HANA Studio

HANA Studio is an important administrative and IDE tool to manage SAP HANA.

Where to get the HANA Studio Software?

You can download  HANA  studio from http://support.sap.com/swdc (requires S-user with download authorization)

Select Support Packages & Patches and Browse Download Catalog

SAP-Software-Download-Center

SAP-Software-Download-Center-Download-Catalog

Now traverse through the following links:

  • SAP NetWeaver and complementary products
  • SAP HANA
  • SAP HANA PLATFORM EDITION
  • SAP HANA PLATFORM EDIT. 1.0
  • Entry by Component
  • HANA Studio
  • SAP HANA STUDIO 2
Depending on your PC's operating system, choose one of the four links.


SAP-Software-Download-Center-Download-Catalog-NetWeaver-SAP-HANA-Platform-HANA-Studio-2

Download one of the SAR files (the revision should either match or exceed the HANA Database Server revision).

HANA-Studio-Download

To extract the SAR file, you need SAPCAR executable.

Extract HANA Studio SAR File

Go to the folder where you downloaded  the HANA studio SAR file and SAPCAR.EXE, and run the following command

SAPCAR.EXE -xvf IMC_STUDIO2_<Revision>_<Patch>_<Material>.SAR

where IMC_STUDIO2_<Revision>_<Patch>_<Material>.SAR is the SAR file you downloaded.

The SAR file will be extracted to SAP_HANA_STUDIO folder.

HANA-Studio-Extract

Install HANA Studio

Run hdbsetup.exe file from SAP_HANA_STUDIO folder.

HANA-Studio-Extracted

Choose the location where you want the HANA Studio to be installed.

Location where you want the HANA Studio to be installed

Select which features you want to use based on your role. I am installing all the features.

Select HANA Studio features

Select HANA Studio features

Depending on the features you are installing the appropriate components are installed. Running Equinox P2 Director took about 5-10 minutes on my computer.

HANA Studio installation progress

Finally you get a confirmation that the install was successful.

HANA Studio installation completion

As I chose the HANA Studio to start up after installation, I get to see the first run right away.

You will be prompted to choose the workspace used by eclipse. I tend to have all my application profiles inside one folder (for portability reasons), so I changed the default location to my preference.

HANA Studio workspace

A master password is set on the first run. If you need to recover the password at a later point, you will need to answer a few questions. At this step, define what the questions and the answers should be.

HANA Studio master password

HANA Studio master password

Now we are all set to use HANA Studio and connect it with the HANA applicance/database.

HANA Studio administrative console


Comments

Post a Comment

Popular posts from this blog

OS/DB Migration - CMD. STR, TOC, EXT, R3load, DDLDBS.TPL and more

Image
With increasing need to improve performance or reduce costs or vanishing support for operating systems/databases it becomes inevitable to migrate to a better OS or DB. We feel take a quick look at the primary ingredients of the tools for OS/DB migration handled by R3SETUP. Tools - R3load, R3ldctl and R3szchk R3ldctl creates STRucture files, TemPLate files by reading the technical settings for table/indexes in SAP data dictionary. R3szchk calculates the database size object sizes (EXTent files) for the target system based on the STR files created by R3ldctl. The EXT and STR files can be later split into smaller groups. The most crucial tool R3load is responsible for unloading and loading data from the database. R3load uses the files created by R3ldctl and R3szchk and dumps the data into compressed binary format as .001, .002 .. files. It uses cmd files to achieve the task. If the cmd files are not present, it creates on its own. Files Command files*.cmd  are created i
Read more

Fixing Inconsistent Table - Table activation fails due to inconsistency between DD and DB

If you find a table to be available on the database, but not active in ABAP dictionary, try calling SE14 as DDIC user, enter the table name and choose Table > Reconstruct, Execute. If this method fails follow these steps: Call transaction code SE37 and execute the function module  DD_TABL_ACTM with single test On the next screen, do not change any other field except the following and set them as shown below: MODE: 12 NTAB_PUTSTATE: N TABNAME: <enter the correct table name> Click on Execute The export parameter ACT_RESULT should show 0. To verify if the inconsistency is fixed, call transaction SE14 > Extras > Database Object > Check and  SE14 > Extras > Runtime object > Check.
Read more

301 Redirect Using SAP Web Dispatcher

301 redirects are typically used to redirect accesses that include www to non-www or vice-versa. Example, when you call http://blogger.com, the call is redirected to www.blogger.com. An end-user may prefer to call a URL in any manner. You must ensure that all these calls are redirected to relevant URLs with content. SAP web dispatcher can be configured to send a redirect (301) to the client. To enable redirection add icm/HTTP/redirect_<xx> to the web dispatcher's profile file. The parameter uses the following syntax: icm/HTTP/redirect_<xx> = PREFIX=<URL prefix>[, FROM=<pattern for URL>, FROMPROT=<incoming protocol>, FOR=<pattern for host name:port>,TO=<new URL prefix>, PROT=<protocol>, HOST=<host>, PORT=<port number/name>] Let's say you want to redirect all the HTTP requests on mysource.com on 80 port to mytarget.com on HTTPS 443 port icm/HTTP/redirect_0 = PREFIX=/, FROM=*, FROMPROT=http, FOR=mysource.com:80,
Read more