Show Posts
1
General Board / Connecting Database Builder to Redshift
« on: December 01, 2018, 04:52:30 am »
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
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