Skip to Content
avatar image
Former Member

Changing database connection in IDT

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,

Prajakta.

capture1.png (34.3 kB)
capture1.png (34.3 kB)
capture2.png (30.4 kB)
capture3.png (47.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers