Home
Analytics
Multiple Data Sources in a report
jballnik
<p>Hi Gang,</p><p> </p><p>I would like to connect to Multiple databases in my BIRT Maximo report. Does anyone know how to create multiple dataSources in a report, besides the standard maximoDataSource?</p><p> </p><p>John</p>
Find more posts tagged with
Comments
wwilliams
<p>Under Report Admin, Select Action, Configure Datasources.</p><p><a data-ipb='nomediaparse' href='
http://www-01.ibm.com/support/docview.wss?uid=swg21304936&aid=1'>http://www-01.ibm.com/support/docview.wss?uid=swg21304936&aid=1</a></p>
;
micajblock
<p>I read the answer to your post. It seems to me that the additional data source needs to be like the Maximo data source. Almost a replication. What if the secondary data source is a complete different data source? maybe a finance database. How would one deploy an additional JDBC driver to Maximo? How would one define the connection to Maximo?</p><p> </p><p>P.S. This is very easy if you use Actuate BIRT and ERI (yes, there is a cost to this solution).</p>
jballnik
<p>Hey Wes....I mean having one report that needs to connect to a financial database along with the Maximo database within the report. I want to hard code the connection information within the report</p>
micajblock
<p>According to this post all you need to do is add the JDBC jar to the server class path. I am not sure how true that is. I have never tried this.</p><p> </p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/28006-how-to-bind-maximo-with-mysql-db-or-where-is-the-init-bat-file/'>http://developer.actuate.com/community/forum/index.php?/topic/28006-how-to-bind-maximo-with-mysql-db-or-where-is-the-init-bat-file/</a></p>
;
jballnik
<p>Wes...the document you posted is GREAT, answered all my questions. Thanks!!</p>
