How to insert database view in workspace

[Former Member]

Hi,

I am very new to Universe Designer. I am trying to insert DB VIEWS in workspace using Table Browser; however, I only see TABLES.

Some data in our Oracle repository is only availabe in VIEWS. The VIEWS data are coming from some datasources and they are not available in the repository's TABLES.

Could anyone help me ?

Thank you,

Sri

[Former Member · Accepted solution]

Hi,

Views are listed with tables. There is no difference between voiew and tables in Universe Designer.

So do you have rights to see those views? If you are not the owner of the views, do you know if synonyms have been created on those views?

Regards

Didier

[Former Member · Accepted solution]

Thank you, Didier, my problem now is solved. Have an awesome weekend