IRI Delivers Fast Extract (FACT) in Eclipse
Very Large Database (VLDB) Unload Tool Gets Powerful GUI Front-End
Melbourne, Fla. (November 4, 2011) – Innovative Routines International (IRI), Inc., a leading developer of big data transformation and data-centric protection software, has released its Fast Extract (FACT) utility in the IRI Workbench, an Eclipse plug-in that already supports CoSort for big data transformation, and FieldShield for data masking functions in PII and PHI environments.
Fast extracts from -- and pre-CoSorted loads into -- very large database (VLDB) tables play key performance roles in: high-volume data warehouse extract-transform-load (ETL) and operational data store (ODS) data acquisition, off-line reorgs, database migration and replication, archive and retrieval, data preparation for BI tools, and reporting.
The new job wizard, syntax-aware configuration file editor, and graphical execution options for FACT in the IRI Workbench provide all the front-end support necessary for rapidly off-loading table data into portable flat files. “In addition to creating and launching the FACT configuration file, the Workbench now supports target table creation and loader control file specification for faster loading,” said Lisa Mangino, Director of North America Sales for IRI, "facilitating job design and satisfying production SLAs simultaneously."
To support subsequent (batch) or concurrent (piped) transformation and load operations, FACT automatically creates the extract file metadata in both CoSort's Sort Control Language (SortCL) Data Definition File (DDF), and the database's load utility metadata, formats. Using FACT in the IRI Workbench integrates that functionality in a broader visual and operational context, so that users can:
- see and work with data in source and target tables via the Data Source Explorer
- use the Data Definition File (DDF) metadata FACT creates in CoSort SortCL and FieldShield jobs
- run CoSort data transformations and reports, plus direct path loads, in-line with FACT (batch/piped ETL)
- feed FACT, CoSort or FieldShield output to other Eclipse plug-ins like BIRT for advanced reporting
- work on unload, load, reorg, and ETL projects in teams with version control
For more details, please visit http://www.iri.com/products/FACT_GUI, or email email@example.com.
About IRI, The CoSort Company & FACT
Founded in 1978, Innovative Routines International (IRI), Inc. is an independent software vendor headquartered in Melbourne, Florida with license and support offices in more than 30 cities worldwide. IRI's flagship package, CoSort, transforms and reports on big data, migrates legacy sorts, and replaces many SQL, shell, and 3GL programs. CoSort-compatible tools include FACT (fast extract), FieldShield (data masking), NextForm (data conversion), and RowGen (test data). FACT unloads data rapidly from Oracle, DB2, Sybase, SQL Server, and Altibase.
For more information, contact: Jason Koivu, PR Coordinator
IRI, The CoSort Company
(321) 777-8889 ext. 210