Dell Boomi : Review

We tried implementing some scenarios on Dell Boomi. We were looking for a replacement for Informatica, a tool which would not only be cost effective but would also perform up-to expectations.Dell Boomi follows a different approach to play with data.Following are the pros and cons of the same.

Pros:

1. Cloud based architecture : Atoms (analogous can be installed on the local machines) which co-ordinates with the atom on the main cloud and runs the processes.

2. Connector Cost- The basic model is very cheap and it increases with the kind of connectors you would add. i.e. if you are very specific with salesforce integration then you need to buy the salesforce connector only.

3.Seamless integration across various sources
4. Dedicated online community
5. Good introductory videos on youtube. : http://www.youtube.com/user/boomitraining

Cons:

1. Not a very impressive look and feel.

2. Limited transformations in the expression 

3. Difficult to implement heterogeneous joins.

4. Boomi Suggest: All processes/mappings made on Boomi are saved in the main server.If a similar mapping is made by a third party, Boomi will suggest the developer the mapping architecture based on the mappings stored in the server. This might have intellectual property constraints. Using Boomi Suggest is optional, however if we are not allowing Boomi to include our processes in Boomi suggest , it does not allow us to refer the same as well.

Summary:  I was impressed with Dell Boomi, as it approaches data integration from a new perspective. The Document cache transformation is one of it’s kind, and many features similar to it’s thick client cousins like Informatica , make it an interesting tool to explore. Although it is not recommended to implement a full fledged DWH, it could target the Small and Medium Business (SMBs) who would want to enjoy the benefits of data integration at low costs.

Market Competitors: Snaplogic, Cast Iron