Skip to Content
0
Jun 10, 2022 at 10:01 AM

How to update a table structure (UDT) from a PostgreSQL AWS RDS Database

161 Views Last edit Jun 10, 2022 at 12:40 PM 2 rev

Hello,

I am used to work with BOXI to SAP BI 4.2 on universes that are based on Oracle database and have no particular issues with them.

Today I have to work on an universe that is based on a AWS RDS Aurora PostgreSQL database I made a few weeks ago. One of the table has changed and I want to update this table structure in the universe, like I have already done many times with Oracle databases.

The issue is that I can not do that.

First of all, the "check integrity" test says that every table I am using "is not in the database structure".

Secondly, when I select the table and click on "Refresh structure", UDT says "The selected tables were not found".

Beside, everything is working, I can see the table values in UDT, the reports are working in WebI...

I can just no update the structure. Even if a try to add the table again (UDT makes an alias) , I don't have the new table structure.

My connection to the database is based on an ODBC link.