Top 10 Cloud Data Integration Software Solutions 2022

PeerSpot takes a user-centered approach to creating product comparisons that help IT decision-makers arrive at informed decisions. Instead of relying on the word of the companies that create the technological solutions, they go to the users themselves. Real users offer true feedback without any of the partiality that the solutions’ vendors may have. This is a  place where peers in the tech world unite to help each other choose the products that are most appropriate for their needs. 

PeerSpot’s users have made it easy for decision-makers to choose the Cloud Data Integration Solutions that most fit their business objectives. They have created a ranked list of solutions according to how potentially valuable they feel these products may be to other users. What follows are the top ten ranked products for 2022:   

1. Mule Anypoint Platform

Mule Anypoint Platform has been PeerSpot’s top ranked Cloud Data Integration solution since the beginning of 2021. It is also ranked as the number 1 Business-to-Business Middleware and the number 1 Integration Platform as a Service provider solution. This solution gives users the ability to deal with all sorts of connectivity issues. In addition, users can also manage and create new integrations as they find necessary.

The senior technical architect at a tech services company writes, “Performance-wise also they need to improve a lot. Basically, the number of ports is lacking. When you have ETL kind of transformation, ideally it will be supported, however, we end up using a large number of ports. That will drastically increase the cost to the customer, however. They need to be able to allow for an increase in ports without expanding the price.”

John L., the owner of Skyward Tech, writes “This is a good platform for designing, flowing out APIs, and then doing API-based integrations. It also offers a lot of adapters for commercial products like Salesforce, SAP and the like. It has good monitoring abilities. If you use it for API management, security monitoring and things like that, it works well at the experience API layer.”

2. AWS Glue

AWS Glue is PeerSpot users’ second favorite Cloud Data Integration solution. It makes it easy for users to prepare their data for analysis and eventual storage. The command console allows users to create tasks with only a few clicks. Once you use AWS Glue to catalog your data, you can easily search and extract it. 

Akash S., the team lead at a financial services firm, writes, "Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."

A senior software engineer at a consumer goods company writes,  "The start-up time is really high right now. For instance, when you start up a new job, you have to wait for five or eight minutes before it starts. If the start-up time is reduced to one or two minutes, it will be great. It will be better to have a direct linkage to Redshift in AWS. If we can use data catalogs from Redshift, it will be so easy to create some data catalogs. Currently, we can only use data catalogs from S3."

3. Informatica Cloud Data Integration

Informatica Cloud Data Integration is PeerSpot’s third highest ranked Cloud Data Integration solution. It gives users the ability to easily integrate and move data as their business needs dictate. Users have access to artificial intelligence, which helps to move and integrate large amounts of data across both multi-cloud and on-premises environments. Informatica Cloud Data Integration’s real-time analytics gives users insights which aid them in using their data most effectively.

A senior technical architect at a tech services company writes, “The connectivity and their whole suite are valuable features. Whether we need data cleansing or data mastering, we get it all in one platform. There's no need to test different cloud vendors and then integrate with one solution. Informatica is a one-stop shop.”

A BI Consultant at a computer software company writes, “I would like to see support for more data sources. At this point in time, I'm not sure if they are supporting Microsoft Azure or Google Cloud, but continually adding new data sources is one area that they can improve on.”

4. Denodo

Denodo is PeerSpot’s fourth highest ranked Cloud Data Integration solution. It is an agile and powerful data virtualization solution that offers users a number of advantages. Users can operate it for less than half of what more traditional integration technologies might cost. They can run Denodo across a wide variety of sources and environments. Additionally, the data layer that it can create is unified. This allows it to do everything from data analysis to web integration without requiring users to turn to other products.

An ELT and BI Senior Consultant at a consultancy firm writes,  “This solution is a really good way to get all your sources organized when there are data problems and things are scattered everywhere. You have some flat files, some databases and it's all over the place. This provides one central place for all those connected to carry out governance and build up the views and type of information that need to be extracted. It's like a whiteboard in the sense that it helps you to map things. You can then build on top of it.”

Asil A., the senior BI Developer at a tech vendor, writes, "There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."

5. Equalum

Equalum is PeerSpot’s fifth highest ranked Cloud Data Integration solution. It allows users to simplify the processes by which they create and deploy data pipelines. They can now move data with ease and without having to devote a great deal of time and other resources. It is also fairly simple to maintain, which adds to its value. The user interface requires no coding. Anyone can easily maintain it without needing to have specialized training.

The managing director at a consultancy firm writes, “It's a really powerful platform in terms of the combination of technologies they've developed and integrated together, out-of-the-box. The combination of Kafka and Spark is, we believe, quite unique, combined with CDC capabilities. And then, of course, there are the performance aspects. As an overall package, it's a very powerful data integration, migration, and replication tool."

Shirin K., the database administrator at an energy and utilities company, writes,  "Right now, they have a good notification system, but it is in bulk. For example, if I have five projects running and I put a notification, the notification comes back to me for all five projects. I would like the notification to come back only for one project."

6. Palantir Foundry

Palantir Foundry is PeerSpot’s sixth highest ranked Cloud Data Integration solution. It is ranked number one in four other categories: supply chain analytics, data management, data migration, and top data and analytics service providers solution. Palantir Foundry is a cutting-edge solution that enables users to integrate any type of data at any scale necessary. 

An in-house consulting associate at a pharmaceutical and biotech company writes,  “This solution allows you to do an extensive analysis that cannot be done on a personal computer, or even an on-premises server because of the computational effort that is required. It is enormous.”

Wallace C., the senior director at a tech services company, writes, “The workflow could be improved. Although it works rather seamlessly, the workflow is too complicated sometimes. Maybe they can reduce the complexity of the workflow. It could be more modularized in the future.”

7. Matillion ETL

Matillion ETL is PeerSpot’s seventh highest ranked Cloud Data Integration solution. It is a highly effective solution that is easy to use and allows users to extract and transform data with ease Additionally, it runs 100 times faster than traditional ELT solutions. This increase in speed makes it a very valuable solution.

The managing director at a tech services company writes, "The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."

A data & analytics practitioner at a computer software company writes, "There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."

8. AWS Database Migration Service

AWS Database Migration Service is PeerSpot’s eighth highest ranked Cloud Data Integration solution. It enables users to quickly and securely move their data to Amazon’s Web Service cloud servers. AWS Database Migration Service allows them to move the databases without disrupting their work. Users can also automate certain tasks, which allows them to devote energy to the places that most need it.

Alvaro Q., the senior solutions architect at DBSolution, writes, “The tools are very user-friendly. You can have instances or replications instances from the databases with two or more clicks. The console is also very user-friendly, and it's very easy to create new instances for migration purposes.”

Jayaraj V., data platform architect at S&P Global Market Intelligence, writes, “There's a lot of room for improvement in AWS Database Migration Service, e.g. more endpoints to be supported, more control and transparency on the product and on how we get things done, and better operational support.”

9. SnapLogic

SnapLogic is PeerSpot’s ninth highest ranked Cloud Data Integration solution. It uses artificial intelligence to automate every aspect of data integration. SnapLogic’s intuitive controls enable both tech experts and novices to manage all of their integration needs. Users can deploy it and get to work quickly.

A technical architect at a tech services company writes, “The amount of coding required is very low and the development time is low when designing the pipelines.”

Lazo I., a technical architect at a tech services company, writes,  “The API monitoring could still be improved upon.”

10. Zapier

Zapier is PeerSpot’s tenth highest ranked Cloud Data Integration solution. It is a web-based- application integration solution designed specifically for non-technically inclined users. The fact that anyone can use this solution makes it valuable. 

A Technical Content Writer at a computer software company writes, “Its integration capabilities and the kind of automation it provides to the user are fantastic. It has integration with lots and lots of tools.” 

Sarthak S., a salesforce developer at a tech services company, writes,"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."