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.
New Record Detection Property Page |
The New Record Detection property page enables you to configure how the Integration Service detects database updates for your Database integration.
Database Connection
Database Connection Setup: Opens the Database Setup Wizard, where you can connect to the database that you want the Integration Service to monitor. For more information about using the Database Setup Wizard, refer to
Database Type: After you have completed the database connection setup, this field displays the database type.
Location: After you have completed the database connection setup, this field displays the location of the database.
Poll Interval: Specifies how often the Integration Service checks the database for changes.
New Record Detection Method
The new record detection options enable you to specify the database trigger event that the Integration Service will detect and which database records it will process.
|
|
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. |
Use all records and remove when done: When you select this option, the Integration Service processes all the records in the specified database and either deletes all the records after processing or copies them to another table. This option is available for database connections that can be updated and where the monitored table has a primary key. A primary key is essential to find the exact record to delete or copy.
Copy to other table: 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.
Table: Specifies the table that you want the processed database records copied to.
Field has increasing value: When you select this option, the Integration Service monitors the specified field for an increased value.
Field: Specifies the field that is to be monitored. This field must be a numeric field that increases in value, such as an auto-incrementing ID.
Last value: Specifies the value that the Integration Service monitors for. This field can be populated manually or automatically, as follows:
To populate the field manually, enter the value that will trigger the integration. For example, if the database contains rows that have the values 1 through 5, you can enter 3 in the Last value field to cause the integration to be triggered from 3 onward.
To populate the field automatically, click Reset to Last Field Value. The Integration Service will search for the highest value in the specified database field and then populate the Last value field with that value plus 1. The service will then monitor for the incremented value.
Reset to Last Field Value: Causes the Integration Service to search for the highest value in the specified database field and then populate the Last value field with that value plus 1. This incremented value also appears in the Next expected value field.
Next expected value: Specifies the value that the Integration Service uses to trigger the integration. This value is updated automatically in the following ways:
By triggering the integration
By manually adding a value to the Last value field and then clicking in any other field on the page
By clicking Reset to Last Field Value
Field has newer timestamp: When you select this option, the Integration Service monitors the specified field for a newer timestamp.
Field: Specifies the field that is to be monitored. This field must uniquely identify the record and must increase in value each time a record is created or updated.
Last value: Specifies the timestamp that the Integration Service monitors for. This field can be populated manually or automatically, as follows:
To populate the field manually, enter the value that will trigger the integration.
To populate the field automatically, click Reset to Last Field Value. The Integration Service will search for the highest value in the specified database field and then populate the Last value field with that value plus 1 of the smallest time unit. The service will then monitor for the incremented value.
Reset to Last Field Value: Causes the Integration Service to search for the newest timestamp value in the specified database field and then populate the Last value field to that value plus 1 of the smallest unit. This incremented value also appears in the Next expected timestamp field.
Next expected timestamp: Specifies the timestamp value that the Integration Service uses to trigger the integration. This value is updated automatically in the following ways:
By triggering the integration
By manually adding a value to the Last value field and then clicking in any other field on the page
By clicking Reset to Last Field Value
Field has specified value: When you select this option, the Integration Service monitors the specified field for a specific value. It then processes each record where the value is found in that field. This option is available for database connections that can be updated and where the monitored table has a primary key.
Field: Specifies the field that is to be monitored.
Value: Specifies the value that the Integration Service is monitoring for in the specified field.
Update field after processing: 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. Updating the value in the monitored field ensures that the record will not be re-processed when the database is next polled by the Integration Service. This option is available when the monitored table has a primary key. A primary key is essential to find the exact record to update.
New Value: Specifies the value with which to update the monitored field after the record has been processed.