IBM® WebSphere® Portlet Factory provides a variety of database tools from high-level to low-level.
These tools allow you to connect to and interact with a database. In terms of functionality, the tools can be described as follows:
Relational Database New Model wizard
A wizard that walks you through the steps required to build a model that contains all the builders necessary to retrieve, create, update, edit, and delete database entries. This wizard provides the best solution for most general database tasks and will also construct an SQL query and set up page displays for the data.SQL Call builder
Use this builder if you need to run an SQL statement or stored procedure on a database. In addition to providing basic connectivity, this builder includes a database explorer that will assist you in constructing an SQL query. This builder also provides settings that allow you to control the formatting and translation of a returned result set.SQL Family of builders
Parent topic: Developing Web applications with IBM WebSphere Portlet Factory: wpf7