About the data source connection configuration file

You can use the iServer data source connection configuration file to externalize data source connection property values. This file is also used by BIRT report designs, BIRT spreadsheet designs, e.report executables, and Actuate Analytics cube profiles. A set of connection property values appears in a ConnectOptions element in the configuration file’s Runtime element, for example:

<Runtime>

…

  <ConnectOptions Type="My_DB2_Connection">

    <Property PropName="server">My_DB2_Server</Property>

    <Property PropName="database">My_DB2_Database</Property>

    <Property PropName="username">My_DB2_User</Property>

    <Property PropName="password">My_DB2_Password</Property>

    <Property PropName="port">50000</Property>

    <Property PropName="appcodepage">3</Property>

  </ConnectOptions>

…

</Runtime>

The password is not encrypted.

You can create an entry for a new set of connection property values or add connection property values to an existing entry. For information about creating a ConnectOptions element, see one of the following topics:

Externalizing connection property values for a preconfigured connection type

Externalizing connection property values for a configurable connection type

Externalizing connection property values for an ODA connection type

In each case, you must first locate the file in which the connection properties are specified.

The configuration key specified in the .dcd file must match the Type attribute for the ConnectOptions element. In Figure 2-22, the configuration key matches the Type attribute in the ConnectOptions element above.

Figure 2-22

Specifying a configuration key

To locate the data source connection configuration file, check the setting of Configuration file for database connections using Configuration Console. For more information about this configuration variable, see Configuring BIRT iServer.

Copyright Actuate Corporation 2012