Feed on
Posts
Comments

Archive for the ‘Java’ Category

New universal SQLite JDBC library.

Posted in ETL, Java, SQLite, Talend, kettle, news, tagged , , on July 21, 2008 | No Comments »

Both Talend (Java) and Kettle distribute the Zentus.com pure-Java SQLite JDBC driver and for most purposes this run-anywhere version is fine. But, if you really need to take advantage of SQLite’s speed then connecting using the native JNI version is a must.  Doing this was easy enough, just change over to using a generic JDBC [...]

Read Full Post »

Groovy as Talend’s scripting language

Posted in ETL, Groovy, Java, Palo, SQLite, Talend, data, tagged , on July 20, 2008 | 5 Comments »

Although I had decided to use Talend (Java version) as my primary datasmithing tool I still had one major problem with it, its lack of a scripting tool.  Kettle (Pentaho PDI) has Javascript, Excel has VBA, Picalo has (well OK, is) Python and Talend in its Perl version has Perl.  I could have gone (and [...]

Read Full Post »

Java - at the eye of a perfect storm

Posted in ETL, Java, Palo, cloud, tagged , , , , , , , , on March 11, 2008 | 3 Comments »

The “perfect storm” of ubiquitous broadband, powerful and cheap laptops, virtual machines, cloud-based services/infrastructure and open-source software is changing the nature of IT in a way that’s reminiscent of the revolution started by the IBM PC. Although a lot of emphasis has been put on the influence of consumer-focused services on [...]

Read Full Post »

PALO ETL Server, more sightings …

Posted in ETL, Java, Palo, olap, tagged , , , , on January 3, 2008 | 1 Comment »

First day back after Christmas, snow falling outside.
More additions to the PALO ETL-Server SourceForge project, new version of the core and, a new web server - built using Jetty and Apache Axis. Axis is a SOAP handler so I looked around for the WSDL file to see what services are to be exposed and [...]

Read Full Post »

Using the latest Pure Java SQLite JDBC driver in Kettle

Posted in ETL, Java, SQLite, kettle, tagged , on October 5, 2007 | 3 Comments »

The bug in the pure Java SQLiteJDBC driver that caused an “out of memory” error when trying to connect to a SQLite database using standard windows drive letters (e.g. c:\kettle\mydata.db) is now fixed. The current version (V037) has also been updated to SQLite version 3.4.2. To use the latest driver within Kettle, download [...]

Read Full Post »

Facebook Apps using Ruby on Rails

Posted in Java, Ruby, Web2.0, tagged , , on July 19, 2007 | 2 Comments »

This is what I love about Ruby and Ruby on Rails, once you learn the basics of Ruby and how a RoR app is put together you can use this knowledge to learn about other technologies, in this case Facebook Applications. The reason for this is, as soon as a new technology hits the [...]

Read Full Post »

Talend vs. Kettle (Pentaho PDI)

Posted in BI, ETL, Java, JavaFX, JavaScript, Palo, Ruby, SQLite, Talend, kettle, xLite, tagged on May 27, 2007 | 5 Comments »

Over the last few weeks I’ve received a lot of traffic from Goggle searches comparing Talend and Kettle and also from Vincent McBurney’s ITtoolbox article comparing the two products, so where do I stand?
As ETL tools they take different approaches, Kettle is a meta data driven framework (which is in turn tightly integrated into an [...]

Read Full Post »

JavaFX - a GUI DSL

Posted in ETL, Java, JavaFX, JavaScript, Ruby, SQLite, Talend, VBA, excel, programming on May 19, 2007 | 4 Comments »

Having mastered JavaScript (OK master is too strong a word - having become comfortable with both its syntax and usage patterns) my next port of call is JavaFX the recently announced Flash/Silverlight competitor. What led me to JavaFX Script was not its role in this Flash/AJAX alternative platform (which unless  Sun improves [...]

Read Full Post »

I’ve got talend and I’m going to use it…

Posted in BI, ETL, Java, Palo, SQLite, Talend, data, excel, kettle, olap, xLite on April 30, 2007 | 1 Comment »

For the last few months I’ve being looking for my ideal ETL platform. That ideal would be open source, platform independent (well at least Windows and Linux), flexible, and easily deployable. It had looked like a combination of Kettle and my micro-ETL combinations of Ruby/SSQLite and Excel/SQLite would be the eventual “winners”. [...]

Read Full Post »