{"id":5768,"date":"2014-07-09T11:26:14","date_gmt":"2014-07-09T15:26:14","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=5768"},"modified":"2017-11-06T13:57:07","modified_gmt":"2017-11-06T18:57:07","slug":"cosort-speed-sort-process-pentaho","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/","title":{"rendered":"Using CoSort to Speed Pentaho Sort Jobs"},"content":{"rendered":"<p><em>This article is the first 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 <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 <a title=\"Creating Test Data for Pentaho Blog\" href=\"http:\/\/www.iri.com\/blog\/test-data\/iri-workbench-pentaho-create-test-data\/\" target=\"_blank\" rel=\"noopener\">create test data<\/a>, in the Pentaho Data Integration (PDI) environment.<\/em><\/p>\n<p>Since 1978, <a href=\"http:\/\/www.iri.com\/products\/cosort\" target=\"_blank\" rel=\"noopener\">IRI CoSort<\/a> has been used to accelerate or replace third-party <a href=\"http:\/\/www.iri.com\/solutions\/data-transformation\/sort-merge\" target=\"_blank\" rel=\"noopener\">sort<\/a> functions or sort process steps. CoSort is a standalone product, and the default data manipulation engine in <a href=\"http:\/\/www.iri.com\/products\/voracity\">IRI Voracity<\/a> data management platform operations. Licensees of either product can run CoSort jobs in the free <a href=\"http:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a>\u00a0GUI, \u00a0on the command line, from Pentaho, etc.<\/p>\n<p>Pentaho Data Integration (PDI) software includes a native sort that may not run fast enough for your\u00a0high volume inputs. However, PDI process flows support the use of third-party functions, so\u00a0data can be sorted externally without undue process disruption.\u00a0By using PDI&#8217;s shell script\u00a0step to call a CoSort job (e.g.,\u00a0<a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\" target=\"_blank\" rel=\"noopener\">SortCL<\/a> script), sorting\u00a0times can be reduced dramatically.<\/p>\n<p>Pentaho and CoSort users can create a SortCL sort script\u00a0in a text editor or via the new sort job\u00a0wizard in the <a href=\"http:\/\/www.iri.com\/products\/workbench\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a> GUI, built on Eclipse\u2122. They must also create a batch file to tell Pentaho to run the CoSort command:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-1-e1406301696679.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5769\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-1-e1406301696679.png\" alt=\"pentaho-sort-1\" width=\"600\" height=\"551\" \/><\/a><\/p>\n<p>This CoSort job sorts\u00a0a one-million-row CSV file (10.4 MB) on a 2.8 GHz Windows 8 PC using 2 of its 4 cores and 3 of its 12 GB\u00a0of RAM.<\/p>\n<p>In PDI, create a job that uses a Start step and a Shell step referencing the batch file created above. To run multiple sorts, add multiple SortCL commands to the same batch file referencing the various scripts.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-2-e1406301735581.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-5770\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-2-e1406301735581.png\" alt=\"pentaho-sort-2\" width=\"300\" height=\"317\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-3-e1406301774466.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5771\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-3-e1406301774466.png\" alt=\"pentaho-sort-3\" width=\"359\" height=\"317\" \/><\/a><\/p>\n<p>Benchmarks show that using the Pentaho\/CoSort hybrid is 14-16 times faster than using the native sort step in Pentaho alone.\u00a0The chart below shows the number of seconds it takes to sort 1 million (10.4 MB file), 25 million (238 MB file), and 100 million (953 MB file) CSV rows with each method on the same PC (above).<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5772\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort-4.png\" alt=\"pentaho-sort-4\" width=\"478\" height=\"488\" \/><\/a><\/p>\n<p>The one-million-row sort in CoSort\u00a0was\u00a0so fast at only 1 second, its timing\u00a0didn&#8217;t display well on this graph. Unlike CoSort, tuning PDI to hold more than 1 million records in memory hung those native sort\u00a0jobs.<\/p>\n<p>When sorting\u00a0millions of records, the difference easily adds up.<\/p>\n<p>Beyond sorting, the\u00a0CoSort SortCL program performs a number of <a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\/function-matrix\" target=\"_blank\" rel=\"noopener\">additional<\/a> transformations at the same time, plus\u00a0cleanse, migrate, federate, protect, and report on data in disparate <a href=\"http:\/\/www.iri.com\/products\/workbench\/data-sources\" target=\"_blank\" rel=\"noopener\">sources<\/a>. Thus, even if you use\u00a0Pentaho for many activities, you may find offloading certain slower-running steps to CoSort is more efficient in high-volume\u00a0circumstances.<\/p>\n<p>Click here to learn about a similar approach to\u00a0<a title=\"Masking Data in Pentaho Blog\" href=\"%20http:\/\/www.iri.com\/blog\/data-protection\/iri-workbench-pentaho-perform-data-masking\/\" target=\"_blank\" rel=\"noopener\">masking production data<\/a> in Pentaho to protect PII and comply with data privacy laws.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is the first 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. Since 1978, IRI CoSort has been<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\" title=\"Using CoSort to Speed Pentaho Sort Jobs\">Read More<\/a><\/div>\n","protected":false},"author":43,"featured_media":11774,"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":[1,776],"tags":[501,850,498,497,503,502,496,499,500],"class_list":["post-5768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-transformation2","category-etl","tag-faster-sorts","tag-iri-workbench","tag-make-pentaho-sort-faster","tag-pentaho","tag-process-pentaho-data-faster","tag-replace-third-party-sorts","tag-sort-replacement","tag-speed-pentaho","tag-third-party-sort-functions"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using CoSort to Speed Pentaho Sort Jobs - IRI<\/title>\n<meta name=\"description\" content=\"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using CoSort to Speed Pentaho Sort Jobs - IRI\" \/>\n<meta property=\"og:description\" content=\"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-09T15:26:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-06T18:57:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png\" \/>\n\t<meta property=\"og:image:width\" content=\"478\" \/>\n\t<meta property=\"og:image:height\" content=\"488\" \/>\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:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\"},\"author\":{\"name\":\"Claudia Irvine\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\"},\"headline\":\"Using CoSort to Speed Pentaho Sort Jobs\",\"datePublished\":\"2014-07-09T15:26:14+00:00\",\"dateModified\":\"2017-11-06T18:57:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\"},\"wordCount\":454,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png\",\"keywords\":[\"faster sorts\",\"IRI Workbench\",\"make pentaho sort faster\",\"pentaho\",\"process pentaho data faster\",\"replace third party sorts\",\"sort replacement\",\"speed pentaho\",\"third-party sort functions\"],\"articleSection\":[\"Data Transformation\",\"ETL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\",\"name\":\"Using CoSort to Speed Pentaho Sort Jobs - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png\",\"datePublished\":\"2014-07-09T15:26:14+00:00\",\"dateModified\":\"2017-11-06T18:57:07+00:00\",\"description\":\"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png\",\"width\":478,\"height\":488},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using CoSort to Speed Pentaho Sort Jobs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.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:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\",\"name\":\"Claudia Irvine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.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:\/\/beta.iri.com\/blog\/author\/claudiai\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using CoSort to Speed Pentaho Sort Jobs - IRI","description":"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.","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:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/","og_locale":"en_US","og_type":"article","og_title":"Using CoSort to Speed Pentaho Sort Jobs - IRI","og_description":"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.","og_url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/","og_site_name":"IRI","article_published_time":"2014-07-09T15:26:14+00:00","article_modified_time":"2017-11-06T18:57:07+00:00","og_image":[{"width":478,"height":488,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.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:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/"},"author":{"name":"Claudia Irvine","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0"},"headline":"Using CoSort to Speed Pentaho Sort Jobs","datePublished":"2014-07-09T15:26:14+00:00","dateModified":"2017-11-06T18:57:07+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/"},"wordCount":454,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png","keywords":["faster sorts","IRI Workbench","make pentaho sort faster","pentaho","process pentaho data faster","replace third party sorts","sort replacement","speed pentaho","third-party sort functions"],"articleSection":["Data Transformation","ETL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/","url":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/","name":"Using CoSort to Speed Pentaho Sort Jobs - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png","datePublished":"2014-07-09T15:26:14+00:00","dateModified":"2017-11-06T18:57:07+00:00","description":"Learn why and how you should sort large data sources faster in Pentaho ETL by adding a seamless CoSort transformation step.","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png","width":478,"height":488},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/data-transformation2\/cosort-speed-sort-process-pentaho\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using CoSort to Speed Pentaho Sort Jobs"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.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:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0","name":"Claudia Irvine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.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:\/\/beta.iri.com\/blog\/author\/claudiai\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/07\/pentaho-sort.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5768"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=5768"}],"version-history":[{"count":27,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5768\/revisions"}],"predecessor-version":[{"id":17623,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5768\/revisions\/17623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/11774"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=5768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=5768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=5768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}