HANA Cookbook

Cookbook:  https://cookbook.experiencesaphana.com/

BW on HANA FAQ: https://www.experiencesaphana.com/community/solutions/net-weaver-bw/bwonhanafaq

SAP HANA DB Connect

SAP HANA as Source System for SAP BW through DB Connect:

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/84/0CB892EDFBC34290C1685132006662/content.htm?frameset=/en/4A/1DF9315C171B40E10000000A42189C/frameset.htm

Note 1597627 - SAP HANA connection
Note 1589983 - No DBCON entry possible for SAP In-Memory Database

Note 400818 - Information about the R/3 database library

SAP HANA Single Sign on

SAP  HANA Single Sign on

Single sign-on (SSO) allows a user to login once and gain access to multiple systems without being asked to login again. Depending on how SSO has been setup, this could permit the user login to just a front end application or it can enable SSO all the way down to the database in what’s known as SSO to database (SSO2DB).


https://websmp105.sapag.de/~sapidb/012003146900000774762013E/HowTo_HANA_SSO_Kerberos_v1_2.pdf



SAP Notes:

 Note 1813724 - HANA SSO/Kerberos: create keytab and validate conf

 Note 1837331 - HOWTO HANA DB SSO Kerberos/ Active Directory

SAP HANA

• SAP HANA is a flexible, data-source-agnostic appliance that enables customers to analyze large volumes of SAP ERP data in real-time, avoiding the need to materialize transformations.

• SAP HANA is a hardware and software combination 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 is delivered as an optimized appliance in conjunction with leading SAP hardware partners.

SAP HANA database

• The SAP HANA database is a hybrid in-memory database that combines row-based,

column-based, and object-based database technology. It is optimized to exploit the parallel

processing capabilities of modern multi-core CPU architectures. With this architecture, SAP

applications can benefit from current hardware technologies.

• The SAP HANA database is the heart of SAP’s in-memory technology offering, helping customers to improve their operational efficiency, agility, and flexibility.

Windows Server 2008 R2 Support

SAP Supports Windows Server 2008 R2.

Note:

Note 1152240 - Setting Up Microsoft SQL Server 2008 (R2).pdf
Note 1486772 - SAP Systems on Windows Server 2008 R2.pdf

ECC6 EHP3 Upgrade

Procedure:

1. Download EHP3 patches using solution manager mopz.
2. upgrade latest kernel, tp and r3trans.
3. extend the file system /usr/sap/trans - 25 GB and tablespace should not be full.
4. uncar all the addons and patches and put it in EPS/in.
5. transaction SAINT start
6. select all the components including addon patches.
7. ddic activation phase errors solve using the note no:1083533
DDIC Activation
- Activation errors may occur that can be solved by repeating the
activation phase. If errors occur, try to correct them.
- The following activation errors cannot be solved by repeating
the activation phase. For these, proceed as follows:
"Indexes 001 and KEY for table PFO_GO_00IS have identical
fields."
In transaction SE11, call the table PFO_GO_00IS in change mode,
and choose the menu 'Go to -> Indexes'. In the dialog box that
is then displayed, select the index 'KEY' and choose 'Delete
Index'. Do not activate Index 001 or the table, but continue
with the import in transaction SAINT. A corrected version of
this table is delivered with EA-APPL 603 Support Package 01.

8. Complete the installation.

ECC 6.0 IDES SR3 Harddisk Space Requirement

2. Hardware Requirements

DB size (GB):MS-SQL:190, ORACLE:290, MaxDB:240, DB2 Win/Unix:180, AS/400:340


3. File Sysem for Oracle shortcut:

/oracle- 300 GB
/sapmnt- 20 GB
/usr/sap<--->/sapmnt(softlink)

During the Sap Installation sapinst Creates the folders inside.





Regards,
Srinivasa Rao Arjala