Overview
Configuration is provided for establishing connections with Oracle Cloud Object Storage service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Manage remote files and directories
Use File Transfer Task to manage remote files and directories.
Advanced settings for managing file uploads
When uploading a file optional request headers can be specified. The headers can be specified in the File Transfer Task property AdditionalOptions. The property is optional and can be shown by clicking the Expand Options button.
The format of the property is [header name]=[value]. Multiple headers are separated by newline.
Example how to set canned access control list and server-side encryption:
x-amz-acl=private x-amz-server-side-encryption=AES256
To get full list of available headers for small files smaller than 20MB go to PutObject. For large files go to InitiateMultipartUpload.
Quick Start
In this guide, we will show you step-by-step how to create a connection to Oracle Cloud Object Storage REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Oracle Cloud Object Storage.
Step 3. Set [bucketnamespace] and [region] to the desired Bucket namespace and Region in the Server host parameter. Then provide Access Key and Secret Key in the grid below for the Access Key and Secret Key parameters.
Step 4. Click Test Connection to test your connection.
Congratulations! You have now established a connection to your Oracle Cloud Object Storage instance.
In this guide, we will show how to read data from the Oracle Cloud Object Storage service resource using the COZYROC REST Source component.
Step 1. Open the right side panel and drag and drop REST Source component. Double click on the REST Source component and select Oracle Object Cloud Storage connection from the combo. Select from available Oracle Object Cloud Storage resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 2. Click on the Columns tab and select Oracle Cloud Object Storage resource columns you want to read.
Step 3. If necessary, you can configure the Error Output.
Step 4. Click on Preview tab to view the retrieved data.
Step 5. Connect the newly created REST Source component to suitable Destination component and edit mapping.
Bravo! You have now learned how to read data from Oracle Cloud Object Storage service.
Step 1. Drag and drop REST Destination component from the SSIS Toolbox. Double click on it and select Oracle Cloud Object Storage connection. From the Resource drop-down menu select Object and from the Action drop-down menu select Create.
Step 2. Connect suitable Source component to the newly created REST Destination component and map columns.
Step 3. If necessary, you can configure the Error Output.
Configuration
Base URL address: https://[bucketnamespace].compat.objectstorage.[region].oraclecloud.com.
- Oracle Cloud Storage keys authentication
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Access Key: Required. Specify access key.
- Secret Key: Required. Specify secret key.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
{{=aws4s.makeAuthorization(request, connection)}} -
Host:
{{=request.signedRequest.headers['Host']}} -
X-Amz-Content-Sha256:
{{=request.signedRequest.headers['X-Amz-Content-Sha256']}} -
X-Amz-Date:
{{=request.signedRequest.headers['X-Amz-Date']}}
Documentation: https://docs.oracle.com/en-us/iaas/Content/Identity/Tasks/managingcredentials.htm#Working2.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/.
The result is extracted from:{{=utils.ensureArray(response.ListBucketResult.Contents)}}.The action has the following user-defined parameters:
- query-max-keys: Optional. Sets the maximum number of keys returned in the response. The response might contain fewer keys but will never contain more.
- prefix: Optional. Limits the response to keys that begin with the specified prefix.
The following request parameters will be automatically processed:
-
max-keys:
{{=parameters.get('query-max-keys')}} -
prefix:
{{=parameters.get('prefix')}}
- [Read] action
-
Endpoint URL address:
/{{=parameters.bucket}}.
The result is extracted from:{{=utils.ensureArray(response.ListBucketResult.Contents)}}.The action has the following user-defined parameters:
- bucket: Required. Name of a bucket in current namespace.
The following request parameters will be automatically processed:
-
bucket:
- [Create] action
-
Endpoint URL address:
/{{=item.Key}}.The following request parameters will be automatically processed:
-
application/octet-stream:
{{=item.Content}}
-
application/octet-stream:
- [Delete] action
-
Endpoint URL address:
/{{=item.Key}}.
- Key
Template: ShortText.
- LastModified
Template: DateTime. A read-only field.
- ETag
Template: ShortText. A read-only field.
- Size
Template: ShortText. A read-only field.
- Content
Data type: DT_IMAGE The value is gathered from
{{=item.Size ? '/' + item.Key : '' }}address.
- [Read] action
-
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
- [Create] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
item:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
item:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
Knowledge Base
Related scripts
What's New
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.