Using CloverDX for ETL pupose
What do you like best about the product?
It has very simple graphical user interface which requires minimal coding, using which we can automate most of the process. Reading data from flat files, csvs to database tables. Can transform using the inbuilt transformation component. Can configure the data mapping add data validations using the inbuilt components to make sure all junk data is caught and handled. and can generate output again in a range from flat file to database.
We can also make webservice call which is another added advantage.
Good customer support. Good community to assist with any problems if you are looking for a solution
We can also make webservice call which is another added advantage.
Good customer support. Good community to assist with any problems if you are looking for a solution
What do you dislike about the product?
Little heavy to use, takes some time to load and transfer data from CloverDX server to local server.
have some limited connectivity in terms to connecting to SFTP.
Didnt find anything for encryption and decryption.
have some limited connectivity in terms to connecting to SFTP.
Didnt find anything for encryption and decryption.
What problems is the product solving and how is that benefiting you?
Large data volume transformation, mapping data from different set to different set. Validate the data before transform or load.