Archon ETL Training

Smart ETL for Legacy Data Migration 

Course Overview

Archon ETL Training provides an all-in-one solution for simplifying data integration and transformation processes. This course covers powerful tools for automating data migration and archiving, from handling legacy systems to integrating with modern software. With Archon ETL’s Smart ETL™ approach, data extraction, transformation, and movement become efficient and adaptable. You’ll learn how to set up secure, resource-friendly data pipelines tailored to your organization’s needs, whether it’s modernizing data systems, decommissioning outdated platforms, or archiving essential records. This training empowers you to focus on business growth, knowing your data migration processes are seamlessly managed.

Estimated time: 45-50 hours

Course Content

Module 1

Getting Started

Gain foundational knowledge of the Archon Suite, understanding its architecture, workflow, and challenges with legacy data management. Learn how to identify and work with diverse data sources and formats.

Subtopics
  1. Overview of the Archon Suite
  2. Architecture and Workflow Essentials
  3. Challenges with Legacy Data Management
  4. Identifying and Working with Different Data Sources
Module 2

Setup

Learn how to configure the Archon ETL system, set up users and groups, and connect to various data profiles. Understand best practices and configurations for audits, notifications, and task scheduling. 

Subtopics
  1. Configuring the Archon ETL System 
  2. Setting Up Users and Groups 
  3. Personalizing User Preferences and Themes 
  4. Connecting to Source Data Profiles 
  5. Managing Target Data Profiles (Archon Data Store, Postgres) 
  6. Audits and Status Monitoring Essentials 
  7. Handling News, Alerts, and Notifications 
  8. Creating Job Templates and Scheduling Tasks 
Module 3

Workspaces

Explore custom application integrations and data handling through various systems like SharePoint, Lotus Notes, and UniverseDB. Understand the connectivity options with structured and semi-structured data. 

Subtopics
  1. Custom Application Integrations 
  2. Managing File Shares 
  3. Working with Flat Files 
  4. Integrating with Lotus Notes 
  5. Accessing Mobius 
  6. Using SharePoint 
  7. VSAM Data Handling 
  8. Working with UniverseDB 
  9. RDBMS
Module 4

Entities

Understand the concept of entities, their configuration, and management. Explore how each entity can be used flexibly for more modular execution. 

Subtopics
  1. Understanding Metadata Entities
  2. Extraction Entity Configuration
  3. Managing Blob Entities
  4. Chain of Custody Entities
  5. Setting Up Ad-hoc Entities
Module 5

ETL Workflow

Master the ETL workflow by organizing entities, configuring extraction options, and managing reporting and custody chains. Discover how to launch and monitor ETL pipelines effectively.

Subtopics
  1. Defining and Organizing Entities
  2. Conducting Character Analysis
  3. Configuring Extraction and Output Options
  4. Managing Chain of Custody and Reporting
  5. Task Setup and Launching ETL Pipelines
Module 6

Preset Application Workflows

Learn how to integrate Archon with popular business systems like SAP, Dynamics 365, and Temenos T24. Set up workflows and connections to streamline operations.
Subtopics
  1. Integrating with Peoplesoft
  2. JD Edwards Workflow Setup
  3. Oracle EBS Integration
  4. Dynamics 365 Connection
  5. SAP Integration
  6. Working with Temenos T24
Module 7

Migration Workflows

Understand migration entities and automate schema migrations. Learn to load data to target systems, generate detailed reports, and use dashboards for tracking migration progress.
Subtopics
  1. Setting Up Migration Entities
  2. Automating Schema Migrations
  3. Loading Data to Target Systems and Application Binding
  4. Generating Detailed Migration Reports
  5. Utilizing Migration Dashboards for Tracking

Enroll Your Course