You can extract data of BIT data type from SQL server databases. A value extracted from a BIT-data field can be mapped to a value of BOOLEAN data type.
Example of extracted BIT data fields
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE eventlist SYSTEM "event.dtd">
<eventlist>
<metadata>
<attr_desc type="DATATYPE_BIT-ID">
<ppmdatatype>LONG</ppmdatatype>
</attr_desc>
<attr_desc type="DATATYPE_BIT-VALUE_BIT_2">
<ppmdatatype>BOOLEAN</ppmdatatype>
</attr_desc>
<attr_desc type="DATATYPE_BIT_2-VALUE_BIT_1">
<ppmdatatype>BOOLEAN</ppmdatatype>
</attr_desc>
<attr_desc type="DATATYPE_BIT_2-VALUE_BIT_3">
<ppmdatatype>BOOLEAN</ppmdatatype>
</attr_desc>
<attr_desc type="DATATYPE_BIT_2-VALUE_INT">
<ppmdatatype>LONG</ppmdatatype>
</attr_desc>
</metadata>
<event>
<attribute type="DATATYPE_BIT-ID">1</attribute>
<attribute type="DATATYPE_BIT-VALUE_BIT_2">false</attribute>
<attribute type="DATATYPE_BIT_2-VALUE_BIT_1">false</attribute>
<attribute type="DATATYPE_BIT_2-VALUE_BIT_3">true</attribute>
<attribute type="DATATYPE_BIT_2-VALUE_INT">1</attribute>
</event>
You can use table fields of BIT data type also in conditions to restrict data extraction. The value can be true (respectively 1) or false (respectively 0).
Example of an extraction configuration
<jdbc_tableconfiguration>
<configuration name="BitConfig">
<docspec>
<doctable name="DATATYPE_BIT">
<condition fieldname="VALUE_BIT_1" logicaloperator="eq">
<value>true</value>
</condition>
<pkfield name="ID"/>
</doctable>
</docspec>
<table name="DATATYPE_BIT">
<pkfield name="ID" fktablename="DATATYPE_BIT" pkfieldname="ID"/>
<fieldtoread name="VALUE_BIT_2"/>
</table>
<table name="DATATYPE_BIT_2" tablename="DATATYPE_BIT">
<pkfield name="VALUE_BIT_2" fktablename="DATATYPE_BIT" fkfieldname="VALUE_BIT_2"/>
<fieldtoread name="VALUE_BIT_1"/>
<fieldtoread name="VALUE_BIT_3"/>
<fieldtoread name="VALUE_INT"/>
</table>
</configuration>
</jdbc_tableconfiguration>