Loading XMLs into Db2 UDB -

ArjunK · Post by **ArjunK** » Mon Jun 07, 2010 1:43 pm

Hi ,
We have requirements around loading data (coming in XML format) into a Db2 UDB data warehouse. In the past we have done it using Datastage ( XML PlugIn Stages) but we are dabbling with using pureXML instead of DataStage . I have read a couple of articles on it but wanted to see if anyone has had first hand experience using it. Any pros , cons , challenges or recommendations that you can provide would be appreciated.

Also, is there a possibility of using Datastage version 7.5 with pureXML? Can we fire Xquery in the Db2 stage in 7.5 to retrieve indivisual XML element values?

Thanks.

eostic · Post by **eostic** » Mon Jun 07, 2010 3:39 pm

Have you seen this article? I haven't seen any sites using it, but perhaps this will help...

http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

eostic · Post by **eostic** » Mon Jun 07, 2010 3:45 pm

It's possible that the DB2 Connector (new with release 8) is required to understand the pureXML datatypes.........but perhaps pureXML has ways of loading xml from disk, which DS could produce....

Ernie

ray.wurlod · Post by **ray.wurlod** » Mon Jun 07, 2010 4:25 pm

Is the manual for the DB2 Connector available in PDF format?