FAW: Automating the Upload Process of your Custom Data to Oracle Object Storage for Fusion Analytics Warehouse (Doc ID 2983912.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Purpose

This document provides steps to automate the upload process of your Custom Data to Oracle Object Storage for Fusion Analytics Warehouse

To upload datasets (xlsx and csv) to Oracle Object Storage Service (OSS) and then load the data to run analytics using the OSS Connector, you can take advantage of this sample script this will help optimize time and simplify the data refresh process.

If you have N number of data files to upload for the OSS Connector, then:
- You must create N number of csv-files where each files represents a datastore/table and its columns which will be uploaded as folder in OSS
- You must upload (N*2)+1(common-metadata) files.

By using this sample script approach you provide two values:
- The directory that contains datasets to be used in Fusion Analytics through the Oracle Object Storage Service Connector.
- The pre-authenticated URL for the OSS directory where you plan to upload the datasets.

The script creates and uploads all the (xlsx or csv) files to Oracle Object Storage while maintaining the directory structure. For more details about the data loading requirements.
For more details about the data loading requirements, refer to - Loading Data from Oracle Object Storage into Oracle Fusion Analytics

Scope

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.