I have one view created in oracle database and I need to display some reports based on it on a SharePoint 2013 enterprise farm.

I want to know which approach is preferable, should I create a BCS eternal list to generate the reports on or should I generate SSRS directly using credentials?

Can anyone suggest me the best way to achieve this?

1 Answer 1


I can think of absolutely no reason to use an external list for SSRS when a direct Oracle connection is available. I also think your performance would be much better, depending on the size of the view. There's no downside to the direct connection, save BCS external lists for use as a column type.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.