CODEWITHSUNDEEP
excelvbaamazon-redshift
Debanjan Ghosal
Debanjan Ghosal

Reputation: 33

Connecting to Amazon Redshift via Excel Macro (ODBC Connection String to Amazon Redshift)

Has anybody connected to Amazon Redshift database via excel macros (VBA)? I want to connect to Amazon Redshift database using the same process as I do to connect to Teradata- via connection string from Macrco directly. Can anybody please help?

Teradata i follow this : Conn.ConnectionString = "DRIVER={Teradata};" & "UID=" & suid & ";" & "PWD=" & spwd & ";" & "DBCNAME=" & sdbcnm & ";" & "AUTHENTICATION=;"

Upvotes: 2

Views: 4725

Answers (1)

aaronsteers
aaronsteers

Reputation: 2571

Assuming you have the ODBC driver installed already, you should be able to use an alteration of this string:

Driver={Amazon Redshift (x64)}; 
Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com; 
Database=dev; UID=masteruser; PWD=your_password; Port=5439

Note: If you have the 32 bit version of Excel (most common), you'll need to make sure your connection string (and driver installation) reflect this.

Doc ref: http://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html#obtain-odbc-url

Upvotes: 2

Related Questions