Learn IRI Software

• Installation
• IRI Workbench
• Data Discovery
• Data Integration
• Data & Database Migration
• Data Governance
• Analytics & BI

Self-Directed Learning Site for IRI Software

This page links you to free, self-help content in the many data management objectives that IRI software products can help you achieve.

Please note that:

1. All IRI software users, from freemium to licensed subscribers, can access this material.  Only supported users, however, can get help from IRI beyond this content.
2. The IRI software product or licensing agreement you have may or not support the functionality, or entitle you to support for that feature even if the feature itself is enabled in your product. For more information, please refer to this product-feature matrix.
3. Additional training materials are available on request, custom designed for your company's requirements and certification-oriented learning. Please describe your material requirements below and an IRI services representative will contact you.

IRI Product Installation

• All IRI Workbench-supported Products
• IRI Workbench Demo Projects in Git
• IRI Chakra Max Database Firewall

IRI Workbench - General

• Getting Started
• DB Setup (J/ODBC Connections)
  • Connection registry
  • Multi-Table Filtering
  • DSN files
  • PostgreSQL Example
  • Snowflake Example
• Job Design Methods
  1. New Job Wizards (see Welcome > First Steps)
  2. Dialogs (use ? for in-context Help)
  3. Script Editor & Outline (see product manuals for syntax)
  4. Work Flow (Palette) (video intro to diagrams)
  5. erwin (AnalytiX DS) Mapping Manager
  6. Building Voracity Jobs in Your App via Gulfstream API
• Flow Design (how-to articles for Voracity ETL and other batch jobs)
  • Creating a Work Flow Using Existing Job (SortCL, etc.) Scripts (3 parts)
  • Creating a Work Flow from a Wizard (2 parts)
  • Creating a Work Flow from the Palette (2 parts)
    • Demo video
• Job Deployment
  • Command Line / Wicked Shell
  • Single Job Execution Options
  • Batch Job (Work Flow) Execution Options
  • Creating & Executing SQL Statements
  • Remote Connection/Executions
  • Running Voracity Jobs in Hadoop
    • ​When to Use Hadoop
      • Connecting to HortonWorks/Ambari
      • Connecting to Cloudera
      • Connecting to MapR
• Job Scheduling
  • Workbench Task Launcher
  • Oracle Job Scheduler
  • Stonebranch UAC

Data Discovery

• DB Profiling
  • Displaying Profiling Results in Splunk
• ER Diagramming
• Flat-File Profiling
• Dark (Unstructured) Data Search/Structure/Profile
• Multi-Table Filtering
• Structured Metadata Discovery
• Data Classification
  • Applying (Masking or other) Rules to Classified Data
  • Demo video
• Directory Data Class Search
• Schema-wide Data Class Search
  • Multi-Schema/DB Data Class Masking
• Schema-wide Pattern Search
  • Schema Pattern Search to Data Class Association
• Metadata Search (via Git)
• PII (Sensitive Object) Scanning in IRI Chakra Max

Data Integration

• Data Integration Architectures (and Voracity's applications)
  • Enterprise Data Warehouse 
  • Logical Data Warehouse
  • Operational Data Store / Enterprise Data Hub
  • Production Analytic Platform (4-part series)
  • Data Lake
  • ETL vs. ELT
• ETL Job Design (see IRI Workbench > Flow Design above)
• ETL Execution (see IRI Workbench > Job Deployment above)
• Faster Extraction
• Data Transformation
  • Date Masking
  • Filtering
  • Sort/Join/Aggregate
  • Inner Join
  • Left Outer Join
  • Sort
  • Summary Aggregation
    • IoT edge aggregation demo (video)
  • Row-Column Pivoting
  • Set Lookups
• Fast Loading
• Change Data Capture
• Slowly Changing Dimensions
• DB-Specific Optimization (see tabs)
• Voracity ETL Workflow (wizard mode video; see Flow Design above)
  • Oracle to MongoDB Example
• Voracity ETL Job Preview (via live or test data)
• Legacy ETL Optimization
  • ​Accelerating Informatica
  • Accelerating DataStage
  • Accelerating Pentaho
  • Accelerating Talend
• Legacy ETL Tool Migration (via erwin/AnalytiX DS Code Automation Templates)
  • Re-platforming Informatica

Data & Database Migration

• File-Format Conversion
• Database Migration
• Database Subsetting
• Basic Data Replication
• Incremental Data Replication
  • Incremental Changes, Oracle to MongoDB
• Data Federation
• Schema (Relational to Star) Migration
• Vision File Conversion
• XML (Complex) Parse/Process

Data Governance

• Data Masking
  • Dynamic Data Masking (DDM)
    • IRI FieldShield in DB Apps
      • Java & Hadoop (API) 
        • FieldShield ("Sandkey") SDK
    • IRI Chakra Max (DB Firewall)
  • Static Data Masking (SDM)
    • Getting Started with FieldShield
    • Single source masking demo (video)
    • Multi-table masking demo (video)
    • DB Data Class Masking
    • Which Data Masking Function Should I Use?
      • Blurring (Random Noise)
      • Bucketing (Generalization)
      • Deletion (GDPR Erasure)
      • Encryption
      • Hashing
      • Pseudonymization
      • Redaction
      • Tokenization
    • Multi-Table Masking (& Referential Integrity)
      • Rule-based (like column names)
      • Data Class-based
        • Data Class DB Masking Wizard
        • Applying Field Rules Using Classification
        • Data classification & masking demo (video)
    • Discrete Sources & Types
      • Cassandra DB 
        • Structured Collections
        • Structured & Unstructured Collections via DarkShield
      • Cassandra
      • CSV
      • Dates & Ages
      • Excel
      • HL7
      • Live Feeds
      • MongoDB
        • Structured Collections via Ex/Import 
        • Structured Collections via J/ODBC
        • Structured Collections via Native Driver
        • Structured & Unstructured Collections via DarkShield
      • NIDs / SSNs
      • NRIC
      • Pentaho
      • PostgreSQL
      • Snowflake DB
      • Splunk
      • Web Logs
  • Re-ID Risk Determination
    • Risk scoring wizard & blurring intro (video)
    • HIPAA Data Certification course
  • Unstructured (Dark) Data Masking (IRI DarkShield)
    • Getting Started Guide
    • DarkShield CLI SDK
    • Universal Forwarder (sending search/mask logs to Splunk)
    • Adaptive Response to Log Events in Splunk ES
    • Analyzing DarkShield Search/Mask Results in Splunk
• DB Firewall (IRI Chakra Max DAM/DAP-DCAP)
  • Data Security Governance
  • Training Syllabus
    • Policy Setting & Dynamic Data Masking
    • Monitoring & Alerts
    • Auditing
    • SIEM/SOC Integration
• Data Quality
  • Filter & De-Duplication
  • Fuzzy Searching
  • Data Validation
  • Data Unification (Homogenization, Reconciliation)
  • Finding Business Rule Violations
  • Finding Format Errors
• Master Data Management (MDM)
  • MD Consolidation
  • MDM Registry (pending)
  • Alternative (via GIT)
• Metadata Management
  • Teamwork (via GIT)
    • Version Control
    • Lineage (via Git)
    • Lineage & Impact Analysis (via Erwin/ADS)
    • Data & Metadata Lineage (built-in, pending)
    • Asset Security (via Git)
• Role Based Access Controls (RBAC)
  • AD-compatible IAM (pending)
• Test Data Management (TDM)
  • Goal Setting & Team Building
  • Test Data Needs Assessment
  • Test Data Generation & Provisioning
  • Test Data Sharing & Persistence
• Test Data Generation, for:
  • RDBs via data masking (see SDM above)
  • RDBs via auto-parse/populate/generate
  • RDBs via masked subsets
  • Single files via the job wizard
  • Specific formats or data classes
    • COBOL files
    • Customer (transaction) data
    • Personally Identifiable Information (PII) (fake PII for DevOps)
    • Credit Card Numbers
    • NIDs (US & Korea SSNs, Italy CF, Netherlands BSN)
    • UUIDs/GUIDs
    • Cassandra
    • MongoDB
    • Teradata
  • Weighted distributions
  • Java & Hadoop (API)
    • RowGen ("Outrigger") SDK

Analytics & BI

• Embedded BI
  • see report examples in CoSort manual (SortCL program)
• IoT Edge Aggregation
• Change Data Capture
• Slowly Changing Dimensions
• Predictive Analytics
• Clickstream Analytics
• BIRT integration
• Splunk Integration
  • Voracity add-on for Splunk
  • Voracity app for Splunk (Splunkbase download)
  • Voracity Results into Splunk via Universal Forwarder
• Data Wrangling for Other BI & Analytic Tools
  • for IBM Cognos
  • for Microsoft Power BI
  • for Oracle Visualization Desktop
  • for KNIME
  • for QlikView
  • for R (Revolution Analytics)
  • for SAP Business Objects
  • for Splunk (see above)
  • for Tableau
  • for Tibco Spotfire
• DWDigest (NextCoder cloud dashboard)
• Production Analytic Platform (4-part series)
• Voracity provider for KNIME Analytics / ML / AI in IRI Workbench)
• JupiterOne integration via Kafka (for streaming/sentiment analytics, pending)