I searched the ETL tool and found out about the Pentaho Kettle lottery.
I also need a data analyzer to work in Star Schema so that a business user can play and generate any report or matrix. PentaHo Analyzer looks good again.
The other part of the application will be developed in java, and the application must be an agnostic database.
Is Pentaho good enough or are there other tools that I should check out.
Pentaho , BI, , , . ... , , BI, , , ... , " " . , Microsoft Analysis Services , , MDX/XMLA, , , .
Pentaho, , , Postgresql Mysql. , Postgresql OLAP, , Mysql - - "" SQL, OLAP- ( GROUP BY COUNT DISTINCT). , , , , - , , , - ( ) , .
GROUP BY
COUNT DISTINCT
, . :
ETL - , , . , .
Talend . , . WTF, , .
Talend Java, ETL- . , .
. BIRT, Talend Pentaho, . , Tableau BIRT Analytics.