Astera Centerprise

Astera Centerprise

Customer Verified
About TrustRadius Scoring
Score 8.9 out of 100
Astera Centerprise

Overview

Recent Reviews

Invest with Astera it will worth the price

8
November 08, 2021
Astera Centerprise is being used by different organizations here in our company. As a user or developer, it is really helps me to do a …
Read full review

Centerprise-10/10

9
November 08, 2021
We use it in part of our automation process to extract data from PDF's and deliver to our clients. It allows us to utilize time we …
Read full review

Astera Software

9
November 02, 2021
We have used the Astera software package to process existing data for one of the famous clients in Qatar. Several types of file e.g. …

Loving Cenerprise

9
November 01, 2021
We are currently using Centerprise to transform incoming files from vendors. The files are transformed and uploaded into our homegrown …
Read full review

Solid choice for mid-sized organizations

9
May 13, 2020
We use it primarily for publishing to a data warehouse. Another production application creates and exchanges XML files with a federal …
Read full review

Astera: ETL in the cloud

9
May 01, 2020
Astera streamlines our data integration process by doing all the work through a workflow. It enables our analysts to connect to virtually …
Read full review

Astera Review

10
April 30, 2020
It helps us in the massive storage of data and the resolution of intelligence problems of our business. It simplifies complex …
Read full review

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Best of Award, Best Of Customer Support 2021
TrustRadius Award Top Rated 2020

Popular Features

View all 10 features

Simple transformations (25)

8.6
86%

Connect to traditional data sources (25)

8.6
86%

Business rules and workflow (23)

8.4
84%

Complex transformations (23)

7.9
79%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Astera Centerprise, and make your voice heard!

Pricing

View all pricing

Centerprise Enterprise

Contact rep

On Premise
Lifetime License per Seat

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.astera.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

Data Source Connection

7.9
79%

Data Transformations

8.3
83%

Data Modeling

7.5
75%

Data Governance

8.2
82%

Product Details

What is Astera Centerprise?

Astera Centerprise is a complete data integration solution that includes data integration, data transformation, data quality, and data profiling capabilities in a code-free environment, and promises to enable business users to handle data with minimal IT support. Centerprise enables users to exchange data with a wide range of supported applications, databases, and formats.

Astera Centerprise Features

Data Source Connection Features

  • Supported: Connect to traditional data sources

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Data model creation
  • Supported: Business rules and workflow
  • Supported: Testing and debugging

Additional Features

  • Supported: Integrated development environment
  • Supported: Data quality and profiling
  • Supported: Job flow, scheduling, and execution
  • Supported: Extensibility and openness
  • Supported: Performance and scalability
  • Supported: Ease of use for business users

Astera Centerprise Screenshots

Centerprise features a highly intuitive UI that is designed to enable business users to work with data easily.Our ever-expanding library of Centerprise Connectors is preconfigured to provide a plethora of integration options.Centerprise's  data profiling feature ensures that you deliver only quality data to your en users.Choose from a variety of write strategies for your workflows.Easily define how you data moves and behaves with the workflow component

Astera Centerprise Video

Astera Centerprise Integrations

Astera Centerprise Competitors

  • Informatica
  • Adeptia
  • Talend

Astera Centerprise Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)11%
Mid-Size Companies (51-500 employees)47%
Enterprises (more than 500 employees)42%

Astera Centerprise Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported CountriesUSA
Supported LanguagesEnglish

Comparisons

View all alternatives

Frequently Asked Questions

What is Astera Centerprise?

Centerprise Data Integrator is an integration platform that includes tools for data integration, data transformation, data quality, and data profiling.

What is Astera Centerprise's best feature?

Reviewers rate Connect to traditional data sources and Simple transformations and Data model creation highest, with a score of 8.6.

Who uses Astera Centerprise?

The most common users of Astera Centerprise are from Mid-sized Companies (51-1,000 employees) and the Insurance industry.

Reviews and Ratings

 (45)

Ratings

Reviews

(1-25 of 38)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Review Source
You have to pick 2 of 3 - Good, Fast, Cheap - Astera Centerprise is Good and Fast. If you have a smaller team, need low administrative burdens, and need something that doesn't require a big learning effort Astera Centerprise is a fantastic fit for these situations. It's a tool that even non-technical people could use to build ETL pipelines and do so well. If you use a number of disparate data sources, Astera Centerprise shines but holds its own even if you are moving data around like to like or even on the same server with its pushdown capabilities. I think if you had a strong need to have a large group work on your ETL, you could do it with Astera Centerprise, there are source controls available, but they aren't very robust, and keeping track of versions, what's deployed, what's changed is not as tight as it could be.
Score 7 out of 10
Vetted Review
Verified User
Review Source
As a typical ETL tool, Astera Centerprise will perform most core functions. The ability to create a HIPAA 834 file as an established module is a huge benefit. We have yet to integrate with RESTful services but that is something we are looking forward to as a use case for Astera Centerprise.
Score 8 out of 10
Vetted Review
Verified User
Review Source
This software is easy to understand and manage. Each query or transformations are easy to use and manipulate due to the interface of this software, it also includes the explanations of each transformation which help the users to be familiar with. It will benefit the users and the developers of this software. For the users, their manual data entry turns into auto data entry, time consuming turns into just a second or a minute and data quality are accurate. This software is very useful on any data automation, data validation, data manipulation and data integration that is why it is a must application to deal with.
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is well suited for any simple or complicated ETL process. It can pull data from various sources and can send it to multiple destinations. Expressions feature in Astera Centerprise is very helpful for data formatting and implement business rules. Database connections are simple and seamless. Project Build and deploy feature was made very easy to use.
November 04, 2021

Astera Centerprise Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
Suited scenarios: 1) It is really good in integrating the REST APIs 2) Data preview feature is really good which helps in debugging of dataflow easier and faster. Per my knowledge, Astera Centerprise is not very well suited for very large data loads.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Designing and deploying low to medium complexity ETL process are easier to complete as compared to something like SSIS. But, I wouldn't design a full blown enterprise data warehouse with it. I don't think it's up to that level of complexity or performance.
Score 9 out of 10
Vetted Review
Verified User
Review Source
It does not have the horsepower of much more expensive Fortune-200 tools like PowerCenter, Ab Initio, DataStage, and that ilk. And it is much too sophisticated and powerful for a mom/pop shop. Our organization is in the 500-1000 user range, so it's a good fit. It scales to organizations larger than ours—t's a matter of licensing more co-processing threads and having servers to support it. It supports a wide (and gradually growing) range of sources and targets. It's a good choice for combining the data of heterogeneous data sources.
Score 8 out of 10
Vetted Review
Verified User
Review Source
It handles large volumes of data well and has the ability to transform and play with data in ways you wouldn't even deem imaginable or necessary. However, that can sometimes be a bit overwhelming or cumbersome until you get used to the tool. However, compared to other comparable tools, it has a reasonable learning curve and can be picked up by an engineer that is used to handling and manipulating data.
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is a software for the integration and replication of data in real-time in IT environments. The Astera Centerprise suite of products offers high availability, replication, data integration, and ETL process solutions operating in an end-to-end configuration.

April 30, 2020

Astera Review

Score 10 out of 10
Vetted Review
Verified User
Review Source
Astera provides SQL Server integration services to connect SQL Server to different databases, it also allows easy migration to data structures that guarantee data consistency, thus eliminating the risks that can occur when performing this type of operation.
It is a business platform focused on building and executing batch processes and streaming data flows. It can be deployed on premise and in the cloud and is ready to scale comfortably. Astera is divided into several components that can be configured and deployed separately.
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is an enterprise-grade solution that can be quickly deployed on-premises or in the cloud. The ability to containerize the application, along with its compatibility with Linux and Windows machines, makes it a truly platform-independent solution.
Score 9 out of 10
Vetted Review
Verified User
Review Source
The Centprise product is very well suited for business analysts to easily manage and create custom workflows and models to automate complex data integration. The Astera products make extracting data from a PDF a simple and straight forward process, which makes ingestion and integration with other systems a breeze that simplifies workflows and complexity.
April 29, 2020

Worth it!

Amanda Moede | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise is specific to EDI files. From what I've seen it can be used on EDI files across multiple industries. We use it specifically for healthcare EDI files. We do not create any files using this software because we do not have that need at CCHP, but I know the software could be used for that. CCHP uses the software to correct EDI errors and to import EDI data to our SQL data warehouse. EDI files have a layered structure so they need to be broken down in order to be loaded into the data warehouse. Without this tool we would not be able to import the files. Also, with the layered structure, fields, segments, dependencies and hierarchy, making changes manually is both risky and time consuming. Centerprise reduces the amount of time used to correct files and removes the possibility of creating other errors.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Provides a single database schema fully managed by Astera. Simplify the management and integration of data from different sources thanks to the multiple ways it offers to load. Helps ensure data integrity and availability while improving efficiency by eliminating time-consuming tasks.

April 29, 2020

Astera rocks!

Score 10 out of 10
Vetted Review
Reseller
Review Source
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.
April 27, 2020

My Astera experience

Score 9 out of 10
Vetted Review
Verified User
Review Source
If you are working with the large data and try to do validation/transformation, this is good to have. Also, if you do not have a programming or database background, I think you will find this is very easy to use. I think you can use this to do any data validation and massage with it.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Astera Centerprise works well with all kinds of file interactions, with several native connectors, with web services... It has a great benefit of being simple to read and hence for building simple flows and for troubleshooting simple to medium flows, you don't even need someone with deep Centerprise knowledge - many advanced business analysts and consultants should be able to read and act on simple Astera flows, so you don't always need a developer for such tasks.

On the topic of less appropriate usage scenarios - we have seen Astera struggling with vast amounts of data. Also if you have a huge system architecture, there is a good chance that some of the systems will not have any kind of native connectors. When compared to competition, Centerprise is definitely not that rich in terms of native connector collection for different systems. Should you choose Astera Centerprise, for some target systems you might need to opt for workarounds with webservice calls or file exchange to set up your interfaces.
May 24, 2018

Great data tool!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Great for anything with databases. Moving data from one table to another, one database to another you name it. You can even pull data out of text files. Really can be used for big and small projects. I wouldn't use it for things I can do faster in SQL but overall I would use this for almost everything.
Andre Beaumont | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Centerprise Data Integrator is well-suited for creating ETL packages to load a data warehouse. The product makes it easy to insert data in a variety of ways into a SQL table. It can create a new table-structure, append to existing tables, or reload data in any number of ways. If an organization is already highly skilled in SSIS, this may not be the product for you, but if you're just getting started in having a data warehouse as business practice, this may make the implementation faster and easier for your IT team. You may also find that its easy enough to use that you don't need extensive IT training to use it. We've also found that Data Integrator makes a useful bridge between various database applications. We can easily use it to create automated scripts that run, or to transfer data between systems. Without a team of highly trained software developers, some of these options would've been out of reach for us.