Oracle PL/SQL versus a commercial ETL tool

When implementing a data warehousing environment in a company, a question needs to be asked: whether to use already owned tools and technologies or buy a new, commercial ETL product. Having in mind the fact, that most big companies use an Oracle database, the question becomes: use PL/SQL to do the processing or buy an ETL tool?.
Before making a decision on that, the managers need to compare pro’s and con’s of buying a commercial ETL solution.

Strengths and weaknesses of using Oracle PL/SQL as an ETL tool

The conclusion is - there is no easy answer to the question which approach is better. The most important thing is to review the company’s needs, calculate costs, estimate results and then make a choice between buying an ETL tool or using a PL/SQL processing.

  • Oracle Business Intelligence - read more about Oracle products in the Data Warehousing area