Dear Team,
We are using SpagoBI 5.2 for both SpagoBI studio and SpagoBI Server. Recently we have migrated our data source and for the same to reflect in Spagobi reports, we changed our connections from JDBC to JNDI.
In JDBC, we can able to connect multiple datasources, for ex. Oracle and Mysql but how to do the same in JNDI Connection. In report, I have mentioned connectionName parameter to JNDI URL for both MySQL and Oracle datasources. After deployment in the server, in document properties i can able to select either Mysql DS or Oracle DS and sited result sets as per the connection selected.
Is there any way to specify both connections in the Server level?
Kindly revert as soon as possible.
Thanks in advance.
WR,
Sathish R