SAP HANA also supports multitenant database container system, along with singe logical database. Using multitenant isolate databases, administration of HANA system becomes easy in a distributed environment.You can also implement cross tenant database structure where one application running on one HANA system can also run on logical database from other ... Read More

To run the query, click on green arrow button on top right corner  or press F8.

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

To manage software updates and patch management in HANA system environment, you should install SAP Host Agent on all the machines that are part of SAP system landscape. SAP Host Agent is used by Software Update Manager to install the software patches on all the component servers in your system ... Read More

LM structure in SAP HANA system landscape is used to manage installation details of all the components under HANA. LM structure information helps to manage software updates and patches. The information with LM structure is used by Software Update Manager SUM to install the software updates and new releases in ... Read More

This is used to update versions of HANA Studio to newer versions. Studio Repository maintains the code to perform updates for HANA Studio.All the objects that you develop are maintained in Packages which are maintained under SAP HANA Repository. These packages are arranged in the form of hierarchy to make ... Read More

By default it creates a Row store table. The horizontal lines in front of table name represents row based storage table in database. HANA database also supports column store tables but you need to add a keyword “Column” in create table query.Below snapshot confirms that by default a row based ... Read More

With use of SAP HANA SPS06 Smart Data Access, you can only perform SELECT operation on virtual tables moved using new remote data source.

With use of SAP HANA SPS06 Smart Data Access, you can only perform Select, Insert, Update and Delete operation on virtual tables moved using new remote data source.

Yes, it is possible to differentiate between both the table types.  When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a ... Read More