![Configuring ODBC connection_ Informatica with Redshift issues-after-qlikview-version-upgrade-on-passive-node-of-production-servers](https://www.s-squaresystems.com/wp-content/uploads/Configuring-ODBC-connection_-Informatica-with-Redshift.png)
Create a cluster in AWS
![Picture161](https://www.s-squaresystems.com/wp-content/uploads/Picture161.png)
Download and install one of the following, depending on the system architecture of your SQL client tool or application:
-
- 32-bit:https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.4.1001/AmazonRedshiftODBC32-1.4.4.1001.msi (The name for this driver is Amazon Redshift (x86)).
- 64-bit:https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.4.1001/AmazonRedshiftODBC64-1.4.4.1001.msi (The name for this driver is Amazon Redshift (x64)).
Configure the DSN as shown below
-
- Open an odbcad32.exe by navigating to Windowsà system32
- Navigate to System DSN then click on Add
![Picture162](https://www.s-squaresystems.com/wp-content/uploads/Picture162.png)
Select Amazon Redshift(x64) and click finish.
![Picture163](https://www.s-squaresystems.com/wp-content/uploads/Picture163.png)
A wizard opens-up, provide all the details.
![Picture164](https://www.s-squaresystems.com/wp-content/uploads/Picture164.png)
-
- Data source: Name for DSN
- Database: Database name as given in the cluster
- Server : End point URL from cluster
- Port: Port as given in Cluster
- Username and Password as configured with the cluster
Test the connection and connection should be succeeded
![Picture165](https://www.s-squaresystems.com/wp-content/uploads/Picture165.png)
Then open the Informatica workflow manager and then click on connections.
![Picture166](https://www.s-squaresystems.com/wp-content/uploads/Picture166.png)
Select ODBC then click OK.
![Picture167](https://www.s-squaresystems.com/wp-content/uploads/Picture167.png)
Then fill the required details(Connection string should be DSN name) then click on ok.
![Picture168](https://www.s-squaresystems.com/wp-content/uploads/Picture168.png)