Skip to Content

pointing universe from Oracle connection to SQL connection

Hello Experts,

I have a unx universe which is based on Oracle DB connection (the underlying DB is oracle). The DB is now migrated to SQL. The tables and objects are identical.

But after I change the universe connection from Oracle connection to SQL connection, and refresh the universe structure, it shows that all the tables are missing.

Also in Data foundation layer, when I right click on the table and click on replace to "Database Table", and replace by appropriate table, the dimension and measure in the business layer show [Unknown Reference] in SQL Defination.

So ideally, it is similar to re-creating the universe, is there any other way where I can avoid these issues.



Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Feb 24, 2017 at 02:27 PM

    Not really. You're changing database vendor, so the SQL is different (if you have manual queries - they need to be changed), tables, views, indexes are all different.
    there is no way IDT or UDT can do this sort of switch automatically.

    Fastest way is to create new Universe vs. chasing all the places where manual adjustment will be needed.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 27, 2017 at 08:56 AM

    Hi Denis,

    I found the way as below, After changing the connection from Oracle to SQL, right click on table and select Change Qualifier/Owner. Check mark Delimit

    And then browse the Owner to select DBO

    Perform the steps for all the tables in the universe and then refresh structure of universe. Save and validate all the objects and then publish the universe back to repository.

    1.png (8.9 kB)
    2.png (6.2 kB)
    Add comment
    10|10000 characters needed characters exceeded