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 in the Properties window, and click the Properties icon.
Add the connection parameters. See the “DB Data Provider Index Load properties list” for specific field requirements. You must add a valid interface and host name.
Click Finish.
In the Properties window, 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 and select Reset Execution Properties.
