How to design universe with tables from two databases using a db link?

[Former Member]

I am building a universe (v3.1) that has tables from two different oracle db instances. My dba created synonyms for me and there is a database link in place. I don't know how to get this working in Designer. I can see the views under my ID when I browse to insert a table, but there is no structure. I think I have to create a new strategy. I attempted to do that, but the directions aren't very clear to me, and it isn't working. Any help or advice would be greatly appreciated. Thanks!!

[amrsalem1983 · Accepted solution]

i've been working with DB links much before, but this was since long time ago before i join the Business Intelligence field

from my understanding that you Have link from DB1 to DB2

and from your user in DB1 you can access tables and view from DB2

if you are using your user to create a universe im not sure if you can use tables from DB2 or not

and you dont see the tables of the link in the Universe

but you can try to create a drived table selecting from any tables from DB2

for example

select id,name from user.table2@mylink

check this way and give me your feedback

good luck