{"id":1987,"date":"2013-08-16T10:07:58","date_gmt":"2013-08-16T14:37:58","guid":{"rendered":"http:\/\/www.danielpradilla.info\/blog\/?p=1987"},"modified":"2015-04-07T16:51:09","modified_gmt":"2015-04-07T21:21:09","slug":"short-guide-to-pentaho-data-integration","status":"publish","type":"post","link":"https:\/\/www.danielpradilla.info\/blog\/short-guide-to-pentaho-data-integration\/","title":{"rendered":"A short and sweet introduction to Pentaho Data Integration"},"content":{"rendered":"

\"6906OT_Instant<\/a>
\nWhenever I have to create or maintain a Pentaho Data Integration scheduled job I have to go back to the Pentaho wiki or google for use cases. Although I should, I never remember the specifics and going through 2007 forum posts and outdated documentation is always a pain.<\/p>\n

Recently, I stumbled upon Instant Pentaho Data Integration Kitchen<\/a>, a quick and inexpensive reference guide for using the PDI command line tools.<\/p>\n

Sergio Ramazzina guides you through the process of designing a simple Data Integration job \u00e2\u20ac\u201calong with best practices that will ease your life come maintenance day\u00e2\u20ac\u201c, using the proper command line tool and scheduling the transformation for periodic execution.<\/p>\n

If you’re looking for a short, inexpensive and authoritative guide on creating Pentaho Data Integration jobs and scheduling them using the command line tools, this is it.<\/p>\n

Instant Pentaho Data Integration Kitchen<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Whenever I have to create or maintain a Pentaho Data Integration scheduled job I have to go back to the Pentaho wiki or google for use cases. Although I should, I never remember the specifics and going through 2007 forum posts and outdated documentation is always a pain. Recently, I stumbled upon Instant Pentaho Data… Continue reading A short and sweet introduction to Pentaho Data Integration<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[172,331],"tags":[],"class_list":["post-1987","post","type-post","status-publish","format-standard","hentry","category-projectmanagement-en","category-software-development-en-en","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1tlzy-w3","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1984,"url":"https:\/\/www.danielpradilla.info\/blog\/una-breve-guia-de-pentaho-data-integration\/","url_meta":{"origin":1987,"position":0},"title":"Una breve gu\u00c3\u00ada de Pentaho Data Integration","author":"Daniel Pradilla","date":"16\/08\/2013","format":false,"excerpt":"Cada vez que tengo que mantener un job de Pentaho Data Integration, tengo que volver al wiki de Pentaho o buscar en google algunos casos de uso. Aunque deber\u00c3\u00ada, nunca recuerdo los detalles espec\u00c3\u00adficos y buscar entre posts de 2007 y documentaci\u00c3\u00b3n a\u00c3\u00b1eja, es siempre doloroso. Hace poco, me tropec\u00c3\u00a9\u2026","rel":"","context":"In "Control de Proyectos"","block_context":{"text":"Control de Proyectos","link":"https:\/\/www.danielpradilla.info\/blog\/category\/controldeproyectos\/"},"img":{"alt_text":"6906OT_Instant Pentaho Data Integration Kitchen","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/6906OT_Instant-Pentaho-Data-Integration-Kitchen.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2174,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-connect-pentaho-data-integration-to-sap-hana\/","url_meta":{"origin":1987,"position":1},"title":"How to Connect Pentaho Data Integration to SAP HANA","author":"Daniel Pradilla","date":"22\/06\/2016","format":false,"excerpt":"Recently I had to connect Pentaho Data Integration to SAP HANA and I made some notes along the way: The first step is to get the SAP HANA JDBC driver, a file called ngdbc.jar. The quickest way is to\u00a0download and install the SAP HANA client from the SAP Software Download\u2026","rel":"","context":"In "Software Dev."","block_context":{"text":"Software Dev.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/software-development-en-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2016\/06\/pentaho-saphana.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2016\/06\/pentaho-saphana.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2016\/06\/pentaho-saphana.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2224,"url":"https:\/\/www.danielpradilla.info\/blog\/pentaho-is-slow-for-servers-with-too-many-home-directories\/","url_meta":{"origin":1987,"position":2},"title":"Pentaho is slow for servers with too many home directories","author":"Daniel Pradilla","date":"28\/04\/2018","format":false,"excerpt":"Over the course of two years, browsing solutions on our Pentaho 5.4 server became progressively slow. It came to a point in which you had to wait 2-3 minutes to see the list of solutions in the Pentaho User Console. The catalina log didn't say much and we didn't have\u2026","rel":"","context":"In "Software Dev."","block_context":{"text":"Software Dev.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/software-development-en-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2020,"url":"https:\/\/www.danielpradilla.info\/blog\/zoomdata-bi-without-etl\/","url_meta":{"origin":1987,"position":3},"title":"Zoomdata: BI without ETL","author":"Daniel Pradilla","date":"29\/10\/2013","format":false,"excerpt":"This weekend I took a few minutes to test Zoomdata. And when I say minutes, I literally mean minutes. These guys have done an amazing job to provide a quick mobile-ready demo that you can download as a VM, or as I did, install from an RPM package in a\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"zoomdata","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/10\/zoomdata.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/10\/zoomdata.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/10\/zoomdata.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/10\/zoomdata.jpg?resize=700%2C400 2x"},"classes":[]},{"id":1846,"url":"https:\/\/www.danielpradilla.info\/blog\/post-capitalist\/","url_meta":{"origin":1987,"position":4},"title":"Post-Capitalist Society","author":"Daniel Pradilla","date":"23\/12\/2012","format":false,"excerpt":"Fifteen years ago, Peter Drucker's Post-Capitalist Society (1993)\u00a0changed my life forever. The main idea behind Post-Capitalist Society is that the economic rules that governed the world up to the 1980's are (or were?) obsolete; that the land, labor and capital, and other capitalism engines had seized to be. And that\u2026","rel":"","context":"In "Lifestyle"","block_context":{"text":"Lifestyle","link":"https:\/\/www.danielpradilla.info\/blog\/category\/lifestyle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2010\/10\/519Wz97ezdL._SL160_.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2162,"url":"https:\/\/www.danielpradilla.info\/blog\/the-incredible-rarity-of-falsifying-data-about-changing-your-mind\/","url_meta":{"origin":1987,"position":5},"title":"The incredible rarity of falsifying data about changing your mind","author":"Daniel Pradilla","date":"12\/06\/2015","format":false,"excerpt":"Episode 555 of This American Life has a very cool story about a study on how a group of canvassers were able to influence people who were against gay marriage to change their mind: Curious, but kinda logically, people appeared to change their mind once the canvasser, a member of\u2026","rel":"","context":"In "Lifestyle"","block_context":{"text":"Lifestyle","link":"https:\/\/www.danielpradilla.info\/blog\/category\/lifestyle\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/1987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/comments?post=1987"}],"version-history":[{"count":0,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/1987\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/media?parent=1987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/categories?post=1987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/tags?post=1987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}