What's the best way to connect Cognos with SAP 4.6c on iseries V5R4

[Former Member]

We have SAP 4.6c on iseries V5r4.

What's the best way to connect Cognos with SAP so that data could be extracted from SAP and create reports with Cognos.

Thanks

Joe

[christian_bartels · Accepted solution]

I have no practical experience with that, but you can find supported environments here: http://www.ibm.com/support/docview.wss?uid=swg27014110. According to that one, accessing DB2 on IBM i is supported through the DB2 Connect Runtime Client and ODBC via iSeries Access.

Kind regards,

Christian Bartels.

[Former Member · Accepted solution]

Hi Christian,

Does that mean that we will have to install DB2 Connect 8.2 Runtime Client on the AIX/HP-UX (PA-RISC), Solaris, Windows box running the COGNOS 8 SERVER, DATA MANAGER (8) and TRANSFORMER ??/

Can DB connect 8.2 Runtime Client talk to the DB2/400 database? Aren't they kinda different?

Where do we find the DB connect 8.2 Runtime Client???

Thanks

Abhi

[christian_bartels · Accepted solution]

DB2 Connect version 8.2 is no longer supported by IBM (support ended April 30, 2009, see http://www.ibm.com/software/data/support/lifecycle/). As far as I know, DB2 Connect is communicating through DRDA, which is a platform-independent protocol supported by all DB2 platforms, so any DB2 Connect client should be able to talk to any DB2 database. However, there may be limitations on the supported release combinations.

Kind regards,

Christian Bartels.

Edited by: Christian Bartels on Sep 6, 2010 4:17 AM