"The Mind Makes It Happen..."
Svenska

E-Archiving Smarter, Faster and Better

Introduction

 

The Xtract-ETL architecture is based around the entities 'Extractor' and 'Loader'. Between these stages - conformation, filtration, verification, validation, manipulation, Stylesheets etc. can be applied.

 

Extractors

An Extractor is responsible for extracting or gathering data from a given source.

 

Default Extractors are:

  • SQL Extractor - Extract data from an SQL database. The preferred angle of attack.

    •  

  • File Extractor - Extract information from a file system e.i "Directory" based data storage (Old School)

    •  

  • Excel Extractor - Extract data from an MS Excel file.

    •  

  • CSV Extractor - Extract data from a CVS file (e.i tab,comma,space) separated data in text file.
    This is common in plain database dumps from legacy systems.

    •  

All extracted data will be presented as XML in the XML Text Area. This is the base for all further processes
Xtract-ETL will provide one or more default stylesheet templates in the XSLT Text Area for an initial view. The stylesheets can of course be overridden,changed at the convenience and skill of the user.

There is an option to create a JSON file mirroring the XML file. This option can be useful in further system communication with the archived material.
A simple Notepad is provided for user comments, cut and paste or what ever. This will be saved along with the project itself when saved as a *.atl project. Useful in development stages.

 

Loaders

A Loader is simply responsible for delevering your SIP package to it's target destination (e.i e-archive).

 

Default Loaders are:


  • File System Loader - This 'Loader' is special (and final). It 'loads' the SIP package to disk

     

  • XIA Loader - This Loader loads a SIP package to a XIA service.

    •  

  • REST Loader - This Loader send the SIP package to a user defined REST point (HTTP-POST)

    •  

  • Mail Loader - This Loder mails the SIP package to one or more user defined recipients.

    •  

  • FTP Loader - This Loader upload the SIP package to a user defined FTP or SFTP service.

 

Both Extractors and Loaders has an open Java Interface API and can be implemented by any user with corresponding skill and licensing.