Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP Basis Articles
Page 18 of 50
TCP/IP port in SAP HANA to access Index server
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.
Read MoreMultiple perspectives to perform different functions in SAP HANA
In SAP HANA Studio, you have multiple perspectives to perform different functions. When you go to Open Perspectives, you can see long list of options. It has different Perspectives to manage HANA system like −SAP HANA DevelopmentSAP HANA Administration Console (Default)SAP HANA ModelerSAP HANA PlanVizBW Modeling (SAP BW on HANA functions)You have different ABAP and Java Perspectives to perform application development and to host applications on HANA system −ABAPABAP Connectivity and IntegrationABAP ProfilingJavaJava BrowsingJava EEJava Type HierarchyJava Script
Read MoreCustomizing SAP HANA Perspective in HANA Studio
To customize a perspective, right click on Perspective name → CustomizeWhen you click on Customize, it opens a new window which can be used for customization of a Perspective.
Read MoreShowing and hiding menu items in SAP HANA Studio Perspective
Yes, you can choose to hide menu items and toolbar buttons and then show them again.Switch to the perspective that you want to configure. Select Window → Perspective → Customize Perspective -> Open the Menu Visibility or Tool Bar Visibility tab.Find the item you want to hide. You can do this two ways −Expand the menu or toolbar hierarchy to find the item you want to hide.Click the Filter by command group check box to see a list of command groups which contribute items, and choose the command group the item you wish to hide. Then navigate to the item ...
Read MoreAdding a system in SAP HANA Studio
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 MoreDatabase objects in SAP HANA Studio
In Catalog folder, you can see all the database objects in SAP HANA system. You can see the list of all schemas in HANA database and each schema contains different Database objects inside it. In below pic, you can see different database objects under AA_HANA11 schema object.
Read MoreChecking information about executed savepoints in SAP HANA
M_SAVEPOINT_STATISTICS view shows information about executed savepoints.This view contains columns- START_TIME, STATE, VERSION and LAST_* relate to the last executed or currently-executing savepoint.Following information is available −
Read MoreFolder options in SAP HANA Studio
When you add a system under SAP HANA Studio, you can see the different folders to manage different objects. HANA Studio provides different folders that allow you to manage Database objects, Design Time Repository objects, HANA Provisioning, HANA Security to manage users and roles and Backup folder. The available options in these folders also vary as per the selected Perspectives in HANA Studio. Following are the different folders in HANA Studio −BackupCatalogContentProvisioningSecurity
Read MoreChecking backup configuration in SAP HANA
Backup folder in SAP HANA Studio can be used to manage backup properties in HANA system. Backup properties under HANA system are specific to that system.To see the backup configuration, you have to double click on Backup folder. HANA Studio opens the backup configuration for HANA system −
Read MoreChecking currently active data backup in SAP HANA
This can be checked in Backup configuration in HANA Studio. In Overview tab, you can see status of Currently Active Data Backup.
Read More