What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
44 Ratings

Astera Centerprise

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100
85 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Feature Set Ratings

  • Astera Centerprise ranks higher in 1 feature set: Data Source Connection
  • Informatica PowerCenter ranks higher in 3 feature sets: Data Transformations, Data Modeling, Data Governance

Data Source Connection

7.9

Astera Centerprise

79%
7.5

Informatica PowerCenter

75%
Astera Centerprise ranks higher in 1/2 features

Connect to traditional data sources

8.6
86%
25 Ratings
9.0
90%
18 Ratings

Connecto to Big Data and NoSQL

7.3
73%
1 Rating
5.9
59%
14 Ratings

Data Transformations

8.3

Astera Centerprise

83%
8.5

Informatica PowerCenter

85%
Astera Centerprise ranks higher in 1/2 features

Simple transformations

8.6
86%
25 Ratings
9.2
92%
18 Ratings

Complex transformations

7.9
79%
23 Ratings
7.8
78%
18 Ratings

Data Modeling

7.5

Astera Centerprise

75%
8.4

Informatica PowerCenter

84%
Informatica PowerCenter ranks higher in 6/6 features

Data model creation

8.6
86%
15 Ratings
8.8
88%
15 Ratings

Business rules and workflow

8.4
84%
23 Ratings
9.0
90%
18 Ratings

Collaboration

6.4
64%
1 Rating
8.8
88%
16 Ratings

Testing and debugging

6.7
67%
21 Ratings
8.8
88%
17 Ratings

Metadata management

N/A
0 Ratings
7.2
72%
16 Ratings

feature 1

N/A
0 Ratings
8.0
80%
2 Ratings

Data Governance

8.2

Astera Centerprise

82%
9.0

Informatica PowerCenter

90%
Informatica PowerCenter ranks higher in 2/2 features

Integration with data quality tools

8.2
82%
1 Rating
9.0
90%
15 Ratings

Integration with MDM tools

8.2
82%
1 Rating
9.0
90%
13 Ratings

Attribute Ratings

  • Informatica PowerCenter is rated higher in 4 areas: Likelihood to Recommend, Likelihood to Renew, Usability, Support Rating

Likelihood to Recommend

8.1

Astera Centerprise

81%
38 Ratings
9.1

Informatica PowerCenter

91%
21 Ratings

Likelihood to Renew

8.2

Astera Centerprise

82%
3 Ratings
10.0

Informatica PowerCenter

100%
4 Ratings

Usability

8.0

Astera Centerprise

80%
5 Ratings
9.0

Informatica PowerCenter

90%
3 Ratings

Performance

Astera Centerprise

N/A
0 Ratings
9.4

Informatica PowerCenter

94%
4 Ratings

Support Rating

8.4

Astera Centerprise

84%
21 Ratings
8.9

Informatica PowerCenter

89%
3 Ratings

Implementation Rating

9.1

Astera Centerprise

91%
6 Ratings

Informatica PowerCenter

N/A
0 Ratings

Likelihood to Recommend

Astera Centerprise

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.
RAHUL SINGHAL | TrustRadius Reviewer

Informatica PowerCenter

Informatica Powercenter is the centerpiece of our overall enterprise data warehouse strategy. It's a critical enablement to ensure we can feed in multiple data stream and transform them into digestible data within our data warehouse. With its flexible capabilities and API availability, we were able to feed in industry standard data format as well as home grown data structure. Overall, we are very pleased with their capability and contribution to our data warehouse strategy.
Anonymous | TrustRadius Reviewer

Pros

Astera Centerprise

  • Astera's customer service and help team are quick to respond and have always found solutions to my questions or problems. They also follow up after completing a support request to make sure everything was working correctly. If it's not something the current version allows, as far as functionality, they develop a solution for the next version because they assume if one company has that need that others will as well.
  • I've never lost touch with our sales representative. She checks in at least twice a year, if not more, to make sure that we are happy with their product and to see if we need anything. I've rarely needed anything, but when I did she made sure to have the correct person contact me regarding what I asked for and she followed up to make sure the request was resolved.
  • EDI is a very complex language and making any changes can cause errors in other areas that you aren't aware of. Astera Centerprise creates an environment that is much easier to understand than looking at a raw data file. The functionality allows us to make changes to each transaction within a file in under a minute with no errors created. Making these changes before we had Astera Centerprise took a week for one file. We can now get to more files to create clean data for the state and have reached 97% acceptance.
  • Centerprise's functionality can be applied at any level. It can be a broad change to an entire segment, or it can be a single digit that is changed. You can program the system to look for specific items within a file and change only the records that need to be changed. It can sequence items, it can remove items and it can add items when specifically programmed to. And if you run into a wall creating the program, Astera's help desk will help you get past it. And the program language used is easy to understand as well. If you understand functions in Microsoft Excel or SQL statements, you will be able to use this product.
Amanda Moede | TrustRadius Reviewer

Informatica PowerCenter

  • Informatica has a wide range of support for databases. Pretty much every mainstream DBMS is compatible here.
  • Designing ETL mappings and workflows is a very intuitive process, and takes minimal learning time and effort even for a beginner.
  • Informatica's biggest strength is its sheer performance. It is unmatched in terms of handling large volumes of data.
Anonymous | TrustRadius Reviewer

Cons

Astera Centerprise

  • We had some issues in getting the software running with their licensing model on our Citrix Desktop. They were very helpful in working with us on this issue.
  • With any product that creates SQL code in the background, I am skeptical of how optimized that will be for our specific environment. We have not yet had problems related to this, but customers may want to monitor closely.
  • They do not yet seem to have a large customer base and robust user community.
Andre Beaumont | TrustRadius Reviewer

Informatica PowerCenter

  • There are too many ways to perform the same or similar functions which in turn makes it challenging to trace what a workflow is doing and at which point (ex. sessions can be designed as static or re-usable and the override can occur at the session or workflow, or both which can be counter productive and confusing when troubleshooting).
  • The power in structured design is a double edged sword. Simple tasks for a POC can become cumbersome. Ex. if you want to move some data to test a process, you first have to create your sources by importing them which means an ODBC connection or similar will need to be configured, you in turn have to develop your targets and all of the essential building blocks before being able to begin actual development. While I am on sources and targets, I think of a table definition as just that and find it counter intuitive to have to design a table as both a source and target and manage them as different objects. It would be more intuitive to have a table definition and its source/target properties defined by where you drag and drop it in the mapping.
  • There are no checkpoints or data viewer type functions without designing an entire mapping and workflow. If you would like to simply run a job up to a point and check the throughput, an entire mapping needs to be completed and you would workaround this by creating a flat file target.
Jody Gitchel | TrustRadius Reviewer

Pricing Details

Astera Centerprise

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No

Starting Price

$0 Lifetime License per Seat

Astera Centerprise Editions & Modules

Edition
Centerprise EnterpriseContact rep1
  1. Lifetime License per Seat
Additional Pricing Details
Discounts are provided for 10 pack, 20 pack, 50 pack, and enterprise wide Centerprise Professional licenses.

Informatica PowerCenter

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Starting Price

Informatica PowerCenter Editions & Modules

Additional Pricing Details

Likelihood to Renew

Astera Centerprise

Astera Centerprise 8.2
Based on 3 answers
We renew yearly, it is a core part of our department's functionality.
Anonymous | TrustRadius Reviewer

Informatica PowerCenter

Informatica PowerCenter 10.0
Based on 4 answers
Our team enjoys using Informatica and feels that it is one of the best ETL tools on the market.
Robert Goodman | TrustRadius Reviewer

Usability

Astera Centerprise

Astera Centerprise 8.0
Based on 5 answers
It's very intuitive and visually descriptive. The interface is standard windows drag and drop although cut and paste are not universally available depending upon what function you're trying to do. You see the ETL and what it's doing. You can inspect the data elements the transformations and perform data previews incrementally along the data flow. You actually SEE what the results are and you can make adjustments without black box testing
Phil Nacamuli | TrustRadius Reviewer

Informatica PowerCenter

Informatica PowerCenter 9.0
Based on 3 answers
Positives;- Multi User Development Environment- Speed of transformation- Seamless integration between other Informatica products.Negatives;- There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center.- Oracle Analytical functions should be natively used.- E-LT support as well as ETL support.
Gurcan Orhan | TrustRadius Reviewer

Performance

Astera Centerprise

No score
No answers yet
No answers on this topic

Informatica PowerCenter

Informatica PowerCenter 9.4
Based on 4 answers
PowerCenter is robust and fast, and it does a great job meeting all the needs, not just the most commercially vocal needs. In the hands of an expert power user, you can accomplish almost anything with your data. It is not for new users or intermittent users-- for that the Cloud version is a better fit. Be prepared for costly connectors (priced differently for each source or destination you are working with), and just be planful of your projects so you are not paying for connectors you no longer need or want
Anonymous | TrustRadius Reviewer

Support Rating

Astera Centerprise

Astera Centerprise 8.4
Based on 21 answers
The customer support at Astera is amazing. The support team is always friendly, quick to respond, and very knowledgeable of the product and features. Mike O'Quinn went above and beyond and provided great technical assistance when we migrated to a new version of Centerprise. Munira Lalani was also very helpful in answering any licensing and product questions our team encountered.
Jeffrey Wilson | TrustRadius Reviewer

Informatica PowerCenter

Informatica PowerCenter 8.9
Based on 3 answers
Informatica power center is a leader of the pack of ETL tools and has some great abilities that make it stand out from other ETL tools. It has been a great partner to its clients over a long time so it's definitely dependable. With all the great things about Informatica, it has a bit of tech burden that should be addressed to make it more nimble, reduce the learning curve for new developers, provide better connectivity with visualization tools.
Anonymous | TrustRadius Reviewer

Implementation Rating

Astera Centerprise

Astera Centerprise 9.1
Based on 6 answers
Extremely fast implementation. From install to completed data flows in under a day.
Mark Rubin | TrustRadius Reviewer

Informatica PowerCenter

No score
No answers yet
No answers on this topic

Alternatives Considered

Astera Centerprise

After the purchase of the new company, we were required to go with their software choices until after TSA. The ETL product they had in use was Informatica. I'm sure Informatica has some great benefits for huge companies, but I am having a hard time adjusting to their style. Centerprise has Dataflows (Informatica has Mappings). You can run a Dataflow all by itself (Informatica you cannot run a Mapping by itself therefore requiring a workflow to run which doubles up your objects and maintenance). With Centerprise you can preview your data in every object in the Dataflow saving development time (with Informatica you cannot). Centerprise has a very nice scheduler to use (An Informatica consultant suggested not using the scheduler in Informatica because it wasn't very good thus, requiring a 3rd party purchase | we are using JAMS). Centerprise is a stand-alone product (Informatica had to be put on an Unix Box--thus requiring unix knowledge). Centerprise can pass variables quick easily between Flows (Informatica has to read parameter files from a stored/LAN location). Both products have the exact same project set up for the Government file transmissions: Centerprise had a total of 112 objects (DataFlows and Workflows). Informatica has 651. The once nice thing about Informatica is that you can call unix jobs to run (not sure if this was available in Centerprise)
Dawn Bauer | TrustRadius Reviewer

Informatica PowerCenter

PowerCenter is the industry leader when it comes to interfacing with multiple source and target systems. The graphical interface increases employee productivity while reducing human resource expenditures and training requirements. These other tools offer some similar capabilities, but lack the range and depth when compared with the PowerCenter platform.
Brian Randolph | TrustRadius Reviewer

Return on Investment

Astera Centerprise

  • We have seen that the use of this package saved us 2 hours per conversion but now since the templates are already developed it is saving us more. This reduces our lead time for conversions, and increases our efficiencies as a conversion team.
  • We have four licenses and in one conversion this year it allowed us to do a conversion that would not have been done. This conversion generated more than enough money to cover the cost of these four licenses for the entire year. The customer is ecstatic about the information that we were able to pull out of their reports and most of all the upper management of our company had their socks shocked off of them. Since the supplier of the software for this customer would not provide data to us for a conversion our upper management was going to cancel the sale to this customer, unless the customer was going to build our system from scratch. We were able to provide nearly a complete accounting and payroll conversion to this customer all from the data on their reports thanks to centerprise.
Don Smith | TrustRadius Reviewer

Informatica PowerCenter

  • The data pipeline automation capability of Informatica means that few resources are needed to pre-process the data that ultimately resides in a Data Warehouse. Once a workflow is implemented, manual intervention is not needed.
  • PowerCenter did require more resources and time for installation and configuration than was expected/planned for.
  • The lack of or minimal support of unstructured data means that newer sources of dynamic/changing data cannot be easily processed/transformed through PowerCenter workflows.
Anonymous | TrustRadius Reviewer

Screenshots

Add comparison