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.