IRI and Full 360 Cooperate on ETL Orchestration; CoSORT Integrated into metaController for Scheduled Data Warehouse Operations.MELBOURNE, Fla. -- Innovative Routines International (IRI Iri (ē`rē`), former city, North Jeolla (Cholla) prov., SW South Korea. An agricultural center and transportation hub, it was absorbed into Iksan. ), Inc. ("The CoSORT(R) Company"), a pioneer in high-volume sorting and data warehouse acceleration software for open systems, and Full 360 LLC (Logical Link Control) See "LANs" under data link protocol. LLC - Logical Link Control (New York New York, state, United States New York, Middle Atlantic state of the United States. It is bordered by Vermont, Massachusetts, Connecticut, and the Atlantic Ocean (E), New Jersey and Pennsylvania (S), Lakes Erie and Ontario and the Canadian province of , NY), a premier solutions and technology provider specializing in scalable, repeatable infrastructures for corporate performance management (CPM) and business intelligence (BI) services, announced the formation of a technical and marketing alliance. The partnership is designed to help each company strengthen their offerings in the extract-transform-load (ETL (Extract, Transform, Load) The functions performed when pulling data out of one database and placing it into another of a different type. ETL is used to migrate data, often from relational databases into decision support systems. ) market through product integration, concept sharing, and customer referral. IRI's high-performance file manipulation package, CoSORT, has been recognized for years as an ETL and BI engine because its SortCL program rapidly performs large scale data warehouse transforms and reports - integrating, staging, and presenting flat files from and to many formats. CoSORT users define their input layouts, manipulations, and output targets - all in one I/O (Input/Output) The transfer of data between the CPU and a peripheral device. Every transfer is an output from one device and an input to another. See PC input/output. I/O - Input/Output pass and/or job script written in SortCL's explicit 4GL. SortCL job scripts, compatible across all UNIX UNIX Operating system for digital computers, developed by Ken Thompson of Bell Laboratories in 1969. It was initially designed for a single user (the name was a pun on the earlier operating system Multics). and Windows platforms, can be built with a text editor or free Java GUI (Graphical User Interface) A graphics-based user interface that incorporates movable windows, icons and a mouse. The ability to resize application windows and change style and size of fonts are the significant advantages of a GUI vs. a character-based interface. , and get run on the command line, in batch scripts, via the GUI, or from a program. IRI's FAst extraCT (FACT) software rapidly unloads large Oracle tables to flat files and simultaneously creates SortCL field layouts for transforms and SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. *Loader control files for piped ETL and reporting operations. Full 360's metaController(TM) manages processes in data warehousing and OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. data mart environments and facilitates the evolution from batch scripting to true project orchestration. By precisely controlling the many steps involved in data warehousing and OLAP, metaController users can encompass the most important dimensions of process orchestration - human touch points, process metadata, and business rules. FACT and SortCL will now be among the jobs and other major ETL packages that metaController users can modify and launch, including Informatica PowerCenter, IBM (International Business Machines Corporation, Armonk, NY, www.ibm.com) The world's largest computer company. IBM's product lines include the S/390 mainframes (zSeries), AS/400 midrange business systems (iSeries), RS/6000 workstations and servers (pSeries), Intel-based servers (xSeries) DataStage and Hyperion Essbase. "By integrating FACT and SortCL into MetaController, Full 360 is adding value to its portfolio of manageable applications, delivering more choice to data warehouse ETL architects looking to control and schedule high-performance, flat-file extract and transformation components," noted Rohit Amarnath, Full 360's CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. . metaController also gives data architects a drag-and-drop means to design and manage process flows between systems (including scripts, along with existing ETL or EAI (Enterprise Application Integration) Refers to various techniques used to share data and business processes in large enterprises. When companies acquire another organization, disparate information systems have to be made to work together. tools) in the context of upstream and downstream process steps. For example, a data warehouse architect can pipe multi-gigabyte Oracle tables directly from FACT into CoSORT SortCL scripts, building many pre-sorted load and report targets at once. From IRI's perspective, "the integration of FACT and CoSORT within metaController will benefit everyone involved with either company's toolsets, as well as those looking to accelerate DataStage or Informatica," according to David Friedland, VP of Business Development. "Data warehouse architects and end-users will be able to develop, run, and trouble-shoot faster E, T, and L jobs in an efficient, inter-dependent, and visually-managed production framework," he added. About Innovative Routines International (IRI), Inc. Founded in 1978 and headquartered in Melbourne, Florida, IRI develops and markets high-speed data sorting, reporting and ETL software for UNIX and Windows data centers. CoSORT tools perform and accelerate large-volume: mainframe sort and data migrations, database reorgs, data warehouses, report generation, and, third-party software applications. The CoSORT package has 18 user interfaces, all of which leverage a record-setting, parallel sort engine in proprietary coroutine architecture. Many of these interfaces seamlessly replace slower, third-party sorts. CoSORT's primary native interface, SortCL, can also simultaneously: select, sort/merge/join, aggregate, calculate, convert, reformat (1) To change the record layout of a file or database. (2) To initialize a disk over again. and report. IRI's core products: CoSORT, FAst extraCT (FACT) for Oracle, and the RowGen test data synthesizer synthesizer Machine that electronically generates and modifies sounds, frequently with the use of a digital computer, for use in the composition of electronic music and in live performance. and file format simulator, are represented in more than 30 international offices. For more details, visit http://www.cosort.com. About Full 360 LLC Founded in 1999, Full 360 has focused exclusively on delivering infrastructure solutions for data warehousing, business intelligence and performance management initiatives. The company specializes in solving information delivery problems for organizations with fragmented or complex information challenges. Full 360's end-to-end solutions help clients transform siloed information assets into meaningful business insight--insight that leads to improved decision-making and optimized business processes. Full 360 offers expertise in information strategy, enterprise data integration, data warehousing, metadata, data delivery and analytic applications, and client education. By combining the metaController product with existing technology and business deliverables, Full 360 customers can architect best of breed ETL platforms and BI applications that are easy to manage and scale. For more details, visit http://www.full360.com. CoSORT(R) and SortCL are trademarks of Innovative Routines International, Inc. metaController is a trademark of Full 360 LLC. All other products or brandnames are trademarks or registered trademarks of their respective holders. |
|

Printer friendly
Cite/link
Email
Feedback
Reader Opinion