Multiple DataSources with BIRT Runtime

Rep0rter
edited February 11, 2022 in Analytics #1
<div>Hi!</div>
<div> </div>
<div>We have a BIRT Runtime (4.4.0) embedded in a web application that manages datasources in runtime with two options:</div>
<div> </div>
<ul><li>Reports with JDBC Datasource</li>
<li>Reports with XML Datasource</li>
</ul><div> </div>
<div><strong>Now we need to work with more than one data source, for example with two JDBC Datasources.</strong></div>
<div> </div>
<div>How can we change this code (for one JDBC Datasource):</div>
<div> </div>
<div>
<blockquote class="ipsBlockquote">task.getAppContext().put("OdaJDBCDriverPassInConnection", conn);
<p> </p>
</blockquote>
<p> </p>
</div>
<div> </div>
<div>or this (for one XML Datasource):</div>
<div> </div>
<div>
<blockquote class="ipsBlockquote">contextMap.put("org.eclipse.birt.report.data.oda.xml.inputStream", XMLContent );
<p> </p>
</blockquote>
<p> </p>
</div>
<div> </div>
<div>to meet these requerements: </div>
<div> </div>
<ul><li>Two or more Datasources (each one accesing differente Databases) on the same report.</li>
<li>Mixing of datasource types in same report.</li>
</ul><p> </p>
<p>Thansk a lot!!!</p>