Database Migration in IRI NextForm
The “Multi-Table Migration Wizard” in the DBMS edition of the IRI NextForm data migration tool maps and moves data from one database to another, multiple tables at a time. Read More
Connecting to 84 More Data Sources
Data architects and data scientists, as well as DBAs and governance teams, may need to use or migrate data in legacy file formats and databases. Additionally, the ability to mash-up those sources with newer file and database repositories is important in data integration (ETL) and analytic projects, as well as in data profiling for data loss prevention and privacy law compliance. Read More
Just How Fast is ODBC? A “Loaded” Comparison.
The Opening Question
ODBC gets a bad rap for speed sometimes … but should it? You’d think from what’s posted online that ODBC is intrinsically slow:
Microsoft disagrees in the case of SQL Server. Read More
(ACU)COBOL Vision File Conversion and Processing
This article covers COBOL file handling, and more specifically COBOL index file processing using the COBOL file conversion tools available from IRI.
COBOL data management sometimes involves index files in proprietary formats like I-SAM and Vision for COBOL file system optimization. Read More
CLF and ELF Web Log Formats
This article is first in a 3-part series on CLF and ELF web log data, where we introduce these file formats. The next article covers IRI solutions for processing web log data, and the last demonstrates web log data masking to protect visitor identities and destinations. Read More
Connecting to Teradata in IRI Workbench
Introduction
The ability to directly move very large database (VLDB) data from/to, and manipulate it within IRI software is essential for those requiring:
big data integration (ETL) database performance optimization (unloads, loads, reorgs, queries) database migration data masking (encryption, redaction, de-identification, etc.) Read More
Say Hello to UTF-8 Support in CoSort
Thanks to the Internet, the IT world is now a smaller place, too. Information conveyed in different languages must be accurately represented in multiple data sources, email clients, and applications. Read More
Finding Dark Data in Unstructured Sources
Update April 2019: Added more unstructured file formats.This is the first of a three-part blog series introducing IRI’s new data structuring technology. This article defines “dark data” and the unstructured sources IRI now supports. Read More
ASN.1 CDR Transformation & Reporting Support
Every land line or cellular telephone call made over a Public Land Mobile Network (PLMN) creates one or more call records. These Call Detail Records (CDRs) or Usage Detail Records (UDRs) are generated by the mobile switching center (MSC) — the primary GSM/CDMA service delivery node responsible for routing voice calls, SMS, and other services. Read More
Data Profiling: Discovering Data Details
Data profiling, or data discovery, refers to the process of obtaining information from, and descriptive statistics about, various sources of data. The purpose of data profiling is to get a better understanding of the content of data, as well as its structure, relationships, and current levels of accuracy and integrity. Read More
Converting & Upgrading VSE JCL Sort Parms
VSE, short for Virtual Storage Extended, is an operating system for IBM mainframe computers. Programs scripted in its job control language (JCL) instruct the system in how to run batch jobs or start subsystems. Read More