SAP Stand-Alone Connection Test

To use a standalone java utility to test the connection:

1. Open a command window.
2. Change to <ODI_HOME>/odi/sdk/lib 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 <ODI_HOME>/odi/sdk/lib 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 the illustration GUID-DA168F85-5A58-4338-B912-1DE32DE44C78-default.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 the illustration GUID-590894B4-D7A0-403A-9B7D-9216F76DACD0-default.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_CODE and UPLOAD_ABAP_BASE set to true).

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