18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.7 out of 100
74 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Likelihood to Recommend

Centerprise Data Integrator

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.
Andre Beaumont | TrustRadius Reviewer

Informatica PowerCenter

PowerCenter is well equipped to handle large amounts of data movement in an organization with many disparate sources and a structured development team. It excels in enforcing enterprise development standards through things like metadata manager and the monitoring capabilities (as well as being able to design monitoring rules for everything from naming standards to design practices). It is especially well suited at handling flat-file data in addition to its many connectors and native support for just about any ANSI standard database. For large development teams or the desire to remain flexible at an enterprise scale, Powercenter is a top-tier solution.For small projects or even smaller development teams with mostly a single data source, expect frustration with being able to quickly test a solution as the design flow is very structured. It is also designed in a way that segregation of duties at a very high level can also cause small development teams to be counter-productive. Each step in the design process is a separate application, and although stitched together, is not without its problems. In order to design a simple mapping for example, you would first need a connection established to the source (example, ODBC) and keep in mind that it will automatically name the container according to how you named your connection. You would then open the designer tool, import a connection as a source, optionally check it in, create a target, optionally check it in as well, and design a transformation mapping. In order to test or run it, you will need to open a separate application (Workflow Manager) and create a workflow from your mapping, then create a session for that workflow and a workflow for those one or more sessions at which point you can test it. After running it, in order to observe, you then need to open a separate application (Monitor) to see what it is doing and how well. For a developer coming from something like SSIS, this can be daunting and cumbersome for building a simple POC and trying to test it (although from the inverse, building an enterprise scalable ETL solution from SSIS is its own challenge).
Jody Gitchel | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Centerprise Data Integrator
7.7
Informatica PowerCenter
8.9
Connect to traditional data sources
Centerprise Data Integrator
8.2
Informatica PowerCenter
9.5
Connecto to Big Data and NoSQL
Centerprise Data Integrator
7.3
Informatica PowerCenter
8.3

Data Transformations

Centerprise Data Integrator
8.6
Informatica PowerCenter
8.6
Simple transformations
Centerprise Data Integrator
9.1
Informatica PowerCenter
8.7
Complex transformations
Centerprise Data Integrator
8.2
Informatica PowerCenter
8.6

Data Modeling

Centerprise Data Integrator
7.3
Informatica PowerCenter
8.3
Business rules and workflow
Centerprise Data Integrator
8.1
Informatica PowerCenter
8.5
Collaboration
Centerprise Data Integrator
6.4
Informatica PowerCenter
8.7
Testing and debugging
Centerprise Data Integrator
7.3
Informatica PowerCenter
7.8
Data model creation
Centerprise Data Integrator
Informatica PowerCenter
7.4
Metadata management
Centerprise Data Integrator
Informatica PowerCenter
8.9

Data Governance

Centerprise Data Integrator
8.2
Informatica PowerCenter
8.1
Integration with data quality tools
Centerprise Data Integrator
8.2
Informatica PowerCenter
8.1
Integration with MDM tools
Centerprise Data Integrator
8.2
Informatica PowerCenter
8.1

Pros

Centerprise Data Integrator

  • Allows for integration of custom functions.
  • Allows us to easily migrate data to and from any data source. Our department has become the go-to for automated data extracts.
  • We use emails from jobs we run in Centerprise to ensure all jobs run successfully.
Anonymous | 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

Centerprise Data Integrator

  • Our main concern is backward compatibility with QA testing. We had a few releases of new code, changes or fixed that broke existing code which took us over 90 hours to run thru and refresh all our flows. We like the enhancements, but we don't have time to back thru everything, everytime there is a release to retest and refresh all the Flows. It's not feasible for us.
  • Help documentation. There needs to be a lot more with a lot of examples (so we aren't calling and bugging support all the time). Although, they were extremely helpful, but I'm sure they have other things to do than teach us how to use the product.
  • Pretty much any enhancement we needed at the time (or asked for) was given to us in a pretty timely manner. The Cobol objects were fixed/enhanced. The out variables were added. The only thing we didn't get to use that we asked for was the REST service calls. We had a lot more we wanted to do with the product.
Dawn Bauer | TrustRadius Reviewer

Informatica PowerCenter

  • One of the challenges of PowerCenter is the lack of integration between the components and functionality provided by PowerCenter. PowerCenter consists of multiple components such has the repository service, integration service, metadata service. Considerable time and resources were required to install and configure these components before PowerCenter was available for use.
  • In order to connect to various data sources such as Netezza database or SAS datasets, PowerCenter requires the installation and configuration of separate plug-ins. We spent considerable time trouble-shooting and debugging problems while trying to get the various plug-ins integrated with PowerCenter and get them up and running as described in the documentation.
  • PowerCenter works well with structured data. That is, it is easy to work with input and output data that is pre-defined, fixed, and unchanging. It is much more difficult to work with dynamic data in which new fields are added or removed ad-hoc or if data format changes during the data ingest process. We have not been as successful in using PowerCenter for dynamic data.
  • One of the challenges of learning PowerCenter is that it is difficult to find documentation or publications that help you learn the various details about PowerCenter software. Unlike SAS Institute, Informatica does not publish books about PowerCenter. The documentation available with PowerCenter is sparse; we have learned many aspects of this technology through trial and error.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Centerprise Data Integrator

Centerprise Data Integrator 9.1
Based on 2 answers
Best product I have evaluated. No need to seek alternatives.
Mark Rubin | 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

Centerprise Data Integrator

Centerprise Data Integrator 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.5
Based on 2 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

Centerprise Data Integrator

No score
No answers yet
No answers on this topic

Informatica PowerCenter

Informatica PowerCenter 9.5
Based on 2 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

Centerprise Data Integrator

Centerprise Data Integrator 7.7
Based on 4 answers
The Centerprise support team is extremely knowledgeable about the product and they respond very quickly. Our account manager also has no issue getting involved and helping us follow-up. To me, that is an indicator of great customer service, when an account manager still cares if you are having issues and tries to help you interface with other departments such as billing and tech support.
Anonymous | TrustRadius Reviewer

Informatica PowerCenter

Informatica PowerCenter 8.0
Based on 1 answer
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

Centerprise Data Integrator

Centerprise Data Integrator 9.1
Based on 2 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

Centerprise Data Integrator

Some of the other packages' price was too high for the budget provided for our team which eliminated those. Others had a requirement that they needed to be connected into our network. Because we have so much sensitive information in our network we could not allow them this access and that eliminated them. We had several other trial periods with other packages and they did not have the flexibility of data format input or output. We have used SQL, reports, csv, Excel, COBOL, database, and fixed length sources in conversion in less than 1.5 years. We continue to see ways that Centerprise could have been used and are developing them. The standardization of comparison data out of different reports that have different formats was something we did not think about when we selected this package
Don Smith | 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

Centerprise Data Integrator

  • It's still too early to tell for us because this is a new data warehouse and reporting system, but I expect the difference will be like night and day.
  • Today we face long waits and timeouts just to get some simple data out of our database. Centerprise will make those a thing of the past.
Mario Ferrer | TrustRadius Reviewer

Informatica PowerCenter

  • Positive - Easy to maintain processes built in Informatica Power Center.
  • Positive - Rapidly build and deploy ETL data mappings.
  • Positive - Develop the overall workflow process to run all ETL processes for the project.
  • Negative - Informatica Power Center can be a bit expensive, so your application needs to warrant the enterprise support.
Anonymous | TrustRadius Reviewer

Screenshots

Informatica PowerCenter

Pricing Details

Centerprise Data Integrator

General

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

Centerprise Data Integrator 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

Informatica PowerCenter Editions & Modules

Additional Pricing Details

Rating Summary

Likelihood to Recommend

Centerprise Data Integrator
9.1
Informatica PowerCenter
8.6

Likelihood to Renew

Centerprise Data Integrator
9.1
Informatica PowerCenter
10.0

Usability

Centerprise Data Integrator
8.0
Informatica PowerCenter
9.5

Performance

Centerprise Data Integrator
Informatica PowerCenter
9.5

Support

Centerprise Data Integrator
7.7
Informatica PowerCenter
8.0

Implementation

Centerprise Data Integrator
9.1
Informatica PowerCenter

Add comparison