Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Help - DB Config

  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Default Help - DB Config

    Today I am using the pentaho with the oracle database and is working perfectly. The problem is that the customer has an application that he wants to integrate the pentaho, but in MySQL.
    Here my doubt, it is possible to connect the Pentaho 2 different database?

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    sure, it is. You can define as many datasources (JNDI Datasources in PAC) as you want to.

    But keep in mind: A Pentaho Report only can connect to one datasource from one query. You would need to define sub-reports if you want to query data from more than one database within one report.

    Cheers,

    Tom

  3. #3
    Join Date
    Aug 2010
    Posts
    2

  4. #4
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    Seems like the objects on the left side are reports... so all you need to do is:
    a) add the missing datasource inside PAC
    b) re-configure the affected report(s) to use the other database

    Cheers,

    Tom

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.