Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Uploading Data Sources to User Console

  1. #1
    Join Date
    Apr 2015

    Exclamation Uploading Data Sources to User Console

    Hello all,

    I am currently in the process of migrating my company from version 4.8 to 5.3 of Pentaho EE.
    After using the migration tool included with 5.3, I noticed that none of my existing data sources for Interactive Reports transferred over from 4.8. I did some investigating and discovered that the .xmi files were living in the \biserver-ee\pentaho-solutions\admin\resources directory for 4.8, which the migration tool does not touch.
    It looks like I can upload each of these .xmi files one at a time to the user console in 5.3, but seeing as I have hundreds of .xmi files I was wondering if anyone knew of a better way of getting this data in to the repository?
    Any help or suggestions are appreciated!

    Thank you,


  2. #2
    Join Date
    Apr 2008


    I suggest going to to pose the same question. Since you have EE, this is exactly the kind of issue they are used to solving or need to know is a friction point.

    I would say this, you may need to import the xmi files via the datasource manager if they are really metadata schemas or some such thing. Uploading them to the repository (JCR) won't really put them in play. Also, I'm not sure why you are going to version 5.3 instead of 5.4 of the EE server. There should be no reason not to run the latest codeline that Pentaho offers. This is not like the normal patching dance they have you do where you install and old version, layer it 5 times, then go to the next bigger version.

    Check out the or import-export.bat file in your 5.x biserver-ee directory. It has options to import datasources, but painfully the syntax is different for those than for importing files from the filesystem into their new repository.

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.