Portlet Factory, Version 6.1.2

---

 

Adding an SQL Call builder to an existing model

Use the SQL Call builder to establish a database connection and retrieve data.

1. Place an SQL Call builder in a model.

2. Fetch datasource names and assign a datasource to the builder.

3. Use the builder's Database Explorer to locate tables or stored procedures or to generate a sample SQL statement.

4. Use the builder's ResultSet handling settings to format data returned by the query and transform results into XML for display.

5. Use a Data Page builder to display the data returned by the SQL Call builder.

Parent topic: Working with a database

---

Library | Support |