CloverDX vs. SolarWinds Task Factory

CloverDX designer as a standalone is well suited for fairly straightforward transformations of data. If you want to do large scale data integrations, then their server edition adds an extra level of automation and job control.

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

• Connects with Salesforce very well
• The graphical view of the transformations allows for easy creations and maintenance
• Support has always been eager to assist with any graph creation difficulties I run into

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

• The initial learning curve is a little steep. Not very steep or super steep, just a little steep.
• Having enough memory for large multi-step problems can be an issue if the graph isn't designed well.

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

While CloverDX has an active forum for users to submit questions and assist with answers, their in house support team is incredibly responsive when I've contacted them for assistance. This seems almost at odds with most other software companies who try to save money on tech support by promoting a forum or knowledge base.

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

CloverDX was a less expensive alternative to Talend and had a more intuitive interface from what I could see during the evaluation.

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

• Work that use to take multiple people 20 to 30 hours a week to complete each has now been fully automated to where only 1 or 2 hours a week for maintenance is required.

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