Change Database URL at runtime

vibharavi2001

I would like to change the Data Source connections dynamically. Can some one please provide some steps or any example on how to "Change Database URL at runtime based on Parameter".

Thanks in Advance,
Ravi

Find more posts tagged with

Comments

mwilliams

Hi Ravi,

In the dataSource editor, there is a property binding section and there are expression builders for the connection settings there. You should be able to set these up based on a parameter in there.

Hope this helps.

vibharavi2001

William,

Thankyou for your reply, would you be able to provide me an example report. I searched the forum I foud the link (http://www.birt-exchange.org/org/forum/index.php/topic/15782-using-external-config-files-to-load-jdbc-info/page__hl__CONNECTION PROFILES__fromsearch__1) But link is not working. Please provide an example if you have any.

Thanks,
Ravi

mwilliams

Ravi,

If you're just passing the value in as a parameter, you can just build the URL in the expression builder using the parameter value and whatever other characters you need to create the URL string.