Adding DB Data Provider Index Load to a project opens a configuration window. Use the configuration window and properties section to define connection parameters, queries, and Ascending Index attributes.
To enter required properties
Enter the Connection Parameters as described in “Entering database connection parameters”.
Select the Ascending Index attribute from the list of database objects.
Select an attribute with values that increase whenever data is changed or added to the source, such as an auto incremental ID or a modification date. It is not required to have this attribute indexed on the database schema level; however, for performance reasons Sybase recommends that you create an index.
Enter a Query for the incremental load.
The selection criteria in the WHERE clause needs to be qualified using the predefined variable LoadIndex. Enclose the LoadIndex with square brackets, because it is evaluated before the query is sent to the database, for example:
SELECT * FROM SALES WHERE SA_DELIVERYDATE > '[LoadIndex]' ORDER BY SA_DELIVERYDATE
Quote characters differ between database systems. On
Microsoft Access databases, use # for datetime values.
