The [i]cpimport[/i] program is the fastest way to load data into a InfiniDB instance. It can be used with Pentaho's spoon as the last step in a transformation.
1. Use [i]colxml[/i] to set up the [i]cpimport[/i] job, colxml [u]-j 123[/u] -l data.tbl -t demo test
2. Set up the Spoon transformation so that the data file ends up in /usr/local/Calpont/data/bulk/data/import/ where [i]cpimport[/i] expects to find it.
3. Drag a [b]Text file output[/b] icon onto the transformation panel and link it as the last hop in the transformation.
4. Double click on the icon. Set the Filename to [i]/usr/local/Calpont/bin/cpimport -j 123[/i] and select [i]'Run this as a command instead?'[/i]
5. Run the transformation.
A more detailed document on using Spoon with InfiniDB is in the works.