Using Open Batches

The open batch functionality is used to read file-based data sources and import them into the appropriate POV based on the file name. This feature enables you to automate the process of loading large number of files. Open batches cannot contain jobs. Additionally, open batches can be scheduled to run periodically.

The high-level process overview of the Open Batches function consists of:

  1. In Batch Definition, create an openbatch folder in the application inbox\batches subdirectory where the files to be imported are copied.

  2. Select the File Name Separator character.

    This character is used to separate the five segments of an open batch file name.

  3. Select the Auto Create Data Rule option.

  4. Stage the open batch files by copying files to the inbox\batches\openbatch folder using the name format for batch files.

  5. In Batch Execution, process the batch.

    After a batch is processed, a directory is created, all files within the openbatch directory are moved into the new directory, and the new directory is assigned a unique batch ID