About Generic_ODBC mappings.xml

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 <Actuate11_HOME>\BRDPro\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.

Copyright Actuate Corporation 2012