Top Cloud Data Integration Software 2017


Top Cloud Data Integration Software Reviews

What do users look for when choosing cloud data integration software?

In his article on TechTarget, Serdar Yegulalp points out that the process of integrating on-premise data with data hosted natively on the cloud can prove to be a daunting task. He writes, “The data you have “out there” and the data you have “in here” aren’t just stored in different places; they may be subject to completely different data-integrity rules, and may not be easily reconciled into a single stream without major heavy lifting.”

Due to this concern, investing in cloud data integration software is crucial for any enterprise. A cloud data integration solution configures both cloud and on-premise data successfully, providing centralized monitoring, as well as multiple levels of security and transparency to accommodate all solutions.

There are many cloud data integration software vendors to choose from, including Informatica, Dell, Jitterbit, Zapier and others. Yet while there is a wide range of solutions to choose from, IT professionals have significantly more information to sift through and decisions to make when selecting the right tool for their company.

To make this decision process a bit easier, a good way to begin looking into cloud data integration software is by researching which tools are recommended by other users.

Keep reading to find out which cloud data integration software solutions are favorites in the IT Central Station user community, and what users say to watch out for during the research process.

Informatica Cloud Data Integration

Ranked #1 with an 8.0 rating

The Pros

Data replication and data sync

Hardik Patel, Informatica Lead - Architect at a pharma/biotech company, describes the benefits of Informatica’s data replication and data sync capabilities:

“I particularly value data replication and data sync jobs. Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job. I also appreciate the flexibility of the reset target option to reflect the source object structural changes to be implemented on the target database table side. This is awesome.”

Flexibility

Director777c, Director at a tech vendor, highlights Informatica’s flexibility as particularly valuable:

“With recent versions of cloud-based products in use for all applications, it provides flexibility in integrating the different applications. With AWS S3 and Informatica, integration is flexible and loosely coupled.”

Room for Improvement

For Nick Joseph, Solution Architect at a software R&D company, he sees room for improvement with their UI:

“There are a small number of UI bugs that occur on occasion. In several browsers, such as Chrome, elements of the UI can disappear when navigating through steps in any of the integration tasks' wizards. Additionally, on data synchronization tasks, the source fields in a mapping can disappear altogether as well.”

Dell Boomi AtomSphere

Ranked #2 with an 8.2 rating

The Pros

Easy workflow creation

Kevin Osborn, a System Analyst / Programmer at a logistics company, highlights how Dell Boomi makes it easier to create workflows:

“It is easy to create workflows from one system to another, drawing on multiple systems at the same time. For example:

  • Creating a process from EDI transmissions to WMS

  • Creating marriages of data from multiple systems (time clock/payroll/HR/WMS/financial) to create reports

  • Taking information from one system to update it to another system (legacy EDI to WMS, payroll to financial, time clock to payroll, WMS to Legacy)”

Great ESB alternative

Aman Sinha, an Enterprise Integration Specialist at a tech services company, points out that Dell Boomi is a great alternative to enterprise service bus solutions in the market:

“I have worked with ESBs, such as MuleSoft. However, based on the usage and the end-user requests, we moved to Dell Boomi. It is mainly a carrier and it provides an integration platform as a service. This, in itself, provides the solution for an easy and mature way to communicate.”

Room for Improvement

Andy Katherman, Supervisor of Application Development & Integration at RSM US LLP, notes some issues he has had with custom scripting:

“Since the application is Java-based, custom scripting within the map data, used to transform shapes to handle more complex process, is lacking in some ways. There is no validation in the mapping profile custom scripting, such as IntelliSense or advanced error checking. If one wants to do custom scripts within a map shape, they must have knowledge of Groovy or JavaScript. Only Groovy has the ability to use Java-based libraries.”

Jitterbit

Ranked #3 with a 8.5 rating

The Pros

User-friendly UI

Tugçe Yilmaz, a CRM Administrator at a media company, highlights Jitterbit’s user-friendly UI as one of its many valuable features:

“We use this product on a daily basis and rely on it for inserting, updating, and deleting critical records in our organization. Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features. We are extremely satisfied with this product.”

Maps data quickly

In his review, John Gaughan, Director of Technology Services, Retail Direct & Ecommerce at a consumer goods company, points out how quickly he and his team can map data with Jitterbit:

“Jitterbit provides the ability to quickly map data between files and databases. Because it is done without much coding, it can be done quickly with a small team and maintained more easily. We continue to find more and more ways to leverage the tool. With it, we are able to pull orders from eBay using an API without formal in-house expertise.”

Room for Improvement

For John Gregory, VP of Business Technology at a tech services company, Jitterbit can benefit from more dedicated cloud services:

“I would like the ability to offer a dedicated cloud version for security. Some of our customers are uncomfortable allowing their data to go to the cloud unless there is a dedicated service just for them in which their data is never co-mingled.”

Zapier

Ranked #4 with an 8.5 rating

The Pros

Integration capabilities

Heather Page, a Manager of Marketplace Success at a recruiting/HR firm, describes how Zapier’s ability to integrate with other tools has impacted her company:

“It allowed us to create integrations between our own proprietary operations tool, and a variety of other tools like Salesforce, Slack, and HubSpot. Zapier, combined with MailParser, is an essential element of our back-end operations. It allows us to maintain dynamic datasets about customers and sales without a ton of overhead.”

Better transparency

Rowena Bolo, a Digital Marketer at a tech services company, writes how Zapier has improved transparency among team members:

“As a SaaS business, client onboarding is a crucial part of our workflow. Zapier makes it a lot easier for us to create sales (Pipedrive) to CRM (Autopilot) integrations, as well as setting up the necessary push notifications (Slack), so all team members get constant updates about what’s happening. This allows the team to be more transparent and accountable as everyone knows who’s doing what and everyone is on the same page.”

Room for Improvement

Yago Casasnovas, Head of Customer Relationship & Operations - Digital Division at a leisure / travel company, suggests where Zapier can improve:

“I would expect to see more Zapier-own-built apps that provide business rule capabilities. The current apps are basically acting as an interface. It would be interesting to be able to create business rules within the Zap, connecting to databases and such.”

SnapLogic

Rated #5 with an 8.0 rating

The Pros

Faster Connections

For Evan Hovorka, Director of Digital Media and Data Products at a retailer, SnapLogic provides faster connections to partners and data sources:

“My teams can connect to new partners and data sources in hours, not days. We complete more work and integrate faster, allowing us to prove ROI quicker on new ideas.”

Simpler Integrations

Businessc920, a Business Systems & Operations Manager at a manufacturing company, points out how SnapLogic allows for simpler integrations:

“It makes creating complicated integrations that would normally be scripted, easy to digest, design, and understand. By using snaps instead of functions in code, you can see the building blocks of the integration visually. This helps a lot.”

Room for Improvement

He also points out that the solution could improve by including more canned integrations:

“The product can include more canned integrations that can be used. In the field of integration apps, I see a spectrum of apps where one side is point-and-click with zero technical ability needed, and the other side is a platform where you basically write code. SnapLogic sits somewhere in the middle. It doesn’t offer enough easy canned integrations for its users like some of the easier to use integration apps.”

E2E Bridge

Ranked #6 with a 9.0 rating

The Pros

Fast implementation

ErpFactoa9a0, an ERP Factory Services PI Head at a pharma/biotech company, writes that E2E Bridge allows for fast implementations of otherwise complex integrations:

“UML and integration work hand in hand. It allows for fast implementation of complex integration logic.”  

Graphical interface

Mark De Rond, an ESB/ABAP developer at a retailer, highlights how E2E Bridge allows you to build a model with a graphical interface:

“What I like about the Bridge is the way that you build your model with a graphical interface using UML. This model is then compiled into Java code and deployed onto the bridge server. You don't see the code. Apart from some scripting, there is no coding.”

Room for Improvement

He also suggests improvements that E2E Bridge can make to their server console:

“An area of improvement is the stopping and starting of services from the Bridge server console. The only way to test services on the Bridge is to have them scheduled so that they run at a specific moment in time. It is, at this time, not possible to trigger this by hand from the console. It is possible to trigger it via the analyze tool, which is used to trace the service. It would be nice to have a simple way to test services without having to schedule them.”

Mule Anypoint Platform

Ranked #7 with an 8.0 rating

The Pros

API management

Markus De Haan, an Independent Advice on Strategic Technologies professional at a consultancy, describes Mule Anypoint’s mature API management capabilities:

“The API management capabilities are very mature and allow an organization to re-use microservices. It enables efficient self-service for connecting (external) API consumers through Anypoint Exchange. The API Manager includes out-of-the-box policies that can be used for rate limiting, throttling, and security.”

Room for Improvement

He also points out the room for improvement that he sees in Mule’s release calendar:

“MuleSoft's release calendar is rather conventional with two major, two minor releases and hotfixes in between. The competition sometimes offer more rapid release cycles and provides improved and new functionality with a faster time-to-market.”

IBM App Connect

Ranked #8 with a 7.3 rating

The Pros

Graphical developer interface

SystemEnfb41, a System Engineer at a financial services firm, writes how IBM App Connect’s graphical developer interface impacts his company:

“Because it has a graphical developer interface, we can quickly develop solutions that are connecting to anything on the cloud, without having to build those connectors ourselves.”

Zero to minimal coding

For SrIntConsultant578, a Senior Integration Consultant at a tech services company, IBM App Connect’s value lies with the fact that they require zero to minimal coding for integrations:

“The product is a very simple integration tool with zero or minimal coding effort required. Our organization deals with multiple systems and we want the data to be available 24/7 across all the systems. IBM App Connect has a robust mechanism to handle such scenarios.”

Room for Improvement

Deb Weller, a Development Manager of IT Business Applications at a tech vendor, highlights a need for greater orchestration capabilities:

“I would like the ability for more than one developer to work on the same project (source control/branch merge). If the project has more than one orchestration, you should be able to have different people working on each.”

Oracle Integration Cloud Service

Ranked #9 with a 6.8 rating

The Pros

Easy creation of SOAP and REST endpoints

Phil Wilkins, an Enterprise Integration Architect at a consultancy, writes about how easy it is to create SOAP and REST endpoints with Oracle Integration Cloud Service:

“The simplicity and ease of creating SOAP and REST endpoints and integrating with them. New features are being added regularly to make it a significant integration platform.”

On-premise agent

For Sven Bernhardt, Solution Architect at a tech services company, one of Oracle Integration Cloud Service’s most valuable features is its on-premise agent:

“One of the most important features -- and, of course, the key differentiator -- is the newly-introduced on-premise agent, which allows users to connect Oracle ICS to their on-premise applications without opening application-specific ports in a company's firewall.”

Room for Improvement

Shalindra, an Enterprise Architect at a tech services company, describes where she sees room for improvement in the solution:

“There are certain functionalities which at this moment ICS doesn't cover, such as B2B integration. ICS doesn't cover B2B, but Oracle has SOA CS, which is, in my opinion, nothing but a SOA Suite in a cloud environment. It's the same product. We can use that product to do the B2B. ICS in particular doesn't cover that.”

Matillion ETL for Redshift

Ranked #10 with a 9.3 rating

The Pros

Pipeline UI

Richard Williams, Senior Engineer, Big Data/Data-Warehousing at a manufacturing company, points out Matillion’s pipeline UI as a valuable feature:

“The pipeline UI provides a means to present solutions to analysts and non-tech management for review and agreement. Compared to the likes of traditional ETL’s, like Informatica, SnapLogic, and Talend, or even raw Python scripts, this product needs no improvement, as it is so much better.”

Room for Improvement

BITeamLeeb12, a BI Team Lead (Warehouse) at a tech services company, suggests the following as a way Matillion can improve in future iterations:

“It would be great to have the ability to move windows around to dock in different locations/external windows. This would involve an ability to physically pin, or move the windows within Matillion (for Redshift). I know that they can be resized to some extent – but it would be great to collapse the windows, or move them -- similar to moving a tab from a browser so that it's separate from the main GUI.”

Read more cloud data integration reviews on IT Central Station.



Related Categories: Cloud Data Integration

0 Comments

Guest

Sign Up with Email