Skip to Content

C4C Smart data access for initial load

Oct 09, 2017 at 11:23 AM


avatar image
Former Member

We are on HANA version Hana1SP12(on premise) We have defined a remote table based using Smart Data Access Odata url. We connect to SAP C4C instance to fetch data. We want to do a initial load of a table which has 200k rows. When I do a select * from the remote table it takes lot of time and I have to cancel the query. The select statement works well for a smaller subset of rows ( 100 rows).

Is there any performance tuning option / Best practice we can use in HANA to fetch large rowsets from SDA remote data source.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers