Netweaver PI - Third party adapter to integrate with AS/400

[Former Member]

We are planning to integrate SAP XI with AS/400 ..

Does any one know the different options other than generating the files and JDBC adapter.?

or Any third pary adapter to directly communicate with AS/400 apps.

[Former Member]

Hello Satya,

For integrating SAP XI with AS/400 there are three options :

1) File Transfer

2) JDBC : for which only thing u need to do Deploy the following possible drivers :

There are two types of DB2 JDBC Drivers are available.

1.The "Native" JDBC driver. Driver: com.ibm.db2.jdbc.app.DB2Driver

Sub protocol: db2Ex.jdbc: db2: localhost/COLLECTIONNAME

2.The "Toolbox" JDBC driver. Driver: com.ibm.as400.access.AS400JDBCDriver

Sub protocol: as400

Ex.jdbc: as400://MACHINENAME/COLLECTIONNAME

JdbcUrl=jdbc: db2://hostadres: portno/databasename

If you want to download the driver for DB2, then I think you can do it from these links,

http://www-128.ibm.com/developerworks/db2/downloads/jcc/

http://www-128.ibm.com/developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html

3) JMS : For which we require JMS provider.But advantage of it is :

JMS provides a robust way of Transporting XML data

Supports Asynchronous and Synchronous messaging

If application is busy the messages gets queued up on JMS server

Supports Multiple Senders and Multiple Receivers

4) Third Party iway Adapter for iseries (AS400)

[Former Member]

in addition to FTP and JDBC,you can also use JMS to integrate AS400

Thanx

Aamir

[Former Member]

Hi We had a similar situation at one of my earlier clients and we used JDBC adapter. We have to import the AS/400 Jar files to use the JDBC adapter.