Compare xml file with DB tables

Toad version: Toad 4.2

Can we connect XML as source and compare them with DB tables?


I suggest to use some ODBC XML driver. Then you can add XML to your User DNS and use it in Toad for comparing with other DB tables.


Hi Filip,

Do you have detail steps to use OBDC XML DRIVE in TOAD?

Thanks ^-^

Will be interested in this too!!


We are not natively support XML as a source and we don’t have our own XML ODBC driver. I know that there are few commercial products which offering XML ODBC driver.

There is also second solution and you can use Excel for transferring your XML to Excel file. Then you can easily use this file for compare in Toad.