Omni360 FEP

Omni360-TR

信用卡

Call Center&CRM

其他

顧問服務

The world's first commercial sort package off the mainframe continues to deliver maximum price-performance and functional versatility for manipulating huge files, tables, and other data sources.

IRI CoSort® is not only the world's #1 sort/merge utility, it is also a proven, user-friendly, one-stop "super tool" supported in Eclipse for easily performing, and accelerating.

Use CoSort and its powerful 4GL program and Eclipse GUI for:

• legacy sort replacement and data migration projects
• fast data warehouse ETL and ODS operations
• very large database (VLDB) load and query acceleration
• BI tool performance optimization; data governance
• application performance improvement

Use CoSort to augment - or replace - existing ETL / sort / BI tools, 3GL and SQL programs, or batch and shell (Perl, Python, etc.) scripts.

Feature & Benefit

IRI CoSort Use Cases

Task Consolidation	Unlimited Mapping	Database Acceleration
"CoSort runs our data filtering, sorting, merging, aggregating, and reformatting tasks together, and manages them all in one script we can easily understand and tweak."	"CoSort moves data between massive file sources and targets efficiently. We can pre-sort to speed loads and create hand-off files for BI at the same time."	We use CoSort for change data capture and offline reorgs -- improving performance 80%. It removes our data volume ceiling and speeds up queries."

NextForm v3 is the latest data management product supported in Eclipse from IRI, The CoSort Company. Spun from the SortCL program in IRI CoSort, IRI NextForm is a data migration and reformatting package that helps you convert and re-use the data stored in legacy fields, file formats, and databases.

Apply and view your data in new ways ... in new files and tables, custom reports, BI tools, virtualized views, and more. NextForm handles data in all of these:

¹ NextForm COBOL edition supports standalone conversion of Micro Focus and Acucobol Vision index files.

² Contact IRI Professional Services for VSAM and related semi-structured data conversion services.

³ Non-UIMA versions require XML data elements to conform to a flattened structure and other restrictions.

Feature & Benefit

IRI NextForm Use Cases

Quick and Easy Data Migration	Multiple Files and Data Types	Multiple Files and Data Types
"NextForm simply and quickly customizes our outputs when converting LDIF files to CSV. A 165mb LDIF file converted in seconds, 1+GB in less than a minute. Excellent product!"	"NextForm converts EBCDIC data files (including zoned and PD fields) to ASCII. As a beginner I was able to make new jobs quickly and determine the output was correct."	"Performance was great, and the GUI was not necessary because the jobs self-document. Among all the conversion tools we found, NextForm was at once the easiest and most robust.

IRI Workbench™ is the free graphical user interface (GUI) and integrated development environment (IDE) for all IRI software products. Running on Windows and Linux clients, IRI Workbench combines the proven performance of IRI software engines with the familiar job design and management facilities of Eclipse.

IRI Workbench features metadata creation, conversion, discovery, and application wizards to help you generate, deploy, and manage the simple data definition files (DDF) and job scripts common to all IRI software.

IRI Workbench includes purpose-driven wizards to build new jobs for:

• very large database extraction (E) using IRI FACT
• data transformation (T), loading (L), and reporting using IRI CoSort
• DW ETL and database reorg using FACT and CoSort
• data and database migration, replication, or federation using IRI NextForm or CoSort
• data encryption and masking using IRI FieldShield or CoSort
• test data generation jobs using IRI RowGen or CoSort

Within the wizards and dialogs are also data mapping, MDM, and rule application facilities. Each created or imported job produces one or more standalone job scripts or configuration files to drive the above tasks.

Modify jobs with GUI components or a syntax-aware editor. Execute from the GUI, local or remote system command line, a batch script, or API call.

IRI job scripts are simple, portable text files. Run them anywhere that the back-end IRI software product is licensed. The scripts' data and job definitions all use the shared metadata of the CoSort Sort Control Language (SortCL) 4GL program.

Scripts and metadata managed in the IRI Workbench are easy to search and share with built-in Eclipse functionality. Free Eclipse plug-ins like GIT and SVN support team sharing, version control, and metadata lineage and impact analysis.

Eclipse Facilities

One of the most powerful aspects of the IRI Workbench GUI is that it is built on Eclipse™.

The Eclipse Integrated Development Environment (IDE) gives IRI CoSort, IRI Fast Extract (FACT), IRI FieldShield, IRI RowGen, and IRI NextForm users:

• A familiar, common GUI, and a shared metadata, job, and worfklow management system
• The power to combine products in purpose-driven ways (e.g., the offline reorg wizard)
• Direct browsing and data movement for local and remote source files and on-line RDBs
• Ergonomic features like perspective control and text search (e.g., for metadata impact analysis)
• Plug-in interactions for BI/analytics (e.g., BIRT), metadata asset control (e.g. EGit), data modeling, etc.
• Access to Hadoop (HDFS), mainframe, semi-structured, and unstructured data sources
• The opportunity to use Enterprise Service Bus (ESB) modules from providers like W2O2

For example, the Eclipse data tools platform (DTP) plug-in gives IRI Software users the ability to browse and edit their source and target databases as they:

• unload in bulk with FACT, and select/filter in CoSort/SortCL or in SQL
• load in bulk with pre-CoSorted data, and insert/update in CoSort/SortCL or SQL
• manipulate and protect table contents with FieldShield (or CoSort/SortCL)
• migrate tables with NextForm (or CoSort/SortCL)
• generate test tables with RowGen (or CoSort/SortCL)

In the same GUI, the results of CoSort/SortCL, FieldShield and other IRI software operations can feed advanced data visualization plug-ins like BIRT:

Discover Data

The IRI Workbench supports the discovery and definition of your disparate data sources in both local and remotely connected systems. All flat files and database tables to which you connect can be defined automatically in data definition file (DDF) format. The data discovery and definition features in the Workbench support all IRI software users. Standalone data profiling tools may also be used, outside of or integrated into Eclipse. Once profiled and documented in DDF metadata repositories, you are ready to being using the layout information in their data integration, staging, protection, and BI applications.

Design and Run Job

The IRI Workbench provides a simple visual interface and ergonomic modules to design and run all IRI software. In the GUI, built on Eclipse, you build, modify, share, and execute simple, portable job scripts.

The job scripts for all the products (except IRI FACT) are based on the IRI CoSort Sort Control Language (SortCL) program. SortCL is a fourth-generation language (4GL) designed to be self-documenting for English readers, but with the IRI Workbench, you do not have to learn the language.

Job scripts can also render in a syntax-aware editor. You can use the editor to write or modify parameters. Changes in the scripts are reflected dynamically in the job outline, the GUI dialogs, and broader job flow (project) metadata. Thus there are a number of places you can make changes that will propagate automatically.

IRI FieldShield® is powerful, affordable, and easy-to-use data masking software for structured data sources (DBs and flat files), big and small.

FieldShield shields fields with the compliance industry's broadest array of protection functions. FieldShield provides role-based access controls for sensitive data on a static or dynamic basis to help you comply with CIPSEA, FERPA, HIPAA/HITECH, PCI, SOX, and international data privacy laws like the EU Data Privacy Directive and POPI in S. Africa.

Create, manage, and run FieldShield jobs in its familiar and friendly GUI, built on Eclipse. Modify and run FieldShield's simple text scripts from the GUI, command line, batch programs, or database applications. Or, call FieldShield functions at the API level for embedded data protection.

FieldShield is the best way to:

• Profile, secure, present, and populate data in a familiar integrated development environment (IDE)
• Mask big data using your existing systems, without Hadoop, in-memory databases, or appliances
• De-identify data in one or more sources simultaneously based on your business rules
• Specify protection conditions and rules across tables for efficiency and referential integrity
• Encrypt and remove the individualizing characteristics of data without cutting off access to non-sensitive data, or changing its basic appearance
• Auto-create XML audit logs to help verify compliance with data privacy laws
• Fold data masking into data transformation, migration, replication, loading, federation, and BI activities

Feature & Benefit

IRI CoSort Use Cases

Payment Card Industry Data (PCI)	Personally Identifying Information (PII)	Protected Health Information (PHI)
"FieldShield decrypts and re-encrypts fields in our credit card migration and test files, and easily generates and manages encryption keys."	"We use the FieldShield GUI to design and run our Oracle data masking jobs on Linux. Eclipse is familiar to us already so we didn’t need any help."	"FieldShield’s de-identification and hashing functions help our geo-medical consumer health databases exceed HIPAA requirements."