Adverity vs. SolarWinds Task Factory

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

Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time.

Incentivized

• User-friendly report setup and ingestion
• Easy integration with multiple data endpoints, making it easy for users to drive value
• Incredible customer support, allowing users (regardless of technical background) to act like power-users

Incentivized

• The Slowly Changing Dimension Component saves us a huge amount if time compared to the native SSIS component.
• JSON Transform is really useful to convert record and send it to rest API.
• The advanced derived columns allow us to use really cool functions that are not available in the regular transforms.

Incentivized

• I think it would have been more user friendly if there was more labelling capabilities, so that when you are sharing the dashboard they would explain what the data is - rather than depending on someone knowing how to use the dashboards or being there to explain it.
• Our teams found that some of the scheduling functionality could be a little big buggy, so this was something that needed extra care and attention, so therefore may be an area that needs to be improved (unless it was just our account and usage).

Incentivized

• It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress.
• Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions.
• Occasional random failures observed with the Filter tranform.

Incentivized

Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business

Incentivized

Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get

Incentivized

Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues.

Incentivized

Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us.

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

I've not found too many tools to bolt onto SSIS that encompass what you get with Task Factory. I have used some Enterprise ETL tools like Dell's Boomi, but did not find it to be very intuitive. Task Factory does not leave you guessing how to use its components. Additionally, their support is very responsive and helpful.

Incentivized

• This tool has allowed us to be able to see areas for opportunities, when all of the data has been combined
• We were also able to better prioritise actions and where to focus our attention, when we had one view where all of the data was together. This allowed us to deliver better results for our clients, and also have a clearer roadmap of activity

Incentivized

• We were able to support our developers with Task Factory features and reduce the development time by 40%.
• Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward.

Incentivized