DSXchange

I hate to be so blunt, but why? Save ISD for the single request, single transaction, milli-second response requirements that you have for address validation from a blackberry, or a java portal, or some other real time application that has many users and is coded by someone who needs abstract access ...

Tell us also what your goal is. I'm still not clear --- is the service you are calling in the WSTransformer the service published via ISD, or some other external service? ....and is the Job "with" the WSTransformer one that you are publishing with ISD? What is the overall objective? If you...

I haven't seen FastTrack used for that purpose, although I suppose it could --- but yes, you'd have to manually edit the SQL. As an observation, most sites I speak to don't allow FastTrack users to do any modeling, per se. The SQL that they "might" generate goes to the modelers for their &...

Start here:

http://dsrealtime.wordpress.com/2007/12 ... -a-source/

Read your xml with the External Source Stage....the proceed with searches thru the forum about importing your xml metadata...

Ernie

Do you have any xml jobs working? Is this your first one? Do some searching here on the forum. Look for the xml best practices guide. Then outline how you imported your metadata, whether your external source works without the xml, etc. Test also in a Server Job using Folder Stage as a source. It is ...

I noticed that when following up but haven't had a chance to dig further --- did you get any clarification on "what" specifically in your Oracle Connector was resulting in the issues? It's not happening everywhere, so must have been that Connector in combination with a particular property ...

Well...that depends. If they are just "additional tags" in an xml document (meaning, new "elements" that were added), and you aren't doing formal validation, then nothing will happen. That's the nice thing about XML. Who cares if there are new elements if you don't need them or d...

Solve one problem at a time. First, be able to extract XML. Then start working on how to read that XML. Make sure you can get the XML column from your db2 database into a flat file. Forget about parsing it for now. Assuming you can get it to a flat file, see if you can open it in IE. If that works, ...

It's still not (in its new evolved format of ISD) free......... ; )

It would be nice....but the alternate solution is very easy to set up. RTI had a web services implementation of the Job Control API also, but it was deprecated in ISD, probably because it wasn't used much.

Ernie

A regular Job, even without ISD Stages, can be published as a Service, but that support is not extended to Job Sequences.... So....... create a tiny little Server Job that has ISDInput---Transformer----ISDOutput (play with this technique first using Sequential---Transformer---Sequential until you ge...

It's just a guess. I can't think of anything in particular that would cause this to occur if you aren't using validation. Then again, many of the issues that 8.1 had with XML were namespace related. Delete all the namespace info with a test document and see what happens. Check it with a Server Job t...

Are you at 8.1 with FP1 or higher?

Are you saying that it's just this "one" specific schema it fails...or did you mean that, in the user interface, if you select "just one" schema (any of them, but only one), it fails. If the former, great, what's different about that schema..... I'm not an Oracle expert, but ther...

Some things to try... Just be safe and send it downstream in a dummy job. I never trust view data. Next, be sure you aren't trying to do validation inside the xml stage. ...and also, open one of your documents. See if it has any "SchemaLocation" information in the header. If so, edit the x...