Clover - the Wonder tool!
Clover has been an absolutely fantastic tool to use! I use it every day and love every minute of it! It has transformed my working life from sheer boredom (doing the same manual processes month after month) to being excited to come into work every day. For the team in the company I work in, it has been utilized to greatly decrease the turnaround time and data quality of the reports that we provide our clients.
- Clover gives you complete control of the data so that you are able to take any data input and turn it into the required data output. It also gives you the ability to validate any data input. Also, its speed of processing from input to output is fantastic. Tasks which once took hours to do now take minutes!
- one thing - it would be good if it could handle more file types such as Word or pdf documents.
Clover is convenient
CloverDX has helped my business run smoothly and keep things organized. I would definitely recommend.
Using CloverDX was super easy once I got it all set up & going. I love how easy it is to customize things like settings, display, accounts, categories, and subcategories. It has definitely made my work life easier.
There should be a tutorial on the initial setup.
I love that I don't need to loop against master records due to data parallelism. We haven't used data services yet, but are excited to use when we have the need for our own APIs.
The product isn't always easy to use because of the items listed in the cons section.
I'd really like to see:
1. The ability to embed dictionary values in SQL components the way you can with parameters
2. Be able to use jobflow components on a CloverDX as well as a server project. A big part of my clover work is the design of moving between jobflows and graphs. I have found developing with a CloverDX project useless because I can only design/code jobflows on a server project.
Data services can be used to create web services
Jobflow components can only be used on server projects
Dictionary values cannot be embedded in SQL statements
Managing meta data within jobflow/graphs can be tedious (as compared to SSIS)
Not much documentation other than Clover documentation (when I Google CloverDX topics)
First time user
This is the first time I have used an ETL tool and having manually coded ETL's in the past, I am impressed by the versatility and scope of CloverDX and in particular the ease of reading and writing data from anywhere to anywhere. It has been a fairly steep learning curve but well worth it and the Clover training course helped immensely in understanding how to understand and leverage the features of the tool. I use Clover daily and would see little point going back to hand coding ETL's
Some of the more complicated components can take a bit of working out how and when to use them. A lot of the functionality requires the server component to be purchased which is an expensive option when only a few of the features would be needed e.g calling a graph as a service.