Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a free Web UI that will bind to an sql server database and allow basic column filtering and data export?

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.

like image 739
Liazy Avatar asked Sep 03 '12 15:09

Liazy


Video Answer


1 Answers

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.

like image 96
Liazy Avatar answered Sep 22 '22 13:09

Liazy