{"id":5978,"date":"2014-08-23T18:09:11","date_gmt":"2014-08-23T22:09:11","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=5978"},"modified":"2025-12-08T15:04:49","modified_gmt":"2025-12-08T20:04:49","slug":"iri-data-source-birt","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/","title":{"rendered":"Using IRI Data Sources in BIRT"},"content":{"rendered":"

In the previous article, “Affordable BIRT Acceleration via CoSort<\/a>,” we explained the nature and benefits of a new seamless\u00a0integration between the SortCL<\/a>\u00a0big data preparation program in IRI CoSort<\/a>\u00a0and thus IRI Voracity<\/a> and the Business Intelligence Reporting Tool (BIRT) in Eclipse. This article explains how to use an\u00a0IRI data source in a custom BIRT template so that data views can be simultaneously prepared\u00a0and visualized with ease.<\/em><\/p>\n

The steps below are written for those with a basic background in SortCL, Eclipse, and BIRT. Help contacts\u00a0are at the\u00a0end of the article.<\/p>\n

Enable\u00a0BIRT in IRI Workbench<\/strong><\/p>\n

1) Make sure BIRT is installed in the\u00a0IRI Workbench<\/a>\u00a0plug-in for Eclipse. If not, select Install New Software<\/em> from the help menu. In the ‘Work with’ field, add a repository named “BIRT” that opens https:\/\/download.eclipse.org\/birt\/updates\/release\/latest\/<\/a>. Select all the options\u00a0from the list of available software. Complete the installation and restart IRI Workbench.<\/span><\/p>\n

2)\u00a0Switch to the Report Design perspective. From the IRI Workbench\u00a0Window<\/em> menu, select\u00a0Open Perspective, Other, Report Design. <\/em><\/p>\n

3) Expose the\u00a0IRI project, data source, and remote systems explorers in this perspective via\u00a0Window<\/em>,\u00a0Show View, Other.<\/em><\/p>\n

Prepare the Data<\/strong><\/p>\n

1) Create or modify your\u00a0CoSort SortCL data preparation job in the\u00a0Workbench.\u00a0Use a\u00a0new job wizard from the CoSort menu to create the script, or write it directly in the syntax-aware editing window:<\/p>\n

\"BIRT_&_CoSort_in_Eclipse\"<\/a><\/p>\n

2) Specify all your source and target metadata and transformations in SortCL as usual.\u00a0However, you must define your\u00a0first target as\u00a0\/OUTFILE=stdout for\u00a0BIRT to\u00a0ingest this “IRI Data Source”\u00a0at reporting time. You can still specify additional output files, tables, and\/or procedures in subsequent target layouts.<\/p>\n

3) Ensure all the \/OUTFILE fields destined\u00a0for BIRT\u00a0also specify supporting\u00a0fields. For example,\u00a0any\/SUMMARY fields have to be defined along with their \/FIELD formats so the aggregate values are passed into BIRT. See the image above.<\/p>\n

Design and Run the\u00a0Visualization<\/strong><\/p>\n

1) Click\u00a0File, New, Report<\/em>\u00a0from the top menu, and follow the wizard\u00a0instructions to design\u00a0the BIRT\u00a0report. Be sure to save your new, or move your existing, template into the same folder with the SortCL script so the\u00a0data (“IRI Data Source”) gets\u00a0prepared and fed\u00a0to\u00a0BIRT\u00a0via ODA<\/a>\u00a0at run\u00a0time.<\/p>\n

2) Click\u00a0Data, New Data Source, IRI Data Source.\u00a0<\/em>Click Next, and select the folder that contains your report template and SortCL job script.\u00a0Click\u00a0Finish.<\/p>\n

3) Click Data, New Data Set, New Data Set.\u00a0<\/em>Select the IRI Data Source again, click Next, and at the top of the next dialog, select the SortCL (.scl) file defining the data preparation for your report. Add and arrange the available data fields as you want them\u00a0displayed.<\/p>\n

4) Use the palette to\u00a0modify labels and\u00a0fields,\u00a0and their positions. You can specify additional calculations on the data as well, and customize the\u00a0report or graph layout as needed.<\/p>\n

5) At report creation time, SortCL and\u00a0BIRT will run simultaneously\u00a0to integrate the data and\u00a0display the information you need.\u00a0An example visualization we customized using data from\u00a0the job script above looks like this:<\/p>\n

\"\"<\/p>\n

Consult\u00a0http:\/\/www.eclipse.org\/birt\/documentation\/tutorial\/tutorial-1.php<\/a>\u00a0for help designing\u00a0BIRT reports and\u00a0charts.<\/p>\n

Contact IRI<\/a> if you need assistance or training in the use of CoSort and BIRT in Eclipse.<\/p>\n

Contact OpenText for help\u00a0with more advanced visualization\u00a0and\u00a0analytic requirements, or to build\u00a0rich internet applications using BIRT frameworks.<\/p>\n","protected":false},"excerpt":{"rendered":"

In the previous article, “Affordable BIRT Acceleration via CoSort,” we explained the nature and benefits of a new seamless\u00a0integration between the SortCL\u00a0big data preparation program in IRI CoSort\u00a0and thus IRI Voracity and the Business Intelligence Reporting Tool (BIRT) in Eclipse. This article explains how to use an\u00a0IRI data source in a custom BIRT template so<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":32,"featured_media":11686,"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,2255],"tags":[176,634,25,110,629,359,633,632,71,546,489,631,630],"class_list":["post-5978","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-archived-articles","tag-actuateone","tag-analytic","tag-big-data","tag-birt","tag-business-intelligence-reporting-tool","tag-data-preparation","tag-data-set","tag-data-source","tag-eclipse","tag-iri-cosort","tag-metadata","tag-oda","tag-visualization"],"acf":[],"yoast_head":"\nUsing IRI Data Sources in BIRT - IRI<\/title>\n<meta name=\"description\" content=\"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.\" \/>\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\/iri-data-source-birt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using IRI Data Sources in BIRT\" \/>\n<meta property=\"og:description\" content=\"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-23T22:09:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-08T20:04:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"243\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jackie Sabbagh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackie Sabbagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\/iri-data-source-birt\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\"},\"author\":{\"name\":\"Jackie Sabbagh\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a77b509c111f25f8888fe7bd0c73fa9e\"},\"headline\":\"Using IRI Data Sources in BIRT\",\"datePublished\":\"2014-08-23T22:09:11+00:00\",\"dateModified\":\"2025-12-08T20:04:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\"},\"wordCount\":576,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg\",\"keywords\":[\"ActuateOne\",\"analytic\",\"big data\",\"BIRT\",\"Business Intelligence Reporting Tool\",\"data preparation\",\"data set\",\"data source\",\"Eclipse\",\"IRI CoSort\",\"metadata\",\"ODA\",\"visualization\"],\"articleSection\":[\"Business Intelligence (BI)\",\"Archived Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\",\"url\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\",\"name\":\"Using IRI Data Sources in BIRT - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg\",\"datePublished\":\"2014-08-23T22:09:11+00:00\",\"dateModified\":\"2025-12-08T20:04:49+00:00\",\"description\":\"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg\",\"width\":300,\"height\":243},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using IRI Data Sources in BIRT\"}]},{\"@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\/a77b509c111f25f8888fe7bd0c73fa9e\",\"name\":\"Jackie Sabbagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e8797c735e92e5e8a11c74ddeb2c919b?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e8797c735e92e5e8a11c74ddeb2c919b?s=96&d=blank&r=g\",\"caption\":\"Jackie Sabbagh\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/jackies\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using IRI Data Sources in BIRT - IRI","description":"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.","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\/iri-data-source-birt\/","og_locale":"en_US","og_type":"article","og_title":"Using IRI Data Sources in BIRT","og_description":"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.","og_url":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/","og_site_name":"IRI","article_published_time":"2014-08-23T22:09:11+00:00","article_modified_time":"2025-12-08T20:04:49+00:00","og_image":[{"width":300,"height":243,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","type":"image\/jpeg"}],"author":"Jackie Sabbagh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jackie Sabbagh","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/"},"author":{"name":"Jackie Sabbagh","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/a77b509c111f25f8888fe7bd0c73fa9e"},"headline":"Using IRI Data Sources in BIRT","datePublished":"2014-08-23T22:09:11+00:00","dateModified":"2025-12-08T20:04:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/"},"wordCount":576,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","keywords":["ActuateOne","analytic","big data","BIRT","Business Intelligence Reporting Tool","data preparation","data set","data source","Eclipse","IRI CoSort","metadata","ODA","visualization"],"articleSection":["Business Intelligence (BI)","Archived Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/","url":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/","name":"Using IRI Data Sources in BIRT - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","datePublished":"2014-08-23T22:09:11+00:00","dateModified":"2025-12-08T20:04:49+00:00","description":"Learn to use IRI Voracity data management sources and targets with BIRT for immediate reporting in their common Eclipse IDE, IRI Workbench.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","width":300,"height":243},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/business-intelligence\/iri-data-source-birt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using IRI Data Sources in BIRT"}]},{"@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\/a77b509c111f25f8888fe7bd0c73fa9e","name":"Jackie Sabbagh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e8797c735e92e5e8a11c74ddeb2c919b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e8797c735e92e5e8a11c74ddeb2c919b?s=96&d=blank&r=g","caption":"Jackie Sabbagh"},"url":"https:\/\/www.iri.com\/blog\/author\/jackies\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2014\/08\/data-source-birt.jpg","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5978"}],"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\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=5978"}],"version-history":[{"count":25,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5978\/revisions"}],"predecessor-version":[{"id":17626,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/5978\/revisions\/17626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11686"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=5978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=5978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=5978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}