{"id":5558,"date":"2014-07-10T17:20:56","date_gmt":"2014-07-10T21:20:56","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=5558"},"modified":"2017-11-07T08:26:25","modified_gmt":"2017-11-07T13:26:25","slug":"iri-workbench-pentaho-create-test-data","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/","title":{"rendered":"Creating Test Data for Pentaho"},"content":{"rendered":"<p><em>This article is third in a 3-part series on using IRI products to expand functionality and improve performance in Pentaho systems. We first demonstrate <a title=\"Using CoSort to Speed Up the Sort Process in Pentaho Blog\" href=\"http:\/\/www.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\" target=\"_blank\" rel=\"noopener\">how to improve sorting performance<\/a>, and then introduce ways to <a title=\"Masking Data in Pentaho Blog\" href=\"http:\/\/www.iri.com\/blog\/data-protection\/iri-workbench-pentaho-perform-data-masking\/\" target=\"_blank\" rel=\"noopener\">mask production data<\/a>, and create test data, in the Pentaho Data Integration (PDI) environment.<\/em><\/p>\n<p><em>Abstract: IRI\u00a0RowGen generates safe, <a href=\"http:\/\/www.iri.com\/blog\/test-data\/making-realistic-test-data-production\/\" target=\"_blank\" rel=\"noopener\">realistic\u00a0test data<\/a> for multiple database and file targets, according to business rules. By calling RowGen\u00a0jobs from Pentaho,\u00a0you can supply data with the structure and relationships\u00a0needed for immediate ETL and BI testing,\u00a0but\u00a0not expose personally identifiable information.<\/em><\/p>\n<p>While Pentaho Data Integration (PDI) has a number of database tools, it does not have the native capability to create safe, intelligent test data. This becomes important when you want to prototype ETL operations, share new views or reports with co-workers, and develop new applications without relying on production data.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/products\/rowgen\" target=\"_blank\" rel=\"noopener\">IRI RowGen<\/a>\u00a0software populates tables and flat files with\u00a0benign test data for use in Pentaho and other applications. You would use the Shell step in Pentaho to call pre-defined\u00a0RowGen jobs (or batch job) scripts.<\/p>\n<p>We&#8217;ll begin the example with empty tables to be populated. This means their definitions exist. RowGen will rely on the DDL information to generate structurally and referentially correct test data soon. The Pentaho view of this stage setting is shown below:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5559 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.1-e1405014272655.png\" alt=\"pentaho.1\" width=\"500\" height=\"381\" \/><\/a><\/p>\n<p>The next step is to build the test data using RowGen job scripts automatically created in the <a href=\"http:\/\/www.iri.com\/products\/workbench\/rowgen-gui\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a> GUI, built on Eclipse\u2122. The GUI&#8217;s <em>New DB Test Data<\/em> job wizard for RowGen will connect to the same tables, parse their DDL, and produce a data generation batch operation that will run in Pentaho&#8217;s\u00a0Shell step:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5560 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.2-e1405014282540.png\" alt=\"pentaho.2\" width=\"500\" height=\"416\" \/><\/a><\/p>\n<p>While you can certainly add the Shell step to a larger\u00a0Pentaho project, I&#8217;m only showing the steps needed to run the\u00a0test data generation job. Create the\u00a0job with a Start step and use the Shell step to reference the RowGen batch file created above:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5561 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-3-e1405014297650.png\" alt=\"pentaho-3\" width=\"300\" height=\"280\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5562 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.4-e1405014309649.png\" alt=\"pentaho.4\" width=\"300\" height=\"264\" \/><\/a><\/p>\n<p>After the Pentaho\/RowGen job is executed, you will\u00a0see your tables populated with the test data. Explore the data source again in Pentaho:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5563 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho.5-e1405014328914.png\" alt=\"pentaho.5\" width=\"500\" height=\"374\" \/><\/a><\/p>\n<p>For questions about the use of RowGen or its callability from third-party applications, email <a href=\"mailto:rowgen@iri.com\" target=\"_blank\" rel=\"noopener\">rowgen@iri.com<\/a>. make sure you also saw our previous article on <a title=\"Masking Data in Pentaho Blog\" href=\"http:\/\/www.iri.com\/blog\/data-protection\/iri-workbench-pentaho-perform-data-masking\/\" target=\"_blank\" rel=\"noopener\">masking production data<\/a> in Pentaho.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is third in a 3-part series on using IRI products to expand functionality and improve performance in Pentaho systems. We first demonstrate how to improve sorting performance, and then introduce ways to mask production data, and create test data, in the Pentaho Data Integration (PDI) environment. Abstract: IRI\u00a0RowGen generates safe, realistic\u00a0test data for<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\" title=\"Creating Test Data for Pentaho\">Read More<\/a><\/div>\n","protected":false},"author":43,"featured_media":11804,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[776,29],"tags":[273,519,658,659,100,660,526,662,656,497,655,316,657,661,88,271],"class_list":["post-5558","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-etl","category-test-data","tag-bi","tag-database","tag-db","tag-ddl","tag-etl","tag-file-targets","tag-iri-rowgen","tag-mask-production-data","tag-pdi","tag-pentaho","tag-pentaho-data-integration","tag-realistic","tag-safe","tag-sorting","tag-test-data-2","tag-testing"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating Test Data for Pentaho - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Test Data for Pentaho\" \/>\n<meta property=\"og:description\" content=\"This article is third in a 3-part series on using IRI products to expand functionality and improve performance in Pentaho systems. We first demonstrate how to improve sorting performance, and then introduce ways to mask production data, and create test data, in the Pentaho Data Integration (PDI) environment. Abstract: IRI\u00a0RowGen generates safe, realistic\u00a0test data forRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-10T21:20:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T13:26:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png\" \/>\n\t<meta property=\"og:image:width\" content=\"652\" \/>\n\t<meta property=\"og:image:height\" content=\"463\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Claudia Irvine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Claudia Irvine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\"},\"author\":{\"name\":\"Claudia Irvine\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\"},\"headline\":\"Creating Test Data for Pentaho\",\"datePublished\":\"2014-07-10T21:20:56+00:00\",\"dateModified\":\"2017-11-07T13:26:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\"},\"wordCount\":387,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png\",\"keywords\":[\"BI\",\"database\",\"DB\",\"DDL\",\"ETL\",\"file targets\",\"IRI RowGen\",\"mask production data\",\"PDI\",\"pentaho\",\"Pentaho Data Integration\",\"realistic\",\"safe\",\"sorting\",\"test data\",\"testing\"],\"articleSection\":[\"ETL\",\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\",\"url\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\",\"name\":\"Creating Test Data for Pentaho - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png\",\"datePublished\":\"2014-07-10T21:20:56+00:00\",\"dateModified\":\"2017-11-07T13:26:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png\",\"width\":652,\"height\":463,\"caption\":\"pentaho rowgen combined logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Test Data for Pentaho\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\",\"name\":\"Claudia Irvine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"caption\":\"Claudia Irvine\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/claudiai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Creating Test Data for Pentaho - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/","og_locale":"en_US","og_type":"article","og_title":"Creating Test Data for Pentaho","og_description":"This article is third in a 3-part series on using IRI products to expand functionality and improve performance in Pentaho systems. We first demonstrate how to improve sorting performance, and then introduce ways to mask production data, and create test data, in the Pentaho Data Integration (PDI) environment. Abstract: IRI\u00a0RowGen generates safe, realistic\u00a0test data forRead More","og_url":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/","og_site_name":"IRI","article_published_time":"2014-07-10T21:20:56+00:00","article_modified_time":"2017-11-07T13:26:25+00:00","og_image":[{"width":652,"height":463,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","type":"image\/png"}],"author":"Claudia Irvine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Claudia Irvine","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/"},"author":{"name":"Claudia Irvine","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0"},"headline":"Creating Test Data for Pentaho","datePublished":"2014-07-10T21:20:56+00:00","dateModified":"2017-11-07T13:26:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/"},"wordCount":387,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","keywords":["BI","database","DB","DDL","ETL","file targets","IRI RowGen","mask production data","PDI","pentaho","Pentaho Data Integration","realistic","safe","sorting","test data","testing"],"articleSection":["ETL","Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/","url":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/","name":"Creating Test Data for Pentaho - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","datePublished":"2014-07-10T21:20:56+00:00","dateModified":"2017-11-07T13:26:25+00:00","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","width":652,"height":463,"caption":"pentaho rowgen combined logo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating Test Data for Pentaho"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0","name":"Claudia Irvine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","caption":"Claudia Irvine"},"url":"https:\/\/www.iri.com\/blog\/author\/claudiai\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-rowgen.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5558"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=5558"}],"version-history":[{"count":17,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5558\/revisions"}],"predecessor-version":[{"id":11275,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5558\/revisions\/11275"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11804"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=5558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=5558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=5558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}