How to get DataSource name

ibmsachin1c
edited February 11, 2022 in Analytics #1
<p>Hello Friends,</p>
<p>    I have requirement where same reports needs to run on multiple env. and each env. having different database name. Do we have any option to create dynamic datasource rather that hardcode database url value and compile multiple time.</p>
<p> </p>
<p>Please suggest how to fix this type of problem in birt reporting.</p>
<p> </p>
<p> </p>
<p>Thanks in advance.</p>

Comments

  • <p>Hi Sachin, In your BIRT data source, select Property Binding from the left side, in this area, you can create dynamic entries for the driver and database connection information. This way you can pass in a report parameters or other detectable environment variables to determine the database to use.  It can be a simple expression like "jdbc:classicmodels:"+params["databaseParam"].value or a complex script if that's needed.</p>
    Warning No formatter is installed for the format ipb