Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Do I need a ETL?

Tags:

etl

We currently use Datastage ETL to - Export a CSV/text file with data from 15 tables(3 different schemas) on a daily basis.

I am wondering If there is a simpler way to accomplish this with out using an ETL. I tried Scriptella. It looks simple/fast, but it again it is an ETL. Please suggest..

like image 944
pingu Avatar asked Dec 10 '22 10:12

pingu


1 Answers

We use Python. Every programming language -- every single one ever invented -- is an alternative to an ETL.

You never need an ETL.

The questions is these:

  • Which is cheaper to build? Custom software or a configuration of an ETL?

  • Which is cheaper to maintain an operate?

  • Which is easier to adapt to changing requirements?

like image 117
S.Lott Avatar answered Jan 24 '23 00:01

S.Lott