Item: Astera Centerprise
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

We leverage the tool to perform ETL (Extraction, Transforming and Loading) of new customer data into our application's database. The problem it solved is providing the visibility to issues with moving the data from a legacy system database into our system. Plus, we can reuse the projects when implementing future customers from the same legacy system. Having this feature tremendously reduces the time and technical skills required to move the data.

Pros and Cons

Option to copy an entire project to reuse it for similar but new situations
Option to "write SQL" when it really is simply easier
Ability to Preview the data before actually pushing it
Ability to implement rules or honor database-level rules
Ability to quickly get exports of data snippets for 3rd party review of the data

The ability to use AI to "connect" the data through
The ability to have teams working on the same project at the same time
Having more "undo" options

Most Important Features

Visual flows
Option to work in SQL
Preview before pushing the Go button

Return on Investment

We needed to invest a lot of time upfront to create the first several projects plus the learning curve.
Once we were able to reuse a previously created project, we were able to complete a data conversion in 5 to 30% of the original time before using Centerprise.
Onboarding a new data specialist with pre-existing projects went tremendously better than simply teaching them "manual" methods of data transfer

Alternatives Considered

Oracle GoldenGate

GoldenGate is not really designed for "interactive reusasbility" situations. Centerprise is perfect for the concept of reusing previous work for new projects! Plus, the cost difference is so huge!

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

Microsoft SQL Server

Likelihood to Recommend

It absolutely will shine in areas where it is connecting the same systems together all the time. It will be a huge asset where people do not need to modify the flows very often, but when you do, it provides a lot of insight into any changes that will occur before actually moving any physical data. Some areas that it struggles, and this is the case for most ETL software, is when the source or destination changes or the requirements of the data change, it requires human intervention, which can lead to creating unexpected results.

A back office gem whose power is in the simplicity

Overall Satisfaction with Astera Centerprise