Referencing Files on Object Storage

Access to files is typically required in Batch processes. Some batch processes include direct reference to the files they need to process (for input or output) while some processes rely on additional configuration (for example, the Configuration Migration Assistant (CMA) Import and Export processes that rely on the CMA Master Configuration Settings).

Direct Reference

Reference to Object Storage can be used anywhere that a file location is allowed. The format is:

file-storage://<File Location>/<Bucket>/<Filename.ext>

  • <File-Location>: The File Storage Extendable Lookup value that is defined for that file.It should include all the details the system needs to access the Object Storage location for that file.

  • <Bucket>: The equivalent of a Folder in the Oracle Cloud Object Storage.Since the folder structure in Object Storage is flat, Buckets cannot include other Buckets and therefore only one Bucket can be noted here.

CMA Master Configuration

CMA Master Configuration includes the location of files for export and import processing:

  • Import Folder: should reference a file location for an Object Storage Bucket(i.e. just the file location without the a file name, for example: “file-storage://CMALocation/CMA-Files”), “CMALocation” is the File Location Extendable Lookup name.

  • Export Folder: should reference a file location for an Object Storage Bucket (e.g “file-storage://CMALocation/CMA-Files”).
    Note: In order to take advantage of the automation of migration of configuration data from one system environment to another via the Process Automation Tool, the Import and Export directories have to point to the same location!

Conversion Data Upload Processes

The batch process that loads customer data files into the cloud (K1-CNVLD) using SQL Loader has two parameters that describes where to get the input data files and where to store the output files:

  • inputFileStorage: should reference a file location for an Object Storage Bucket (e.g. “file-storage://CONVLocation/Input”),“CONVLocation” is the File Location Extendable Lookup name.

  • outputFileStorage: should reference a file location for an Object Storage Bucket (e.g. “file-storage://CONVLocation/Output”).