If yous desire to job BIRT reporting every minute choice to Microsoft SSRS yous tin easily create it past times instaling BIRT on whatsoever linux distro. There are several tricks yous accept to create earlier everything volition hold out fine. We volition present yous how to install BIRT Eclipse designer, BIRT Runtime server amongst apache two together with tomcat vii together with how to add together mysql JDBC driver to Eclipse hence yous tin add together dataset to BIRT reports together with connect to data.
First yous must download Eclipse IDE, yous tin download it from here:http://download.eclipse.org/birt/downloads/
|Choose All inward one|
On the same page yous tin download BIRT runtime, runtime is of import because apache together with tomcat job birt runtime to operate your reports similar SSRS together with it is similar BIRT Report Viewer.
Here is link(I recommend yous to become to principal spider web page together with download latest): http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-4_2_1-201209181113/birt-runtime-4_2_1.zip
|Also download Latest BIRT Runtime|
After yous download bundle extract it somewhere on your disk hence yous tin easily access it later.
Now download MySQL JDBC driver for Eclipse together with Java hence yous tin brand connecter to MySql database. Here is link: https://www.mysql.com/downloads/connector/j/
|Download JDBC MySQL driver|
Now install apache2 together with tomcat7 on your Linux distro. Here nosotros job Ubuntu derivate Lubuntu 12.10. But the same matter is for Mint, Snow, Lubuntu, Kubuntu, Xubuntu, Ubvuntu Server together with versions Ubuntu 10.10 , Ubuntu 10.04 LTS, Ubuntu, 11.04, Ubuntu 11.10, Ubuntu 12.04, Ubuntu 12.10….
|Installing inward Synaptic|
When yous finished installing apache together with tomcat yous must configure it.
Open /etc/tomcat7 folder together with opened upwardly file tomcat-users.xml amongst rootage permisions.
|Open it inward about text editor, remmember that yous must hold out rootage to edit this file!|
|Uncomment lines on botton together with add together selected roles to your user.|
In file tomcat-users.xml become to bottom together with yous volition meet default users config commented. Uncoment it , add together your users together with add together roles to your admin user. Add this roles: manager-gui, manager-script, manager-jmx, manager-status.
Then restart tomcat. Enter command: sudo service tomcat7 restart
Now become to http://localhost:8080/manager/html together with come inward password yous entered inward tomcat-users.xml file. DON’T come inward localhost instead localhost:8080 because tomcat runs exclusively on localhost:8080. You tin alter that subsequently of course of study but that is default.
|Click “Choose File”|
|Choose birt.war inward folder of BIRT runtime|
|Then click “Deploy” to deploy BIRT Viewer nad teach inward active.|
|You tin meet BIRT installed when yous refresh localhost:8080/manager/html|
|Copy WebViewerExample to /var/lib/tomcat7/webapps/ROOT|
|When yous re-create WebViewerExample to /var/lib/tomcat7/webapps/ROOT, RENAME folder to birt.|
Now opened upwardly http://localhost:8080/birt together with and hence click View Example. It should display yous something similar this:
|BIRT Report Example|
Now opened upwardly Eclipse from the place where yous extracted it, yous don’t accept to install it , merely operate the file eclipse. After that Go to File-> New->Other…
|Choose Bussines Intelligence together with Reporting Tools , together with and hence Report Project|
|Click on push inward correct upper corner|
|Choose MySQL JDBC Driver Version 5.1|
|Click “Edit JAR/Zip”|
|Choose mysql-connector-java yous downloaded together with extracted previously at begining of this tutorial|
|Set connecter string to database|
…. at 1 time pattern study together with relish 🙂