ODBC/DSN less connection to Redshift database in Alteryx

[Mahadeva]

Hi All,

I have multiple workflows which reads, transforms & writes data into RedShift database using ODBC/DSN connections.

However, the database connection details like server name, username, password etc. that are required to establish connection to the database would need to be fetched from AWS Secret Manager dynamically during run time so that any change in the connection details doesn't impact the workflow and also due to the security compliances.

Hence would like to know the feasibility and procedure to enable database connectivity dynamically within workflows without using the ODBC/DSN connections.

I'm using Alteryx Designer 2021.3 and the plan is to schedule these workflows at a fixed interval in the Scheduler available within Alteryx Designer.

Thanks in advance. Please revert if you need further information.

[apathetichell]

Alteryx needs better ARN support.

[Mahadeva]

@apathetichell Apologies, couldn't understand your message. Could you please explain what does ARN support mean.

[apathetichell]

amazon resource name - that's how you connect dynamically to redshift.