How to connect to AWS Redshift

[nickchang_1]

I have set IAM role.

Policy 

{ "Version": "2012-10-17", "Statement": [ { "Sid": "Stmt1416984435000", "Effect": "Allow", "Action": [ "ec2:*" ], "Resource": [ "*" ] }, { "Sid": "Stmt1416984459000", "Effect": "Allow", "Action": [ "rds:Describe*" ], "Resource": [ "*" ] } ] }[/code] 

{ "Version": "2012-10-17", "Statement": [ { "Sid": "Stmt1416980380000", "Effect": "Allow", "Action": [ "redshift:Describe*" ], "Resource": [ "*" ] } ] }[/code]

But, I always can't connect to AWS Redshift

Always tell me, unknown host

Can everyone tell why ??

Thanks

[nthapa]

Did you go through this document 

http://community.jaspersoft.com/documentation/v561/jaspersoft-aws-user-guide, page 6 ?

[nthapa]

This might also be useful.

https://community.jaspersoft.com/questions/820159/aws-unable-connect-redshift

[alampitt]

It's advised to use the cloud formation templates here in launching:

http://community.jaspersoft.com/jaspersoft-aws/launch

And then the Redshift instance can be auto-detected and ease connecting as here:

http://community.jaspersoft.com/jaspersoft-aws/connect