SAP HANA Articles - Page 9 of 58

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.

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.

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

Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h  Host name-n  Instance number-u  User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux OShdbstudio -h hana -n 03 –u HANAADMINhdbstudio -h hana -n 03 -u "&hana"Mac OSopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u HANAADMINopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u "&hana"Once you run above from command line, this will open HANA Studio. If you are prompted to enter password ... Read More

Following tabs are available under SAP HANA Administration Console −OverviewLandscapeAlertsPerformanceVolumesConfigurationSystem InformationDiagnosis FilesTrace Configuration

You can drop a view using Drop command like we drop a table. You can perform all the operations that you perform on a table on the database view.Drop view "AA_HANA11"."DEMO_TEST";