Compare xml file with DB tables - Toad Data Point Forum - Toad Data Point - Toad World

Compare xml file with DB tables

Follow / 12 Jul 2017 at 8:32pm

Toad version: Toad 4.2

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

Thanks

Replies

  • Follow / 14 Jul 2017 at 6:56am

    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.

    Filip

  • Follow / 14 Jul 2017 at 2:39pm

    Hi Filip,

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

    Thanks ^-^

  • Follow / 14 Jul 2017 at 6:36pm

    Will be interested in this too!!

    Chris

  • Follow / 17 Jul 2017 at 8:29am

    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.

    Filip