Page 1 of 1

Connection to Amazon Redshift

Posted: Mon 14 Jan 2019 15:50
by pippolino
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

Re: Connection to Amazon Redshift

Posted: Tue 15 Jan 2019 11:23
by Shalex
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