Pentaho Data Integration: Remote execution with CarteTutorial DetailsSoftware: PDI/Kettle 4.1 (download here), installed on your PC and on a serverKnowledge: Intermediate (To follow this tutorial you should have good knowledge of the software and hence not every single step will be described)Carte is an often overlooked small web server that comes with Pentaho Data Integration/Kettle. It allows remote execution of transformation and jobs. It...
Monday, 31 January 2011
Wednesday, 26 January 2011
Kettle Transformation Logging and Change Data Capture (New)
Posted on 13:09 by Unknown
Kettle Transformation Logging and Change Data CaptureUpdated Version including the great feedback from Matt Casters and Jos (both authors of the fantastic "Kettle Solutions" book)CDCSetting up LoggingA safe approach to CDCSample FileTutorial DetailsSoftware: PDI/Kettle 4.1 (download here), MySQL Server (download here)Knowledge: Intermediate (To follow this tutorial you should have good knowledge of the software and hence not every single...
Saturday, 1 January 2011
Pentaho Data Integration and Infinidb Series: Bulk Upload
Posted on 04:37 by Unknown
Pentaho Data Integration and InfiniDB Series: Bulk UploadIntroductionPrepare TablesUsing mainly Kettle stepsCheck if file existsSetup Infinidb job filesLoad TablesDelete text fileRound upUsing the power of shell scriptsSetup Infinidb job filesLoad TablesDelete text filesRound upIf things go wrong ... Error log is your friendFiles and referencesIntroductionCalpont InfiniDB is one of the more popular column oriented databases. If you are not familiar...
Subscribe to:
Posts (Atom)