Java Batch Job Vs ETL Tools (Extract, Transform, Load)

Recently I got a work to transfer data from database A to database B for 5 tables.

After quick research, decided to write in Java. Used simple JDBC calls and completed the work in 42 hours.
During this transfer there are few conditions, we need to check to update other tables too.

Conclusion:
1. No cost on ETL tools.
2. Easy to mange through Crontab in Linux.
3. As a Java developer I have complete control on my Code.

For bigger jobs, definitely we need ETL tools.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s