Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Trouble connecting PDI to Remote Oracle

  1. #1

    Default Trouble connecting PDI to Remote Oracle

    Hi,

    This is my first time when i tried to connect to Oracle from PDI.
    I have remote Oracle server and I provide all info required in the direct connection windw (host name, database, port, user/pass).
    When testing connection I'm getting message:
    Code:
    Driver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed. oracle.jdbc.driver.OracleDriver
    I'm using PDI the community edition.
    Can somebody tell me where I should have the jdbc driver placed?
    Thanks

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    JDBC drivers for commercial products (like Oracle RDB) are not bundled with pdi-ce.
    You must download the driver from the vendor site and install it yourself.
    So long, and thanks for all the fish.

  3. #3

    Default

    Thanks,

    I downloaded and it works already.

  4. #4
    Join Date
    Dec 2016
    Posts
    2

    Default

    You have to copy the ojdbc jar into the <path/to/penthao-bi-server>/tomcat/lib
    then see here:
    http://wiki.pentaho.com/display/EAI/Oracle

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.