Raw data access

Question

Hello

I'm looking for the best way to give end users access to raw data (100 000+ rows).

Currently I see only two options, but in the end both have some issues and that's why I'm looking for sth else, any ideas?

• SSRS reports (+ easy and user friendly; - poor performance with current size of database)
• SQL views (+ good performance; - too complicated for non tech users)

Background: application has web based front-end; back-end is on SQL server; app don't has any built-in export option; above 500 users

Appreciate your suggestions...

Answer 1

Hi,
Have you thought about using Master Data Services? I swear by it and have just implemented another production system.
It has a spreadsheet appearance to it, data can be sorted and filtered, and more importantly securely controlled.
You may want to have a look at an article that I just posted on my website.
Http://infogoldusa.com

As always, should you wish to take this one further, please feel free to contact me at [e-mail]
Regards Steve Simon SQL Server MVP

Answer 2

Just a thought, but had you considered using both?  Create your view in SQL Server.  Then in SSRS, create a "Shared Dataset" that pulls from the view.  Not sure if that's a win win in this case, but maybe worth a try...