How to force a BSI SQL Adapter to re-import old data
Article ID: 113091
CA Business Service Insight
Sometimes, it's necessary to force a SQL Adapter to import data again, whether because old data has been corrected or the existing raw data has been removed for some other reason. How does the Adapter know what it has already imported, and therefore how can we change that?
Release: Component: OBLCRE
Adapters track the most recently read value in the output\datasourcecontrol.xml file to make sure old values are not read twice. Here are the contents of an example file after creating the adapter:
The query has one KeyField, called "ref_num". No rows have been read yet, so the LastValue is 0. After reading in and processing some rows, this will show the last (and therefore highest) value read, so the section might read