Skip to Content
0

Hana Cloud Plaform (Connect Oracle)

May 25, 2017 at 01:12 PM

54

avatar image
Former Member

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?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Appleby
May 25, 2017 at 01:18 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded