cancel
Showing results for 
Search instead for 
Did you mean: 

EDW layer as HANA for Non SAP environment

Former Member
0 Kudos

Dear All,

We would like to build HANA as EDW Layer, Would please suggest best practice , Node configuration etc

Regards,

manoj.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Manoj,

I suggest you check out the material about BW on HANA on http://experiencesaphana.com.

There is no general answer, as the configuration highly depends on you data volume, update frequency, etc.

The largest single HANA server available comes with 2 TB of memory - that gives you about 1 - 1.2 TB in data storage (the rest will be used for processing the data). That doesn't sound like much, but early BW on HANA projects have seen a data volume reduction of about 1:5, so if your existing data warehouse is less than 5 TB, a single node might be an option...

If you go for a multi-node system, there's not a lot of options for landscape configuration. Just follow the [scaleout guide|http://help.sap.com/hana/hana1_imdb_scale_en.pdf]...

Not an official best practice, but personally I would say that bigger is better - so if you decide to build a multi-node landscape, I would go with XL servers...

cheers

--Juergen

Answers (1)

Answers (1)

tomas-krojzl
Active Contributor
0 Kudos

Hello,

Would please suggest best practice , Node configuration etc

If you are looking for SAP HANA sizing - then please check this SAP note:

Note 1514966 - SAP HANA 1.0: Sizing SAP In-Memory Database

Tomas