Configuring database types: DatabaseTypes element

The DatabaseTypes element has one or more child elements called DatabaseType. Each DatabaseType element specifies the connection type and mapping for a database type. Several database types can use the same connection type, provided they use similar JDBC drivers, or the same mapping. For example, two different versions of a MySQL Enterprise database can use the same connection type.

Here is an example of a DatabaseTypes element:

<DatabaseTypes>

  <DatabaseType Name="MySQL4"

    ConnectionType="MySQL"

    DataSourceMapping="MySQL4" />

  <DatabaseType Name="Ingres"

    ConnectionType="Ingres"

    DataSourceMapping="Ingres" />

</DatabaseTypes>

Each DatabaseType element has the attributes shown in Table 9-4.

Table 9-4

Attributes of the DatabaseType element

Attribute	Description	Required?
Name	Name of the database type.	Yes
DisplayName	Display name for the database type in the New Data Connection Definition dialog in Information Object Designer.	No
ConnectionType	Name of the connection type to use with this database type. The connection type is configured using the ConnectionType element.	Yes
DataSourceMapping	Directory where the mappings.xml file is located. This directory must be in the $AC_SERVER_HOME/etc/data_integration and <Actuate11_HOME>\BRDPro\eclipse\plugins\com.actuate.ais.embeddable_<version>\Config\aisconfigfiles\etc\data_integration directories.	No. If not specified, the Integration service uses the mappings.xml file in the Generic_ODBC directory. If you set this attribute to No_Mappings, all operations are executed by the Integration service executor.

 

 

Copyright Actuate Corporation 2012