Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Anil SAP Gupta
Page 4 of 10
Components in SAP HANA multi-system architecture
Each HANA system contains multiple serves inside, which are responsible to perform different functions. Index Server is heart of SAP HANA system which contains SQL/MDX processor for handling SQL statements. Key component includes −Index ServerPreprocessorName ServerStatistics ServerHANA XS EngineSAP Host AgentSAP Solution Manager Diagnostic AgentSAP HANA Studio + RepositorySAP HANA Software Update Manager SUM
Read MoreCreating virtual tables from remote source in SAP HANA
When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.To add a table as a virtual table, you need to navigate to remote data source → Schema name → Table name → Right-click and Add as Virtual TableBelow shows how you can add a table as a Virtual Table using HANA Studio.
Read MoreContent of property_orcl.ini file in SAP HANA Smart Data Access
When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With the use of config file- features, function mappings, data type mappings, and other properties will be linked together with the data source. This decides the communication between the SAP HANA and the data source.You can see part of the content of property_orcl.ini shown below −
Read MoreDifferent ODBC connection types under SAP HANA Smart data access SDA
You can check the following example to create a new remote source −CREATE REMOTE SOURCE TEST_11g ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral11g_lnx’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In above SQL statement, can be one of − ASEODBC, IQODBC,TDODBC, HIVEODBC,ODBC. Obviously, ASEODBC is for Sybase ASE as data source, IQODBC is for Sybase IQ, TDODBC is for Teradata Database, HIVEODBC is for Hadoop.
Read MoreConnecting to MSSQL, MaxDB using SAP HANA Smart Data Access
In SAP HANA SPS07, following data sources are supported under Smart data access −Sybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12cWhen you click on the Adapter name while creating a new remote data source, you can see a list of all supported databases.You can also see in the above snapshot that all databases use the ODBC connection for a remote data sources.
Read MoreResetting a customized Perspective in SAP HANA Studio
Yes, if you customize a perspective, and you want to reset it, you can select Reset PerspectiveHere you have an option that allows you to perform following options on a Perspective −Customize PerspectiveSave PerspectiveReset PerspectiveClose PerspectiveClose All Perspective
Read MoreUse of Data Foundation in Attribute view in SAP HANA
When you enter the Attribute name, Type, and Subtype and click on Finish, it will open three work panesScenario pane that has Data Foundation and Semantic Layer.Details Pane shows attribute of all tables added to Data Foundation and joining them.Output pane where we can add attributes from Detail pane to filter in the report.You can add Objects to Data Foundation, by clicking on ‘+’ sign written next to Data Foundation. You can add multiple Dimension tables and Attribute Views in the Scenario Pane and join them using a Primary Key.
Read MoreCreating an Attribute view in SAP HANA
To create a new Attribute view, select the Package name under which you want to create an Attribute View. Right Click on Package → Go to New → Attribute ViewClick on Attribute View, and this will open a new Window. You need to pass Attribute View name and description. From the drop-down list, choose View Type and subtype. In subtype, there are three types of Attribute views − Standard, Time, and Derived.Once you finish the wizard, you can see view is created under the specified package.
Read MoreOpening SAP HANA Cockpit from HANA Studio
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications.Following roles are required to open and access tile-based SAP HANA Cockpit − sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: AdministratorYou can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system -> Configuration and Monitoring -> Open SAP HANA Cockpit.You can also open HANA Cockpit in an offline mode using a ...
Read MoreIndex server in SAP HANA system
Index server contains SQL/MDX processor to handle query statements for the database. When SQL or MDX is fired for SAP HANA system, an Index Server takes care of all these requests and processes them. All HANA processing takes place in Index Server.Index Server contains Data engines to handle all SQL/MDX statements that come to HANA database system. It also has Persistence Layer that is responsible for durability of HANA system and ensures HANA system is restored to most recent state when there is a restart of system failure.Index Server also has Session and Transaction Manager, which manage transactions and keep ...
Read More