For me it is unclear what you want at the moment.
If you want to have a ACID transaction behaviour for all used databases you must use XA-Transactions.
The HA DS connector is to have a fallback database in case the first is down.
So please attach the DS files and provide how you use it.