Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Postgres Remote rpository or database in Pentaho Report Designer

  1. #1

    Unhappy Postgres Remote rpository or database in Pentaho Report Designer

    Hello

    I am trying to put my ip address 192.187.xx.xx in hostname field of Pentaho Report Designer Data Base.
    It is working fine if put "loaclhost" as hostname

    Getting following error as

    Error connecting to database [PGTest] rg.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database


    Error connecting to database: (using class org.postgresql.Driver)
    Something unusual has occurred to cause the driver to fail. Please report this exception.




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occurred while trying to connect to the database


    Error connecting to database: (using class org.postgresql.Driver)
    Something unusual has occurred to cause the driver to fail. Please report this exception.




    at org.pentaho.di.core.database.Database.normalConnect(Database.java:472)
    at org.pentaho.di.core.database.Database.connect(Database.java:370)
    at org.pentaho.di.core.database.Database.connect(Database.java:341)
    at org.pentaho.di.core.database.Database.connect(Database.java:331)



    Hostname :10.7.14.17
    Port :5432
    Database name postgres


    I want to use postgres data of remote pc in my report designer .Please help.

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    Are you using Pentaho Report Designer client tool or have you published your report to the Pentaho Server? You need to install the jdbc drivers for postgres in both tools. With the community edition there's no JDBC Distribution Tool, but you can manually download the .jar library from postgres documentation and put it in the corresponding path for your tool, at the end of this page there's a table indicating paths for each tool.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

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.