Configure Where to Load Data
Click the Configure External Storage button in the panel tab and select the Configure External Storage link to open the Configure External Storage dialog box, where you can specify storage areas into which Cloud data is loaded.
For example, to load into one or more Oracle Cloud Storage Service instances, select the Storage Service Connection Configuration tab. Select the OCI Object Storage Connection tab to configure Cloud Infrastructure connections, and select the UCM Connection Configuration tab to configure Universal Content Management Server connections.
Storage Type — Cloud Storage Service
To specify the connection details for one or more Oracle Storage Service instances, click the name of a provisioned connection or click Add to create a new connection. Click Delete to delete an existing connection.
Storage areas are associated with extract schedules. You can have as many Cloud Storage Service containers as are required by your Cloud application integrations, but each should be used for its own requirements, so that there's no overlap between them. Runtime metadata, including the last extract date, is managed across all storage locations, so configuring the same data store in multiple schedules with different external storage configurations results in loss of incremental data.
| Field Name | How to Use |
|---|---|
| Name | Specify a name for the connection. |
| OAC External Storage | Select this option if the connection is to an Oracle Analytics Cloud (OAC) storage service. You can specify only one OAC storage service connection. Note that encryption is disabled for OAC storage. |
| Protocol | Specify http for non-SSL, or https for SSL connection. |
| Host | Specify the Host name for the Oracle Storage Service. For example, mystorage.storage.oraclecloud.com. |
| Port | Specify the port number (optional). |
| User Name | Specify the user that is provisioned to load data. The user should have privileges to upload files in the container specified. User credentials will be stored in the Weblogic credential store under oracle.apps.security/FUSION_APPS_OBIA_STORAGESERV_USER-KEY. |
| Password | Specify the password for the user specified in the User Name field. |
| Service Name | Specify the service name of the Oracle Cloud Storage Service.
For example, gse-otbie1. |
| Container | Specify the name of the container that is allocated to upload extracted files. Click Refresh button to refresh the list of the containers. It's a good idea to check the storage service connection. Click Test Storage Service Connection to verify succesful connection. |
| Data Encryption — Support Encryption | If you want to encrypt communication, select this option and use the Import Certificate option to specify the encryption keys. |
| Import Certificate | Click Browse and navigate to and select the location of the key file, or type the literal path location and file name. |
| Download Folder | Shows the directory in the domain server where the Batch Extract file is downloaded to reset extract dates before the extraction process. |
| Upload Folder | Shows the directory in the domain server where files are temporarily extracted by the cloud extractor before uploading to the storage service. |
Storage Type — OCI Object Storage Connection
| Field Name | How to Use |
|---|---|
| Name | Specify a name for the connection. . |
| Host | Specify host name. Host information is available inObject Storeage Service API in the OCI API Documentation. |
| Tenancy OCID | Specify Tenancy OCID. To obtain the Tenancy and user OCID, refer to this to Where to Get the Tenancy's OCID and User's OCID. |
| User OCID | Specify User OCID. |
| Namespace | Specify the namespace. Namespace is obtained in the OCI Console. |
| Bucket | Specify the bucket into which extracts are uploaded. Bucket names are obtained in the OCI Console. |
| Generate API Signing Key | Generate the required API signing key for OCI. The fingerprint is displayed after generation. |
| Export Public Key | Export the public key for upload to OCI. |
| Test Connection | Test the connection. |
Storage Type — UCM
Review the connection details for Universal Content Management (UCM) using the following fields:
| Field Name | How to Use |
|---|---|
| Protocol | Specify http for non-SSL, or https for SSL. If you select https here, you must also enable HTTPS on the UCM server, using the UCM Server Console. |
| Host | Shows the host name for the UCM Server. For example, myserver.companyname.com |
| Port | Specify the port number of the UCM Server (optional). For example, 7012. |
| Test UCM Connection | Test the UCM connection. |
| Download Folder | Shows the directory in the domain server where the Batch Extract file is downloaded to reset extract dates before the extraction process. |
| Upload Folder | Shows the directory in the domain server where files are temporarily extracted by the cloud extractor before uploading to UCM. |