Can transformations have more than one input source

[vpantvai]

I am trying to chain 3 operations - the first 2 are transformations that create two targets. The 3rd is a webservice call whose source needs to combine result data from these two targets. I see no way to do this - is this possible?

Another question - in the above scenario, is there anyway to have the targets of the two transformations remain in temp storage i.e. memory - it does not seem to allow that, so for now I am having to save the targets as files.

[Ilan]

Assuming that the first two operations create multi-record targets, then the best way to have multiple sources for the third operation is to store your results in database tables vs files. You can select from multiple tables and create a relationship between these tables in defining your source.

If you do not have a database readily available, you can use PostgreSQL provided as part of the Jitterbit Server to test this out.

The current functionality does store global variables that can be used between operations, however, the current version does not support global variable arrays. We plan to provide this. We also plan to provide support for mutiple sources (different database and files in one source).

Please tell us if you need further assistance.

Thanks.

[vpantvai]

So I guess what you are saying is that I should create two tables one for each of the targets and then the specify the source for the webservice as a join of these tables. Is that correct? Will try that out and let you know.

Another question - how do the success and failure actions for a webservice operation determine success or failure? Axis typically delivers a web service exception as a soap fault entry (<soapenv:Fault>) in the message. Does Jitterbit look for this soap fault to determine webservice call failure?

[emanuel]

Hi,

the answer to your soap fault question is yes, the Jitterbit server recognizes a soap fault response and reports that as a failure to call the web service.

As Ilan noted it is not currently possible to use two input files as source for a single output target, in your case the web service request. Using a database is probably the best way to go.

Having results stored in temporary storage will be possible in a later release, this will not help you in combining the result of two targets though.

/Emanuel

[vpantvai]

Actually I am having second thoughts about the database table approach - in the two transformations that I have mentioned there is no data that is common betwen the two results that I can use as a key to relate the appropriate records in the two tables.

[Henrik Nordberg]

Another way to do it, is to output the first operation to a file and the second to a database. The third transformation would then transform from the file to the web service. In each mapping you can call the DBLookup() script function to get data from the database, that the second operation generated.

Cheers,
- Henrik

[vpantvai]

That sounds like something that is likely to work - will try and let you know. Thanks.