FDA Connector Redshift to Adobe campaign

I would like to establish a connection between Aws Redshift and Adobe campaign.

can you just drive me what are all the details i need to establish a a connection. I do have Access to Redshift as well.

I know that we need server details of Redshift and do we need to create a seperate Account in Redshift