Hi every body
i use to work with Actuate Erd Pro and e.spreadsheet from actuate.
On these tools we could define connection definition in a xml file.
Such definition helps us to move reports from development environment to Test environment and from test environment to Production environment without having to modifiy anything into the report.
The file is connection.xml and defines all the connections for each environments
what i have to do is just define the correct connection on the correct environment.
My problem:
Does this exists for BIRT reports? (I do not want to open each time the report in order to change this connection definition).
What is the syntax for defining the connection?
for Erdpro you must enter: (for oracle)
<ConnectOptions Type="My_Connection">
<Property PropName="HostString">tnsname_string</Property>
<Property PropName="UserName">USR_NAME</Property>
<Property PropName="Password">PWD_CLEAR_MODE</Property>
</ConnectOptions>
for information objects: (for oracle)
<ConnectOptions Type="CONN_NAME">
<Property PropName="server">SERVER_NAME</Property>
<Property PropName="username">USR_NAME</Property>
<Property PropName="password">PWD_CLEAR_MODE</Property>
<Property PropName="port">PORT_NUMBER</Property>
<Property PropName="sid">DB_SID</Property>
</ConnectOptions>
for e.spreadsheet:
<ConnectOptions Type="EssDataSource.DATASOURCE_NAME">
<Property PropName="datasource">DATASOURCE_NAME</Property>
<Property PropName="database">jdbc: oracle:thin:
@SERVER_NAME:PORT_NUMBER: DB_SID</Property>
<Property PropName="UserName">USR_NAME</Property>
<Property PropName="Password">PWD_CLEAR_MODE</Property>
</ConnectOptions>
thanks for answer
Arno
