Configuring connection types: ConnectionTypes element
The ConnectionTypes element has one or more child elements called ConnectionType. Each ConnectionType element specifies how the Integration service connects to a database. You define a name for each connection type using the Name attribute.
The ConnectionType element has two child elements:
*
*
Here is an example of a ConnectionTypes element:
<ConnectionTypes>
  <ConnectionType Name="MySQL">
    <JDBCDriver DriverName="com.mysql.jdbc.MySQLDriver">
      <ConnectionString>
        jdbc:mysql:mysql://%server%:%port%;SID=%sid%
      </ConnectionString>
      <ConnectionProperties>
        <Property Name="Username">%username%</Property>
        <Property Name="Password">%password%</Property>
      </ConnectionProperties>
      <LibraryPath>
        <Location>/home/jsmith/bin/</Location>
        <Location>/home/jsmith/mysql/bin/</Location>
      </LibraryPath>
    </JDBCDriver>
    <ConnectionParams>
      <ConnectionParam Name="server"
        Display="Server"
        Type="String"
        DefaultValue="end2243"
        Optional="true"
        ValueIsCaseSensitive="false">
      </ConnectionParam>
      …
    </ConnectionParams>
  </ConnectionType>
</ConnectionTypes>
ConnectionType child element: JDBCDriver
The JDBCDriver element contains information used to create JDBC connections. This element has one attribute, DriverName, as shown in Table 9-1. The JDBCDriver element has three child elements, ConnectionString, ConnectionProperties, and LibraryPath, as shown in Table 9-2.
Class name of the JDBC driver, for example com.mysql.jdbc.
MySQLDriver.
JDBC connection string syntax. Do not include user name and password.
Connection
Properties
Paths to search for libraries used by the JDBC driver. Use a separate Location element for each path.
ConnectionString element
The JDBCDriver element has a ConnectionString child element, for example:
<ConnectionString>
  DRIVER={MySQL 4.0};DB=%database%;PORT=%port%;IP=%server%
</ConnectionString>
The ConnectionString element provides a template for the JDBC connection string. The parameters enclosed in percent signs (%), for example %server%, are placeholders for the values you type on the Data source connection properties page, shown in Figure 9-1, when you create a data connection definition. These values are retrieved from the data connection definition (DCD) file when the Integration service creates a connection.
You can exclude a portion of a connection string when no value is provided for a connection parameter by enclosing it in double brackets ([[...]]). In the following example, to exclude the IANAAppCodePage parameter from the connection string when the value is left blank, define the ConnectionString element as follows:
<ConnectionString>
  DRIVER={MySQL 4.3}; HOST=%server%; PORT=%port%; SID=%sid%;[[IANAAppCodePage : CODEPAGE=%IANAAppCodePage%]]
</ConnectionString>
[[IANAAppCodePage : CODEPAGE=%IANAAppCodePage%]] is not included in the connection string unless the IANAAppCodePage parameter is set.
To include the following literal characters in a ConnectionString element, precede the character with a backslash (\):
*
*
*
*
*
ConnectionType child element: CatalogFilter
The CatalogFilter element filters catalogs returned by the JDBC driver when Information Object Designer displays a list of tables, views, or stored procedures in the New Maps dialog. By default, all catalogs are returned. Like the template for the JDBC connection string, the catalog filter can contain placeholders for the values of connection parameters, for example:
<CatalogFilter>%database%</CatalogFilter>
ConnectionType child element: ConnectionParams
The ConnectionParams element defines the parameters that are used in the ConnectionString element. The ConnectionParams element has a single child element, ConnectionParam. Here is an example of a ConnectionParam element that defines the server parameter:
<ConnectionParam Name="server"
  Display="Server"
  Type="String"
  DefaultValue="end2243"
  Optional="true"
  ValueIsCaseSensitive="false">
</ConnectionParam>
One ConnectionParam element is required for each parameter. Each ConnectionParam element has the attributes shown in Table 9-3.
Name of the connection parameter. This attribute is case-insensitive.
Display name that appears on the Data source connection properties page in Information Object Designer.
Connection parameter type. Must be one of the following:
*
Masked (Use for a string whose value should be hidden, such as a password.)
Specifies whether a parameter is optional.
Specifies whether the parameter value is case-sensitive. Used when comparing two DCD files to see if they are equivalent.

Additional Links:

Copyright Actuate Corporation 2012