DSXchange

There's a check box "generate chunk" which will leave out the header and > etc is required for the xml to be valid. Content inside of an element that contains such characters has to be "escaped" in order for another xml parser to properly read the content. Look at your final xml ...

I'd like to know what browser you're using....and then encourage you to change it. It needs to receive an error. It's entirely "non-well-formed" xml if <Address1 is left open. Same string in the thread above blows up in both my copies of IE and firefox, as it should.

Ernie

both xmlInput and xml Stage work the same way regarding valid xml. Every tag must have a closing tag. Chances are, there is a typo in the thread up above and Address1 is actually <Address1 stuff="xxx" morestuff="xxx" /> Without the '/', (as shown in the thread above) the xml is e...

make sure you can open the xml in your browser. If you cannot, then it is not well formed.

....each repeating "node" of the xml document gets its own output link.....leading to a different relational table.

Work with your output file and get that to work, and then you can tie them together in the same Job.

Ernie

might depend on what the service is sending back. Have you fully tested it in a tool like SOAPui? That's a good idea so that you can get very familiar with the payload that the service returns. Another good thing to do is to copy your job, then put one column on the output link from the WSClient.......

No...the Transformer reads rows and/or writes them...that is the interface to the link. Benchmark your results at the DataStage interface point and reduce the link to a single column and it will be faster. If you are on 9.1, the new Java Integration Stage achieves higher performance than the Java Tr...

Could be lots of things, but the example here would indicate that the xsd for "schema1" actually contains (at least) the element for "schema2" (with the rest being undefined... often xs:any ). Lots of ways to handle this....pass the schema2 details out as a chunk, and process it ...

The Java Stage's API reads rows "from a link" using readrow, and it writes output to DataStage links using writeRow. Then...within your java class, we assume that you have your own code to perform I/O to those databases. If you are having performance issues, determine where they are happen...

IMAM can show you a lot, but you would have to drive the managed import....meaning, you first might import database "x" using IMAM....and then weekly you might re-import database 'x' at the command line....I haven't tested all of the command line permutations for change identification, but...

WebService Client Stage ought to do it...but first be sure you are VERY familiar with the web service, the format of the data it requires, the look of the payload, etc. Test it first with a tool like SOAP UI so that you know exactly how it behaves, what parameters it needs, it's security requirement...

...I agree with you there....and there are times when it is the better choice.

Ernie

I'll let others suggest other possibilities --- there may be some, but java is the only way I've seen it done. Yes, with java you would implement your class to "talk" with the JavaClient or the Java Transformer Stage (or Java Integration Stage if you are in 9.1). ...and further, yes, it re...

In 8.7 there was a feature added that allows you to put usage tracking into Business Glossary --- so that you could then track the usage with something like Piwik or other web monitoring tools. It can show which Terms get the most hits, etc. Been awhile since I've played with it, but it was pretty c...

One way that I've seen it done is via JavaPack..(using a small java class that does whatever it needs to with HTTP). letting you do whatever you need/want with whatever you bring back via HTTP, and send content or messages downstream.

Ernie