{"id":212,"date":"2006-11-20T14:17:01","date_gmt":"2006-11-20T21:17:01","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/11\/20\/command-line-etl-job-execution\/"},"modified":"2006-11-20T14:17:01","modified_gmt":"2006-11-20T21:17:01","slug":"command-line-etl-job-execution","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/11\/20\/command-line-etl-job-execution\/","title":{"rendered":"Command line ETL Job Execution"},"content":{"rendered":"<p>I know this might seem pretty obivous to those that use Kettle frequently, but there&#8217;s a VERY easy way to execute Kettle jobs at the command line.  Kitchen is the command line interface and is quite convenient for executing that ETL job you&#8217;ve built.  Crontab anyone?<\/p>\n<blockquote><p>kitchen.sh -file=\/mnt\/pentaho-professional\/pentaho-solutions\/software-quality\/data\/etl\/jira_do_everything.kjb<br \/>\n-OR-<br \/>\n<strike>kitchen.bat -file=c:\\dir\\jira_do_everything.kjb<\/strike><br \/>\nkitchen.bat \/file:&#8221;c:\\dir\\jira_do_everything.kjb&#8221; (from comments below, thanks!!!)<\/p><\/blockquote>\n<p>Does anyone use kitchen or pan and have any best practices or suggestions to offer?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I know this might seem pretty obivous to those that use Kettle frequently, but there&#8217;s a VERY easy way to execute Kettle jobs at the command line. Kitchen is the command line interface and is quite convenient for executing that ETL job you&#8217;ve built. Crontab anyone? kitchen.sh -file=\/mnt\/pentaho-professional\/pentaho-solutions\/software-quality\/data\/etl\/jira_do_everything.kjb -OR- kitchen.bat -file=c:\\dir\\jira_do_everything.kjb kitchen.bat \/file:&#8221;c:\\dir\\jira_do_everything.kjb&#8221; (from comments [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15,11],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/212"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}