CONFIGURATION FILE ‘property_orcl.ini’ It is only required for Adapter ODBC for Oracle data sources. Below shows SQL query to create an Oracle Remote Source using SQL

Smart Data Access under Provisioning tab allows you to access and analyze the data stored in other database systems without replicating the data into HANA database. Data replication process is always time consuming and requires memory storage. Smart Data Access allows you to create virtual tables which are linked to ... Read More

Following remote data sources are supported under SAP HANA SPS06 Smart Data Access −Sybase ASESAP Sybase IQ 15.4 ESD 3 and Version 16.0Apache Hadoop Version 2.3Teradata Database Version 13.0 or higher

Following remote data sources are supported under SAP HANA SPS07 Smart Data Access −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c

You need to add SAP HANA system authorization CREATE REMOTE SOURCE to create a remote source. If the remote source is not created with the SAP user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP user (CREATE VIRTUAL ... Read More

The database user must assign the corresponding object authorizations to the SAP user −Object privilege: CREATE VIRTUAL TABLE on VIRTUAL_TABLES (SYS)Object privilege: DROP on VIRTUAL_TABLES (SYS)

Following are major changes are done in SAP HANA SPS07 for Smart Data Access −In later version SPS07, it supports SAP Oracle Database 12c, SAP Sybase Event Stream Processor (ESP) 5.1 SP04 and MSSQL server 2012 version 11 as data sources.In SPS07, it is possible to perform insert/update/deletion for remote ... Read More

Last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that defines the system security policy and user management activities −SecurityUserRolesIn Security tab, you can also define Password Policy of HANA system.In Users tab, you can find list of all the existing users ... Read More

Security tab is used to define different policies in HANA system:AuditingPassword PolicySAML Identity ProvidersData Volume EncryptionTo define an Audit policy, you have to click “+” sign −

Users tab defines the list of existing users in HANA system and you can also create a new user, new restricted user or find a user in HANA system.In above pic, you can use Find User to filter a particular user from existing list.