Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

suggestion of free ETL tool

ravi29Nov 1 2021 — edited Nov 1 2021

Hi All,
We have the website.
We are doing below work:
fetching the data files from ftp server.
Doing some checking(logical, Business rules, data type) on files.
loading the data into tables with the help of sql loader, procedures, packages etc.
During loading we are doing some transformation also in procedures, packages.
After loading sending mails to users if it is successful and if its failed we are sending failure messages also.
That is the basic work all we are doing through shell scripts.
My question is Can We use ETL tool to do all this work. Also Can any free tool available in market to do these tasks.
Thanks in Advance.

Comments
Post Details
Added on Nov 1 2021
0 comments
291 views