Page 1 of 1

XML Schema to Existing RDMS Table Mapping

Posted: Thu Jan 10, 2008 3:36 am
by kazam
I don't know if this data mapping feature is available. However, can I import XML data using a xml schema to RDBMS mapping.

I have a xml schema and I have the corresponding DB2 Tables. Is it possible, I can import data from xml file into the database using some form of xml schema to DB2 Table Mapping.


Thanks, kazam.

Posted: Thu Jan 10, 2008 12:25 pm
by sorin_ristache
Hello,

oXygen can insert the data from your XML data files into some tables of a DB2 database only by running an XQuery against a DB2 database connection configured in oXygen that creates the necessary records in the database tables by reading the data from the data files and writing them to the tables. You have to write the XQuery that inserts the data in the DB2 tables yourself. If you want a tool that maps automatically the data of the XML files to the DB2 tables you should look for a specialized import tool on the DB2 website.


Regards,
Sorin