Solid choice for mid-sized organizations
May 13, 2020
Solid choice for mid-sized organizations
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Astera Centerprise
We use it primarily for publishing to a data warehouse. Another production application creates and exchanges XML files with a federal regulatory agency, and as a 1-off, we are using Centerprise to validate an Oracle-to-SQLServer migration.
- Of the six mid-tier ETL/DI tools I studied, Centerprise is the most intuitive to use.
- Customer support is email-centric, but nonetheless solid. Astera happily does conference calls when the need arises.
- Wide range of features.
- Expression transformation uses SQL-ish (as opposed to Java-ish or MS-ish) commands. Simple to use, and select/paste helps.
- Love the PowerCenter-style expression transformation.
- Documentation explanations are in video and text format. While most explanations are relatively clear (or even very clear), in my opinion, the documentation is a bit haphazardly-organized. It takes me longer than I'd like to find something, although I usually do.
- Look-ups transformation certainly works, but it could be more robust. (There are ways around that.)
- It's difficult to measure. We had a slower start with it and we are picking up speed. Our best ROI is to come.
From honing the web I made a long-list of about 25 products, leaving off the big (and expensive) 4 as well as clearly inferior products. Then, due to the nature of our organization, I excluded cloud-specific solutions. That got us to about 15. I read reviews and was persuaded to reduce the shortlist to eight, which somewhat unfairly I arbitrarily cut to six because eight was just too much to deep-dive. I took a deep dive including vendor product demo with all six. From that study, two emerged, and I recommended both to my management as excellent choices. My management preferred Centerprise because it is not Java-based, and we are not a Java organization.
Do you think Astera Centerprise delivers good value for the price?
Yes
Are you happy with Astera Centerprise's feature set?
Yes
Did Astera Centerprise live up to sales and marketing promises?
Yes
Did implementation of Astera Centerprise go as expected?
Yes
Would you buy Astera Centerprise again?
Yes