Changing DB Integration

HarveySpecter

Hi in Decisions 9.8, if a Database Integration connection is changed from Oracle to PostgreSQL, do existing queries/views/access patterns stay in place and just need syntax updates, or do they need to be recompiled/recreated?

VinhTran_Decisions

Hello Harvey,
 

It is possible to update the existing Database Integration connection so that it points to a new database. To do this, you would need to edit the current connection and provide the full PostgreSQL connection string.

 

Once the connection is changed, any new or updated integrations, such as queries or views, will use the new database. Existing items would not necessarily need to be recreated, but as you mentioned, they should be reviewed and updated as needed to match the PostgreSQL schema. Otherwise, they may not behave as expected.

 

Since more complex queries and integrations can vary in behavior after the change, I would recommend testing locally first with a new connection if possible before applying the update more broadly.

Regards,
Vinh Tran | Decisions Support