I am replicating data from our operational database to our reporting database. There are certain fields in the database tables that have NULL on the operational side that need to be replicated onto the reporting side as NULL. Is there a way to do this? Currently webmethods takes the NULL value and translates it to a default value. For example a NULL datetime field gets translated as “01-01-1900 00:00:00.000000”, NULL in integer fields get translated as “0” etc.
Did you try checking “Allow unset fields” on the properties tab, for the desired integration component?