Optional mapping of the database settings

The standard mapping of database tables and access specifications that include database queries depends on database design. You are not free to define your own data source schema. To connect the name attribute to the data source Name they must have the same value. The columns of the database and the name for ValueDefinition elements must be the same.

The new XML schema version of the LookupMgrCustomizing.xml file allows a mapping definition. You can use the optional attribute DbAccessSpecification to map the name of the access specification in the connections.xml file to your own data source schema. You must use the DbAccessSpecification attribute if you want to process the delete command.

If the name of a ValueDefinition does not match the database column name then you must use the DbColumnName attribute to map the column name.

The following figure shows the described cross-references between the customizing file, configuration settings, and input source:


Lookup Manager application - customizing database as input