How do cloud data integration tools help enterprise tech professionals?
In the review excerpts below, IT Central Station users share how their companies have benefited from their cloud data integration software, and describe how their pain points have been solved.
Informatica Cloud Data Integration
Nick Joseph, Solution Architect at a tech vendor with 201-500 employees, writes about Informatica’s “Mapping Designer” feature:
“The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations.
The designer allows for the creation of mappings to be leveraged as templates. Within the templates, parameters can be set up that serve as variables for deployment to mapping configuration tasks.
Mapping Configuration Tasks, MCTs, are specific uses of a mapping to fit a situation or set of circumstances.”
A Senior Manager of Global Business Services at a tech services company with 501-1,000 employees suggests how Informatica Cloud Data Integration could improve further:
“Informatica goes down for maintenance quite a lot due to the upgrades. They also need to improve their security. As an administrator, I could very easily make connections to other people's machines through their agent without their knowledge.”
Dell Boomi AtomSphere
A Technical Manager at a tech services company with 51-200 employees shares how his company benefits from Dell Boomi:
“We are a consulting firm that works closely with Dell Boomi. Since we have started using this product, we have added multiple clients. Many clients are moving away from the traditional integration tools to cloud-based integration tools. Dell Boomi is a leading iPaaS tool."
Andy Katherman, Supervisor, Application Development & Integration at RSM US LLP, shares the challenges he’s had with Dell Boomi:
“The scripting capabilities are lacking, in my opinion, based on the user experience. There is not much tooling assistance. There are no “helpers” or examples on how to do more advanced post/pre-processing of data.”
John Gaughan, Director Technology Services, Retail Direct & Ecommerce at a Consumer Goods with 501-1,000 employees, describes what he likes most about 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.”
Tugçe Yilmaz, CRM Administrator at a media company with 51-200 employees, describes how Jitterbit could improve:
“Sometimes we experience disconnections and I have to close all Jitterbit programs. I have to hit the ‘Jitterbit Cloud Data Loader Start Services’ button to reopen and reconnect to the Salesforce organization. This issue can be fixed.”
Alexander Novikov, Quality Assurance Chapter Lead at a marketing services firm with 201-500 employees, shares how Zapier has helped his company:
“One of the basic examples can be automation that we use to onboard our customers and handover from sales to the account management team. When a sales manager moves his or her deal to the "setup" stage in the CRM system with Zapier, we send notifications to responsible account managers on Slack.
If certain crucial information was omitted in a deal, another Zapier automation will send a pre-filled Google form to the sales manager with a request to fill the gaps. When it is done, the account manager gets a nice and shiny handover form and is able to act in a timely manner. Moreover, a respective account is automatically created for the new customer in our ERP system, thus saving the account manager's time.”
Lieven Oosterlinck, Technical Marketing Manager at a tech vendor with 51-200 employees, suggests what could be improved in Zapier:
“In the past three years, I've seen Zapier improve a lot in the user interface and in the amount of possible integrations.
I would like to have more integration with lesser known, local tools. Zapier serves all widely used global apps, but not all well-known local applications.”
Oracle Integration Cloud Service
Sven Bernhardt, Solution Architect at a tech services company with 501-1,000 employees, shares what has been most useful to him in Oracle Integration Cloud Service:
“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.”
Phil Wilkins, Enterprise Integration Architect at a retailer with 1,001-5,000 employees, suggests enhancements be made to some of the adapters:
“Some of the adapters could be enhanced to make integration even simpler.
The example I would use is the Gmail interface - it requires Base64 encoded content. But to make the interface simpler, the API should provide the encoding and the adapter simply accept plain text.”
Read more cloud data integration reviews on IT Central Station.