Tutorialspoint

Connection used in SAP HANA Smart Data Access

I am creating a new remote data source in SAP HANA Smart data access. Which connection is used under Smart data access?
Anil SAP Gupta
Answered on 21st Feb, 2018

The remote system access communication is based on ODBC connection, and ODBC drivers for remote data sources: ASEODBC, IQODBC, and TDODBC. To create remote data source, Right click on Remote Sources -> New Remote Source

Connecting to MSSQL, MaxDB using SAP HANA Smart Data Access

In SAP HANA system, I want to use MSSQL to connect to database objects for performing HANA Modeling. Is it supported under Smart Data access?
Anil SAP Gupta
Answered on 21st Feb, 2018

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 Adapter name while creating a new remote data source, you can see list of all supported database.You can also see in above snapshot that ... Read More

Different ODBC connection types under SAP HANA Smart data access SDA

In SAP HANA Smart data access SDA, I have heard about different ODBC connection types- ASEODBC, IQODBC, and TDODBC. What is the difference between these?
Anil SAP Gupta
Answered on 21st Feb, 2018

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, <adapter_name> can be one of:  ASEODBC, IQODBC, TDODBC, HIVEODBC, ODBC. Obviously, ASEODBC is for Sybase ASE as data source, ... Read More

Content of property_orcl.ini file in SAP HANA Smart Data Access

I have heard about use of orcl.ini configuration file while creating a new remote source in SAP HANA Smart data access. What is the content of property_orcl.ini file?
Anil SAP Gupta
Answered on 21st Feb, 2018

When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With 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 ... Read More

Updating configuration property file in SAP HANA Remote source

In SAP HANA Smart Data access, configuration property file is used to perform function mappings, data type mappings and other properties will be linked together with the data source. Can I upd.....
Anil SAP Gupta
Answered on 21st Feb, 2018

Note that while modifying or creating the property configuration file, only the property which is different from default value needs to be set. The mistake in property configuration file may result in incorrect action or result of data source.

Creating virtual tables from remote source in SAP HANA

I have created a new remote source in SAP HANA Smart data access feature. Now I want to create virtual tables in HANA db to use. How this can be done?
Anil SAP Gupta
Answered on 21st Feb, 2018

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 remote data source in SAP HANA Studio. This can be done using GUI option.To add a table as virtual table, ... Read More

SQL statement to add a table as Virtual table in SAP HANA Smart Data Access

In SAP HANA Studio, I want to add a table as Virtual table under remote data source. Can someone provide me with a SQL statement to perform this?
Anil SAP Gupta
Answered on 21st Feb, 2018

You can use following SQL statement for this:CREATE VIRTUAL TABLE <table_name> <remote_location_clause>Example:CREATE VIRTUAL TABLE ABC.test_VT AT “ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;In this SQL statement, ABC.test_VT is Virtual table name“ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;- Remote location for creating Virtual table Read More

Components in SAP HANA multi-system architecture

What are the different components present under SAP HANA system architecture? We are using a distributed HANA environment. Can someone provide with more details?
Anil SAP Gupta
Answered on 21st Feb, 2018

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 statement. Key component includes:Index ServerPreprocessorName ServerStatistics ServerHANA XS EngineSAP Host AgentSAP Solution Manager Diagnostic AgentSAP HANA Studio + RepositorySAP HANA Software ... Read More

Functions of Index server in SAP HANA system

In SAP HANA distributed environment, I have heard that Index server is one of the key components. What are the different functions performed by Index server?
Anil SAP Gupta
Answered on 21st Feb, 2018

Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In ... Read More

Use of SQL/MDX processor in SAP HANA Index server

In SAP HANA system, how SQL and MDX transactions are processed? What are the different functions performed by SQL/MDX processor?
Anil SAP Gupta
Answered on 21st Feb, 2018

SQL/MDX processor in HANA system processes all SQL and MDX statements executed in HANA system. SQL statements are generated for all the tables, schemas and MDX statements are raised for OLAP data processing. SQL stands for Structured Query Language and is Relational database language to manage two dimensional objects in ... Read More

Different Engine types in SAP HANA Architecture

What are the different engine types in SAP HANA system to process SQL/MDQ queries? Which engine is used by which view type in SAP HANA?
Anil SAP Gupta
Answered on 21st Feb, 2018

In SAP HANA system, there are three basic engines used to processes queries in SAP HANA. Following engines are used:Join EngineOLAP EngineCalculation EngineJoin EngineUsed when querying an Attribute View in SAP HANAOLAP EngineAnalytic Views (without derived columns) use the OLAP EngineCalculation EngineCalculation Views or Analytic Views with derived columns use ... Read More

Using different Engine types in SAP HANA

In my SAP HANA model, my Analytic view is joined to an Attribute view. Which all engines are used in SAP HANA Modeling?
Anil SAP Gupta
Answered on 21st Feb, 2018

It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.

Handling failed transactions in SAP HANA system

in SAP HANA system, I want to understand how all transactions are handled- including running and closed transactions? Can someone help me to understand?
Anil SAP Gupta
Answered on 21st Feb, 2018

In SAP HANA system, Session and Transaction Manager is responsible to keep track of all the executed transactions in HANA database. It includes both running transactions and closed transaction. When a transaction in HANA system is failed due to any reason, Transaction Manager informs corresponding engine to handle the error.Session ... Read More

Handling user requests for applications based on HANA system

In SAP HANA system, I want to know how user requests are handled from web applications hosted on HANA platform. How the queries are processed?
Anil SAP Gupta
Answered on 21st Feb, 2018

It consists of various components as mentioned above for processing of SQL statements from application users hosted on the top of HANA system.User requests via user interface/web browsers are sent to Web server hosting application which is communicated to SQL/MDX Processor in form of SQL queries. These are further segregated ... Read More

Handling system failure, database corruption in SAP HANA

In SAP HANA system, how do we manage system or power failure issue or database corruption and perform data and log file restoration?
Anil SAP Gupta
Answered on 21st Feb, 2018

Persistence layer is used in case of system failure, database corruption or power failure to restore the database to most recent save point in HANA. Persistence Layer is responsible for data and transaction log backup and also to store configuration of HANA system.Backup of data and transaction log files are ... Read More

Advertisements
Loading...
Unanswered Questions View All

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.