Group Discounts available for 3+ students and Corporate Clients

HANA Set-up END – TO – END scenario

HANA Set-up END – TO – END scenario:-

Set up 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

 

Screenshot_81

 

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 binst

 

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 restated 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 other wise you will get follow up errors with the Index serer and inconsistent system up

  • For Installing HANA, we need to Install like
    IMCE ODBO 00

IMCE  JDBC                        1.00

IMCE  ODBC                      1.00

IMCE  SQLDBC 1.00

 

  1. Create a ODBC Connection:-

  • Go to UntitledStart   Untitled   Settings  Untitled Control panel
  • Click on administration tools
  • Double click on Data Source (ODBC)
  • Click on system DS (tab)
  • Click on add
  • Will get available source
  • Select HANA DB
  • Will get dialoge box t provide
  • Source Name:

Server name:

Data base       :

  • Click on connect
  • Provide port number:
    • User name :
    • Password :

OK

  1. Adding system (HANA system) in SAP HANA STUDIO

Right click on navigation control

 

  • Provide Host system:
  1. Instance number:
  2. Nameey the system:

Language:

  • Click on next

Provide JDBC connection for HANA system

NOTE:-

If data base 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 UNUX server

  • Log on to extra putty & provide IP address of HANA DB
  • Select SSH (to provide secured connection)
  • To start SAP to provide command

NOTE:-

while adding system we need to provide select usr ID & password other wise will get RED stales

After creating system will get two components

  1. content &
  2. Catalog

 

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

  1. 2. Catalog:- It is mainly used to organize standard & custom schemas as well as administration control & public synonyms
  • Catalogs which 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   Untitled  User management data

  1. sys          Untitled which holds all system related tables
  2. IC – tables – which composer holds the tale created information

– sys – sys BI        Untitled  Meta data for created views + Master data of MDX

  1. – sys – BIC Untitledsome generated tables  of MDX as – well as holds to  create in BD.
  2. – sys – repo  Untitled EG: list of active / modified versions or models
  3. -sys – STATISTICS  Untitled It contains monitoring and performance statistics
  • Authorization components which organizes roles & users.
  • Public synonyms which holds for system related tables

 

 

 

 

 

 

 

 

 

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on HANA Set-up END – TO – END scenario"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6