Skip Headers
Oracle® Fusion Middleware Getting Started with SAP ABAP BW Adapter for Oracle Data Integrator
11g Release 1 (11.1.1)

Part Number E16597-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

C SAP Stand-Alone Connection Test

This appendix describes how to perform an SAP stand-alone connection test.

In addition to the Connection Testing described above, a test can be performed outside of ODI using a standalone java utility:

SAP Stand-Alone Connection Test

To use a standalone java utility to test the connection:

  1. Open a command window.

  2. Change to oracledi/drivers directory.

  3. Make sure that JAVA_HOME points to a JVM (at least 1.5).

  4. Make sure that you have installed SAP Java Connector and that the sapjco3.jar and the sapjco3 library are in the oracledi/drivers directory.

  5. Launch the utility using the following command:

    On Windows:

    java -cp sapjco3.jar;odi-sap.jar oracle.odi.sap.km.test.JCoTest

    On Linux/UNIX:

    java -cp sapjco3.jar:odi-sap.jar oracle.odi.sap.km.test.JCoTest

    This should result in an output similar to this:

    Description of image134.jpg follows
    Description of the illustration image134.jpg

  6. Use a text editor to open the ODI_SAP_CON_POOL.jcoDestination file in the oracledi/drivers directory. The file should look like this:

    #for tests only!
    jco.client.lang=EN
    jco.destination.peak_limit=10
    jco.client.client=800
    jco.client.passwd=<SAP Password>
    jco.client.user=<SAP User>
    jco.client.sysnr=00
    jco.destination.pool_capacity=5
    jco.client.ashost=<SAP Application Server>
    
  7. Enter your SAP connection information, which you have received from your SAP administrator. The file will then look similar to this (use your connection information!):

    #for tests only !
    jco.client.lang=EN
    jco.destination.peak_limit=10
    jco.client.client=800
    jco.client.passwd=ODI123
    jco.client.user=ODI
    jco.client.sysnr=00
    jco.destination.pool_capacity=5
    jco.client.ashost=123.123.123.123.
    
  8. Launch the utility again using the following command:

    On Windows:

    java -cp sapjco3.jar;odi-sap.jar oracle.odi.sap.km.test.JCoTest

    On Linux/UNIX:

    java -cp sapjco3.jar:odi-sap.jar oracle.odi.sap.km.test.JCoTest

    This should result in an output similar to this:

    Description of image136.jpg follows
    Description of the illustration image136.jpg

    In addition to just testing the SAP connection, the utility will also validate the existence of certain Function Modules required for the RKM. These are installed during first execution of the RKM (UPLOAD_ABAP = Yes).

  9. Delete the ODI_SAP_CON_POOL.jcoDestination file after execution, as it contains the SAP login credentials.