Connecting SAP to iSeries.
We are undergoing a project implementation in which we need to connect SAP to iSeries where SAP would be the target for fetching data from iSeries which is the source. Can anyone help me by providing the steps involved for Connecting SAP to iSeries. Also let me know if any addtional product is to be installed on SAP or iSeries. Thanks in advance. Haaider Ali
Software/Hardware used:
iSeries 570, V6R1
Software/Hardware used:
iSeries 570, V6R1
ASKED:
September 14, 2011 7:40 AM
UPDATED:
March 31, 2012 4:37 PM
Answer Wiki:
I seem to remember that SAP have a versio that runs natively on IBM i, so they should know all your answers.
Have you tried asking them?
Have you defined exactly *what* information needs to move?
I've written a few SAP interfaces for different companies, so the functionality to move data is OK, but you need to have a definition of what you need before we can help on the specifics.
To see all answers submitted to the Answer Wiki: View Answer History.
At Present on one hand we have SAP running on IBM P Series and on the other we have a Library A on IBM iSeries. Through SAP we want to extract data from Library A which on IBM iSeries.
But before that we need to create a handshake / link between SAP (P Series) and Library A (iSeries) so that data transfer take place from iSeries to P Series.
SAP is on AIX. SAP Team is trying to connect to DB2 of iSeries using DB Connect Function of SAP where they need some parameters like DB2 NAME along with the below mentioned parameters AS4_HOST, AS4_DB_LIBRARY, AS4_NQE_OPTIMIZE_METHOD, AS4_QAQQINILIB, AS4_HOST_PORT.
If you have a DB Connect tool, then the answer will lie in the documentation of that product. It’s evidently not a pioneering thing to do.
AS4_HOST should equal your RDB name for your system, WRKRDBDIRE and look for *LOCAL entry, and have a DNS entry on your network as well for this value that points to a valid TCP/IP interface. AS4_DB_LIBRARY should equal your data library which you call Data Library A. AS4_HOST_LIB default is 446, ensure the database server jobs are started on the i Series, AS4_NQE_OPTIMIZE_METHOD=F, and leave QAQQINILIB out or default it unless you have created your own version.
change the second AS4_HOST_LIB to AS4_HOST_PORT = 446.