Force a SQL Adapter to re-import data

Products

• CA Business Service Insight

Issue/Introduction

Sometimes it is necessary to force a CA Business Service Insight SQL Adapter to import data again.

How does the Adapter know what it has already imported?

Environment

CA Business Service Insight 8.x and 9.x

Resolution

BSI 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:

<AdapterControl Save="end" LastSaveTime="2018/02/20 16:02:58"><Data><QueryCollection><Query QueryName="NewQuery"><KeyField Name="ref_num"><LastValue>0</LastValue></KeyField><LastFileName/></Query></QueryCollection>
    </Data></AdapterControl>

The query has one KeyField, called "ref_num".

In the example above, no rows have been read yet so the LastValue value is 0.

After reading and processing some rows, this will show the last (and therefore highest) value read, so the section might read

<KeyField Name="ref_num"><LastValue>10110</LastValue></KeyField>

If it is necessary to import everything again, stop the Adapter service, edit  the XML file and the LastValue entry to go back to where the import should start and restart the Adapter service.