Companies today need a powerful yet flexible data access solution to extract, aggregate, transform and load across multiple disparate data sources from databases, applications, as well as office documents. With business users quickly becoming more technically savvy, the data access bottleneck can be eliminated with an easy-to-use data extraction and transformation tool like Elixir Repertoire for Data ETL.
Which features does Elixir Repertoire for Data ETL support?
If you want to know how Elixir Repertoire for Data ETL scores on different evaluation election criteria and exactly which features and functions it provides. We did all the work for you. Suppliers will often tell you only the strengths of their product(s). In our vendor neutral survey, all the features are revealed, including the weak points. Why buy our 100% independent study?
[wp-review]
Information from the vendor
Debugging
- Can the procedures be run step by step? Yes
- Can the procedures be run row by row? Yes, by using a Top/Bottom N extractor.
- Can breakpoints be built into either a process or a row? Not relevant, because every procedure can run step by step at any point.
- Is it possible to define software watchpoints? Yes, by using a DataDrop processor.
- Is it possible to find and highlight any errors in the code with one mouse click? Yes, a console is provided for easy viewing of errors.
Screenshot
Functionality
- Can a data-source be read once and written to two or more different target tables/databases? Yes, by using DataDrop operator.
- As above, but then conditional on a field value e.g. Revenue > 1000 write to table 1 otherwise write to table 2 Yes, by using Subflow
- Can the rows from two different tables with the same structure be written to one table? Yes, by using to do split Concat operator.
- Is it possible to write non-normalized data structured in columns to rows? Yes, by using Invert Data operator.
- Is it possible to write non-normalized data structured in rows to columns? Yes, by using Invert Data operator.
- Is it possible to load a full table in memory and run queries on it (without joining)? Yes, with Data Cache
- Are key lookups reusable across different processes, i.e. The table is loaded once and is reusable Yes, with Data Cache
- Are slowly changing dimensions supported (hm = by hand; wizard = wizard; auto = out-of-the-box) Yes, Out-of-the-box
- Is there an ability to schedule jobs based on interdependencies? Yes, by factoring in the interdependencies in the data transforming design.
- Can the route taken by following jobs be based on errors detected in the preceding job? Yes, using OnError task in Job Scheduler.
- Is impact analysis possible for a proposed change to the database? Partial, by reading in the repository as a data source to examine dependencies. A full metadata tool is planned for further.
- Is it possible to trace the source of an attribute/data element quickly? (reversed impact analysis) Partial, by reading in the repository as a data source to examine dependencies. A full metadata tool is planned for further.
- Is it possible to publish/document a given process/transformation and navigate through it with a browser or word processor? Partial, by reading in the repository as a data source to examine dependencies and publish as a report output. A full metadata tool is planned for further.
- Is it possible to use the results of a data mining process within a given load process? Yes, through Ant Task to trigger external process before reading in the results. This is also support for ARFF, a data mining format.
- Is it possible to call analytical functions e.g. forecasting, basket analysis, regression from within the load process? Yes, through Ant Task to trigger external process before reading in the results. This is also support for ARFF, a data mining format.
Source: elixirtech.com.
Their BI product is better than the ETL product
Rick van der Linden, senior analyst and author of the ETL Tools & Data Integration Survey said about Elixir Repertoire for Data ETL: “The ETL part of a Business Intelligence Suite, not expensive but the Business Intelligence tools are probably richer in functionality than the ETL product.” Find out more and order now the ETL Tools & Data Integration Survey 2018.
100% vendor independent research
In the ETL Tools & Data Integration Survey 2018 you’ll find a professional comparison of ETL tools in the market, including for each ETL solution an expert review, many comparison graphs and a comparison matrix. And a thorough 100% vendor independent evaluation of Elixir Repertoire for Data ETL and all the major ETL solutions with all their features.
