What Jaspersoft package is best for my requirement?

[jaspertrial3]

I am wondering if Jasper reports is the right technology to use here?

I have four tables representing users visits to four pages of a site and each table has multiple distinct say 15 attributes/columns(attributes like userid, clicked link, no of buttons ,client IP, user-agent, traffic source, campaignId etc) and each table gets populated with about a few million rows a day.

I want to build an online dashboard, which provides various reports aggregated based on combined/aggregated data of the four tables. Example: total users (or % users) who vised all 1-2-3 or 4 pages, per campaign ids, or per user-agent, etc. in last one hour, last one day, last one week etc. Also I want an external application look at these figures and notify other if certain criterias are met say if there are no request coming from a particular IP in last 1 hour.

I looked at hosting Jaspersoft AWS instance and use that for reporting for above requirement? I can host the 4 tables in RDS in AWS. Do you suggest combination of AWD RDS + AWS Jasperfott Reports Server would solve the problem here? If not any suggestions?

 

[marianol]

I think that AWS will be a good one for you to start with. Since your tables are pretty big I will probably try RedShift instead of RDS, you will have better performance there (just my 2 cents)

Once you get your instance stood up you can build the reports in Jaspersoft Studio to create your own dashboard. Also if you need some type of Alerting you can generate some specific reports withe just some raw data and use the REST API of Jaspersoft to call those reports from your application.

The good thing of AWS is that you can spin off an hourly instance to do some tests and of you need to switch this to a 24/7 service you can get a standard subscription and use the BYOL AMI's