What users are saying about
75 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100
77 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

Dell Boomi

Dell Boomi is well suited for integrating between ERP systems, especially Netsuite, SAP, Salesforce. Built in access to platform API, Auth to API, access to data or triggers/actions, etc. speeds delivery. There are many connectors available making this process faster. It is best suited to an organization that needs to rapidly roll out new integrations or changes on a regular basis. It's less well suited when larges amounts of data need to be processed very quickly in a parallel method. It's possible to handle things in parallel, but because of the workflow connectors and design process you are much more likely to build something that is handling one record at a time sequentially instead of building a process that is processing hundreds of records simultaneously for real time processing. It's also less well suited where complex code is the common path for integration as it does not connect to source control and common software development processes for managing code/test/deploy. (Those things can be used, but it requires additional effort to manage.)
Anonymous | 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

Cloud Data Integration

Dell Boomi
8.2
Informatica PowerCenter
Pre-built connectors
Dell Boomi
9.0
Informatica PowerCenter
Connector modification
Dell Boomi
7.7
Informatica PowerCenter
Support for real-time and batch integration
Dell Boomi
9.1
Informatica PowerCenter
Data quality services
Dell Boomi
8.4
Informatica PowerCenter
Data security features
Dell Boomi
7.4
Informatica PowerCenter
Monitoring console
Dell Boomi
7.3
Informatica PowerCenter

Data Source Connection

Dell Boomi
Informatica PowerCenter
8.8
Connect to traditional data sources
Dell Boomi
Informatica PowerCenter
9.4
Connecto to Big Data and NoSQL
Dell Boomi
Informatica PowerCenter
8.1

Data Transformations

Dell Boomi
Informatica PowerCenter
8.6
Simple transformations
Dell Boomi
Informatica PowerCenter
8.7
Complex transformations
Dell Boomi
Informatica PowerCenter
8.4

Data Modeling

Dell Boomi
Informatica PowerCenter
8.4
Data model creation
Dell Boomi
Informatica PowerCenter
7.5
Metadata management
Dell Boomi
Informatica PowerCenter
9.1
Business rules and workflow
Dell Boomi
Informatica PowerCenter
8.8
Collaboration
Dell Boomi
Informatica PowerCenter
8.6
Testing and debugging
Dell Boomi
Informatica PowerCenter
7.9

Data Governance

Dell Boomi
Informatica PowerCenter
8.2
Integration with data quality tools
Dell Boomi
Informatica PowerCenter
8.1
Integration with MDM tools
Dell Boomi
Informatica PowerCenter
8.3

Pros

Dell Boomi

  • Pre-built connectors to almost anything which greatly reduce time to release of your integration needs.
  • Easy to use development platform with drag&drop features. Non-technical people could build simple integration processes in no time.
  • Great user community where you can get quick help if needed. Boomi people hang around there a lot.
Cristian Bodnarasec | 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

Dell Boomi

  • The dashboards are limited
  • Running Low latency improves performance but makes resolving issues very difficult
  • Unable to sign up for alerts for one process only. Alerts go out at an account level. If you want to get notifications for a process you need to build it into your application.
  • The folder structure of components can get messy if not well governed.
  • Easy to create duplicate components and not realizing that someone else in your company already created one.
  • Scripting could be improved. You don't know if you have errors in your code until you run the process.
Adam White | 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

Dell Boomi

Dell Boomi 10.0
Based on 9 answers
Dell Boomi has provided us with the ability to connect our campus together using our various existing platforms. There are many supported features and have yet to run into something that we cannot do. Its user interface is very intuitive which would allow users to begin developing fairly easily. There is a myriad of resources available
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

Dell Boomi

Dell Boomi 8.7
Based on 5 answers
My IT and Finance teams have noted that setting up the tool is a breeze. Dell Boomi has never caused an issue during a system implementation that I am aware of. We are pleased with the tool and recommend others consider it.
Anonymous | 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

Dell Boomi

Dell Boomi 8.3
Based on 6 answers
The atom sphere takes a time to load, when I open a process or when I open a log. One more slow processing is when I import objects from NetSuite.
About the performance of processing, it looks like Boomi takes a time to initialize some things such as connectors before starting the process. This is also performance we have.
Phi Hoang | TrustRadius Reviewer

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 Rating

Dell Boomi

Dell Boomi 6.0
Based on 2 answers
Boomi support was responsive and knowledgable, however being a closed cloud service, it doesn't have good community support. We found the learning curve to be steep and there aren't avenues like google, forums, or blogs that provide community driven insight into the product or how to go about designing solutions using the tool
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

Alternatives Considered

Dell Boomi

Our team has used Actian DataConnect since the Mid 1990's. It was formerly known as Data Junction and then Pervasive Data Integrator. We looked at Boomi as an additional tool to aid in our Integrations. We did compare it to Informatica and thought it was a better fit for our customers.

We have been using Boomi and doing great. I like the way we can break down data into small units of work. It simplifies how to handle multi-conditional pathing and the unit of work level.

Currently, I am working at SFCG, using various tools to build integrations into Oracle CX products. When we started kicking the tires on Boomi and in the training and development since that time, I've tried a series of processes out that have given me trouble in other tools. Below is a brief recap of my experience and growing admiration for the way in which this tool has made my job easier.

My first goal with using Boomi was to connect to an instance of CRM On-Demand (a task that can on other platforms be a time-consuming endeavor). What I found was a useful wizard, pictured below, with a series of pop-up steps to follow.
In other tools, I have spent more time in trying to define the schemas, than actually completing the maps that use them. Boomi reduced that time from my process. This is one small example of many demonstrating how my teammates and I feel as if we were working in black and white and are now working in color with Boomi AtomSphere. Tasks I've taken for granted are complex, time-consuming and meticulous are simplified, streamlined and transformed with powerful features like Boomi Suggest - a handy feature that leverages the collective intelligence of the Boomi community to suggest which fields should be mapped in a Data Map.

You don't need to take my word for it, another member of our team, Li Mo started building out an integration to Oracle Sales Cloud, using the SOAP API Connector. He was able to do a complete integration to insert a record into the Account entity, and it took about an hour and a half.

Note: it had been about 1 month since we both actually took the training courses. I believe we choose an additional tool that plays to the inner strengths of working in the cloud, and I can not wait until I start full blown to continue development on new integration projects using Dell Boomi AtomSphere.

Recommendations to other buyers: Try it to see if it fits your needs.
David Byrd | 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

Dell Boomi

  • It has allowed us to scale significantly without having to add headcount, specifically those geared towards data entry. We went from a $10m ARR business to $200m ARR business with the same amount of Order Processors and 12x amount of transactions by leveraging Boomi to perform a lot of the work, and then having the Order Processing team to simply review that the transaction was processed successfully.
Jake J. Darley | 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

Pricing Details

Dell Boomi

General

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

Informatica PowerCenter

General

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

Rating Summary

Likelihood to Recommend

Dell Boomi
8.5
Informatica PowerCenter
8.6

Likelihood to Renew

Dell Boomi
10.0
Informatica PowerCenter
10.0

Usability

Dell Boomi
8.7
Informatica PowerCenter
9.5

Performance

Dell Boomi
8.3
Informatica PowerCenter
9.5

Support Rating

Dell Boomi
6.0
Informatica PowerCenter
8.0

Add comparison