HANA Set-up END – TO – END scenario
Set up the core SAP HANA Scenario:
1.Installation sequence provided by docupedia:-
Use the End – to – End roadmap:
- Installing SAP HANA
- Installing the SAP in-memory computing engine (IMCE) server 1.0
- Installing the SAP in-memory computing engine (IMCE) clients 1.0
- Installing the SAP In-memory computing studio (including SAP HANA models)
- Installing the SAP host agent
- Installing the Sybase Replications Server
- Installing the SAP HANA load controlled options,
- Installing the SLT Replication server
Setup core HANA scenario
Installation sequence provided by docupedioa:
Use the End – to – End road map:-
- Installing SAP HANA
- Installing the SAP IN-memory computing eng line (IMCE) server 1.0
- Graphic tool: ./hdb setup
- Command tine tool: ./hd best
Installations details – IMCE 1.0
Set up options and useful cheeks – 3
- Installations/upgrades are always done with the root user. ser ./hdbinst
- Use the user combination SYSTEM/manager and change the password awards
- The setup of the IMCE can be restarted again. It will continue at the point where it stopped (unexpectedly). Use ./dbinst –S <SID> use./hdbunist – k to kepp data / <SID>
- Whose the Installation/upgrade process is pinioned Allow up to 500 see. To completely stack the IMCE
Instance otherwise you will get follow up errors with the Index serer and inconsistent system up
If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administartion Training" This course will help you to achieve excellence in this domain.
- For Installing HANA, we need to Install like IMCE ODBO 00
IMCE JDBC 1.00 IMCE ODBC 1.00 IMCE SQLDBC 1.00
2.Create an ODBC Connection:-
- Go to
Start Settings Control panel - Click on administration tools
- Double click on Data Source (ODBC)
- Click on system DS (tab)
- Click on add
- Will get the available source
- Select HANA DB
- Will get dialogue box t to provide
- Source Name:
Server name: Database :
- Click on connect
- Provide a port number:
- User name :
- Password :
OK
3.Adding system (HANA system) in SAP HANA STUDIO
Right-click on navigation control
- Provide the Host system:
- Instance number:
- Name the system:
Language:
- Click on next
Provide JDBC connection for HANA system
NOTE:-
If the database system is ‘Up’ (running) then we will get ‘GREEN’ color staties other were it will should ‘RED color’ Procedure to state HANA DB:- Before string ‘SAP’ we need run the UNIX server
- Log on to extra putty & provide the IP address of HANA DB
- Select SSH (to provide secured connection)
- To start SAP to provide command
NOTE:-
while adding the system we need to provide select user ID & password otherwise will get RED stales After creating the system will get two components
- content &
- Catalog
- Content:- It is organized packages
- We have two types of package: 1) structural
2) Non – structural Packages which is used to organized view (information models)
- Catalog:- It is mainly used to organize standard & custom schemas as well as administration control & public synonyms
- Catalogs are used to organize column views, views, tables & procedures.
- Column views are used to organize information models (attribute, analytical, calculated views)
- We have two types of schemas: 1)standards &
2)Customize For customized schema we need to write SQL command in SQL editor.
- To create schema will provide below command
- Create schema <schema-name>
- To SAP HANA delivered some standard schemas
They are 1. System User management data
- sys which holds all system-related tables
- IC – tables – which the composer holds the tale created information
- - sys – sys BI Metadata for created views + Master data of MDX
- - sys – BIC some generated tables of MDX as – well as holds to create in BD.
- - sys – repo EG: list of active/modified versions or models
- -sys – STATISTICS It contains monitoring and performance statistics
- Authorization components that organize roles & users.
- Public synonyms which hold for system-related tables
Get In-Depth Knowledge on SAP Hana Click on: