Drag the DB DataProvider Full Load component onto the Design window. The Database Configuration window appears. Alternatively, to open the configuration window, select the component, and click the Properties icon in the Properties window.
Enter the connection parameters. See “DataProvider Full Load properties list”.
You must add a valid Interface and Host Name.
Click the Query icon. Create and save a query to retrieve the data set from the data source.
You can create a simple query directly in the Query window, or click the Query Designer icon to open Query Designer and generate queries. See “Query Designer”.
Click Finish.
In the Properties window, specify any other optional properties and database options.
To update the port structure with changes made to the database:
Right-click the DB DataProvider Full Load component.
Select Reconfigure.
The Reconfigure option updates the component configuration when there is a change in the database schema. It closes the current connection, opens a new connection to the database, reads the metadata of the query, and applies the updates to the port structure.
Updating port structure