Astera rocks!
April 29, 2020

Astera rocks!

Munshi Alam | TrustRadius Reviewer
Score 10 out of 10
Vetted Review

Overall Satisfaction with Astera Centerprise

We are using it in Data Migration project to move data from legacy applications to state of the art applications. It is being used by projects under the Data Migration programs. Being used to migrate HR data, CRM data, ERP data, etc.
Data Sources: Oracle DB, SQL Server DB, XML, CSV.
Targets: Oracle DB, XML
  • Very simple installation and configuration.
  • Easy to learn.
  • User Interface (UI) is very intuitive.
  • Simple licensing.
  • Expert product support services.
  • Performance with large dataset (50 million+ rows) can cause some issues. But there are ways to work around that.
  • Generating XML using CSV source - adding additional header elements in the XML was not available in the product. Needed to do some post processing. Should be included in the product feature.
  • Data Accuracy - 38 decimal places (i.e NUMBER data type in Oracle type) not supported by Astera in the version we used. Newer version may have addressed this issue
  • Needs more pre-built connectors for well-known cloud apps (Dynamics, SFDC etc.).
  • Short learning curve for any ETL developer.
  • Easier licensing for various modules.
  • Shorter development cycle.
  • Some performance issue with large datasets (e.g. 50million+ rows).
SSIS and Informatica.
Very prompt, pro-active, 24/7 support.

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

Small to Medium size companies, or even large companies (with not large volume of data, e.g. 50 million+ rows in data transformation) can very well use this tool. For any traditional batch ETL, Astera is the best (I have used SSIS, Informatica as well).

However, Astera may not best suited for real-time, API-based integration. One can make it work (it has REST/SOAP client), but it may not be as good as Mulesoft, etc.

Astera Centerprise Feature Ratings

Connect to traditional data sources
10
Simple transformations
10
Complex transformations
9
Data model creation
9
Business rules and workflow
9
Testing and debugging
8