Skip to Content
avatar image
Former Member

Hana Database Encryption

We are in the process of implementing Hana DB in our environment. We are taking 15TB Oracle non-encrypted database to a Hana 6TB Database on Linux. I understand the concept behind encryption and the advantages and disadvantages of implementing it in the Oracle world.

My question is around the Migration and when to implement the Encryption. Per SAP, one should enable the encryption right after the Software installation and I think that it will slow down the Migration speed significantly. We have tables with Billions of rows and each data point now has to go thru the encryption Logic. We were wondering if it makes sense to implement the Encryption after the migration. That way we take out one big factor.

We are also not sold to the idea of Encryption. Do you guys have any suggestion/Recommendation?

Thanks in Advance!!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 20, 2016 at 01:59 AM

    SAP HANA encrypts data on the persistence level - not row-wise and not while the data in in memory.

    The encryption is part of the so called savepoint process, which runs, for the majority of it, asynchronously.

    The estimated overall performance impact of activating encryption is considered to be below 5% if I'm not mistaken.

    Based on that I don't expect a high impact on the overall migration runtime.

    Add comment
    10|10000 characters needed characters exceeded