For the AWS Attunity Replicate AMI we have created an EC2 instance with a new IAM role and a security group.

For the ingestion from SQL Server Source to AWS Redshift Destination the AMI requires three connections namely SQL Server Source, S3 staging and Redshift Destination.
Out of these three connections I am facing issues with connecting to S3 staging -
The UI asks for an Access key and a Secret Key which we can get only if a user is created. We access the AWS account as federated users. I tried using temporary access and secret keys but the connection doesn’t seem to work. Do we need to create a user with a permanent access and secret key for this connection or is there a way around this ?

The error I get is

SYS-E-HTTPFAIL, Failed to connect Network Error has Occurred.

Looking forward to hearing back from you.

Thanks.