SAP HANA Articles - Page 17 of 58

In below table, you can see the list of remote data sources that are supported under SAP HANA Smart Data Access for SPS06 and SPS07 and the operations supported −SAP HANA VersionsSPS06SPS07 or higherSupported Data Sources under Smart Data AccessSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higherSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higher Oracle database 12c MSSQL version 11 for SQL Server 2012 IBM DB2Operations SupportedSelectSelect, Insert, Update and Delete

In SAP HANA SPS07, it has been extended to MSSQL server and Oracle database and write operation was permitted to perform on remote data sources.Following remote systems are allowed under Smart Data Access with Write operation in SAP HANA SPS07 −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c

_SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository.  When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.These column views are used by front-end tools like BusinessObjects to get the data in a query._SYS_BI:This schema in HANA system stores table created for variables, time dimension- Gregorian, Fiscal and schema and content mapping tables.

Common system schema are −_SYS_BIC_SYS_REPO_SYS_BI_SYS_XS_SYS_STATISTICS and many more

Following objects are available in a Package under Content tab in HANA system −Attribute ViewsAnalytic ViewsCalculation ViewsAnalytic PrivilegeStored ProceduresSub-PackagesDecision Tables

In SAP HANA Studio, Content folder contains all the design time repository objects. In this folder, all objects created in HANA system are managed under packages. To create a new object, you have to first select a Package.In a package you have different HANA Modeling Views- Attribute Views, Analytic Views, Calculation Views and Analytic Privileges. Each of the object type is managed in different folder in a package.

It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews

In Catalog folder, you can see all the database objects in SAP HANA system. You can see the list of all schemas in HANA database and each schema contains different Database objects inside it. In below pic, you can see different database objects under AA_HANA11 schema object.

This can be checked in Backup configuration in HANA Studio. In Overview tab, you can see status of Currently Active Data Backup.

Backup folder in SAP HANA Studio can be used to manage backup properties in HANA system. Backup properties under HANA system are specific to that system.To see the backup configuration, you have to double click on Backup folder. HANA Studio opens the backup configuration for HANA system −