Do we need DSN for Excel at Server side?.
I have a client requirement to create multisource universe : one from DB2 and another from Excel source.
We were able to create local DSN for excel but couldn't able to publish .CNS file to repository?. and I don't see any ODBC drivers under Microsoft middleware drivers in IDT.
Is there any best practices to create a multisource Universes and also on Excel as source?.
Also, Do we need DSN configuration and file to set up at BO Server side?. Please advice.
We are on:
Windows 7 64 bit
SAP BO 4.1 SP3 Patch1