During the process of archiving, old data in DataProviders (DSO, ADSO, etc.) is moved to different storages. At the same time, each DataProvider can have several objects (e.g. queries) that are dependent on them. If dependent objects aren't adjusted, they would access only partial data.

The diagram below illustrates an example. We have the DSO object ZJG_DS2. A dependent object, in this example a query, reads data from this DSO. After archiving, a significant part of the data is archived into another storage. In this example into the Target storage table. The query reads after archiving only half of the data, as the other half can not be read by the query.

In this section:

To solve the problem, dependent objects like queries must be translated. It is necessary to perform this translation before the actual archiving process starts.

SNP OutBoard™ Data Tiering supports the automatic translation of dependent objects. The translation process consists of two steps:

Step: Impact analysis - is executed on the system and searches for dependent objects (like queries and lookups)
Step: Object adjustment - once the dependent objects are found, they must be adjusted. The adjusted dependent objects are added into transport and imported up the transport route (e.g to a production system).

Both steps are part of the DataProvider Wizard.

Browser not supported