Skip to Content
avatar image
Former Member

C4C Smart data access for initial load

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers