Drag the DB DataProvider Index 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.
Add the connection parameters. See the “DataProvider Index Load properties list” for specific field requirements.
You must add a valid interface and host name.
Click Finish.
In the Properties window, click the Ascending Index icon and select an ascending index attribute from the list of database objects.
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. See “Query Designer”.
In the Properties window, specify any other optional properties and database options.
Resetting the ascending index value
You cannot directly manipulate the persistent value of load index in the repository. However, you can reset the value to the one stored in the Load Index Value property. To reset execution properties:
Right-click the project in the Navigator.
Select Reset Execution Properties.
To update the port structure with changes made to the database:
Right-click the DB DataProvider Index 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.
