A great vendor to manage an ELT stack
Use Cases and Deployment Scope
Used to ETL data from various data sources into our data warehouse. Data sources include internally built systems on cloud software, as well as third party vendors (such as a contact center, marketing CMS systems, ad spend data, etc.) Alooma allows management of all these data sources as well as transformation in order to manage the data warehouse schema.
Pros
- Transformation of data before entering the data warehouse -- allows for a consistent/understandable schema for analytics teams.
- Adding of additional data sources: Alooma has a large library of pre-built, common 3rd party vendors for which data is often needed to be ETL-ed.
Cons
- More tools on managing the data warehouse itself. Although great on the ingest and transformation of data, more help provided by the tool on managing the outputs would be welcome.
- Increase possibilities in the transformation step, rather than single event transformations.
Likelihood to Recommend
Very appropriate for managing an ELT stack -- Alooma handles the 'E' and 'L' pieces very well. Due to the way transformation is setup, it is more on the lightweight side of things and thus works for this kind of stack. For more traditional ETL stacks, Alooma would probably not be the right fit.
