Configuring the Import Process
This section describes the setup needed to enable file import processing, including establishing communication between the Oracle Utilities cloud service and Object Storage, configuring batch parameters, and testing the process.
The following steps will enable file import batch processing to run and import the data from the import file to the appropriate application tables in the Oracle Utilities cloud service:
Setting Up Communication Between Cloud Service and Object Storage
The export process requires authentication and communication between the Oracle Utilities cloud service and Object Storage. See
Chapter 18:
Object Storage Connection Management for more information about setting up this communication and authentication.
Configuring File Import Batch Controls
The next step is to configure the following parameters of the file import batch control created earlier:
• File Name: The name of the file to import.
• File Path: the path to the file location in Object Storage where import files will be located. The format for the path is as follows:
file-storage://<File Location>/<Bucket>
where:
• <File-Location>: The File Storage Configuration extendable lookup value defined for that file location. This will include the compartment identification.
• <Bucket>: The object storage bucket in the compartment that is defined as part of the File Storage Configuration extendable lookup value.
For example, the "File-Import" bucket in a compartment that is referenced in the "INT-UPLOAD" File Storage Configuration extendable lookup value can be referenced as:
file-storage://INT-UPLOAD/File-Import
• Refer to the batch control for information about other parameters.
Testing the Import Process
The last step is to test the import process using the sample data.
To test the import process:
1. Run the file import batch process.
2. Navigate to the Batch Run Tree portal and make sure the batch process ran successfully.
3. Check that the records have been added to the FACT table.