20 © 2003-2020 Qlik Analytics (ISR) Ltd.
After the containers are added, some columns will update. Using Refresh will give a record
count for the header table for any Data Echo containers. The Status column is yellow until the
Data Wave Export ID is executed for the first time. The lightbulb will turn yellow in the
Transformation and Subset Sync columns if they are applicable to the data type.
Once the Data Wave Export ID contains the desired data types and scenarios, the user may
choose to back out to the main Data Wave screen to initiate the export process. However,
there is an optional set of post processing utilities that can be configured to execute after the
data import completes in the target system. This further enhances the export/import
automation, and the post processing utilities do not need to be manually executed in the
target system. Please Note: There are four utilities offered but not all may be required in
your target system.
Post Processing
The Post Processing options detailed below are all available as part of standard Gold Client.
For Data Wave, they can be configured for each Export ID to execute as part of the import
process. This should be executed in conjunction with the Import Options functionality where
the import process is automated. The goal of this is to execute any needed import post
processing utilities without manual intervention.
• Number Range Utility (Fig. 2.27) - This utility artificially inflates the number range
statuses (current numbers) in the target system. The table updated with this utility is
NRIV. It creates a buffer between the new data natively created in the target system
and the data imported from a source system using Gold Client. This avoids a duplicate
record error when additional data is imported from the source system and allows for
more flexibility to copy more data after the initial refresh.
Enter the percentage by which to inflate the number range status (current number) for
number ranges in the target system. The number range statuses, found on table NRIV,
are updated by the percentage increase requested in the utility. By default, all number
ranges are updated, but under Selection Criteria, this can be customized.
Figure 2.27