Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Stored Procedure access from Metadata Editor

  1. #1
    Join Date
    Oct 2009
    Posts
    11

    Default Stored Procedure access from Metadata Editor

    I am new to Pentaho/Metadata editor. I have successfully created a JNDI/JDBC connection to DB2 database. Database Explorer from Metadata Editor shows all the Tables, Views, Synonyms etc., but does not list Stored Procedures. In the feature list window it has an option for showing procedures but I am not sure how to enable it.

    Is there any JNDI parameter to enable store procedures within Metadata editor ?

    I apologize if this was answered somewhere but I could not find any where. Any help in this regard much appreciated.

  2. #2
    wgorman Guest

    Default

    Hello,

    Unfortunately the metadata layer does not support stored procedures at this time. I recommend filing a feature request here: http://jira.pentaho.com/browse/PMD and then voting on the feature.

    Thanks,

    Will

  3. #3

    Default

    Is metadata editor support Store Proc now? If yes can we pass a report parameter to SP .

    Is there any document or article available to go trough.

    The current scenario for me is ..I need to build a meta model based on a SP...Since there are no direct connections to SP from metadata, I have created a view using SP and using the view as my physical connection. Now the caveat
    is the SP needs some run time parameters and the values will be user inputs ,i.e. there will be parameters in report end and I need to bind the user input value to the SP....is there a direct / indirect way to accomplish this...or this can't be done in Pentaho metada data.

    Help will be greatly appreciated
    .

    Thanks
    Amit



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.