|How to change ODA Data Source 'Connection &Profile Name' at runtime? [message #1004749]
||Wed, 23 January 2013 19:56
| Brian Graham
Registered: January 2013
In my Connection Profile Store I have 3 JDBC connections defined (DEV/QA/PROD), all residing within the same connection profile store.
The ODA Data Source property 'Connection &Profile Name' changes as I select either the DEV, QA or PROD JDBC connections in the the Designer. This is fine, and allows me to easily switch environments during report development.
I notice in the Data Source Explorer there are also 'Common Properties' that can be user-defined for each JDBC Data Source.
A couple of questions:
1. How do I set the datasource 'Connection &Profile Name' property programmatically, for example in the 'Before Open' script for the data source? Note that I do not want multiple connection profile stores; I want just one connection profile for as many of the DEV/QA/PROD environments I use.
2. How can I programmatically access the Name or Description properties from the Common Properties? I'd like to print the values in the report header, so folks will know where their data are sourced from when reading the report.
Powered by FUDForum
. Page generated in 0.02007 seconds