Now, I know HDP doesn't support for update of on-premise data source using transaction.
Often, customer is required to support transactions when updating data.by using HDP to business application.

It is desirable to support transactions on all ODBC / JDBC and oData connections where possible.