# Redshift connection

**URL:** <https://community.easymorph.com/t/redshift-connection/1122>\
**Category:** General Q&A\
**Created:** [June 8, 2019, 8:39am UTC](https://community.easymorph.com/t/redshift-connection/1122 "2019-06-08T08:39:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![reynsnivea](https://community.easymorph.com/letter_avatar_proxy/v4/letter/r/9f8e36/32.png) [@reynsnivea](https://community.easymorph.com/u/reynsnivea)\
**Post date:** [June 8, 2019, 8:39am UTC](https://community.easymorph.com/t/redshift-connection/1122/1 "2019-06-08T08:39:47Z")

</div>

I can't find a native connector to Redshift. Could you describe in detail how to connect to redshift?  
Will a native connector become available in the near future?

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [June 8, 2019, 9:46am UTC](https://community.easymorph.com/t/redshift-connection/1122/2 "2019-06-08T09:46:48Z")

</div>

Hi Nikolaas,

Amazon documentation states that Redshfit cluster should be connected to either through JDBC or ODCB driver: [Query a database - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/query-databases.html)

So in case of EasyMorph, you should install ODBC driver, configure ODBC DSN to your Redshift cluster and create EasyMorph ODBC connector with Redshift SQL dialect selected.

As a workaround, you can try to use the native PostgreSQL connector to connect to your Redshift cluster. But some EasyMorph database-related actions may not work as expected or not work at all which such connection.

Does ODBC connector will work for you? If no - can you please tell us why do you specifically need a native connector?

---

<div class="post-metadata">

**Author:** ![reynsnivea](https://community.easymorph.com/letter_avatar_proxy/v4/letter/r/9f8e36/32.png) [@reynsnivea](https://community.easymorph.com/u/reynsnivea)\
**Post date:** [June 8, 2019, 12:06pm UTC](https://community.easymorph.com/t/redshift-connection/1122/3 "2019-06-08T12:06:44Z")

</div>

Thanks. Is a native connection not easier than ODBC ?

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [June 8, 2019, 12:23pm UTC](https://community.easymorph.com/t/redshift-connection/1122/4 "2019-06-08T12:23:33Z")

</div>

The database vendor (Amazon) provides only ODBC/JDBC drivers for Redshift. No Redshift drivers provided for .NET apps.

> Amazon Redshift does not provide or install any SQL client tools or libraries, so you must install them on your client computer or Amazon EC2 instance to use them to work with data in your clusters. You can use most SQL client tools that support JDBC or ODBC drivers.

> **[Connecting to an Amazon Redshift data warehouse using SQL client tools -...](https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-to-cluster.html)**
>
> Connect to an Amazon Redshift data warehouse using SQL client tools that support JDBC and ODBC drivers.
