Boomi vs. Informatica Cloud Data Integration vs. Toad Data Point

Legacy systems often need to be replaced or integrated with new applications in order to modernize businesses. A strong API strategy that avoids custom coding and third-party programs is essential to enable this integration. Boomi's new-age connectivity and integration solutions ensure safe, secure, and robust integration. In the age of information, businesses are under more pressure than ever to be able to collect and manage large amounts of data. This data comes in from a variety of sources, including personalized devices such as voice assistants and wearable tech. While this data can be immensely valuable to businesses, they often lack the infrastructure necessary to handle it effectively. This can lead to data build-up in databases or silos, and can eventually lead to problems with integration and security.

We use it a lot for importing data. We transform the incoming data to match the formatting of our CRM. We also match on existing records to avoid creating duplicates. Informatica handles all of this exceptionally well. Our users are system administrators. The tool is not well-suited for users who do not have a technical background

Incentivized

Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.

Incentivized

• 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.

Incentivized

• Data synchronisation
• Data replication
• Data integration

• Export data into excel.
• Export data into excel using a pivot table functionality.
• Navigation between windows is intuitive and easy to understand.
• Good for SQL novices and experts alike.

Incentivized

• More from a development perspective. It is always difficult to use the properties features. It takes a while to understand how the data/variables can be used across an integration.
• Dell Boomi should also invest more on API Management and not just seen as a ETL,ESB tool.
• Should roll out features more often based on users reviews.

Incentivized

• There is a moderately steep learning curve
• Has some idiosyncrasies
• Can be finicky with date formats

Incentivized

• The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now.
• Would be nice if the 'Automate' feature was a bit easier to use.
• Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release).
• Would be nice if there were fewer releases.

Incentivized

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

Incentivized

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.

Incentivized

There is a learning curve with Informatica. It is not always intuitive to use. It is best suited for technical users such as system administrators

Incentivized

I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap

Incentivized

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.

Incentivized

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

Incentivized

We decided to go with Dell Boomi because another department in our company was already using the software. We did not research competitor applications to use as our business solution. Dell Boomi was very easy and quick to set up, so once we decided to use Dell Boomi for systems integration, we had it set up and running within a few working days.

Incentivized

It is really easy to comply and understand its features.

Although Toad and UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.

Incentivized

• 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.

Incentivized

• Really greatest than any other conventional application.

• It is the least common denominator - not particularly optimized for our environment or workflows.
• Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
• Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
• It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.

Incentivized