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.
Loading XMLs into Db2 UDB -
Moderators: chulett, rschirm, roy
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
http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: