5432: PostgreSQL Server
8080: BA Server Tomcat Web Server Startup Port
8012: BA Server Shutdown Port
9080: DI Server Port
9001: HSQL Server Port
9092: Embedded H2 Database
50000 or 50006: Monet Database Port
Windows, Android, iPhone / iPad, Mac
Pentaho Repository supports for a collaborative ETL environment wherein jobs and transformations can be stored, managed, maintained with full revision history to track changes, compare revisions and revert to previous versions on-demand with enterprise security and content locking.
In Pentaho only Admin has the right to change the users password, but it supports the same through code customization.
Relational Databases, Analytic Databases, NoSQL Databases, Hadoop and other Data Sources such as Files, Business Applications, etc.,
For more details visit: http://www.pentaho.com/data-sources-for-business-analytics
Pentaho provides support to make the calculated measures available to all users by saving it directly to the data source and not just to your reports. It can be saved either using the Layout Panel, Report Panel or in the properties dialog box by using the option ‘Add to Data Source’.
Pentaho Administration perspective enables Admin to set up the user and their roles, configure an outgoing email server, change authentication settings on the Pentaho server, manage Pentaho software license, delete older generated files.
Lots of people in your organization spend time manually producing reports –downloading data into Excel, manipulating it then e-mailing it out. It’s costly and error prone.
Pentaho Data Integration provides advanced clustering and partitioning capabilities that allow organizations to scale out their data integration deployments.
Data Ingestion, Manipulation and Integration, Enterprise and Ad Hoc Reporting, Data Discovery and Visualization
Predictive Analytics.