Skip to Content

Changing database connection in IDT

Feb 25, 2017 at 07:22 AM


avatar image
Former Member

Hi All,

I have a universe based on oracle database. 100+ reports and 7 dashboards are based on same universe.

Now the requirement is to change the database connection from oracle to SQL.

I have created the SQL connection in same project and changed the connection from oracle to SQL.

I tried by changing the Owner/Qualifier option. Also i have tried by Replace option.

It gives table reference unknown.

Also there is structure change in both the databases.

Like for eg. in Oracle we have Schema->Tables->Table Name.

In SSMS we have Databases->Database Name->Tables->Table Name

Is it possible to achieve this requirement. Please suggest the way.

Thanks in advance,


capture1.png (34.3 kB)
capture1.png (34.3 kB)
capture2.png (30.4 kB)
capture3.png (47.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers