Accessing DB2 as data source from BO XI R2 SP3 on Windows
We're an Oracle shop, but recently were asked to use a DB2 database for a data source. We're running BO XI R2, SP3 on Windows 2003 Server. We understand that DB2 is running on MVS. My question is, what version of DB2 connect do I need to install on my Windows 2003 Server, so that DB2 can be used as a data source? For example, we want to use Universe Designer to build a universe to point to DB2. Also, we're going to want to use Desktop Intelligence from Windows XP clients , to hit DB2 as well. So, I imagine DB2 Connect (version 9, personal edition?) will have to be installed on the client too. Any tips or pointers would be appreciated. Or, if you can point me to the right doc or .pdf, that would be great.
Thanks in advance,