SAP HANA is a tool that enables customers to analyze large volumes of SAP ERP data in real-time, avoiding the need to materialize transformations.
It is a combination of hardware and software that integrates a number of SAP components including the SAP HANA database, SAP LT (Landscape Transformation) Replication Server,
SAP HANA Direct Extractor Connection (DXC) and Sybase Replication technology.
SAP HANA database is not just a datbase but a Hybrid database because it is combination of other objects also. It is called sap In memory database also. SAP HANA is used to acess tables from the database.
You can run HANA for 3rd party S/W or non-sap systems for your real time anlytics.
Microsoft and BO BI 4.0 clients are recommended tools for reporting on SAP HANA.
The different HANA Clients are:
- ODBC Driver
- JDBC Driver
- ODBO Driver
- SQLDBC Driver
It has ODBC and JDBC both and you can combine it with other systems also in other words when we want to access "tables" directly instead of "Models" HANA is used. The main function of SAP HANA is to accelerate reporting over the massive amounts of data...It not widely accepted by SAP because it has limitations on number of table accessed.
In SAP HANA, we can create tables in two ways.
- Using SQL editor.
- Using Information Modeler.
Steps to connect to SAP HANA DB.
Select “DATA” and goto “ From Other Sources” and select “From Microsoft Query”
Now Choose the “Data Source” i.e. ODBC connection which you have created to SAP HANA DB.
It will ask for server name, user name and password
Now you can see that excel is trying to connect to the “Data Source”
Thus we are able to connect to SAP HANA DB and we can access “Tables” and “Views”.
Read Here for More SAP HANA Tutorials.