Home

Jump to bottom

Bas van den Berg edited this page Nov 21, 2018 · 29 revisions

Welcome to BETL Wiki. Here you will find help in

Installing BETL
Getting started
Debugging BETL

and more advanced topics on BETL architecture.

BETL in a nutshell

betl birds eye

All BETL does is generate TSQL statements that transfers data from A to B using a template and configuration.

The BETL database consists of the following:

static tables ( tables that contain data that does not change, except when changing betl internally. Not customer dependent)
Utility functions (util) ( e.g. split function. utility functions have no dependencies at all )
all other tables and procedures live in the dbo schema. dbo tables can contain customer specific data.

We use database schemas to seperate functionality and table prefixes to go one level further:

History table ( hst_ )