Amazon Storage Connection Manager
PreviousNext

Amazon Storage Connection Manager can be used to connect to AWS Storage Services such as S3, DynamoDB, Redshift Cluster. You can supply your Accesskey and Secret Key (Or use Temporary credentials with Session Key) to connect to various services.

Download SSIS PowerPack

Content

Video Tutorial

Properties

Property Name Description
AccessKey
ServiceUrl
UseRegionSpecificEndpoint Set this option to true if you connecting to specific region rather than US Standard. By default all requests made to US Standard region first and then it obtains correct region information for your request but in some rare case AWS server doesn't return correct region and it throws Bad Request error. Setting this option to true can help you to fix such errors. Leave this option to false if you are not sure about your region.
Encrypt If you want to enable encryption for content uploaded or downloaded to and from Amazon S3 then check this option. This is not valid for ServiceType=DynamoDB
EncryptionAlgorithm Algorithm for encryption. Supported algorithms are AES256 and RSA1024. If SSS3 connection is used for Redshift data transfer then only AES256 is supported.

Available Options

Option Description
Notset Notset
ASE256 ASE256
RSA1024 RSA1024
EncryptionKeyFile Path of secret encryption key file. Key file content is in base64 format for AES and for RSA encryption key file content is XML format. You can open it in notepad and validate if key is in right form.
ServiceType

Available Options

Option Description
S3 S3
DynamoDB DynamoDB
Redshift Redshift
Notset Notset
Region
UseHttp
SecretKey
CredentialType

Available Options

Option Description
KeyBasedAccess key-based access control
TemporaryToken temporary token credentials
SessionToken
ProxyPassword
ConnectionString
ProgressUpdateInterval Update interval in KB. System will report upload/download progress based on this setting. By default progress is reported every 1000 KB.
Timeout
MaxRetryOnError
RetryInterval
MaxParallelThreads

Screenshots

Amazon Storage Connection Manager UI

Amazon Storage Connection Manager UI

Amazon Storage Connection Encryption Options for S3

Amazon Storage Connection Encryption Options for S3

Amazon Storage Connection Proxy Options

Amazon Storage Connection Proxy Options

Amazon Storage Temporary Credentials for AWS (Session Token and temp AccessKey, SecretKey)

Amazon Storage Temporary Credentials for AWS

See Also

References


Copyrights reserved. ZappySys LLC.