Solihull
10-16-2007, 06:02 PM
Can Pentaho be deployed over the web accessing a multi tenanted SQL server BD?
mtarallo
10-17-2007, 03:19 AM
Yes it can.
There are a number of ways this can be achieved.
For example, the Pentaho BI Platform can be deployed as a web application to any J2EE application server. So you could have a separate instance for each tenant with a footprint as little as 2 MB each on the same app server. Each with it's own repository.
You could have a single Pentaho web app and single repository. Pentaho then can access the data via JDBC and can be configured to point that instance of JDBC to the specific MSSQL tenant.