version: 1.0.0
Category: File System
Tier: 1
Type: Source, Target
Authentication:
Basic authentication. Enter the actual access key and secret key.
Temporary security credentials using assume role. Enter the secret access key and secret key of an IAM user with no permissions to access Amazon S3 bucket.
Files Supported:
Csv files
Excel Files
Supported Save Mode as Target:
Append
Overwrite
New
See: Target Connector Save Modes
Connection Properties
Name | Mandatory | Description |
---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of connection |
Folder Path | Yes |
|
Region Name (of the s3 bucket) | Yes | |
Access Key | Yes | |
Secret Key | Yes | |
IAM Role ARN | No | The IAM Role ARN for temporary credentials for credentials that has no direct access to s3 bucket but can assume a role |
External Id | No | Indicates the External id used for the IAM Role ARN (If necessary) |
Reading Objects
For excel objects indicate the choose the sheet name from the drop down
For date string handling See Date and DateTime String Handling in EazyDI