For Index Server Instance No: 03Port # 30315Standard format: 3NN15 These port numbers are used for index server for SQL/MDX access port for standard database access. You should enable the access on these ports for all database clients. By default Index server Port no is 30015.The standard port number format for different instances 3NN15, NN- represents the instance number of HANA system to be used in client tools.Port 3615 should be open to connect to DatabasePort 31015 Instance No 10Port 30015 Instance No 00SSh port should also be opened.

To access HANA system on client tools, you need to open different ports to database for these clients. These ports refer to different servers and application service in HANA system.

You can add multiple local/remote HANA systems in HANA Studio. To add a system, you have to open HANA Studio from Program Files.Once you open HANA Studio, go to system pane on right side → Right click and select Add System. You can also add SAP HANA Cloud system or a new folder in system pane.When you create a folder, it allows you to add HANA system, cloud system or a new folder inside it. This folder option can be used to create hierarchies when you have multiple systems to manage in a distributed environment.When you click on Add System, ... Read More

On right side you have Modeling Perspectives, under which you can see multiple options inside it. In SAP HANA Studio you have the options to access different perspectives that can be used to perform variety of different functions.You can see HANA Modeler Perspective in below pic −You can also perform a search on different options in Perspective by typing in search bar below Quick View.

When you login to SAP HANA Studio first time, it doesn’t have any system added to it. You can add multiple local/remote HANA systems to Studio and manage them.On left side, you have system pane where you can add multiple systems in Studio. When you add a system in HANA Studio, it consists of different folders. Each folder in HANA system performs different functions. We will cover the details later in this tutorial. At bottom you have Properties pane and Job Log pane. In Job Log pane you can check the status of each action that you perform in HANA ... Read More

You can also install SAP HANA Studio from SAP Market place with a valid user license. You need to have SAP Partner ID (SID) and password to login to SAP Market place. This is paid version and you should have a license for SAP HANA Studio. You can also install all the patches and upgrades related to SAP HANA from Marketplace.Go to http://support.sap.com and navigate to Software Downloads.

Once Eclipse installation is done, open software and Navigate to Help → Install New SoftwareWhen you click on Install New Software, a new window will open. You have to enter work with URL for SAP HANA tools.Enter the URL as per Eclipse Mars4.5 https://tools.hana.ondemand.com/marsEnter the URL as per Eclipse Luna 4.4 https://tools.hana.ondemand.com/lunaWhen you enter URL and press ENTER key, it will display all the software installation options under Eclipse for these URL’s. You can also select different options: Show only the Latest version etc.When you want to use SAP HANA cloud platform tools, you can also select this check box. ... Read More

Once Eclipse installation is done, open software and Navigate to Help → Install New SoftwareWhen you click on Install New Software, a new window will open and you can perform HANA plugin installation.

You can install Eclipse Mars or Eclipse Lunar from Eclipse.Org site. Follow this link for the installation and select Operating System type-http://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/marsr

SAP HANA studio runs on the Eclipse platform 3.6. To install SAP HANA Studio, it is two-step process.First to install Eclipse as per Operating SystemSecond is to install HANA software plugin in Eclipse