Astera Centerprise for Every Enterprise
Updated March 29, 2023
Astera Centerprise for Every Enterprise
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Astera Centerprise
We are using Astera Centerprise to build and maintain our DWH solution. Then data is used for various kinds of reporting. This tool is very helpful in the quick development of ETL flows, adding new tables in the DWH, and SCD implementation. Makes operations smooth with scheduling/restart ability, and ease of error handling.
- Easy development of dataflows/workflows
- Scheduling and restart-ability
- SCD Implementation
- Better control/options for the filter in the server monitor panel.
- Improving re-running of the failed job by running only failed/pending jobs in sub-workflows, instead of triggering all the sub-workflows. This might not be as easy to implement as it looks but an area to look into.
- [Push-down mode]: PD mode is very useful and super fast when the source and destination both are in the same database. Performance can be enhanced more by not adding extra subquery ( or the brackets() ) for lookup/insert/update operations
- [Partitioning and parallelism] Diving data into some files and running parallel instances of each component to make run entire flow in a partitioned and parallel manner. This gives a super boost to workflow and huge sized data can be processed quickly.
- creating dataflow/etl flow
- scheduling
- shared components
- Lineage
- This is hard to calculate. but this tool is very easy to use and develop workflows. saves time in the development
Suitable for the environment.
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
Astera Centerprise Feature Ratings
Astera Centerprise Support
Pros | Cons |
---|---|
Quick Resolution Good followup Knowledgeable team Problems get solved Kept well informed No escalation required Support cares about my success Quick Initial Response | None |
Premium support was not required for this environment. Most of the data issues can be temporarily handled by alternate solutions.
Yes - Yes
While working on a data issue for special characters, the Astera team provided an ad-hoc patch of Npgsql specific to our environment issue.