Universe connection in IDT

[Former Member]

Hi,

We created multi source universe using Infocube and Excel sheet. We moved universe and connections to TEST but the conecctions are pointing to DEV source only. So how to update the Excel connection to make sure it should point to TEST ????

Ex: Created DSN A and Connection A in DEV (while creating DSN A, we selected the Excelsheet A from LocationA in DEV)

      So after migrate to TEST, how to update the same connection A (while Creating DSN A, we selected  the  ExcelA from LocationB in TEST)???

After I retrieved the universe from the TEST repository, I opened the ConnectionA in data foundation but it is asking to DEV details (I am expecting TEST details). If I try to give the TEST details and login then it is displaying error "System you are trying to access is different from the Original cluster".

How to update the connectionA in TEST to make sure it should pont to DSN A which is pointing to Excel sheetA from locationB (not from LocationA) ???

Thanks,

[MariannevL]

Hi Reddy,

Normally when you transfer a universe and connections through LCM you work with system overrides for the receiving system. Basically you define the connection that should be used on each of the BI platforms, be it Q, A or P. Did you check out this option? It would make your life simpler.

If you are not using LCM to do the overwrites, you have to transport the connection and edit it on the receiving end, the connection between universe and connection is taken the cuid. Then for later transports you do not transport the connection, but only the universe. It will warn you that it will loose the connection to the connections, but as the cuid is already there, this is not really the case.

Hope this helps,

Marianne

[Former Member]

any update on this issue please ...???

How to update the connectionA in TEST to make sure it should pont to DSN A which is pointing to Excel sheetA from locationB (not from LocationA)

[former_member182521]

Hi,

Can we try migrate the universe alone without the connection. Also try to delete the connection

In CMC which you already migrated in test. Seems the universe is referring to the connection which inturn referring to the connection that is referring to cluster key of DEV?

Regards,

Mani

[Former Member]

Hi Mani, Thank you for your reply..!!

Yes, connections are referring to DEV.

Migrating only universe to TEST is good idea. But later how we can update universe/data foundation to make sure it will point to the new connections created in TEST. Can you please provide me the steps...

Thanks again,