Most of the elements in the Generic_ODBC mappings.xml are for mapping functions or operators. Functions and operators are implemented differently on different databases. Thus, most of your work in configuring a new database type involves mapping functions and operators. To map a function, you provide a template that includes a database function that the Integration service uses when rewriting a query.
The Generic_ODBC mappings.xml file contains the following elements for mapping functions and operators:
<DataSourceMappings>
<DataSourceMapper>
…
<BooleanOpMapper />
<ComparisonOpMapper />
<ArithOpMapper />
<NumericFuncMapper />
<BasicStringFuncMapper />
<SubStringFuncMapper />
<LikeOpMapper />
<DatePartMapper />
<DateDiffMapper />
<DateAddMapper />
<NullFuncMapper />
<CondFuncMapper />
<MultiRowBoolFuncMapper />
<CastFuncMapper />
…
</DataSourceMapper>
</DataSourceMappings>
The Generic_ODBC mappings.xml file does not contain examples or the default templates for mapping Actuate SQL functions and operators. The default templates are listed in the mappings.xml file in the $AC_SERVER_HOME/etc /data_integration/Base_Mappings and <BDPro_HOME>\eclipse\plugins \com.actuate.ais.embeddable_<version>\Config\aisconfigfiles\etc \data_integration\Base_Mappings directories. In subsequent topics, you can find specific examples of how to map functions and operators.