For text-based database types, such as Text File, Microsoft Excel, and Microsoft Access, Integration Builder supports only the Field has increasing value and Field has newer timestamp new record detection methods.
新记录检测属性页 |
通过“新记录检测”属性页可以配置 Integration Service 为“数据库”集成检测数据库更新的方法。
数据库连接
数据库连接设置： 打开“数据库设置向导”，可以在其中连接到希望 Integration Service 监视的数据库。 有关使用“数据库设置向导”的更多信息，请参见
数据库类型： After you have completed the database connection setup, this field displays the database type.
位置： After you have completed the database connection setup, this field displays the location of the database.
轮询间隔： 指定 Integration Service 检测数据库以进行更改的频率。
新记录检测方法
通过新记录检测选项可指定 Integration Service 将会检测的数据库触发器事件，以及其将会处理的数据库记录。
|
|
For text-based database types, such as Text File, Microsoft Excel, and Microsoft Access, Integration Builder supports only the Field has increasing value and Field has newer timestamp new record detection methods. |
使用所有记录，并在完成时删除： 启用此选项后，Integration Service 会处理指定数据库中的所有记录并在处理后删除所有记录或将这些记录复制到其他表中。 对于可以更新并且其中受监视的表具有主键的数据库连接，此选项可用。 A primary key is essential to find the exact record to delete or copy.
复制到其他表： When this option is enabled, the processed records are copied to another table before they are deleted from the original table. When it is not enabled, the records are simply deleted.
表： 指定希望将处理的数据库记录复制到的表。
字段具有递增值： When this option is enabled, the Integration Service monitors the specified field for an increased value.
字段： 指定要监视的字段。 此字段必须为值递增的数值字段，例如自动递增的 ID。
最后一个值： Specifies the most recent value that was added to the field, incremented by 1. The Integration Service monitors for a value that is equal to or greater than the one that is specified. (You can manually enter a value in this field to be used for triggering the integration. If you do this, the values in the Last value and Next expected value fields do not change when you click Reset to Last Field Value.)
Reset to Last Field Value: When the user clicks this button, the Integration Service searches for the highest value in the database and then sets the value in the Last value field to that value plus 1 (unless the value in the Last value field was entered manually). This incremented value also appears in the Next expected value field (unless the value in the Last value field was entered manually).
字段具有更新的时间戳： When this option is enabled, the Integration Service monitors the specified field for a newer timestamp.
字段： 指定要监视的字段。 每次创建或更新记录时，此字段必须唯一标识记录并且值必须为递增。
最后一个值： Specifies the most recent timestamp that was added to the field, incremented by 1. The Integration Service monitors for a timestamp that is equal to or newer than the one that is specified. (You can manually enter a value in this field to be used for triggering the integration. If you do this, the values in the Last value and Next expected timestamp fields do not change when you click Reset to Last Field Value.)
Reset to Last Field Value: When the user clicks this button, the Integration Service searches for the newest timestamp value in the database and then sets the value in the Last value field to that value plus 1 (unless the value in the Last value field was entered manually). This incremented value also appears in the Next expected timestamp area (unless the value in the Last value field was entered manually).
字段具有指定值： When this option is enabled, the Integration Service monitors the specified field for a specific value. 然后再会处理该字段中找到值的每条记录。 对于可以更新并且其中受监视的表具有主键的数据库连接，此选项可用。
字段： 指定要监视的字段。
值： 指定指定字段中 Integration Service 为其监视的值。
在处理之后更新字段： When this option is enabled, the Integration Service is directed to update the monitored field, replacing the value that was detected with a new value. 在数据库接下来由 Integration Service 轮询的情况下，更新受监视字段中的值将确保不再重新处理记录。 此选项在受监视的表具有主键的情况下可用。 A primary key is essential to find the exact record to update.
新值： 指定在处理记录之后用来更新受监视的字段的值。