TEAM

What is TEAM?

The Taxonomy for ETL Automation Metadata (TEAM) is a management tool for Data Warehouse source-to-target mapping metadata. TEAM intends to support generic generation of data integration and virtualisation code by focusing on minimising the required data entry for source-to-target mappings.

Only what is really required is added, the rest is derived using the convention and architecture that has been configured.

TEAM offers metadata mapping validation, data entry and visualisation. The metadata within TEAM is used to generate data logistics (i.e. ‘ETL’, using Biml, SQL, Python etc.) using the interface / APIs.

  • The TEAM code and content is managed via Github here (public repository).
  • The latest version is v.1.6.7 and can be downloaded from the Github releases section
  • The data model and sample code can be generated and viewed from the software (repository menu).

Installation and configuration

A short introduction video on how to set up TEAM (and also Virtual Data Warehouse) for the first time is available here.

Functionality

  • Metadata management (grid, mapping Source-to-Target Mapping – STM) including exporting to graph model etc.
  • Activation and validation of metadata (checking and pushing into target Data Vault generation data model).
  • Graph based interface using the yWorks interface.
  • Repository creation, including standard interfaces for code generation.
  • End-to-end sample data to generate your own Data Vault based solution.
  • Physical model versioning and reverse-engineering to enable virtualisation.

Resources