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
Articles by SAP Expert
Page 5 of 12
Exporting list of all SAP HANA systems in XML file
Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can be performed by following below steps −From the main menu, select File Export... .Expand the SAP HANA folder and choose Landscape.Choose Next.Select the systems you want to export and enter a target file location.Choose Finish
Read MoreSingle Sign-on configuration in SAP HANA system
SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets
Read MoreSearching a SAP HANA system in HANA Studio System view
When you are managing a large number of systems using HANA Studio, this can be used to find a specific system more quickly.To use find system option, the following steps should be performed −From the Systems view toolbar, choose the Find System (Find System) button.2. Enter a search string −You can also use “*” or “?” wildcards.It will display matching systemsSelect the system you were searching for.You can select several systems in the search results by pressing the CTRL key while selecting. You can use this, for example, to mark duplicate systems.Choose whether you want to open the selected system ...
Read MoreUse of Restricted user in SAP HANA system
When you compare standard database users, restricted users have the following limitations −With restricted users, it is not possible to create objects in the database as they are not authorized to create objects in their own database schemaRestricted users are not authorized to view any data in the database as they are not granted the standard PUBLIC roleWith the use of restricted users, you can connect to the database using HTTP.
Read MoreLimitations covered by SAP HANA as compared to conventional database
Following are the key limitations that HANA overcomes −As data size is growing it is a big problem for companies to store huge amounts of data. You talk about any industry domain- healthcare, FMCG, Banking, and Insurance, as subscribers are increasing there is an increase in historical data with time. SAP HANA Column base storage allows data compression and hence reducing the cost of storing the data.As data size is growing it is a huge problem for companies to maintain and analyze the historical data. A conventional database doesn’t provide a mechanism to process large volumes of data. With an ...
Read MoreCreating a mandatory variable in SAP HANA View
Yes, this is possible. When you create variable in HANA, you have an option to make it as a mandate. Also from the drop down, you can make Selection type as Range or Interval
Read MoreCreating a copy of an existing Attribute view in SAP HANA
Yes, it is possible to create a copy of an existing Attribute view. While passing View name and View type, you can select the option of “Copy From” and this will enable Browse option from which you can select any of existing view to copy.
Read MoreCreating a new table in SAP HANA
New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement –Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );When you run this SQL query, you get a message like this:The statement 'Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 5 ms 136 μs (server processing time: 4 ms 432 μs) - Rows Affected: 0To create a table using GUI, you need to right-click on any schema name -> New ...
Read MoreComponent Name in SAP HANA architecture
The following table lists all the key server components in HANA, the corresponding services, and OS process details.
Read MoreDifferent database objects inside Catalog folder in SAP HANA Studio
It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews
Read More