no need to put a DLL on the system PATH) and should also work under Linux. There’s also a Windows and a MacOS X JNI based version but unless speed is a limiting factor the JAVA only version has fewer moving parts (i.e. How to integrate SQLite JDBC with Kettle: If anybody has experience of using any of the others, let me know. Why this one? Open source (goes without saying), simple clear example of how to use it, pure JAVA option, and an active community. I decided on SQLiteJDBC from David Crawshaw. Problem, SQLite is a C implementation and doesn’t come with a JDBC driver as standard, but there are several 3rd party Java wrappers available. It does however, offer support for access to any database via a Generic Driver connection option. I’m also a big fan of Kettle ETL (now part of the growing Pentaho open-source BI family), but Kettle doesn’t offer SQLite as an one of its supported database options. Combine it with the expressive power of Ruby and you have a very powerful micro-ETL environment. Although I come from an Oracle database background, I find for day-to-day data smith’ing SQLite is ideal. I’ve been a big fan of SQLite for several years now.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |