I just downloaded jasperreports server (community edition) which uses postgresql. (there is no option to install using a mysql database). All my databases are using mysql server. The question is does the community edition of jasperreports server have ETL as an embedded functionality since jaspersoft etl is available as a separate download?
If not does this mean I have to convert all the mysql databases to use the postgresql server?
Rumbi
No and you don't need to convert. You can in fact install JasperServer in MySQL though, I'm just not sure if you can do it with the standard installer or if you have to make modifications. But only the JasperServer data is stored in the postgresql db(JRXML files, jasperserver credentials, etc.) you can certainly still build reports off of your MySQL databases and would not have to convert them to postgresql.
Here is a post someone wrote about installing JasperServer on MySQL 5.5 - link
EDIT: The current version (Sept 2015) JasperReports Community Edition does have ETL now download link It is a modified form of Talend Data Integrations.