Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: [PDI and BA Server] Sap Connection

  1. #1

    Question [PDI and BA Server] Sap Connection

    Hi...


    I'm using Pentaho Community suite.


    I met you on Pentaho Day 2017 and you said me that I could ask you my questions.


    In PDI I created a Transformation using SAP Input to connect on SAP and extract informations to a XLS file. This transformation is running correclty on PDI without errors.


    When I try to execute this on Pentaho BA Server, using the Kettle ("http://localhost:8080/pentaho/kettle/executeTrans") the transformation don't work correctly. The log message is:


    " Possibly the SAP JCo implementation library (e.g. sapjco3.dll) does not exist or cannot be loaded. Please copy it to your libext directory! "


    On PDI this error does not happen just on BA Server.


    I need execute this on BA Server because this will be executed by user or by another application calling the transformation (e.g. http://localhost:8080/pentaho/kettle/executeTrans).


    My question is where I need put the sapjco3.dll and sapjco3.jar files?
    I tried put it on "/pentaho-server/tomcat/lib/" , "/pentaho-server/tomcat/webapps/pentaho/WEB-INF/lib/" , "/pentaho-server/pentaho-solutions/system/kettle/plugins/kettle-sap-plugin/" but did not work.


    Could you help me?


    Thank you.


    Regards,

  2. #2

    Question PDI and BA Server, Sap Connection

    Hi...


    I'm using Pentaho Community suite.


    I met you on Pentaho Day 2017 and you said me that I could ask you my questions.


    In PDI I created a Transformation using SAP Input to connect on SAP and extract informations to a XLS file. This transformation is running correclty on PDI without errors.


    When I try to execute this on Pentaho BA Server, using the Kettle ("http://localhost:8080/pentaho/kettle/executeTrans") the transformation don't work correctly. The log message is:


    " Possibly the SAP JCo implementation library (e.g. sapjco3.dll) does not exist or cannot be loaded. Please copy it to your libext directory! "


    On PDI this error does not happen just on BA Server.


    I need execute this on BA Server because this will be executed by user or by another application calling the transformation (e.g. http://localhost:8080/pentaho/kettle/executeTrans).


    My question is where I need put the sapjco3.dll and sapjco3.jar files?
    I tried put it on "/pentaho-server/tomcat/lib/" , "/pentaho-server/tomcat/webapps/pentaho/WEB-INF/lib/" , "/pentaho-server/pentaho-solutions/system/kettle/plugins/kettle-sap-plugin/" but did not work.


    Could you help me?


    Thank you.


    Regards,

  3. #3

    Default

    You need put sapjco3.dll on PentahoIntalltatonPATH\data-integration\libext
    and sapjco3.jar on PentahoIntalltatonPATH\data-integration\lib

    Folder libext cuold be does not exists, you need create it.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.