DSXchange

Indeed. It is a service. They researched and wrote a program several years ago that analyzes the metadata from a variety of ETL tools, generating EE jobs as a result. Some of the parallel jobs will nearly compile and run --- some require more tweaking, as the design paradigms of each are not 100% id...

...contact your IBM InfoServer sales person or partner rep and they can connect you with the right folks in the consulting group who have code that automates large portions of a conversion, or write me offline.

Ernie

Your guess is as good as mine on that one. I've been working closely with the ODBC and DB2 Connector, but haven't had a chance to play with the Oracle Connector since it arrived late last summer. It may just be a configuration thing, but I haven't used it so am not sure....... However....that doesn'...

Nice! ; )

Hi Ganesh.... Great work so far....often times sites don't have a web service that supports the sending of an "array" of rows --- fortunately your Maximo target appears to suppor that just fine.....smart idea also to break it up....even if Maximo didn't have a limit, you might eventually b...

Hi jreddy...I haven't tried the Oracle Connector in FastTrack yet, having done all of the imports using the ODBC Connector......however, it' worth noting that the Connector infrastructure is the same below DataStage and FastTrack....are you using the Oracle Connector in DS, or one of the older Oracl...

Give it try.... what's worked? What hasn't? Any questions on the references above now that you've been through them? The doc is pretty good too....let us know if something is confusing.

Ernie

Thanks. That's good news. At least we know that it is working as it "should" and that you did things correctly. Have you reported it for 8.x? I haven't been able to test as I've been "in between" systems while upgrading further to 8.1.2...., and there have been a lot of patches t...

Not sure what steps you have taken on the input link.....the Stage requires that you tell it something about the structure that you want. For your simple example, try something like this (choose your own names for the node names --- I just made these up) example below. Put these strings on each line...

Thank you Ray.........but that being said, do a few minutes of searching...you'll find hundreds of threads on xml in this forum with all kinds of input from myself and many others......including examples, etc. etc. etc. etc. etc. etc.

Ernie

Sadly, that's a poorly designed xml document. The id's and car names should be together in their own repeating element if they are truly related as you have indicated. This looks like a simple example...do you know anything more about the document? Is the array size always 3? Is it entirely variable...

Sadly, that's a poorly designed xml document. The id's and car names should be together in their own repeating element if they are truly related as you have indicated. This looks like a simple example...do you know anything more about the document? Is the array size always 3? Is it entirely variable...

Strange characters from "elsewhere" will give grief to XML. Fortuntaely, you generatlly don't have to worry about carriage returns and line feeds and blanks.

Ernie

Yes...that's another way to send in filenames to the xmlInputStage....

Ok. Something's up. I'm looking forward to trying it. Probably won't have a thought for you until the end of the w/e....let me know if you resolve it sooner.