Register root folders for File Watcher watched folders

This set of profiles tells the system where to look for SAS and text data files to be loaded into Oracle DMW. There are nine profiles. You enter values for either:

  • Three folders, one for each lifecycle. Both SAS and text files are placed in the same folder.
  • Six folders, one for each lifecycle/file type combination.

You must create the root folders in the locations you specify here. All studies in this Oracle DMW instance must use the same three or six root folders for their input data files. The system creates a study-specific subfolder in each root folder using the name you specify; see Create study File Watchers. The study-specific subfolders become the watched locations for the study.

Note:

If you change these profile values after using them, you must stop and restart the File Watcher service; see Changing the root folder location for data files.

  1. Log in. See Set profiles to determine system behavior.
  2. In the Profile field, enter Oracle DMW:FWR_ROOT_FOLDER%
  3. Click Find.
  4. In the Site column, enter the full path to the subfolder for the profile's file type/lifecycle combination. Oracle recommends using a naming convention so that it is easy to tell which folder should hold which files. Enter values for either the first six profiles or the last three.

    If you want to use six file type-specific root folders, enter values for these profiles:

    • DME:FWR_ROOT_FOLDER_TEXT_DEV for text files in the Development lifecycle.

    • DME:FWR_ROOT_FOLDER_TEXT_QC for text files in the Quality Control lifecycle.

    • DME:FWR_ROOT_FOLDER_TEXT_PROD for text files in the Production lifecycle.

    • DME:FWR_ROOT_FOLDER_SAS_DEV for SAS files in the Development lifecycle.

    • DME:FWR_ROOT_FOLDER_SAS_QC for SAS files in the Quality Control lifecycle.

    • DME:FWR_ROOT_FOLDER_SAS_PROD for SAS files in the Production lifecycle.

    If you want to use three folders for both file types, enter values for these profiles:

    • Oracle DMW:FWR_ROOT_FOLDER_ALL_DEV for SAS and text files in the Development lifecycle.

    • Oracle DMW:FWR_ROOT_FOLDER_ALL_QC for SAS and text files in the Quality Control lifecycle.

    • Oracle DMW:FWR_ROOT_FOLDER_ALL_PROD for SAS and text files in the Production lifecycle.

  5. In the File menu, select Save and Proceed.