{"id":6592,"date":"2014-12-23T12:30:23","date_gmt":"2014-12-23T17:30:23","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=6592"},"modified":"2019-05-17T11:55:08","modified_gmt":"2019-05-17T15:55:08","slug":"how-to-qlikview-12x-faster-with-cosort","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/","title":{"rendered":"How to QlikView 12X Faster with CoSort"},"content":{"rendered":"<p><em>Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0<a href=\"http:\/\/www.iri.com\/blog\/category\/business-intelligence\/\" target=\"_blank\" rel=\"noopener\">this section<\/a> of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of using its external data wrangling engine &#8211; via the IRI CoSort product or Voracity platform &#8212; with QlikView\u00a0when \u2018big data\u2019 sources\u00a0are involved.<\/em><\/p>\n<p>Business intelligence (BI) platforms\u00a0enable organizations to collect data from internal systems and external sources, and\u00a0present it for analysis.\u00a0QlikView is a popular BI tool that bundles an in-memory back-end analytic engine with an intuitive user interface. Its users can integrate data and visualize\u00a0the results in\u00a0the same tool. With demos, training manuals, and tutorials,\u00a0most users can produce\u00a0reports before long, though some complain about the menus being less than intuitive.<\/p>\n<p>QlikView can consolidate data from multiple\u00a0sources, including:<\/p>\n<ul>\n<li>Access, flat files, and XML documents<\/li>\n<li>ODBC and OLEDB relational tables<\/li>\n<li>ERP systems and data warehouses<\/li>\n<\/ul>\n<p>However, QlikView cannot directly address many legacy or dark data sources, nor the multi-billion- row files or database tables common to high-volume transaction environments. And its internal data integration engine does not scale in volume. Thus, it is in big\u00a0data acquisition and preparation (data integration) that the\u00a0<a href=\"http:\/\/www.iri.com\/products\/cosort\">IRI CoSort<\/a>\u00a0data processing product (or the <a href=\"https:\/\/www.iri.com\/products\/voracity\">IRI Voracity<\/a> data management platform which uses it) provides value to QlikView users.<\/p>\n<p>CoSort can extract and join data from <a href=\"http:\/\/www.iri.com\/products\/workbench\/data-sources\" target=\"_blank\" rel=\"noopener\">multiple sources<\/a> and <a href=\"http:\/\/www.iri.com\/solutions\/big-data\/big-data-provisioning\" target=\"_blank\" rel=\"noopener\">provide<\/a>\u00a0it to various targets. Without a\u00a0DB engine, appliance, or Hadoop, CoSort can franchise (munge, subset, wrangle) or otherwise\u00a0prepare massive amounts of raw data for downstream applications.<\/p>\n<p>More specifically, CoSort (or the IRI Voracity data management platform that includes it) via its default\u00a0<a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\" target=\"_blank\" rel=\"noopener\">SortCL program<\/a>\u00a0engine \u2014 speeds, performs, and combines:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/data-integration\" target=\"_blank\" rel=\"noopener\">Data integration <\/a>(ETL) of big\u00a0structured, semi-structured, and unstructured data \u00a0<a href=\"http:\/\/www.iri.com\/products\/workbench\/data-sources\" target=\"_blank\" rel=\"noopener\">sources<\/a><\/li>\n<li>Legacy data-type, file-format, and database <a href=\"http:\/\/www.iri.com\/solutions\/data-and-database-migration\/database-migration\" target=\"_blank\" rel=\"noopener\">migrations<\/a><\/li>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/data-masking\" target=\"_blank\" rel=\"noopener\">Data masking<\/a>, including encryption, pseudonymization, and redaction<\/li>\n<li><a href=\"http:\/\/www.iri.com\/solutions\/business-intelligence\" target=\"_blank\" rel=\"noopener\">Reporting<\/a>, with built-in 2D\u00a0features, or <a href=\"http:\/\/www.iri.com\/blog\/business-intelligence\/data-franchising\/\" target=\"_blank\" rel=\"noopener\">data franchising<\/a>\u00a0for\u00a0BI tools like QlikView<\/li>\n<\/ul>\n<p>To demonstrate the relative performance of\u00a0preparing data for\u00a0QlikView visualizations using both QlikView and CoSort\/SortCL, I acquired and processed large CSV files with both systems, and timed their differences. On my 8GB PC, QlikView failed at 150M rows (CoSort did not).<\/p>\n<p><strong>The Bottom Line\u00a0<\/strong><\/p>\n<p>The data that both systems made available for QlikView charts was the same, but the time they took to prepare it was anything but. Given 20 million rows of source data, the CoSort SortCL program &#8212; tuned to use only half my available RAM (4 of 8GB) &#8212; took 25 seconds to produce the charted values, while QlikView required 303 seconds.<\/p>\n<p>CoSort was considerably faster than QlikView whether testing with small or large amounts of data.The chart below shows the sort and aggregation throughput for files with 20 million records (885MB), 50 million records (2.122GB), 100 million records (4.424GB), 130 million records (5.752GB) , and 150 million records (6.637GB). In each case CoSort&#8217;s SortCL program performed better than QlikView. At\u00a0150 million records, QlikView got an insufficient memory error and could not run the job, while SortCL ran it in 187 seconds &#8212; again with only half the available memory aboard &#8212; almost twice as fast\u00a0as QlikView was at 20M records.<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6659\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\" alt=\"image001\" width=\"600\" height=\"376\" \/><\/a><\/p>\n<p>Following are the steps I followed in both cases:<\/p>\n<p><strong>Data Preparation in\u00a0QlikView<\/strong><\/p>\n<p>The first step to having QlikView make use of the data source is to load it. The montage below reflects the steps I took, though I could also write 3GL programs that QlikView can use instead:<\/p>\n<ol>\n<li>Select New from the File menu, and then\u00a0\u201cEdit Script\u201d from the options<\/li>\n<li>Click on \u201cTable Files &#8230;\u201d button in the bottom pane&#8217;s Data tab<\/li>\n<li>Browse to\/specify the input file<\/li>\n<li>In\u00a0the File Wizard, select\u00a0Delimited Select, and click Next or Finish<\/li>\n<li>Click on the \u201cReload\u201d tab from the top menu\u00a0to load the data\u00a0into\u00a0the dashboard<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6598 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0012-e1421178824193.png\" alt=\"image001\" width=\"500\" height=\"733\" \/><\/p>\n<p>The next steps processed my sales\u00a0data in the way I needed for visualizing it; i.e., sorted and aggregated price values:<\/p>\n<ol>\n<li>Right Click on the dashboard and select \u201cNew Sheet Object\u201d<\/li>\n<li>Select \u201cChart&#8221; from the menu, and select a \u201cTable Object\u201d<\/li>\n<li>In the table object which shows the first\u00a0rows of the\u00a0input\u00a0data, click on the\u00a0DeptNum column to establish the sort order<\/li>\n<li>Repeat the above steps to build a subset table with only the DeptNum and Price columns, which will be the basis for our visualization<\/li>\n<li>Repeat the initial steps to create a new\u00a0table object\u00a0containing\u00a0only the Price column, in order to summarize those values<\/li>\n<li>Click Next, and select the option to insert an aggregation\u00a0formula. Specifying the expression:\u00a0<em><strong>Max(Aggr(Sum([Price]),[DeptNum])<\/strong>)<\/em>\u00a0calculates the total sales volume (via the Price column) for all the items in each DeptNum.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0031-e1419355577550.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6595\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0031-e1419355577550.png\" alt=\"image003\" width=\"600\" height=\"371\" \/><\/a><\/p>\n<p>The sorted and aggregated results are shown in the smaller, two-column table below, along with the\u00a0Pie, Bar, and 3D chart representations of that data which I developed using\u00a0chart objects:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0051-e1419355657543.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6596\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0051-e1419355657543.png\" alt=\"image005\" width=\"600\" height=\"421\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Data Preparation in CoSort<\/strong><\/p>\n<p>To sort and sum the same data in CoSort, I need a simple SortCL job script. I can either write it by hand, or use the new sort job wizard in the free <a href=\"http:\/\/www.iri.com\/products\/workbench\" target=\"_blank\" rel=\"noopener\">IRI Workbench<\/a>\u00a0GUI. IRI Workbench is an integrated development environment\u00a0(IDE) built on Eclipse\u2122\u00a0to create, run, and manage data connections, metadata, and job scripts.<\/p>\n<p>Learning the language is simple enough, and I can write and modify\u00a0the scripts in the GUI&#8217;s syntax-aware editor. But for those finding any 4GL scripting objectionable, the GUI can also\u00a0build\u00a0them\u00a0automatically with\u00a0an end-to-end job wizard or a visual ETL workflow (palette).<\/p>\n<figure id=\"attachment_6663\" class=\"thumbnail wp-caption aligncenter style=\"width: 310px\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0071.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6663 size-medium\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0071-300x179.png\" alt=\"image007\" width=\"300\" height=\"179\" srcset=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0071-300x179.png 300w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0071-1024x612.png 1024w, https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0071.png 1600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption class=\"caption wp-caption-text\">IRI Workbench view. Click to see the CoSort\/SortCL job script that prepared the data.<\/figcaption><\/figure>\n<p>In addition to being easier to learn and use than the 11 QlikView steps above, I have saved\u00a0<a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl-metadata\" target=\"_blank\" rel=\"noopener\">metadata<\/a> and job\u00a0templates that I can re-use, extend, and share, plus\u00a0centrally-accessible data results for use\u00a0in multiple visualization and applications.<\/p>\n<p><strong>From CoSort Into QlikView<\/strong><\/p>\n<p>The file CoSort&#8217;s SortCL program produced can be imported into QlikView as a table object, and visualized with the same chart options described above using the same formula (which essentially re-summarizes that which we already summarized). I chose to bypass the superfluous formula, however, and use the QuickChart wizard to produce like\u00a0graphs from the same (CoSorted)\u00a0data:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/qlikview-graph-e1420652775559.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6643\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/12\/qlikview-graph-e1420652775559.png\" alt=\"qlikview-graph\" width=\"600\" height=\"387\" \/><\/a><\/p>\n<p>To go the QuickChart route:<\/p>\n<ol>\n<li>Load the CoSort (CSV file output) results into the QlikView dashboard using the first 5 steps shown above<\/li>\n<li>From the top toolbar, click on the Chart icon. This brings up the Quick Chart Wizard; click Next<\/li>\n<li>Select a chart type and click Next.<\/li>\n<li>Select First Dimension (DeptNum) and Second Dimension (Price) and click Next.<\/li>\n<li>In the Define Expression dialog, bypass the options and click Finish.<\/li>\n<li>Repeat steps 3-5 above to add additional chart views<\/li>\n<\/ol>\n<p>See <a href=\"http:\/\/www.iri.com\/solutions\/business-intelligence\/bi-tool-acceleration\/overview\" target=\"_blank\" rel=\"noopener\">this section<\/a> of the web site for more information on data preparation\u00a0for BI (tool acceleration).\u00a0If you need help implementing CoSort in QlikView environments, contact <a href=\"mailto:support@iri.com\" target=\"_blank\" rel=\"noopener\">IRI support<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of using its external data wrangling engine &#8211; via the IRI CoSort product or Voracity platform &#8212; with QlikView\u00a0when \u2018big data\u2019 sources\u00a0are involved. Business intelligence (BI) platforms\u00a0enable organizations to collect data from internal<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\" title=\"How to QlikView 12X Faster with CoSort\">Read More<\/a><\/div>\n","protected":false},"author":53,"featured_media":6659,"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":[32],"tags":[276,25,52,57,107,14,359,1163,552,100,338,546,1406,547,550],"class_list":["post-6592","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-accelerate-bi-tools","tag-big-data","tag-business-intelligence-2","tag-data-franchising","tag-data-integration","tag-data-masking","tag-data-preparation","tag-data-wrangling","tag-erp","tag-etl","tag-flat-files","tag-iri-cosort","tag-qlik","tag-qlikview","tag-xml"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to QlikView 12X Faster with CoSort - 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:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to QlikView 12X Faster with CoSort - IRI\" \/>\n<meta property=\"og:description\" content=\"Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of using its external data wrangling engine &#8211; via the IRI CoSort product or Voracity platform &#8212; with QlikView\u00a0when \u2018big data\u2019 sources\u00a0are involved. Business intelligence (BI) platforms\u00a0enable organizations to collect data from internalRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-23T17:30:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-17T15:55:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chaitali Mitra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chaitali Mitra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\"},\"author\":{\"name\":\"Chaitali Mitra\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf\"},\"headline\":\"How to QlikView 12X Faster with CoSort\",\"datePublished\":\"2014-12-23T17:30:23+00:00\",\"dateModified\":\"2019-05-17T15:55:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\"},\"wordCount\":1144,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\",\"keywords\":[\"accelerate BI tools\",\"big data\",\"business intelligence\",\"data franchising\",\"data integration\",\"data masking\",\"data preparation\",\"data wrangling\",\"erp\",\"ETL\",\"flat files\",\"IRI CoSort\",\"Qlik\",\"QlikView\",\"xml\"],\"articleSection\":[\"Business Intelligence (BI&#041;\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\",\"name\":\"How to QlikView 12X Faster with CoSort - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\",\"datePublished\":\"2014-12-23T17:30:23+00:00\",\"dateModified\":\"2019-05-17T15:55:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png\",\"width\":600,\"height\":376},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to QlikView 12X Faster with CoSort\"}]},{\"@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\/9bae14a309616863b027c2d56f532caf\",\"name\":\"Chaitali Mitra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g\",\"caption\":\"Chaitali Mitra\"},\"sameAs\":[\"http:\/\/www.iri.com\"],\"url\":\"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to QlikView 12X Faster with CoSort - 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:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/","og_locale":"en_US","og_type":"article","og_title":"How to QlikView 12X Faster with CoSort - IRI","og_description":"Introduction: As with\u00a0multiple BI platforms discussed throughout\u00a0this section of the IRI blog site, this\u00a0article analyzes the relative data preparation performance (and benefit) of using its external data wrangling engine &#8211; via the IRI CoSort product or Voracity platform &#8212; with QlikView\u00a0when \u2018big data\u2019 sources\u00a0are involved. Business intelligence (BI) platforms\u00a0enable organizations to collect data from internalRead More","og_url":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/","og_site_name":"IRI","article_published_time":"2014-12-23T17:30:23+00:00","article_modified_time":"2019-05-17T15:55:08+00:00","og_image":[{"width":600,"height":376,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","type":"image\/png"}],"author":"Chaitali Mitra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chaitali Mitra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/"},"author":{"name":"Chaitali Mitra","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/9bae14a309616863b027c2d56f532caf"},"headline":"How to QlikView 12X Faster with CoSort","datePublished":"2014-12-23T17:30:23+00:00","dateModified":"2019-05-17T15:55:08+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/"},"wordCount":1144,"commentCount":1,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","keywords":["accelerate BI tools","big data","business intelligence","data franchising","data integration","data masking","data preparation","data wrangling","erp","ETL","flat files","IRI CoSort","Qlik","QlikView","xml"],"articleSection":["Business Intelligence (BI&#041;"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/","url":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/","name":"How to QlikView 12X Faster with CoSort - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","datePublished":"2014-12-23T17:30:23+00:00","dateModified":"2019-05-17T15:55:08+00:00","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","width":600,"height":376},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/business-intelligence\/how-to-qlikview-12x-faster-with-cosort\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to QlikView 12X Faster with CoSort"}]},{"@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\/9bae14a309616863b027c2d56f532caf","name":"Chaitali Mitra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/95a11f3d0b709c00df3262bab0152f3a?s=96&d=blank&r=g","caption":"Chaitali Mitra"},"sameAs":["http:\/\/www.iri.com"],"url":"https:\/\/beta.iri.com\/blog\/author\/chaitalim\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/12\/image0014-e1421176469229.png","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6592"}],"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\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=6592"}],"version-history":[{"count":69,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6592\/revisions"}],"predecessor-version":[{"id":12871,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6592\/revisions\/12871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/6659"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=6592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=6592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=6592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}