We haved moved to https://github.com/basvdberg/BETL

What is BETL

What is BETL NOT

Current Status

Strong elements of BETL are:

How it works


The goal of BETL is making the life of ETL developers easier.
Its a collection of BI best practices which are invoked using the BETL command language.

Suppose we want to move data from A to B. (where A and B are tables or views in a RDBMS)

What we need is the following:
-connection to A (e.g. by using a linked server using an OLEDB driver)
-connection to B
-Some meta data about the transfer that cannot be derived from the source (like transfer type, which columns form a natural key). transfer type tells us which ETL template should be chosen for transfering A to B. the natural keys tells us which columns can be used for change detection.

All we need to do is run this TSQL command:

exec betl.push ‘A’

BETL uses extensive logging, so you can see what happens. Debugging is also easy. Just switch on the debugmode and invoke this command in management studio. You will get de TSQL that will be executed.

Read more on best practices here http://www.biblog.nl/category/bi-design-patterns/

Continue with our installation manual or tutorial here https://betl.codeplex.com/documentation