Externalizing connection property values for a preconfigured connection type

The connection properties for the following connection types are specified in the files <Actuate11_HOME>\BRDPro\eclipse\plugins\com.actuate.ais.embeddable_<version>\Config\aisconfigfiles\etc\intsrvrsources.xml and $AC_SERVER_HOME/etc/intsrvrsources.xml:

DB2

Informix

MySQL Enterprise

Oracle

PostgreSQL

SQL Server

Sybase

For example, the connection properties for the DB2 connection type are:

server

database

username

password

port

appcodepage

The connection properties are specified as follows:

<ConnectionType Name="DB2">

…

  <ConnectionParams>

    <ConnectionParam Name="server"

      Display="Server"

      Type="string"

      ValueIsCaseSensitive="false" />

    <ConnectionParam Name="database"

      Display="Database"Type="string"

      ValueIsCaseSensitive="false" />

    <ConnectionParam Name="username"

      Display="User name"

      Type="string" />

    <ConnectionParam Name="password"

      Display="Password"

      Type="masked" />

    <ConnectionParam Name="port"

      Display="Port"

      Type="integer"

      Optional="true"

      DefaultValue="50000" />  

    <ConnectionParam Name="appcodepage"

      Display="IANAAppCodePage"

      Type="integer"

      Optional="true"

      DefaultValue="" />

  </ConnectionParams>

</ConnectionType>

To externalize the connection property values for a DB2 connection, add a ConnectOptions element to the data source connection 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 property names listed in the ConnectOptions element must match the connection parameter names listed in the ConnectionParams element in intsrvrsources.xml. The match is case-sensitive.

Copyright Actuate Corporation 2012