Connection to Amazon Redshift

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
pippolino
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?

Thanks
Federico

Shalex
Site Admin
Posts: 8754
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