File adapter/JDBC adapter processing

[Former Member]

Hi,

I have scenarion as below

> XI gets an IDOC message from R/3

> Based on that message XI uses a fileadapter to call a UNIX shell script in the other system (system B - non SAP)for pre-processing.

> The script call returns no errors.. So, XI/BPM now uses the JDBC adapter to convert the IDOC into a JDBC insert.

> On successful inserts, the process again uses a file adapter to perform a post-processing script call

Is the above scnarion possible using JDBC/File adapters in XI/BPM ?

Thanks

mad

[sam_raju]

Hi Maddux,

Is it a pre-codintion to execute the unix shell script before inserting the data using JDBC adapter?

FYI, If there is no pre-condition and you want to send the data to two different systems, you can configure multiple receivers(both file and JDBC) in your Receiver Determination object without BPM.

-Sam Raju

[Former Member]

Yes Sam ! It is a pre and post processing for the JDBC inserts

[Former Member]

and it is all to the same target system

[sam_raju]

Hi Maddux,

Did you try these pre-processing steps in a Stored Procedure instead of Unix shell scripts?

Integrating with Unix shell scripts sometimes gets complicated.

-Sam

[Former Member]

for the preprocessing i think there is no other way as to use a different adapter, but for the post processing why not use the post processing in the JDBC Receiver adapter?

Regards

Christine

[Former Member]

Thanks Sam / Christine !

Does this mean I cannot use the combination as I mentioned ? I am verifying if the shell script is just a stored proc and can be called directly ? In a worst case scenario, can this ever be done using XI adapters ? What is the alternative ?

thanks much really !

mad

[Former Member]

oh, i do think you can use the combination as you mentioned. i just thought it would make things easier, if you used the JDBC adapter for both insert and post processing.

Regards

Christine