SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets

When you create a new user, you need to select checkbox- Disable ODBC/JDBC access −

At the time of user creation, you have an option to pass Valid From and Valid Until date.

Below is the list of authentication methods supported by SAP HANA −User name/PasswordKerberosSAML 2.0SAP Logon ticketsX.509You can configure any of authentication method while creating a new user −

In an Audit policy, you can define different audit levels in SAP HANA −EMERGENCYCRITICALALERTWARNINGINFO

In SAP HANA system, following audit trail targets are possible −Syslog (default) − Logging system of Linux Operating System.Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.CSV text − This type of audit trail is only used for test purpose in a non-production environment.

Choose SAP HANA MDX Provider from this list to connect to any MDX data source → Enter HANA system details (server name, instance, user name and password) and you need to click on Test Connection → Connection succeeded → OKIt will give you the list of all packages in drop down list that are available in HANA system. You can choose an Information view → click Next → Select Pivot table/others → OK.

SAP HANA Data Modeling feature allows you to create complex BI reports in real time and it can be easily integrated with different BI tools- Business Objects, Crystal Report, SAP Lumira and non-SAP tools like Microsoft Excel with use of MDX client as shown below.

SAP HANA product is written in C++ and JAVA and runs on Linux platform. Linux Operating System on which SAP HANA runs- SUSE LINUX 11.

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 More