Skip to Content
avatar image
Former Member

Universe connection in IDT

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 14, 2012 at 02:47 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Manikandan Elumalai

      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,

  • avatar image
    Former Member
    Sep 21, 2012 at 07:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded