About configurable database types

If the IO Design perspective does not provide a preconfigured database type for a database you want to use, you can configure your own database type. The connection type configuration and mappings files for configurable database types are located in the following iHub and BIRT Designer Professional directories:

<BDPro_HOME>\eclipse\plugins\com.actuate.ais.embeddable_<version>
\Config\aisconfigfiles\etc\data_integration

The connection type configuration and mappings files for configurable database types on iHub and on the desktop must be identical.

You can use the default mappings file if both of the following statements are true:

Your database implementation adheres closely to the SQL-92 standard.

Your JDBC driver supports features that mask differences between databases, such as ODBC escape sequences and Generic SQL type codes.

The default mappings file is located in the Generic_ODBC directory.

If your database differs significantly from the SQL-92 standard, you must create a mappings file. For example, the configurable database type MySQL Enterprise 4.1 is installed with BIRT iHub. Figure 7‑5 shows the location of the connection type configuration file for configurable database types and the mappings file for MySQL Enterprise.

Figure 7‑5 Location of the connection type configuration file and the mappings file for MySQL Enterprise

When you configure a database type, first test your queries with the default mappings file. If any of your queries fail, you must create a mappings file for the database type. The mappings file in the Base_Mappings directory contains the default mapping as a reference.

1 Configure a connection type for the database type using a ConnectionType element in datasources.xml.

2 Configure the database type using a DatabaseType element in datasources.xml.

</DatabaseTypes>

The Integration service and BIRT Designer Professional use the mappings.xml file in the Generic_ODBC directory.

3 Restart the Actuate iHub service and BIRT Designer Professional to reload database type configurations.

5 Create a directory and a mappings file for the database type in $AC_SERVER_HOME/etc/data_integration and <BDPro_HOME>\eclipse
\plugins\com.actuate.ais.embeddable_<version>\Config\aisconfigfiles\etc
\data_integration.

Start the mappings file by making a copy of the mappings.xml file in the Generic_ODBC directory.

The DataSourceMapping attribute gives the name of the directory in which the mappings file resides, for example:

</DatabaseTypes>

7 Restart the Actuate iHub service and BIRT Designer Professional to reload database type configurations.