Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This query is being parsed by the server and a transformation is being generated to convert the service transformation data into the requested format: !data-service-generated.jpeg\|border=1!
The data which is being injected is originating from the service transformation: !data-service-service.jpeg|border=1!\
So for each executed query you will see 2 transformations listed on the server.

...

!squirrel-sql-kettle-jdbc.png\|border=1,width=300!

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

...

!birt-sql-kettle-jdbc.png\|border=1,width=300!

Pentaho Report Designer

!report-designer-sql-kettle-jdbc.png\|width=300!

Simply replace the kettle-*.jar files in the lib/ folder with new files from Kettle v5.0-M1 or higher.

...

!pentaho-interactive-reporting-sql-kettle-jdbc1.png\|border=1,width=300!

Pentaho Analyses (Mondrian): Analyzer / Saiku / JPivot

...

!pentaho-analyzer-sql-kettle-jdbc1.png\|border=1!

Fun fact: Mondrian generates the following SQL for the report shown above:

...

!spoon-sql-kettle-jdbc1.png\|width=300!

DataCleaner

*TODO: ask project owners to change the current old driver class to the new thin one.*

...

!jaspersoft-sql-kettle-jdbc.png\|width=300!

To be investigated.

...