How to configure a database type
1  
2  
Do not specify the DataSourceMapping attribute, for example:
<DatabaseTypes>
  <DatabaseType Name="MyDatabaseType" ConnectionType="MyConnectionType" />
</DatabaseTypes>
The Integration service and BIRT Designer Professional use the mappings.xml file in the Generic_ODBC directory.
3  
4  
If any of your queries fail, go to step 5.
5  
Create a directory and a mappings file for the database type in $AC_SERVER_HOME/etc/data_integration and <Actuate11_HOME>\BRDPro\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.
6  
The DataSourceMapping attribute gives the name of the directory in which the mappings file resides, for example:
<DatabaseTypes>
  <DatabaseType Name="MyDatabaseType" ConnectionType="MyConnectionType"
DataSourceMapping="MyDataSourceMapping" />
</DatabaseTypes>
7  
8  

Additional Links:

Copyright Actuate Corporation 2012