PI to AS/400 Sync

[ernesto_cruz]

Hi Guys! I have a requirement: SOAP <-> PI <-> JDBC(AS/400). I work with SAP PI 7.10

We will concentrate in  connection PI to AS/400

The steps already ok are:

*From http://sourceforge.net/projects/jt400/ we obtain the driver jt400.jar, it is was deployed at PI.

*The connectivity was tested with the JDBVISUALIZER, I load the jar above and all ok. I have access to the BDD on AS/400.

I read the link and the link does not show a concrete solution using SAP PI.

http://scn.sap.com/thread/1386488

The doubt:

*The requirement indicates, invoke a program CL on AS/400. The program CL expects a request and returns a response, and Pi should capture the response because the interface is synchronous.

*I create the channel receiver JDBC, and I know not how to invoke the program CL on AS/400.

Any idea to achieve my requirement?

Thanks in advance.

[iaki_vila]

Hi Ernesto,

I suppose you have followed this link to install the driver

Honestly, I haven't worked yet with AS400 IBM connectivity. From my point of view i saw weird to invoke a CL program, i havent to do with a SQL statement, then with a integrator like PI will be more difficult, at least for me.

If i was you i would talk with AS400 developers in order that they will wrap the CL program in a stored procedure.

Perhaps, the more elegant way is to do it with the JDBC option Native SQL Format. You can wait for more suggestions.

Good luck!.

Regards.

[ernesto_cruz]

Hi Iñaki, thanks for your contribution. Yes, I use the link indicated to install the driver.

As for your suggestion of wrapping the CL, I will communicate with people AS/400.

And I'll keep waiting for some help to advance.

Greetings.