Performing a Summary Aggregation with CoSort and the IRI…
This demonstration shows how to use the IRI Workbench to create an aggregation job using sums. Workbench is used to create the job script in the SortCL language. Read More
Format-Preserving Encryption … Another Important FieldShield Function [video]
According to Trent Henry of the Burton Group,
Data protection needs to take into account both internal and external threats, including those against critical database and application resources. Read More
? The Case for Safe, Intelligent Database Test Data
Database Test Data Usage – This blog caught my eye because of its title, Do the right thing when testing with production data. It struck me as oxymoronic, since we know production data should not be used for testing at all …
Of course we know how tempting it is to use production data for testing applications, simulating databases, prototyping ETL operations, and just about anything else that needs to work with the real thing. Read More
Delivering Business Intelligence Faster [video]
What is business intelligence, and why is its rapid creation and delivery important?
Business intelligence, or BI, refers to computer-based techniques used in identifying, extracting and analyzing business data. Read More
Data Masking and Encryption Are Different [video]
It is a common mistake to refer to data masking and data encryption interchangeably to mean the same things. While field-level encryption is considered one of many possible “data masking” functions, we define data masking and encryption as technically distinct processes below. Read More
Creating a Metadata File for a CSV Data File…
This demonstration shows how to create a metadata file for a CSV data file. A metadata file contains the definitions of data sources or targets such as flat files, database tables and pipes. Read More
Introduction to IRI FACT, Fast Extract [video]
IRI FACT (Fast Extract) rapidly unloads huge tables in Oracle, Sybase, DB2 UDB, MySQL, SQL Server, Altibase, Greenplum, Teradata, and Tibero to flat files. FACT uses native drivers and parallelization technologies to unload up to 7X faster than other methods. Read More
Introduction to IRI NextForm Data Migration [video]
IRI NextForm converts, replicates, federates, and reports on data in multiple sources and targets. There are six editions that specialize on different migration goals: Lite Edition – basic file conversions, COBOL edition – migrates MF COBOL, MF-ISAM, Acucobol, DBMS edition – database migration, Legacy edition – extracts data from hundreds of legacy sources, Modern edition – addresses cloud, SaaS, and big data sources, and Premium edition – which customizes your migrations for any of these data types, sources, and targets. Read More
Preview Test Data Demonstration [video]
This demonstration shows how IRI Workbench users can preview the format of data when they are creating job scripts. The data can populate from the actual input sources or from generated test data. Read More
Introduction to IRI CoSort Data Manipulation [video]
IRI CoSort is the world’s #1 sort, and single-pass “super tool” for data transformation, reporting, and more. Use CoSort to migrate legacy sorts and data, accelerate BI, DB, and ETL tools, and replace SQL, shell scripts, and 3GL programs that can’t transform fast enough. Read More
IRI CellShield EE (Enterprise Edition) Features [video]
IRI CellShield EE (Enterprise Edition) is the full-featured, professional data masking package for Excel 2010 and later workbooks in your LAN, and MS repositories. Discover, report, protect, and audit PII in cells across multiple sheets at once using encryption, masking, and pseudonymization functions to comply with data privacy laws. Read More