Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho Reporting Output step using a prpt from a BA Server

  1. #1
    Join Date
    Nov 2015
    Posts
    20

    Default Pentaho Reporting Output step using a prpt from a BA Server

    Hi,

    I'm trying to create a Pentaho Reporting Output step in a transformation using a report that is on a BA Server repository. Whenever I use a filesystem filepath value for "Report definition file" the step works, but if I want to use a report that is on a BA Server setting the "Report definition file" to something like "http://pentaho_user:password@localhost:8080/pentaho/api/repos/%3Apublic%3Asales_report_day.prpt" I get a HTTP 401 Unauthorized response. I also tested it substituting the "%3A" by the : (colon) and had the same result. I have the user and password embedded in the URL since there is no option to include it anywhere in the Pentaho Reporting Output step. Testing the URL on a browser like firefox works as expected.

    I have also tested with "http://localhost:8080/pentaho/api/repos/%3Apublic%3Asales_report_day.prpt?userid=pentaho_user&password=password" without success.

    What should be the correct value for the "Report definition file"?

    The transformation itself is on the BA Server too.
    BA Server 6.1
    PDI 6.1
    Last edited by oggers; 01-11-2017 at 08:16 AM.

  2. #2

    Default

    We have similar problems with Pentaho 6.1 EE (coming from Pentaho CE with file repository). We run various kettle Jobs to generate a couple of reports on a daily Basis. Scheduling doesn't seem to be a solution since there is no possibility to store the Output outside /home or /public. We transfer these reports afterwards to different Hosts, so we need the reports in a dedicated Folder outside home / public. Is there any idea how to generate reports in a kettle Transformation using a Pentaho Enterprise Repository? Neither calling pentaho/api/repos... nor hardcoding a file path (because there is no file path in a DB EE repo) seems to work. We are on https and not willing / allowed to code user credentials in a Javascript with a https call for the api. Regards David
    Last edited by DavidUgowski; 01-16-2017 at 07:49 AM.

  3. #3

    Default

    Hello oggers, did you enable URL Parameter passing? It's decribed in the following article and works with 6.1 as well: https://help.pentaho.com/Documentati...URL_Parameters I enabled the property and generated a report with kettle successfully. IMHO the whole procedure is a security risk. I would prefer to avoid passing login credentials as parameters Regards David

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.