dbWebPart is a web component that facilities using, aggregating, analyzing and displaying data from several sources.
DbWebPart is a WebPart for Microsoft Office Sharepoint Server 2007, Sharepoint Portal 2003, Windows Sharepoint Services 3.0, Windows Sharepoint Services 2.0. We studied and implemented DbWebPart to allow database access in a supervised, quick, and secure fashion. This WebPart provides users with data and leave to the administrator the burden to control access through custom interfaces. The structure of tables, fields, data types, and properties are automatically loaded using configuration pages. These pages also allow to modify the view level by changing many available intuitive parameters.
DbWebPart allows to use CRUD (create, retrieve, update, and delete) on a specific table. Also it handles both the policies for data access and the graphic user interface. More powerful functionalities derive from the possibility of connecting more DbWebPart together on the same page. DbWebParts can communicate to each other by exchanging and merging data. These features allow users, with not too many technical skills, to create custom applications used to access enterprise data with few clicks.
Simple and intuitive, configuration pages allow users to set up every data-related property, including security and their presentation on the Web. Configuration parameters allow to control the access to database tables and fields for both groups and single user. In the same way, it is possible to set up permissions to access other various functionalities provided by the application.