Skip to Content
0

pointing universe from Oracle connection to SQL connection

Feb 24, 2017 at 11:58 AM

149

avatar image
Deepak Aswale

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.

Thanks,

Deepak.

SAP BusinessObjects Business Intelligence platform
SAP BusinessObjects - Web Intelligence (WebI) | information design tool
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Denis Konovalov Answered
Feb 24, 2017 at 02:27 PM
1

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Deepak Aswale
Feb 25, 2017 at 05:04 AM

Thank you Denis for your reply.

The table names and the objects are all identical. Example I used the tables State, City and Region from the Oracle DB, the tables with the same name are present in SQL , State, City and Region.

and the data inside these tables is same as well.

Would it still cause the issue as there is a DB vendor change..

0
Deepak Aswale
Feb 25, 2017 at 05:38 AM

Also i have 9-10 such universe and 100+ reports on it. Recreating it would be a very big task

0
Comment
avatar image
Deepak Aswale Answered Feb 27, 2017 at 08:56 AM
0

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)
Show 3 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Denis Konovalov
Feb 27, 2017 at 02:09 PM

you still have to check all your sql.

1
Deepak Aswale
Denis Konovalov
Feb 28, 2017 at 04:48 AM

Yes you are right, but the advantage in this method is that I do not need to perform change source for all my Webi Reports as the CUID of the universe remains the same.

So there is no effort required at Webi. In case of recreation of universe I would need to perform efforts at Universe as well as Webi.

Thank you,

Deepak

0
Denis Konovalov
Deepak Aswale
Feb 28, 2017 at 12:21 PM

that is correct. But the answer to original question is still "there is no other way, manual steps are needed" ;)

1
Comment