The SQL Query Viewer Web Part allows to query external SQL Server databases and displays the result as a pageable list without having to resort to Sharepoint Designer.
The Web Part can be used both with Windows Sharepoint Services V3 and MOSS.
The following parameters can be configured:
- Database Connection String (supports both SQL Server and Windows Integrated Security)
- SQL Select statement
- Number of rows displayed per page
The Enterprise version ($200) adds OLE-DB data source support (MS Access, Excel, CSV, Oracle etc.) and allows to create Web Part connections (row filters etc.)
Free (no time restriction) evaluation version available