cancel
Showing results for 
Search instead for 
Did you mean: 

Hana Cloud Plaform (Connect Oracle)

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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