Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Running reports accross multiple MySQL databases with the same schema

  1. #1

    Lightbulb Running reports accross multiple MySQL databases with the same schema

    Every client of our online services has its own mysql database. All databases has exactly same schema, however # of databases is very dynamic as we archive database for inactive client's as well as new db gets created after every signup. Is there a way to make kettle/pentaho to run reports in this kind of environment?

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The database to use in your Kettle database connection can be specified through a variable.
    So long, and thanks for all the fish.

  3. #3

    Default

    I couldn't find any example or documentation on how to use variables to specify list of databases to connect to :/ Any suggestions? Thanks

Tags for this Thread

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.