When the data is entered, you can see the data in this row-based table by going to the Data Preview option. To see the data, right-click on table name → Open Data PreviewWhen you run Data Preview of a table, you can see full data under the Raw Data tab. You can also view distinct values and perform some analysis.

To insert the data, you need to run the Insert statement in SQL editor. “Demo_HANA” is table name.Insert into Demo_HANA Values (1,'John'); Insert into Demo_HANA Values (2,'Anna'); Insert into Demo_HANA Values (3,'Jason'); Insert into Demo_HANA Values (4,'Nick');In SQL editor, add INSERT statements and execute (F8) as below −

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 table is created.

Let us say you have executed the below create table SQL statement in HANA database −Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );To check the table in HANA database, navigate to AA_HANA11 schema and right click and refresh (F5). Navigate to “Table” folder and you can see new table with name Demo_HANA is created.

Note that you need to check table under schema name under which it is created. You can confirm schema name on top of SQL editor.In below snapshot, you can Current Schema: AA_HANA11.To check if table is created, go to schema name under Catalog folder → Tables and search for the table name used in SQL query.

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 them easy to understand and logical.

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 HANA environment.

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 landscape.

In below SQL statement you have to define orcl_DSN_Name −CREATE REMOTE SOURCE Source_Name ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral_DSN_Name’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.In above statement, is used to specify the connection information for data source where you need to mention the DSN name for your ODBC remote source system. You have to create a System DSN/User DSN to access the data source using ODBC connection. To create an ODBC DSN in system, you need to ... Read More

In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO with SELECT with GRANT privilege to user schemas.GRANT SELECT ON SCHEMA "SCHEMA_NAME" TO _SYS_REPO WITH GRANT OPTIONThis is required when you use objects of a table/view of a schema to build HANA Modeling Views. You need to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.Read More