Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.