SAP PI reading data from AS400

[Former Member]

Hi All,

The scenario is from AS400 to ECC.

Requirement - PI has to read data from AS400. In AS400, data is arranged in some flat file format with Field Fixed Lengths and file doesnot have any extension(.txt/.csv/...). It is stored as physical file.

I have created a sender FTP channel with content conversion. Here PI is able to read only the 1st record and the values for the fields are appearing as special charater.

Please provide your valuable inputs regarding how PI can read physical files from AS400.

Thanks and Regards,

Shweta

[Former Member · Accepted solution]

Hi mate,       Yes, in AS400 the "files" are tables saved in libraries. It means, you must read the data as a table. CommChannel: JDBC Receiver Message mapping: SELECT Regards

[Former Member]

Hi Can,

Thanks for the reply.

Now we are going to use JDBC adapter for this scenario. Could you please help in how to install external JDBC drivers for AS400 on PI server and which drivers are required for the same.

PI version is 7.4

Thanks in Advanced...

Regards,

Shweta

[Former Member]

Hi,

    In the CommChannel configuration. JDBC,

JDBC  Driver: com.ibm.as400.access.AS400JDBCDriver

Connection:  jdbc:AS400://AS400SERVER_NAME/AS400_LIBRARY;errors=full;prompt=false;hold input locators=true;hold statements=true;true autocommit=true;naming=sql

Then the user and passw-

Regards