Linking Amazon Redshift to Data Catalog

Category: azure data catalog


SamSha on Tue, 05 Sep 2017 17:20:29

I am looking for connecting Amazon Redshift to Azure Data Catalog. Will Microsoft be coming up with this in near future?


Matthew Roche [MSFT] on Wed, 13 Sep 2017 16:13:10

Hi Sam,

Support for Amazon RedShift data sources is on our roadmap, but is unlikely to be available in the next few months.

Matthew - Azure Data Catalog Team

Darren Haken on Mon, 30 Jul 2018 10:01:36


Could you provide an update on where this is on the roadmap?



vp98741 on Mon, 06 May 2019 17:09:03

It looks like Azure Data Catalog does not yet support connecting to Amazon Redshift as a named data source BUT I was able to configure the connection as a generic ODBC source.

Here are links which will be useful.

The settings I used after installing the Amazon provided ODBC drivers from the links above are, the actual server addresses, usernames etc. values are made up

Provider - "Amazon Redshift (x64)"

Connection String - "Server=;port=5394"

Database - yourdbname

User - authoriseduser

password - yourpassword

Hope this helps someone.