We have the following problem.
On the same PC, we need to use universes that access data on several platforms : Oracle 7 on Unix platform, and DB2 V4 on MVS platform (so, we created several universes with different database connections). We would like to use a single BO security database, but we don’t know where we should install it. To have a complete independance between the two server platforms (we don’t want to enforce the user to have an Oracle connection for the BO sign-on proces, if he just need to access a DB2 database), we imagine to create a master security referential on one platform (DB2 for example), and to replicate the security referential on the other platform (Oracle, in my case). Does anyone use this kind of mechanism ? Do you think it’s realistic ? Do you have another solution to propose ?
We have the following problem.
On the same PC, we need to use universes that access data on several platforms : Oracle 7 on Unix platform, and DB2 V4 on MVS platform (so, we created several universes with different database connections). We would like to use a single BO security database, but we don’t know where we should install it.
To have a complete independance between the two server platforms (we don’t want to enforce the user to have an Oracle connection for the BO sign-on proces, if he just need to access a DB2 database), we imagine to create a master security referential on one platform (DB2 for example), and to replicate the security referential on the other platform (Oracle, in my case).
Does anyone use this kind of mechanism ? Do you think it’s realistic ? Do you have another solution to propose ?
Christian,
If you set up the connection to the repository, not the source of the data for a particular universe, with a single id, only that id needs access to that platform, not all users. In our case we have two different platforms where our data resides. We have DB2 on the mainframe and DB2/6000 on AIX. OUr repository in on the AIX box. Not everyone who is authorized to use BusinessObjects has access to this box, only those that need access to the data on that particular machine have an account on it. We have one id that we use to connect to the repository. So you can have your security domain on any platform.
Glenn Fredericks
Data Warehouse Specialist glenn_fredericks@aal.org
(920) 730-4700 x4236 or 1-800 CALL AAL
Aid Association for Lutherans
4321 N. Ballard Road
Appleton, WI 54919-0001
Visit our Web site at www.aal.org or e-mail us at aalmail@aal.org
AAL… Financial services. Lutheran heritage. A powerful combination.