Connection to Amazon Redshift

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
Posts: 1
Joined: Fri 03 Mar 2017 17:38

Connection to Amazon Redshift

Post by pippolino » Mon 14 Jan 2019 15:50

We need to connect to Amazon Redshift through EntityFramework 6 but I do not know if it is possible to access Redshift with the entity Framework6 using dotConnect Universal and an ODBC driver or even through other Devart Drivers?


Site Admin
Posts: 8931
Joined: Thu 14 Aug 2008 12:44

Re: Connection to Amazon Redshift

Post by Shalex » Tue 15 Jan 2019 11:23

1. dotConnect Universal doesn't support any ORM frameworks by design.

2. dotConnect for PostgreSQL Professional:
* Entity Developer (*.edml) will not work with Redshift, because Redshift restricted access to the system information_schema table. No way here
* Entity Data Model Wizard (*.edmx) can be adjusted via dotConnect for PostgreSQL for working with Redshift, but there is no timeframe at the moment

Post Reply