Connecting Database Builder to Redshift

[eward]

Hi there,

I require the ability to connect to a Redshift DB from the EA Sparx Database Builder. Using the Redshift driver provided by Amazon works up until the point of generating SQL to bridge the differences between the DB state and the model. The database object itself is defined as PostgreSQL (for those who don't know Redshift is based on PostgreSQL). I'm wondering if anyone has had experience with this before? Would I have success using the PostgreSQL driver or is there someway to have Redshift defined as a DBMS properly within Sparx?

I will try the PostgreSQL driver now and report back with my findings but I thought I should ask if others have dealt with this before.

Many thanks,

EDIT: Have just now tried the PostgreSQL driver and it seems it is unable to retrieve the differences from the database now, although the connection test when configuring the driver was successful.

ERROR: retrieving  procedure/function list  -  [42883]: ERROR: function pg_get_functiondef(oid) does not exist; Error while executing the query

[AndrewMitchell]

I also need to connect to AWS Redshift and I have configured the Redshift driver successfully but Sparxea gives an error when I try connecting to it.

[Modesto Vega]

The problem is likely to be with Redshift and not with PostgreSQL. Sparx EA has no problems reverse engineering PostgreSQL databases deployed on AWS RDS.

pg_get_functiondef is a function on the postgres database which PostgreSQL master database. I don't know how Redshift implements PostgreSQL, including if it supports functions, or whether it hides the postgres database from users or not. It may be a good idea to start by checking permissions.