OHDSI Home | Forums | Wiki | Github

ETL-CDMBuilder Redshift connection String

Driver={Amazon Redshift (x64)};Server=xxx.redshift.amazonaws.com;Database=xxx;Sc=your_schema_name;UID=xxx;PWD=xxx

Anton - that helped. Thanks a lot!
I have a followup question in the configuration file - regrading the following strings - what is the ec2 part doing - is it supposed to spin instances or such?
Thanks!!
s3_aws_access_key_id" value=""/>
s3_aws_secret_access_key" value=""/>
ec2_aws_access_key_id" value=""/>
ec2_aws_secret_access_key" value=""/>

bucket" value=""/>

t