Item: Astera Centerprise
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

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.

Pros and Cons

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.

Most Important Features

creating dataflow/etl flow
scheduling
shared components
Lineage

Return on Investment

This is hard to calculate. but this tool is very easy to use and develop workflows. saves time in the development

Alternatives Considered

Suitable for the environment.

Key Insights

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

Other Software Used

DBeaver, PostgreSQL, Google Cloud Dataflow, Google BigQuery

Likelihood to Recommend

More appropriate - Ease of operations - in terms of scheduling, and re-running, - Ease of development - quick workflow development for simple or semi-complex solutions........ Less appropriate Unix/Linux/AIX-based Integration server installation.

Support Rating

Good support.
Auto Ticket creation.
Tracking all the communication for a given issue.
Good ability in providing alternate solutions or intermediate builds to solve any issue.

Astera Centerprise Customer Support Pros and Cons

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

Astera Centerprise for Every Enterprise

Overall Satisfaction with Astera Centerprise