Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Parameterize PostgreSQL Schema in JDBC Data Source for CDE Dashboard

  1. #1
    Join Date
    Jan 2015
    Posts
    7

    Default Parameterize PostgreSQL Schema in JDBC Data Source for CDE Dashboard

    Our current data structure uses PostgreSQL schemas to keep data from different sources separate. The underlying structure within each schema is identical. The end goal would be to have a dashboard configured in such a way that the end user could pick the desired schema from a drop-down list, and the query updated to get data out of the corresponding schema.

    I've tried numerous things to remedy the problem but cannot get this to work.

    1. Add SET SCHEMA 'schema' to the query
    2. Added currentSchema=schema to the JDBC string
    3. Parameterized the schema name ${schema}.tablename

    I noticed a recent post with the same problem but the solutions appears to be specific to Report Designer. http://forums.pentaho.com/showthread...ght=set+schema

    Any help in getting a similar solution for a CDE Dashboard would be greatly appreciated.

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    your best option is probably to implement a new version of IDBDatasourceService that gets the schema name from the query string (or from a session variable).
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

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.