What are the useful resources which I refer while trying out AWS?

• Referring this  https://help.ubuntu.com/11.04/serverguide/mysql.html
• On how to start,stop mysql in ubuntu
• Referring this  http://www.keywordintellect.com/tutorials/amazon-ec2-scalable-web-hosting/
• Scalable web hosting with Amazon EC2 including launch instance, using putty with EC2
• Referring this  http://www.techsww.com/tutorials/database_management_systems/mysql/installation/how_to_install_mysql_client_ubuntu_linux.php
• Instructions for installing mysql client on ubuntu
• Referring this  http://www.wikihow.com/Install-Oracle-Java-on-Ubuntu-Linux
• Instuctions for installing Oracle JDK
• Referring this http://blog.peterdelahunty.com/2009/06/deploying-grails-app-on-ec2-in-from.html

• Download the Firefox plugins
• Instructions for starting baseline Linux image
• Instructions for installing Tomcat, mysql
• Referring this http://codingthis.com/applications/uploading-files-to-your-amazon-ec2-server-using-winscp/

• Using winscp with Amazon EC2
• Referring this http://hoodbook.wordpress.com/2009/10/13/into-the-cloud-migrating-my-apachejbossmysql-applications-to-amazon%E2%80%99s-ec2-part-ii/
• Get an Elastic IP
• Running JBoss on Amazon EC2
• Referring this http://matthom.com/archive/2012/03/26/using-amazon-rds-for-mysql-in-the-cloud
• Setup mysql on Amazon RDS
• Referring this  http://seamframework.org/153035.lace
• Setup JBoss 4.2.3 Mail service for Amazon SES
• Referring this  http://ubuntuforums.org/showthread.php?t=1696998 
• Setup build-essentials to compile swftools
• Referring this  https://designbye.wordpress.com/2010/02/23/installing-swftools-and-pdf2swf-on-ubuntu-linux/
• Remember to do this: sudo apt-get install --reinstall zlibc zlib1g zlib1g-dev 
• Setup swftools and pdf2swf on ubuntu

What Useful Resources for Pentaho BI CE?

SagoBI looks complex and it takes time to get familiar as compared to http://art.sourceforge.net

I proceed to try out Pentaho BI CE instead, here are the resources I have adopted in my journey:

Suites and Plugins

• This post got the latest update (CE 4.5). This post provides very comprehensive checklist for all the things to be install:  http://interestingittips.wordpress.com/2011/04/27/complete-pentaho-installation-on-ubuntu-part-1/
• Pentaho BI Server CE 3.7 setup but the step-by-step modifications to be perform on the various xml files is clearer than interestingtips -  http://www.prashantraju.com/projects/pentaho/
• Further instructions including including saiku and ctools 
• http://pablotips.blogspot.sg/p/installing-tomcat-and-pentaho.html
• How to add Saiku, BI Server and JPivot OLAP datasource?
• http://interestingittips.wordpress.com/2011/05/08/complete-pentaho-installation-on-ubuntu-part-3/
• The "Eclipses" to download  http://interestingittips.wordpress.com/tag/pentaho-tools/
• Pendular - Another front-end for Pentao BI Server

What interestingtips missed out?

• Recently released : Saiku Report 1.0 ( http://mgiepz.github.com/saiku-reporting/)
• OpenI ( http://openi.org/)

Patches

• Things to modify for the charts in examples to run  http://interestingittips.wordpress.com/2011/05/05/complete-pentaho-installation-on-ubuntu-part-2/
• How to remove the warning messages?  http://interestingittips.wordpress.com/2011/06/05/complete-pentaho-installation-on-ubuntu-part-5/

Tutorials

• Creating Dashboards with CDE:
• http://type-exit.org/adventures-with-open-source-bi/2011/06/creating-dashboards-with-cde/ (no need to seperately download CCC)
• How to join two fact tables with Pentaho Metaeditor?  http://diethardsteiner.blogspot.sg/2011/02/pentaho-metadata-editor-joining-two_04.html

Documentation

• Pentaho Mondrian 3.0.4 Guide  http://docs.huihoo.com/mondrian/

What are the Alternatives to OpenReport?

OpenReports (http://oreports.com/) is being viewed to be DEPRECATED.

Alternatives include the following:

• Open Report V2 (http://code.google.com/p/openreportv2/) - newcomer?
• ReportServer (http://reportserver.datenwerke.net) - seems like not very popular based on the number of postings on the forum
• OpenI (http://openi.org/) - doesn't look comfortable ...
• ART (http://art.sourceforge.net/) - looks ok to try further

InfoQ: Dan Allen on Arquillian Testing Framework

Might be an interesting library to consider if you want to go beyond JUnit:
InfoQ: Dan Allen on Arquillian Testing Framework

What are the Free Cloud Services?

As metioned by Xeround:
http://xeround.com/blog/2012/03/free-cloud-services-for-application-developers

Where to find 3D Ribbon Generator?

Can use this to generate a CSS3 ribbon:
http://www.css3d.net/ribbon-generator

How to do XML <-> JSON?

One option found:
http://beckchr.github.com/staxon/

What is kuler?

http://kuler.adobe.com

What are the Date and Time Picker in ExtJS?

There are a few available:

• apleshkov DateTimePicker -  https://github.com/apleshkov/DateTimePicker
• DateTimeField -   http://www.sencha.com/forum/showthread.php?22661-new-version-DateTime-Field
• 
  

What are the Possible Ways to Draw a Timeline Widget?

Nothing come close in ExtJS (.

Possible methods:

1. This will be the first choice if there is no concern on the learning curve. SIMILE Widget - http://www.simile-widgets.org/
2. By Pure CSS Method, as mentioned in Pure CSS Timeline.
3. jQuery Timelinr -  http://www.csslab.cl/2011/08/18/jquery-timelinr/ - if you only need years
4. timeglider -  http://timeglider.com/jquery/  - it's not free for commercial use
5. Finally found something which might just be what we want: CHAP Links Library -  http://links.sourceforge.net/