Changing database connection in IDT

[former_member377565]

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.