1. Data Loading Guide
  2. Uploading Data Files
  3. Upload Data into Object Storage

Upload Data into Object Storage

You can upload data into Object Storage.

  1. Open the Command prompt, then enter the following cURL command to upload the data.
    curl -v -X PUT --data-binary '@<full file path>' <your PAR URL><file name>
    The following table describes the place holders of the cURL command.

    Table 3-1 cURL Placeholders

    Place Holders Description
    <full file path> Enter the path of the file. For example, /filepath/20201218_STG_CASA_TXNS_1.csv
    <PAR URL> Paste the copied PAR URL. For example, https://objectstorage.us-phoenix-1.oraclecloud.com/p/IWWPtdM1MNr_VG-I2p5YJldIxnNgAwbMHdrTfnqr3rM/n/oraclegbudevcorp /b/fsgbu_aml_cndevcorp_qufspr/o/
    <file name> Enter the file name.
    • For non-split: Format: YYYYMMDD_Tablename.CSV

    For example, 20201218_STG_CASA_TXNS.csv

    • For split: Format: YYYYMMDD_Tablename_#.CSV, YYYYMMDD_Tablename_#.CSV.

    For example, 20201218_STG_CASA_TXNS_1.csv, 20201218_STG_CASA_TXNS_2.csv

    Note:

    For information about configuring Multiple Data Origin, see Multiple Data Origin Support.
    For example: 
    curl -v -X PUT --data-binary @/filepath/20201218_STG_CASA_TXNS_1.csv https://objectstorage.us-phoenix-1.oraclecloud.com/p/IWWPtdM1MNr_VG-I2p5YJldIxnNgAwbMHdrTfnqr3rM/n/oraclegbudevcorp/b/fsgbu_aml_cndevcorp_qufspr/o/20201218_STG_CASA_TXNS_1.csv
  2. Press Enter. Data is successfully pushed into the Object Storage Standard Bucket.

    Note:

    • The status response code must be: < HTTP/1.1 200 OK>
    • If there is any error message, you must provide the correct details and try again. If this issue persists, contact My Oracle Support.
    • To ensure that all data files that are required to be processed in the Object Storage, you must also upload the File Watcher file with yyyymmdd_filewatcher.txt format in the Object Storage. Until this file is not available in the Object Storage, the data loading process will not be initiated.
    • If the data loading batch is initiated but the File Watcher file is not present in the Object Storage, the batch will wait until the file is uploaded. The waiting period for the batch to look out for the File Watcher file is five (5) hours.
    To load data files from the Object Storage Standard Bucket to the application staging table, see Load Data Files.