Reading XML then storing it in DB in table format
I need to read a xml file in which parent node is a table name and other is a column name. There are various parent node which represent various tables in hierachy form of various schema. I need to store data from data nodes to the corresponding tables.And then need to compare the data which i loaded throug QTP and the data loaded by other utility in the corresponding tables are valid or not.
Please assist for the same
Re: Reading XML then storing it in DB in table format
You need to split your problem in 2 problems. One is reading a XML file and second is working with a Database.
For your 1st problem search for XMLUtil in QTP help and this forum.
For your 2nd problem search this forum for "ADODB.Connection"