Looking for best approach.

Hi Gurus,

I am looking for the best practice to follow in calling a Web-Service from Oracle SOA CS.

My Requirement:

Need to extract all the employee details into PAAS DBCS.

Approach 1:

Submit BI Reports for all employees in a single shot. There may be 2,70,000 rows may be coming. with 10 columns.

Approach 2:

Modify the report and add EMP Parameter. and call the report for each and every employee.

There may be 2000 Employee(At maximum) and total rows for each employee will be max of 30.

So, i am looking for best approach,

in Approach 1, we single run but size would be very huge.