Hi all,
We are considering using ETL for a new project we plan.
I'm currently trying to understand what I can (or can't) do with Clover.
I've gone over most of the documentation and played with the GUI a bit too.
I still have a few questions I hope someone can help with.
We plan to provide to our customers a predefined job which will be built from these steps:
1. Read data from Excel file in known format.
2. transformations
3. Load the data to MySQL
It is required that customers will be able to customize/extend our tool by writing their own readers/tranformations.
They might have input files with slightly different formats, it might have different columns or will require preliminary transformation etc.
My question is can I give them this ability with Clover?
Do they need to write Java for that? can they do this with any scriptng languages or just by mapping XML?
Thanks a lot,
Anat
We are considering using ETL for a new project we plan.
I'm currently trying to understand what I can (or can't) do with Clover.
I've gone over most of the documentation and played with the GUI a bit too.
I still have a few questions I hope someone can help with.
We plan to provide to our customers a predefined job which will be built from these steps:
1. Read data from Excel file in known format.
2. transformations
3. Load the data to MySQL
It is required that customers will be able to customize/extend our tool by writing their own readers/tranformations.
They might have input files with slightly different formats, it might have different columns or will require preliminary transformation etc.
My question is can I give them this ability with Clover?
Do they need to write Java for that? can they do this with any scriptng languages or just by mapping XML?
Thanks a lot,
Anat
-
Anat,
thank you for your interest in the first place.
If you played with the Clover.GUI you already know that all of the above is achievable by drag-n-dropping the components and mostly configuring their predefined properties in GUI. For complex expression there is a possibility to use Clover's custom CTL script-like language. Java/XML coding is therefore not necessary and in your case not even wanted.
In case your customer insists on modifying transformations on their own I very much suggest they attend at least the basic clover.GUI training. That will make them comfortable with the basic use of Clover and prevent them from doing elementary errors.
Hope this helps. Please feel free to post more questions/direct me if I got your question wrong.
Michal
Please sign in to leave a comment.
Comments 1