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