The adapter.conf File

This file contains the following settings:

• use.simplified.xml.config=false.true: uses simplifiedConfiguration.xml.

  Note Using this file means that orm.xml, transformations.txt, and reconciliation_rules.txt are replaced with fewer capabilities.

• dal.ids.chunk.size=300. Do not change this value.

• dal.use.persistence.xml=false. true: the adapter reads the Hibernate configuration from persistence.xml.

  Note It is not recommended to override the Hibernate configuration.

• performance.memory.id.filtering=true. When the GDBA executes TQLS, in some cases a large number of IDs may be retrieved and sent back to the database using SQL. To avoid this excessive work and improve performance, the GDBA attempts to read the entire view/table and filters the results in-memory.

• id.reconciliation.cmdb.id.type=string/bytes. When mapping the Generic DB adapter using ID Reconciliation, you can either map the cmdb_id to a string or bytes/raw column type by changing the META-INF/ adapter.conf property.

• performance.enable.single.sql=true. This is an optional parameter. If it does not appear in the file, its default value is true. When true, the Generic Database Adapter tries to generate a single SQL statement for each query being executed (either for population or a federated query). Using a single SQL statement improves the performance and memory consumption of the Generic Database Adapter. When false, the Generic Database Adapter generates multiple SQL statements, which may take longer and consume more memory than a single one. Even when this attribute is set to true, the adapter does not generate a single SQL statement in the following scenarios:

  • The database the adapter connects to is not on an Oracle or SQL Server.

  • The TQL being executed contains a cardinality condition other than 0..* and 1..* (for example, if there is a cardinality condition like 2..* or 0..2).

• in.expression.size.limit=950 (default). This parameter splits the 'IN' expression of the executed SQL, when the size limit of the list of arguments is reached.

• stringlist.delimiter.of.<CIT Name>.<Attribute Name>=<delimiter>. In order to map a string list attribute to a database column in the generic database adapter, the attribute needs to be mapped to a string column that contains a list of concatenated values. For example, to map the attribute policy_category with the CI Type policy, and the string column contains a list of values: value1##value2##value3 (that define a list of 3 values value1, value2, value3), use the setting: stringlist.delimiter.of.policy.policy_category=##.

• temp.tables.enabled=true. Enables using temporary tables to improve performance. Only available when performance.enable.single.sql is enabled (only supported in Microsoft SQL and Oracle). Certain permissions in the database server may be required.

• temp.tables.min.value=50. Defines the number of condition values (or IDs) that are needed to use temporary tables.