You can create an audit policy using Auditing app of HANA system.There are different Actions that can be selected using Add Action button as shown in the following screenshot.In Add action, you need to enter the target object(s) to be audited by clicking the add button and selecting the relevant objects. However, each database contains following components −All the database objects - tables, schemas, database views, SQL procedures - are separate for each database. Additional features are −It is a client tool, which can be used to access local or remote HANA system.It provides an environment for HANA Administration, HANA Information Modeling, and Data Provisioning in HANA database.There are various administration tasks that can be performed using SAP HANA Studio −In SAP HANA Studio, you will find a long list of perspectives, which can be considered as separate tools in HANA Studio.
You can set an interval when batch job executes, for example, every 20 minutes. You can also select actions to be audited. They are web-based tool that allows you to configure and maintain the basic administration-related elements of the application-development process and environment.This is used to maintain runtime configurations for individual applications or a complete application hierarchy.This is used to monitor and maintain SAP HANA XS job schedules defined using the XS job syntax.This is used to maintain certificates which are used to establish trust relationships between servers used by SAP HANA XS applications.This tile is used to define the details of SMTP server that is available for use by all applications running on an SAP HANA XS server.This tile provides the set of tools that allows to maintain self-service requests and administrate the self-service tools by the users.To view the configuration details of HANA XS Engine in HANA Studio, double-click HANA system in the system view pane. SAP HANA (High-Performance Analytic Appliance) is another initiative from SAP for high performance real-time database data processing.See the PDF Training materials.In SAP HANA data resides in RAM than the traditional physical disk storage. When an action is performed, the policy is triggered and an audit event is written to audit trail. User type can be a technical database user or an end user. So the time taken to process data and all are extremely low. This is called You can also covert a single container HANA system to multiple container databases HANA system. This server is responsible for processing SQL/MDX statement using engines in the Index server.
All privileges that are assigned to a repository package are assigned to all sub packages too. User accessing HANA system can either be a technical user or an end user depending on the access requirement. To create users and roles in HANA Studio, go to HANA Administrator Console. Copy & paste, bookmarks, and print-out permitted. From system monitoring with SAP Solution Manager to database If you’re making the leap from SAP BW to SAP HANA, this book is your indispensable companion. You can create a new backup or you can add schedules.You can also see the last backup status, time, duration, size and destination type details under Backup Catalog details.You can also perform SAP HANA Backup using HANA Studio. The SAP HANA Administration Guide is the central operations documentation for the on-premise deployment of the SAP HANA platform. Hadoop system is used for storing huge amount of unstructured data and HANA provides high speed data analysis.Following scenarios can be used to connect SAP HANA system to Hadoop −To use Smart Data Access to connect to Hadoop system in HANA Studio, select Adapter Name: HadoopIn Connection Properties, enter the URL and Credentials.You can also use the following SQL statement to create a remote connection to connect to Hadoop system. You can use Smart data access to get the data from non-SAP systems without importing the data to HANA database, and virtual tables can be used to perform read/write data operationsSAP HANA Administration includes the following activities −Each SAP system contains multiple servers and it can be checked in HANA Studio under Administration tab. Data Partitioning feature of SAP HANA is only available to column store tables and SAP HANA Data modeling can be used only on column store tables.Row store tables are more suitable for performing INSERT and UPDATE SQL statements on small size tables.In SAP HANA database, it is possible to join different store table types - Row store table can be joined to a column store table but it is recommended to join similar table types together to keep the performance high.Right-click on Table tab under Schema → Select ‘New Table’ option as shown in the following screenshot.Once you click on New Table, it will open a window to enter the Table name.