Example: Getting Started Transformation

...

Then we can launch Carte or the Data Integration Server to execute a query against that new virtual database table:

SELECT     dealsize, sum(sales) as total_sales, count\(*) AS nr
FROM         gst
GROUP BY dealsize
HAVING     count\(*) > 20
ORDER BY sum(sales) DESC

...

Since SQuirrel already contains most needed jar files, configuring it simply done by adding kettle-core.jar, kettle-engine.jar as a new driver jar file along with Apache Commons VFS 1.0 and scannotation.jar

Example setup: Image Added

BIRT

The following jar files need to be added:
* kettle-core.jar
* commons HTTP client
* commons code
* commons lang
* commons logging
* commons VFS (1.0)
* log4j
* scannotation

...