Skip to toolbar

Community & Business Groups

ETL Markup Language Community Group

This group is to discuss requirements for an open standard for describing ETL projects, including project structure, sequencing, data flow transformations, data source connectors, for the purpose of transporting ETL projects between commercial and open source ETL tools.

Group's public email, repo and wiki activity over time

Note: Community Groups are proposed and run by the community. Although W3C hosts these conversations, the groups do not necessarily represent the views of the W3C Membership or staff.

ETL standardisations

I thought I would list a few things here in a post that I’ve discovered since proposing the ETL Markup Language group.

Metadata Integration has a product called Metadata Integration Model Bridge (MIMB – http://www.metaintegration.net/Products/MIMB/), which translates between various vendor standards for ETL & BI components.

Common Warehouse Metamodel (CWM – http://www.omg.org/spec/CWM/) allows interchange of metadata information between tools, platforms, and repositories.

Business Intelligene Markup Language (BIML – http://www.varigence.com/Products/Biml/Capabilities) is a markup language covering ETL, schemas, dimensions, reports – but it is currently only compatible with Microsoft products.

Somewhere in between these and other initiatives, there is room for an open ETL standard, and tools to translate between vendor formats and the open standard.