ETL tools for study

[chiennk]

Hi all,

I am now working in a DW project for about 1 year. I use Cognos product 7.3 as DW tool and Oracle 9i as database.

My background is Oracle database designer. I start to learn how to design a start schema for DW, as well as design a ETL process. Because I came from oracle database background so when i come to DW, all the ETL i write in oralce stored procedure (PL/SQL).

I dont know any thing about ETL tool. Could any one suggest any free ETL tool for study purpose. And what is the features of commercial ETL tools such as Datastage, informica? Can these ETL tools integrate with my current ETL in Oracle and speed-up the overrall performance?

 

[johnherman]

As far as I know, there are no free ETL tools. Using PL/SQL or its equivalent for other databases is the only "free" way. I have also used 3GL's like COBOL and VB with embedded SQL calls for ETL.

I would venture to say that every ETL tool on the market will work with Oracle since it would be bad business sense not to work with the most popular database.

There are other threads in this forum which contain links to comparisons of ETL tools. Here's one:

http://www.evaltech.com/tooleval.htm

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[rsomers]

Hi, It is possible to download Oracle Warehouse Builder at the site of oracle. I have no experience with this tool but the download is free.