Skip to Content
avatar image
Former Member

Hana Cloud Plaform (Connect Oracle)

Dear friends, It is a pleasure to join the SAP HANA community.

I'm experiencing performance issues when loading information from my oracle onpremise database into the cloud.

Tables of 14 million records take 40 minutes to load with a dedicated bandwidth of 30 megs.

Is it normal that it takes so long?
I need to configure some or some parameters?
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • May 25, 2017 at 01:18 PM

    Let's challenge some assumptions first.

    1. Why do you need 14 million records on the SAP Cloud Platform (formerly HCP)? Is there a business case for a) that much data and b) storing it on the platform and c) presumably within a secured database?
    2. Why are you loading all those records to the platform instead of exercising pulls from the back end with limited queries as the users need? Is this to address a performance issue?
    3. If it is a performance issue, is it due to pulling too much data for the application's true needs? In over a decade of working with data transfers, when I see something like "14 million" records, my first suspicion is laziness on the part of the business analyst which determined that requirement.

    Perhaps you are trying to fix the wrong issue?

    Cheers, Mike

    SAP Technology RIG

    Add comment
    10|10000 characters needed characters exceeded