Adverity vs. Informatica Intelligent Data Management Cloud

If you're a marketing organization that wants to own your data architecture, get away from hours of manual excel work, and build a flexible and scalable BI practice for yourself and your clients, Adverity is your solution. Especially if you don't have a dedicated analytics team or current database solution. If you have access to a wide variety of API's and a fully staffed team to custom develop new connectors in under 30 days for no incremental cost, you're probably best in-housing

Incentivized

Informatica Cloud is an excellent tool for freeing up trapped data in your internal systems and exporting it into a cloud data warehouse or SQL container. Especially if you have any internal SQL query generators that allow you to copy and paste into the Source setup. For example, we use Business Objects internally, and you can build out the query you need inside the firewall with that, then paste it into the query within Informatica Cloud while establishing the Source connection. This way you are not writing all your source parameters by hand, cutting new jobs setup time by 50%. Where Cloud will not suit you well is if you need significant visibility to the health of the system from a tracking, monitoring or error handling standpoint. Cloud will tell you it failed, maybe give you an example error, but has no further troubleshooting or diagnostic assistance to offer.

Incentivized

• Customizable dashboards, that you could change and make unique to your specific need / business.
• Combining a range of data sets into one view.
• Easily sharable insights, that you can share internally or also with clients.

Incentivized

• Informatica Cloud is a great tool for automating data imports. Raw data files can be scheduled to run at designated times, and using pre-built mappings ensures that the data goes into the system accurately each time.
• It is also a great tool for converting raw data into specific formatting. For example, configuring the mapping so that the first letter of a first, middle or last name is always capitalized.
• Additionally, Informatica Cloud has a built-in field-matching tool so that records that already exist are updated rather than having duplicates created.

Incentivized

• Adverity is running into some issues being able to custom-develop API connectors at scale/speed. This is mostly because of their rapid growth and incredible core product. If you need custom development, be prepared to use one of the many easy-to-use workarounds Adverity offers for endpoints they don't have a direct integration with. Don't worry - you'll get your data either way.

Incentivized

• The User Interface can be a bit difficult to get in initial stages.
• Error messages are hard to understand which sometimes takes a lot of time for the resolution
• Cannot Implement complex SQL queries which should be fixed in future release.

Incentivized

Adverity is easy to understand and use, even for users who are less technical. Reports and dashboards are easy to send out, and back-end users can easily navigate workspaces for creating new data fetches.

Incentivized

I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.

Incentivized

Previously I had never really used a tool like this, only using software such as GA to look at any insights and review performance. So I think that the combined view of having all of the data sets (Which in my role I wouldn't always particularly have access to), was really useful. As an individual who was optimising our clients websites it meant that I was really able to prioritise what was important, but also have a great view of absolutely all activity that was happening

Incentivized

Having used SQL Server Integration Services (SSIS) in the past, Informatica Cloud was a huge-step up in functionality, usability and performance. Hands-down, Informatica Cloud is a much more robust product overall. While SSIS is well-suited for specific instances (i.e. SQL Server-specific implementations), Informatica Cloud is a much better product as an overall integration/transformation tool.

Incentivized

• Scale - the biggest advantage has been the ability to extract, transform, and load data for 150+ clients with a three-person team without a software or data engineering team to support. Adverity would easily allow us to scale up to double or triple the client load if needed.
• Templates - Another advantage related to scale, Adverity allows us to run a templated approach to extraction, transformation, and also data visualization and reporting so that onboarding is very fast. Typical clients with up to 15 data sources can be onboarded in as little as a couple of hours.

Incentivized

• A positive impact is bringing more projects.
• Getting data out of various systems such as Salesforce.com or FTP and consolidating it into tables in one central database.
• Having the ability to run data transformation tasks (the equivalent of batch jobs in SF or stored procedures in SQL) on a schedule without consuming those resources on the target or source systems.

Incentivized