Integration with AWS Redshift

Unknown

Integration with AWS Redshift

Unknown

[color=rgb(34, 34, 34)]Youll have to make use of ODBC Database Integration to achieve this. [/color]
[color=rgb(34, 34, 34)]
[/color]
[color=rgb(34, 34, 34)]To do this,[/color]
[color=rgb(34, 34, 34)]1. Navigate to System → Integration → Databases → Create Connection. [/color]
[color=rgb(34, 34, 34)]2. Choose Database Type as ODBC.[/color]
[color=rgb(34, 34, 34)]3. Pick ODBC DB Type as Redshift AWS.[/color]
[color=rgb(34, 34, 34)]
[/color]
[color=rgb(34, 34, 34)][img]https://i.imgur.com/s6KTW8c.png[/img][/color]
[color=rgb(34, 34, 34)]
[/color]

[color=#222222]You will need to specify the username and password for your Redshift connection in the Connection String property. I have included a sample connection string format below -

[/color]
[color=rgb(34, 34, 34)][font=georgia, serif]Driver={[/font][/color][font=georgia, serif][color=#ff0000]driver[/color][/font][color=rgb(34, 34, 34)][font=georgia, serif]};Server=[/font][/color][font=georgia, serif][color=#ff0000]endpoint[/color][/font][color=rgb(34, 34, 34)][font=georgia, serif];Database=[/font][/color][font=georgia, serif][color=#ff0000]database_name[/color][/font][color=rgb(34, 34, 34)][font=georgia, serif];UID=[/font][/color][font=georgia, serif][color=#ff0000]user_name[/color][/font][color=rgb(34, 34, 34)][font=georgia, serif];PWD=[/font][/color][font=georgia, serif][color=#ff0000]password[/color][/font][color=rgb(34, 34, 34)][font=georgia, serif];Port=[/font][/color][font=georgia, serif][color=#ff0000]port_number[/color][/font]