6

I have been asked to find pre-packaged Web based UI that can be dumped on top of an SQL Server database and allow a non-technical user to browse it. The user must be able to:

  • Browse the table data.
  • Filter results on a per column basis.
  • Save the filters they have applied.
  • Export the data they are viewing to excel.
  • Has to be free for commercial use.
  • There is no need to write or edit the data.

Is there any such software package available?

So far I have looked at OData Explorer but I cannot find a way to save or export filtered data.

Edit: Ideally it should be Microsoft based .Net/Silverlight etc.

Liazy
  • 301
  • 2
  • 11
  • Something phpMyAdmin-ish comes to mind: http://stackoverflow.com/q/3103345/139010 http://stackoverflow.com/q/1372641/139010 – Matt Ball Sep 03 '12 at 15:16
  • There's plenty of links there for me to view so thanks for that @MattBall. They look like they may be quite technical though. I am looking for a data browser than an admin tool. – Liazy Sep 03 '12 at 15:33
  • SQL Server Master Data Services would also meet some of the requirements (although not all, hence not placing it as a full answer). It has a Silverlight-based web UI and comes with SQL Server (64-bit BI/Enterprise). It runs off its own database though, so you'd need ETL processes to keep everything in sync. – GShenanigan Mar 04 '15 at 14:48

1 Answers1

3

Though it does not quite conform to all the requirements above we have elected to use a Excel plugin called PowerPivot. We can easily create an OData Service that consumes our database and our users can then access the data directly through excel.

Liazy
  • 301
  • 2
  • 11