Connecting SAP to iSeries.

215 pts.
Tags:
AS/400 DB2
iSeries connectivity
SAP
SAP connectivity
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Haaiderali
    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.
    215 pointsBadges:
    report
  • Haaiderali
    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.
    215 pointsBadges:
    report
  • Yorkshireman
    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.
    5,580 pointsBadges:
    report
  • DB2iDBA
    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.
    40 pointsBadges:
    report
  • DB2iDBA
    change the second AS4_HOST_LIB to AS4_HOST_PORT = 446.
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following