SAP Articles - Page 11 of 104

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.

Data provisioning is available under SAP HANA Modeler Perspective.

SAP HANA is an in-memory database that supports real-time data replication from SAP and non SAP data sources. Following data replications are supported using SAP HANA −SAP Landscape Transformation (SLT) This is trigger based approach used to transfer data from source system to target systemSAP Data Services (BODS) This is commonly used to move data from SAP and non-SAP data sources to HANA db. It is an ETL based replication which extract, transform and load data from source system to target system.Sybase replication in SAP HANA This includes Sybase Replication agent which is part of SAP source application and Replication server implemented in ... Read More

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.

You can create a restricted user by navigating to Security tab → UsersWhen you select New Restricted User option, it will open New user creation window, and you have to pass the details as requested.

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