Hi everybody,
i have been asked to write a document to explain why should we use Talend rather than PL/SQL scripts to implement ETL processes.
Since i am not that expert with talend yet...can someone suggest, even shortly, a list of advantages using Talend rather tan PL/SQL??
Thank you very much
PL/SQL
- No error/custom/ logging
- Difficult to implement in cross database data transfer
- No support for file systems
- Transformations are difficult
- Bad data logging is not possible
- Third party or integration is not possible
- Rollback on error is not possible
- No tasks could be carried out other than database related tasks
Talend
- Consider all above and lot many other benefits check documentation for more details.
Thanks
Vaibhav
