Control File Collection Strategy(3.2)
- Jenni Wallin
This section includes a description of the complementary Control File Collection Strategy that is applied in  
  for the Disk, FTP, FTPS, HDFS, SCP and SFTP Collection agents.Â
Overview
The collection strategy makes it possible to collect files for which a corresponding control file exist. If the control file does not exist, the file is ignored.
Configuration
The Control File Collection Strategy controls which further configuration options that are available in the Disk tab for Disk Collection agent, the HDFS tab for the HDFS Collection agent and the Source tab for FTP, FTPS, SCP and SFTP Collection agents. If no strategy is selected, the default strategy is used.
To Configure the Control File Collection Strategy:
Collection Strategy - Control File Collection Strategy
Note!
The Collection Strategy drop down list will only be visible if there are other collection strategies available in the system, apart from the default collection strategy available.
| Setting | Description |
|---|---|
Collection Strategy | Select the Control File option in this list. |
Directory | Enter the absolute path name of the source directory on the remote host, where the source files reside. The path name may also be entered relative to the home directory of the User Name account. |
| Include Subfolders | Select this check box if you have subfolders in the source directory from which you want files to be collected. Note! Subfolders that are in the form of a link are not supported. If you select Enable Sort Order in the Sort Order tab, the sort order selected will also apply to subfolders. |
Filename | Enter the name of the source files on the remote host. Regular expressions according to Java syntax can be used. For further information, see https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html. Example To match all file names beginning with |
Compression | Select compression type for the source files. This selection determines if the agent will decompress the files before passing them on in the workflow.
|
Position | The control filename consists of an extension added either before or after the shared filename part. Select one of the choices: Prefix or Suffix. Setting the option to Prefix will ensure that the text entered into the Control File Extension field will be searched for before the shared filename part and the Suffix option will ensure that the text entered in the Control File Extension field, will be searched for after the shared filename part. |
Control File Extension | The text entered in this field is the expected extension of the shared filename. The Control File Extension will be attached to the beginning or the end of the shared filename, depending on the selection made in Position. Note! The Control File Extension will help determine when the data files should be collected. Say for example the extension is set to |
Data File Extension | The Data File Extension will only be applicable if Position  is set to Suffix. There can be cases where a stricter definition of which files should be collected is needed. This is defined in the Data File Extension field. Consider a data file called Note! Consider a directory containing 5 files:
After collection, the control file is handled in the same way as the collected file is configured to be handled, that is the system should delete/rename/move/ignore it. |
If this option is selected, the source files will be moved to the automatically created subdirectory | |
Inactive Source Warning (h) | If this option is selected, a warning message (event) will appear in the System Log and Event Area when the configured number of hours have passed without any file being available for collection: The source has been idle for more than <n> hours,
the last inserted file is <file>. |
If this option is selected, the source files will be moved from the source directory (or from the directory Note! The Destination must be located in the same file system as the collected files at the remote host. Additionally, absolute path names must be defined (relative path names cannot be used). | |
If this option is selected, the source files will be renamed after the collection, and remain (or moved back from the directory | |
If this option is selected, the source files will be removed from the source directory (or from the directory | |
If this option is selected, the source files will remain in the source directory after the collection. This field is not available if is enabled. | |
Destination | If the  option has been selected, enter the full path name of the directory on the remote host into which the source files will be moved after the collection in this field. If any of the other After Collection options have been selected, this option will not be available. |
Prefix and Suffix | If any of the or options have been selected, enter the prefix or suffix that will be appended to the beginning or end of the name of the source files, respectively, after the collection, in these fields. If any of the other After Collection options have been selected, this option will not be available. Note! If  is enabled, the source files will be renamed in the current (source or |
Keep (days) | If any of the or options have been selected, enter the number of days to keep moved or renamed source files on the remote host after the collection in this field. In order to delete the source files, the workflow has to be executed (scheduled or manually) again, after the configured number of days. If any of the other After Collection options have been selected, this option will not be available. Note! A date tag is added to the filename, determining when the file may be removed. |
| Use File Reference/Route FileReferenceUDR | Select this check box if you want to forward the data to an SQL Loader agent. See the description of SQL Loader(3.0) for more information. |