Another BI technology I'm exploring right now is Jaspersoft. It's a powerful Open Source BI tool which is a bit similar to Oracle Hyperion. And since it uses Open Source technology, this means it's way cheaper and easier to sell. lol
Going back to the topic, I'd like to share how easy it is to configure your Jasper Server to use it's report scheduler facility.
Step 1 : Look for your Web-Inf folder from your Jaspersoft folder. I'm using Jaspersoft's later version (3.7) so mine is located at ..\jasperserver-pro-3.7\apache-tomcat\webapps\jasperserver-pro\WEB-INF .
Step 2:At the
js.quartz.properties file, add your smtp and email credentials. If you are using gmail, be sure to use the 587 port as 465 port does not work well with gmail.
For example :
report.scheduler.mail.sender.host= your mail server
(smtp.gmail.com for gmail) report.scheduler.mail.sender.username=
your email's username report.scheduler.mail.sender.password=
your email's password report.scheduler.mail.sender.from=
your email address report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=587
report.scheduler.web.deployment.uri=http://localhost:8080/jasperserver-pro
(This url should be the same url you see when you open your Jasperserver login page. You only need to remove login.php)
Step 3 (Optional) : If you'de like to increase your thread pool, you may do so by modifying the file
js.quartz.base.properties .
Locate the line
org.quartz.threadPool.threadCount and increase the thread count.
For example:
org.quartz.threadPool.threadCount = 3
Step 4 :At the
applicationContext-report-scheduling.xml file, locate the bean id
reportSchedulerMailSender . Modify and add the following prop key under the property
javaMailProperties.
For Example :
prop key="mail.smtp.auth">true
prop key="mail.smtp.starttls.enable">true
Step 5:Restart your Jasperserver and schedule your report =)
Cheers!