Cloud Data Integration Features

Read what people say are the most valuable features of the solutions they use.
Lyon Lim uses Workato
Co-founder and CEO at a tech company with 11-50 employees
Ease of use: We had a very aggressive timeline to implement, therefore were looking for solutions that required minimal training to learn and use effectively. The trigger/action paradigm is fairly simple to understand. Additionally, the app connectors make it easy to get data from and post data to apps. I did not have to read any API documents or write any code. It was as simple as authorizing access to the app with my username and password. I could quickly build automations for some complex business processes by setting up a trigger event, followed by multiple steps which map to the sequence of logical actions in the business process. Even though I can write code, the recipe framework gave me the power and control I can get with code using an intuitive UI. The recipe also allowed quick iterations and testing to validate. In the end, the recipe reads like a series of simple sentences in English that describe what operations were being executed by the recipe. It was refreshing to see the combination of simplicity and power. Speed and Agility: We evaluated other solutions and services to fit the schedule and budget. However, the other solutions either required an architectural overhaul of our systems, which was expensive and not viable or it was building custom integrations by writing code which would have taken several months. With Workato, we could easily connect to our existing CRM and accounting apps in minutes. The ability to quickly connect to apps, build basic integrations, and validate flows was very empowering for the team. Further, as we iterated on the integrations to implement addition business rules to manage exceptions, the autoversioning in Workato ensured all our changes were tracked and allowed us to revert quickly without losing any work. Extensibility via HTTP connector: Although Workato has prebuilt connectors for 100s of apps, one of the third-party services we planned to use for data cleansing was not supported. This, however, did not block us as we could connect to the third-party APIs using an HTTP connector. It is a nice little feature that makes Workato very extensible and does not confine you to using it only for integrating with apps that have prebuilt connectors. As a business, we get a lot of customer requests to integrate our platform to their applications. Workato allows us to build a connector which allows all our customers to connect to their applications easily. Workflow Automation: Besides basic integration for syncing data across multiple apps, Workato also enabled us to automate workflows that map to business processes. One of the hidden features that we discovered was the ability to automate long running processes that need to wait for human input. For example, adding a note/attachment of agreement to a Salesforce is completed and moves to the next step. This helped us eliminate using emails or verbal conversations to track the attachment updates, thus accelerating the process to close opportunities. View full review »
Ryan X Murray uses Workato
Sports Broadcaster at a media company with 51-200 employees
The ability to integrate systems outside of the IT backlog. View full review »
Evan Hovorka uses SnapLogic
Director - Digital Media and Data Products at a retailer with 10,001+ employees
* Fast deployment * Very flexible integration capabilities * An important tool for building prototypes and MVPs than can seamlessly turn into production jobs * Easy automation of interdependent data workflows View full review »
Markus De Haan uses Mule Anypoint Platform
Self Employed/Independent at a consultancy
MuleSoft offers with the Anypoint Platform a unified platform for API management and an integration Platform as a Service (iPaaS) as well as an on-premise Enterprise Service Bus pattern. The iPaaS and API management are offered on CloudHub, MuleSoft's SaaS offering, and is located on Amazon Web Services. API management and the iPaaS run-time can also be deployed on-premise or in a private cloud. The run-time manager, Anypoint Runtime Manager (ARM), for monitoring and alerting on the run-time is located by default on CloudHub (AWS). 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. The platform support High Availability, High Reliability and High Performance if the required patterns and network topology are followed. The platform offers over 200 standard connectors for applications and technology, such as HTTP(s), databases, SOAP, XML, and REST, as well as premium connectors for SAP, HL7, EDI, etc. Integrations are configured visually by dragging and dropping them on a canvas, but they do sometimes require some coding by Java, .NET or Groovy. The API management, iPaaS and on-premise ESB run-times are based on the same source code and allow an smooth in-time move to iPaaS, if desired, with minimal changes to the existing configuration and code. The recent Q3 2017 'Crowd' release of the platform included the flow designer, a browser based visual zero-code IDE for citizen integrators, and additional functionality for API management. View full review »
Businessc920 uses SnapLogic
Business Systems & Operations Manager at a manufacturing company with 11-50 employees
* 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. * It is extremely easy to connect to various business systems and product integrations rapidly. View full review »
Fai Fu uses Matillion ETL for Redshift
BI Team Lead (Warehouse) at a tech services company with 1,001-5,000 employees
Ease of use and a great way to present the ETL process to non-technical observers. View full review »
Shalindra uses Oracle Integration Cloud Service
Principal, Enterprise Architect at a tech services company with 1,001-5,000 employees
We have a lot of other integration platforms, even provided by Oracle itself. The biggest differentiator is that it is simple to integrate. One is, to access an application, you just go in, click, subscribe and you are ready to build the integration. That's one. The second is when you build the integration, you don't need integration expertise. You definitely do need a certain amount of knowledge on the application side, but that's all. You already have a very rich library of connectors, or what you can call adapters. You just need to configure those connectors. You drag and drop. It's very easy to navigate it. It's self-explanatory; just go and select an object, application or whatever you want to work with, and just click Next, Next, Next. That's all. Then you do the mapping. Mapping is the trickiest part, I would say. You need to know what you need to map to. Mapping takes up the most time. Overall, if you look at the experience, they made it very simple in terms of integration. now ICS brought Recommendation engine that can help customer reducing time and effort in mapping. We do use their own products, which are on-prem, like OSB, the Service Bus, and SOA Suite. The basic differentiation is still there. You need to install, you need to maintain, you need to upgrade, and all those things and upgrade wasn't that simple so far. Just like you talk about upgrading from 11g to 12c, it's a selfless exercise. You have to go through the entire thing in order to manage that. Here, that pain goes away. They upgrade themselves. You do not need to worry. They will make sure it's backward compatible. Nothing will wreck your existing integrations. As far as user friendliness goes, I loved it so far. For whatever application that I'm integrating it with, I would give ICS a rating of 9 or 9.5 out of 10; others don't come close to it. They focused on it being user friendly, and they achieved it. View full review »
Sven Bernhardt uses Oracle Integration Cloud Service
Solution Architect at a tech services company with 201-500 employees
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. The rapidly increasing number of adapters to connect to other cloud-based as well as on-premise applications is also very impressive, in conjunction with the consistent and predictable roadmap as well as the short release cycles (at least on a monthly basis). The platform becomes more and more mature. Through an easy-to-understand and intuitive user interface, the creation of system integrations can be done efficiently. View full review »
Fahd Mirza Chughtai uses Oracle GoldenGate Cloud Service
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
The best feature is a log-based, non-intrusive change data capture from on-premise databases, which is the hallmark of Oracle GoldenGate, and it is time-tested. This is now available as a cloud service, which is great. View full review »
CihanGedik uses Delphix
IT Consultant at a tech services company with 51-200 employees
Storage Saving and fast Provision VDB. View full review »
Sreeni Vasireddy uses Azure BizTalk Services
Chief Technology Officer at a tech services company with 51-200 employees
Some of the valuable features are easy development and testing as well as the low license cost. View full review »
Alexander Novikov uses Zapier
Quality Assurance Chapter Lead at a marketing services firm with 201-500 employees
* Ability to easily connect almost any API to another API. We can get synergy that wasn't available before. * Ability to use logical functions and multi-step algorithms for these connections, thus we can avoid triggering certain processes or workflows when we don't want to. * Customize the web-hook handler which allows us to easily connect our internal applications with all the third-party tools that we use for our business View full review »
Heather Page uses Zapier
Manager, Marketplace Success at a recruiting/HR firm with 11-50 employees
The webhooks allow me to create my own integrations. View full review »
Chris Rosser uses Informatica Cloud Data Integration
Business Analyst/Data Engineer with 51-200 employees
I like the fact that you can find almost any product connection that you need and the list is always expanding. View full review »
Customered3c uses Zapier
Customer Education Manager at a tech vendor with 51-200 employees
We integrate with Zapier, allowing our users to use their services. So, it's important that I am up-to-date on how we can use Zapier to integrate with other platforms. View full review »
reviewer669351 uses Zapier
Energy Consultant / Content Marketing Specialist at a recruiting/HR firm with 11-50 employees
Automatic connections between CRM and the email system is the most valuable feature. View full review »
Joseph Chen uses Zapier
Chief Data Officer at a tech vendor with 51-200 employees
The most valuable aspect of this product is its great number of integrations between the systems. Most of the time, if we want to implement a new system, we can find it associated with Zapier. View full review »
Nathan Goodman uses Zapier
Salesforce Administrator / Salesforce Business Analyst at a tech vendor
I like the ability to connect one system to another, whereas that wasn’t previously possible without a custom integration. View full review »
Nathan Sterner uses Zapier
Growth & Marketing Manager at a transportation company with 11-50 employees
Most valuable is the ability to connect many disparate tools, such as Google Sheets, Trello, Slack, Autopilot, etc. View full review »
Robert-Harris uses Devart
CTO & Developer with self employed
Of the various components that I use in UniDac, I use to just about every aspect of them. I cannot pinpoint any single feature as it would diminish the others. They are all very important, they all work without any issues and because of this are valuable. Probably the most important features of the UniDac components are that they do not contain the 100’s of extra options that would be included within a single component of competitors product, these verbose options serve little purpose to the development team other than tinkering, confusion and nightmares when support issues arise. If you really want to go looking for them, you will find them in UniDac also, but at least at that time you know what you’re looking for rather than just tinkering about setting options for things less experienced developers would understand. View full review »
DellBoom9420 uses Dell Boomi AtomSphere
Dell Boomi Atomsphere, Jitterbit, Lotus Notes Lead / Analyst/ Technical Manager at a tech services company with 51-200 employees
* The best features are that it is a cloud-based and a multi-tenant tool. * The licensing feature is its USP. * Boomi charges are based on the number of connections used, rather than the number of users in a company who use the tool. This cuts down the licensing costs by a great deal. View full review »
ProjectMbc93 uses Informatica Cloud Data Integration
Project Manager Oracle Applications at a tech services company with 5,001-10,000 employees
The most valuable features are: * Data synchronization tasks * Mapping designer tasks * Scheduling View full review »
Brennan Valenzuela uses Zapier
Social Media Program & Live Chat Program Manager at a tech services company with 201-500 employees
The Zendesk, MailChimp, and Formstack integrations are valuable. View full review »
Denis Meyer uses Zapier
Senior Project Manager
I especially use the connection with Salesforce to integrate events from other platforms, such as Acuity Scheduling. Connections are made without code, only by field mapping. View full review »
Alex Shively uses Zapier
Salesforce and Database Coordinator at a real estate/law firm with 11-50 employees
The ability to link Google Sheets to Salesforce is the most valuable feature. View full review »

Sign Up with Email