Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How could I let one schema file include other schema?

  1. #1
    Join Date
    May 2013
    Posts
    9

    Question How could I let one schema file include other schema?

    We have 5-6 Systems, and each system let different member to maintain.

    So I want create schema files for each systems' member to maintain , but parts of dimension are the same in these system.

    How could I let one schema file include other schema?

    or others comment for sharing these situation solution?

  2. #2
    Join Date
    Jan 2013
    Posts
    796

    Default

    One thing I've done in the past is drive schema creation from a servlet. That allows doing things like using a template and swapping in the just the features that change from customer to customer. You can configure your datasource.xml to point to the URL of the servlet, passing whatever customer identifier you need per separate catalog. You can even go one further and have the datasource.xml dynamically generated. I should note that when I used this technique I was not using biserver--this is probably not an option if you are.

    I'm sure there are other ways to approach this, though-- anyone else have suggestions?
    Last edited by mcampbell; 07-09-2013 at 08:35 AM.

  3. #3

    Default

    May be using Kettle to merge XMLs together will do good? The Kettle job/transformation can be then natively used on the Pentaho bi-server.

    Also it will be good considering the usage of version control on the server (refreshing in automatic mode on schedule) to get the actual versions from your peers (this is completely the same as general development process).

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.