{"id":14024,"date":"2020-09-21T11:51:50","date_gmt":"2020-09-21T15:51:50","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=14024"},"modified":"2020-09-29T14:48:18","modified_gmt":"2020-09-29T18:48:18","slug":"improving-insight-with-voracity-and-cubeware","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/","title":{"rendered":"Improving Insight with IRI Voracity and Cubeware Cockpit"},"content":{"rendered":"<p><b><i>Abstract<\/i><\/b><i>: In previous articles in the business intelligence (BI) section of this blog, IRI has described how wrangling data with the <\/i><a href=\"https:\/\/www.iri.com\/products\/cosort\/sortcl\"><i>SortCL<\/i><\/a><i> engine in the IRI CoSort data manipulation product and <\/i><a href=\"https:\/\/www.iri.com\/products\/voracity\"><i>Voracity<\/i><\/a><i> data management platform speeds time to data visualization, and thus actionable insight, in BI tools. This article highlights the data blending advantages that Voracity provides for analytics in the Cubeware platform.\u00a0<\/i><\/p>\n<p>While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard visualization and dashboarding tool. This is where Cubeware comes in. Conversely, for users of Cubeware software, Voracity adds value to their Importer process through fast, consolidated data transformation, cleansing, and masking.<\/p>\n<h5><strong>Introduction to Cubeware<\/strong><\/h5>\n<p>Founded in 1997, Cubeware is an innovative BI software manufacturer, located in Rosenheim, Germany. Cubeware provides solutions for data management, visualization, analysis, and planning.<\/p>\n<p>One of Cubeware\u2019s products is Cockpit, the dashboard designer provided in CSP C8. Cockpit can produce reports for Windows, web, mobile, and Snack (Cubeware\u2019s agile instant reporting tool). It can also integrate data from relational and multidimensional databases.<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-charts.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14031 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-charts.png\" alt=\"\" width=\"765\" height=\"410\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-charts.png 864w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-charts-300x161.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-charts-768x412.png 768w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<p>Cubeware also provides Importer, a graphical ETL tool for consolidation of data from various source systems with comprehensive transformation processes that has many feature-function in common with Voracity.<\/p>\n<h5><strong>Then Why Would I Need Voracity?<\/strong><\/h5>\n<p>For more speed in \u201cbig data\u201d preparation jobs, additional data quality features, and data-centric security (PII classification, discovery, and masking) capabilities for compliance with GDPR, etc.<\/p>\n<p>To begin, Voracity uses the SortCL engine to <a href=\"https:\/\/www.iri.com\/solutions\/data-integration\/etl\">integrate<\/a> and wrangle data faster than Cubeware Importer and most every ETL tool on the market. SortCL is a high-speed, task-consolidating data processing program for structured and semi-structured sources that optimizes memory, threads, and I\/O. It runs on Windows and Linux\/Unix command lines on-premise or in the cloud.<\/p>\n<p>SortCL jobs are specified in simple 4GL job scripts, which can also be designed and managed in a free graphical IDE called <a href=\"https:\/\/www.iri.com\/products\/workbench\">IRI Workbench<\/a>, which is\u00a0 built on Eclipse\u2122. In addition to being easy to understand, SortCL programs support a vast range of data manipulation, mapping, munging, masking, and mining features for hundreds of data processing, protection, prototyping, and presentation use cases.<\/p>\n<p>For example, SortCL allows Voracity to support a wide array of <a href=\"https:\/\/www.iri.com\/solutions\/data-integration\/implement\/data-quality\">data quality<\/a> features, including:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14032 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality-1024x359.png\" alt=\"\" width=\"802\" height=\"281\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality-1024x359.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality-300x105.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality-768x269.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/voracity-DataQuality.png 1600w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<p>Its data validation capabilities can improve the quality of data; e.g., by creating conditions to test for empty values, upper or lower case values, alphabetic and numeric values, printable values, and more. It can also filter records meeting specified conditions, ranges, or quantity thresholds.<\/p>\n<p><a href=\"https:\/\/www.iri.com\/solutions\/data-masking\/gdpr\">GDPR compliance<\/a> can be achieved through SortCL-supported data \u2018shields\u2019 that mask PII like deletion, encryption, redaction, and pseudonymization, etc. In fact, Voracity specifically includes:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14033 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic-1024x1024.png\" alt=\"\" width=\"548\" height=\"548\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic-1024x1024.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic-150x150.png 150w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic-300x300.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic-768x768.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/fieldshield-graphic.png 1200w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>However, and <i>most importantly<\/i>, all the above activities involved in ETL, data quality, and masking, can be performed <i>simultaneously<\/i>, in the same job script and I\/O pass, significantly saving job development and execution time.<\/p>\n<p>SortCL can also produce custom 2D detail and summary reports to offer a quick overview of the data and make sure everything seems correct before feeding Cockpit with the handoffs it needs for fast display.<\/p>\n<h5><strong>Benchmarks<\/strong><\/h5>\n<p>So how much can Voracity actually improve the speed of data manipulation and movement? Cubeware provided a benchmark for Importer of 5 minutes and 32 seconds for processing a 4.25 million-row SQL Server table with a size of 1046MB, performing these transformations:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14034 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-table.png\" alt=\"\" width=\"639\" height=\"320\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-table.png 639w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-table-300x150.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/a><\/p>\n<p>and outputting to a text file.<\/p>\n<p>Here are the specs of the computer used by Cubeware:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14035 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1-1024x259.png\" alt=\"\" width=\"814\" height=\"206\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1-1024x259.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1-300x76.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1-768x194.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs1.png 1329w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/a><\/p>\n<p>I created a similar SortCL task-consolidated data wrangling job in IRI Workbench that reads the same data from a SQL Server table, performs similar equivalent SortCL <a href=\"https:\/\/www.iri.com\/solutions\/data-transformation\">transformations<\/a>, and writes to a text file. The specs of the computer used to perform this benchmark were:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14036 size-full\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs2-e1600715637422.png\" alt=\"\" width=\"520\" height=\"479\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs2-e1600715637422.png 520w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-specs2-e1600715637422-300x276.png 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>The benchmark using SortCL in Voracity was an average of 131.0 seconds, or roughly 2.53 times quicker than the benchmark provided using Cubeware Importer at this volume level.<\/p>\n<p>Note: This benchmark was run on a computer with both SortCL and the database installed locally. Here is a view of the source table in IRI Workbench:<\/p>\n<p><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14037 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results-1024x554.png\" alt=\"\" width=\"800\" height=\"433\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results-1024x554.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results-300x162.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results-768x415.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-database-results.png 1600w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>These like transformations were specified in the SortCL job<span id='easy-footnote-1-14024' class='easy-footnote-margin-adjust'><\/span><span class='easy-footnote'><a href='https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#easy-footnote-bottom-1-14024' title='SortCL job script used for this benchmark, created automatically in IRI Workbench.'><sup>1<\/sup><\/a><\/span>:<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14044\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench-1024x545.png\" alt=\"\" width=\"895\" height=\"476\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench-1024x545.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench-300x160.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench-768x409.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script-workbench.png 1902w\" sizes=\"(max-width: 895px) 100vw, 895px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/docs.google.com\/document\/d\/1T-XPw_yQvRMoSSB7frmBRsMh35UNsZx_95J914qnYRk\/edit?usp=sharing\">Link to full script<\/a><\/p>\n<ol>\n<li>Filter weekday to Saturday ONLY<\/li>\n<li>Omit dates from a certain range from the PLSSTARTDAT field.<\/li>\n<li>Validate the PTD_ID field to make sure it consists of numbers.<\/li>\n<li>Output additional summary record to stdout for quick display of key aspects of the data.<\/li>\n<li>New field with absolute difference between two numeric values<\/li>\n<li>New field with math operations performed<\/li>\n<li>New field concatenating two existing fields with comma<\/li>\n<li>New field replacing Saturday with German word<\/li>\n<li>Encrypt the ID field with Format-Preserving AES256 Encryption.<\/li>\n<li>Mask Mandant field<\/li>\n<li>Change date format of datum field.<\/li>\n<li>Encrypt with AES 256 Encryption the JAHR field with a passphrase of \u201cTyphoon\u201d<\/li>\n<li>Pseudonymize the VISIONGRUPPESET field replacing with area codes selected from a set file.<\/li>\n<li>Mask the TEILPLSTV_ID field from positions 3 to 7 with the \u201c*\u201d character.<\/li>\n<li>Output to a text file<\/li>\n<li>Output summary record of total, average, max and min values of\u00a0 the TTSNR field to stdout for a quick overview of the data values of this field.<\/li>\n<\/ol>\n<p>Here is the resulting text file:<\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14040 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script2.png\" alt=\"\" width=\"716\" height=\"157\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script2.png 912w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script2-300x66.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-script2-768x168.png 768w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/a><\/p>\n<p><a href=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-performance-script.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14038 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2020\/09\/cubeware-performance-script.png\" alt=\"\" width=\"800\" height=\"624\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-performance-script.png 932w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-performance-script-300x234.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-performance-script-768x598.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<h5><strong>Further Details\/Conclusion<\/strong><\/h5>\n<p>The biggest advantage or Voracity is <a href=\"https:\/\/www.iri.com\/solutions\/data-integration\/etl\/flat-file-etl\">fast, robust flat-file processing<\/a>. If able to filter out a large percentage of records from a very large file, its SortCL program can provide rapid file-to-database data transfer. Data transformation, validation, cleansing, masking, and reformatting are all supported features that can be combined in one SortCL script and I\/O pass.<\/p>\n<p>Generally, file-to-database SortCL scripts would result in slower results than Cubeware when writing a large number of records to the database. However, SortCL can process the input of flat files faster, and then filter them down to much smaller subsets of records bound for a database.<\/p>\n<p>When reading from a database and writing to a flat file, the SortCL engine can provide some speed advantages. A benchmark provided by Cubeware yielded an average of 5m:32s to perform similar filtering and transformations that SortCL performed in 2m:11s. The input for this benchmark was Microsoft SQL Server, and the output was a semicolon-separated text file.<\/p>\n<p>Bottom line: If you have IRI Voracity and Cubeware Cockpit, you have an affordable, best-of-breed technical solution stack for data integration, governance, and visual analytics.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Abstract: In previous articles in the business intelligence (BI) section of this blog, IRI has described how wrangling data with the SortCL engine in the IRI CoSort data manipulation product and Voracity data management platform speeds time to data visualization, and thus actionable insight, in BI tools. This article highlights the data blending advantages that<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\" title=\"Improving Insight with IRI Voracity and Cubeware Cockpit\">Read More<\/a><\/div>\n","protected":false},"author":119,"featured_media":14030,"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,776],"tags":[1485,421,520,789,850],"class_list":["post-14024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-etl","tag-cubeware","tag-database-acceleration","tag-iri-fieldshield","tag-iri-voracity","tag-iri-workbench"],"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>Improving Insight with IRI Voracity and Cubeware Cockpit - IRI<\/title>\n<meta name=\"description\" content=\"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard\" \/>\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\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improving Insight with IRI Voracity and Cubeware Cockpit\" \/>\n<meta property=\"og:description\" content=\"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-21T15:51:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-09-29T18:48:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1048\" \/>\n\t<meta property=\"og:image:height\" content=\"548\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Devon Kozenieski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Devon Kozenieski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\"},\"author\":{\"name\":\"Devon Kozenieski\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1\"},\"headline\":\"Improving Insight with IRI Voracity and Cubeware Cockpit\",\"datePublished\":\"2020-09-21T15:51:50+00:00\",\"dateModified\":\"2020-09-29T18:48:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\"},\"wordCount\":1060,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png\",\"keywords\":[\"Cubeware\",\"database acceleration\",\"IRI FieldShield\",\"IRI Voracity\",\"IRI Workbench\"],\"articleSection\":[\"Business Intelligence (BI&#041;\",\"ETL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\",\"url\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\",\"name\":\"Improving Insight with IRI Voracity and Cubeware Cockpit - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png\",\"datePublished\":\"2020-09-21T15:51:50+00:00\",\"dateModified\":\"2020-09-29T18:48:18+00:00\",\"description\":\"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png\",\"width\":1048,\"height\":548},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Improving Insight with IRI Voracity and Cubeware Cockpit\"}]},{\"@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\/de972c035aaeecfc40a3ae2ea5ff7ba1\",\"name\":\"Devon Kozenieski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g\",\"caption\":\"Devon Kozenieski\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/devonk\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Improving Insight with IRI Voracity and Cubeware Cockpit - IRI","description":"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard","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\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/","og_locale":"en_US","og_type":"article","og_title":"Improving Insight with IRI Voracity and Cubeware Cockpit","og_description":"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard","og_url":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/","og_site_name":"IRI","article_published_time":"2020-09-21T15:51:50+00:00","article_modified_time":"2020-09-29T18:48:18+00:00","og_image":[{"width":1048,"height":548,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","type":"image\/png"}],"author":"Devon Kozenieski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Devon Kozenieski","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/"},"author":{"name":"Devon Kozenieski","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/de972c035aaeecfc40a3ae2ea5ff7ba1"},"headline":"Improving Insight with IRI Voracity and Cubeware Cockpit","datePublished":"2020-09-21T15:51:50+00:00","dateModified":"2020-09-29T18:48:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/"},"wordCount":1060,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","keywords":["Cubeware","database acceleration","IRI FieldShield","IRI Voracity","IRI Workbench"],"articleSection":["Business Intelligence (BI&#041;","ETL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/","url":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/","name":"Improving Insight with IRI Voracity and Cubeware Cockpit - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","datePublished":"2020-09-21T15:51:50+00:00","dateModified":"2020-09-29T18:48:18+00:00","description":"While Voracity is very fast at wrangling data and features a wide array of data manipulation and data protection capabilities, it lacks an onboard","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","width":1048,"height":548},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/improving-insight-with-voracity-and-cubeware\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Improving Insight with IRI Voracity and Cubeware Cockpit"}]},{"@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\/de972c035aaeecfc40a3ae2ea5ff7ba1","name":"Devon Kozenieski","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e4c421588c1a85dd9a76146fe15528f7?s=96&d=blank&r=g","caption":"Devon Kozenieski"},"url":"https:\/\/www.iri.com\/blog\/author\/devonk\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2020\/09\/cubeware-thumbnail.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14024"}],"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\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=14024"}],"version-history":[{"count":10,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14024\/revisions"}],"predecessor-version":[{"id":14060,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/14024\/revisions\/14060"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/14030"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=14024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=14024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=14024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}