SAP HANA Articles - Page 8 of 58

To setup the following Parameters in BW Using Program SAP_RSADMIN_MAINTAIN  or you can also use T-code SE38 or SA38PSA_TO_HDB_DESTINATION − This parameter defines that where we need to move the Incoming dataPSA_TO_HDB_SCHEMA − This parameter is used to define which schema the replicated data will be assigned to.PSA_TO_HDB − GLOBAL − This parameter is used to replicate all data source to SAP HANASYSTEM − This parameter is used to specify clients to use DXC replicationDATASOURCE − This is used to specify the Data Source usedPSA_TO_HDB_DATASOURCETABLE − This parameter is used to provide the table name which are having list of ... Read More

To enable SAP Web dispatcher, you have to change Instance Value 0 to 1 in sapwebdisp in SAP HANA Studio → Configuration tab. This will enable ICM Web dispatcher and it uses ICM Method to load or read the data from SAP HANA system. Note that this method of data load supports large volume of data.

You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.

To Configure DXC, you need to enable XS Engine (SAP HANA Extended Application Services). To enable XS Engine Change the Instance value to “1”. XS Engine Service in SAP HANA Studio is used to handle Control Flow Logic.

M_PASSWORD_POLICY System View contains several lines of information about the current password policy.>Select * from M_PASSWORD_POLICY

This can be created using following SQL query −CREATE USER TEST_122 PASSWORD Pass123$$

It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER    []    [ ]    [ ]    [ ]    [ ]    [ ]    []In above SQL query, you have to pass following parameters −Specifies a database user in another tenant database as the remote identity of the database user being created.Specifies the user password of the user being created.Defines an external identification mechanism.Defines an external identity that is used to authenticate the user.

It is not possible to add PUBLIC profile to a restricted user. When a restricted user is created, it doesn’t have PUBLIC profile.

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.

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 More