n 80 34 56 w 28.1422 n 80.5822 w 28.1422 ; 80.5822 iri the cosort company type private industry data processing sorting data integration test data data masking data conversion headquarters melbourne florida usa products cosort fast extract fact nextform fieldshield cellshield rowgen fieldshield voracity website www.iri.com innovative routines international iri inc. is an american software company first known for bringing mainframe sort merge functionality into open systems . 1 iri was the first vendor to develop a commercial replacement for the unix sort command and combine data transformation and reporting in unix batch processing environments . 2 in 2007 iri s coroutine sort cosort became the first product to collate and convert multi gigabyte xml and ldif files 3 join and lookup across multiple files 4 5 and apply role based data privacy functions including aes 256 encryption for fields within sensitive files . 6 iri is headquartered in melbourne florida united states and has resale and support offices in 25 countries 7 including france japan south africa and brazil . 8 primary computing platform partners include hp 9 ibm 10 fujitsu 11 intel 12 novell 13 red hat sun microsystems and microsoft . 14 cosort users include aim healthcare 15 eds 16 hsbc insurance 17 and thomson reuters . 18 the company was named a most promising big data solution provider by cioreview in 2015 as it launched voracity to support hadoop processing nosql data sources etc. 19 contents 1 products 2 iri cosort 3 iri voracity 4 other tools 4.1 iri fact 4.2 iri nextform 4.3 iri fieldshield 4.4 iri rowgen 4.5 iri workbench 5 references 6 external links products edit iri software is designed to transform convert report and protect large data volumes rapidly in distributed heterogeneous computing environments . 20 these functions are built into the cosort package or through spin offs for data extraction generation security and migration . each tool uses the same metadata format for defining and manipulating data . 21 this data definition file format is also supported by analytixds and meta integration technology miti so that third party etl bi and data modeling tool users can convert or re use their existing metadata in iri product environments . 22 iri cosort edit cosort was released for cp m in 1978 dos in 1980 unix in the mid eighties and windows in the early nineties 23 and received a readership award from dmreview magazine in 2000 24 cosort was initially designed as a file sorting utility and added interfaces to replace or convert the sort program parameters used in ibm infosphere datastage informatica micro focus cobol jcl natural sas and syncsort unix . 25 in 1992 cosort added related data manipulation functions through a control language interface based on dec vax vms sort utility syntax 26 which evolved through the years to handle file based data integration and staging functions in data warehouse etl operations 27 for data warehouse and data mart applications cosort performs source data extraction data cleansing sorting reformatting data type conversion aggregation and indexing all in a single pass . most operational data in commercial and public sector enterprises reside internally in sequential flat files relational database tables or are imported from data tapes and transmissions generated externally . these historical databases are optimized for ad hoc queries and transactions rather than for extraction . cosort accepts multiple input files large scale tables or flat file data dumps or records streaming through pipes to perform conditional selection on records for downstream processes . dennis hill database trends magazine july 1999 28 cosort version 9 releases begun in 2007 can simultaneously transform convert report and or protect data for etl business intelligence change data capture database load and query 29 application development and data migration activities . version 10 releases are expected to begin in 2015 . iri voracity edit iri voracity is a data management platform launched in december 2015 for data discovery integration migration governance and analytics . it consolidates key data curation activities in the iri workbench gui and transforms data in the cosort engine or optionally in mapreduce spark storm or tez . voracity includes all iri software and adds data profiling etl metadata management master data management data federation and multiple job design and control capabilities . 30 other tools edit iri cosort iri fact and iri nextform are products in the iri data manager suite . iri fieldshield iri rowgen and the new iri cellshield for sensitive data discovery masking and auditing in excel are products in the iri data protector suite . iri fact edit fact fast extract is a high performance unload utility for oracle db2 sybase ase and iq sql server mysql altibase and tibero . it exports large tables into flat files for archive etl reorg reporting and other applications . 31 fact and cosort used together provide for rapid unloading and transformation of data in oracle databases in support of etl processes . 32 iri nextform edit nextform is a data migration spin off from cosort functionality designed to convert between structured file formats such as csv isam ldif and xml 33 plus data types such as ascii ebcdic unicode and packed decimal . 34 newer nextform editions can structure data in unstructured sources convert cobol vision files and facilitate database migration . 35 iri fieldshield edit fieldshield is a cosort spin off designed to protect data privacy . 36 the software protects personally identifiable information and other private data at the field or record level within database tables files and other sources subject to data spill . 37 privacy functions include aes encryption data masking and pseudonymization . job details can be audited from a log file in xml format . 38 iri rowgen edit rowgen is designed to generate test data in production table file and report formats for prototype database population compliance outsourcing and application prototyping projects . 39 40 rowgen s gui parses data models to define table layouts and relationships so database test sets are structurally and referentially correct . 41 rowgen can also transform and format test data during its generation . 42 iri workbench edit the workbench is a graphical user interface gui and integrated development environment ide for all iri software products built on eclipse . the workbench is a free optional place to design run and manage data connections 43 metadata and jobs and to use third party plug ins for business intelligence data modeling version control etc. references edit wilkinson stephanie applications unix today november 14 1988 miller david b. dp labs a better sort of sort hp professional 7 2 february 1993 ipfrontline article june 11 2007 complex joins and lookups now run outside a dbms information management online august 21 2007 cosort v9 ibm systems magazine november 2007 munshi renee cosort adds data protection at the field level windowsitpro june 14 2007 iri web site . retrieved july 21 2009 . 3con brazil news . infrastructure partners . ibm system z linux products . fujitsu solutions catalog . intel early release program . suse linux yes certification . microsoft mainframe migration partners . information management magazine july 2008 information management magazine july 2005 information management magazine july aug 2009 information management magazine jan feb 2009 https drive.google.com file d 0by8hcrafipthqtk1bvpyajz5x3c view pli 1 beall scott . k & hodges robert l. sort merge software comparison columns gartner research dpro 91136 july 16 2002 global research partners july 23 2007 data conversion.org april 24 2006 iri company history retrieved august 1 2009 dm review 100 dm review 10 12 december 2000 iri whitepaper third party sort replacement and conversion tool examples . product brief software magazine may 1992 ittoolbox oracle database connections june 25 2009 hill dennis m. cosort the emerging etl engine database trends july 1999 burleson donald k. hypercharging oracle data loading february 1 2004 iri announces total data management platform businesswire december 1 2015 high speed oracle data extract and reload . burleson consulting friedman ted et al. magic quadrant for data integration tools gartner report september 22 2008 jaxenter portal it republik june 11 2007 cobol user group file conversion tools retrieved august 3 2009 cosort journal march 2014 datagovernancesoftware.com cat5 . jarvis darick 5 tips for protecting sensitive data data storage connection september 4 2007 koopman james are you compliant within flat file processing april 13 2009 ibm partnerworld global solutions directory . otn partner news oracle magazine march 2008 sql server magazine november 2008 information management magazine july 2007 136 data sources and targets iri web site july 2014 external links edit iri inc. home page retrieved from https en.wikipedia.org w index.php title innovative routines international & oldid 711218780 categories companies based in brevard county floridasoftware companies based in floridahidden categories coordinates not on wikidata navigation menu personal tools not logged intalkcontributionscreate accountlog in namespaces article talk variants views read edit view history more search navigation main pagecontentsfeatured contentcurrent eventsrandom articledonate to wikipediawikipedia store interaction helpabout wikipediacommunity portalrecent changescontact page tools what links hererelated changesupload filespecial pagespermanent linkpage informationwikidata itemcite this page print export create a bookdownload as pdfprintable version languages add links this page was last modified on 21 march 2016 at 15 54 . text is available under the creative commons attribution sharealike license ; additional terms may apply . by using this site you agree to the terms of use and privacy policy . wikipedia is a registered trademark of the wikimedia foundation inc. a non profit organization . privacy policy about wikipedia disclaimers contact wikipedia developers cookie statement mobile view