load data from mysql to oracle

Hi eveyone,

I would like to know how i should approach this situation:

I have a mysql database and i have to implement an ORACLE datawarehouse, So i guess i would have to load mysql data to oracle... i have never done this i would like someone to give me suggestions or point me to the right direction please.

Thanks in advance

First of all, if you are working with mysql and oracle there is no point in posting your question in the mssql (aka SQLServer) forum.

You have many options: a batch job to dump data from MySQL to flat file and load it into Oracle through external tables, or an opensource ETL tool like Objectweb's Octopus or OpenDBCopy or Oracle's ability to connect to other dbs with ODBC tutorial about Oracle (Solaris) connecting to MySQL (Linux)

Hi Thanks for your suggestions. would you please tell me which option is better if i am using windows XP and just in case this is relevant , my website is using iis,php 4.3.7 and mysql 4.20

Sorry so this thread was moved to the rigth please or where i should be asking this?
Thanks in advanced

I forgot to say that i am gonna be using the Oracle 9i Warehouse client to build my datawarehouse , I thougth this is important maybe to know the approach i should be taking

Since you'll be using Oracle Warehouse Builder there is no point in investigating options other then setting up a dblink between oracle and mysql.
But I think you should read some of Kimball's writings about datawarehousing and something about Warehouse Builder (http://www.dbazine.com/rittman3.shtml

hi , thanks for your reply. But do u know how to do the dblink you are saying or where i can get an example of how to do this?

Thanks in advanced

Start with Google.

Hi , I found some information about the oracle migration workbench

here: http://www.utexas.edu/its/unix/reference/oracledocs/v92/B10501_01/win.920/a97249.pdf

I just read it works from mysql 3.23 to oracle i9 . mysql server is 4.0.20. Do u know if i would have a problem because it is not exactly the same version as it says there?

well i used the mysql dumpl and changed the syntax a little bit and with the help of a script i found i loaded the data.

Now i have another question:

After build my dataware house i will need to display the content of it in some way. i heard Visual Basic is pritty is for this. but i dont know and i would like someone to tell me if this is truth or if there are a easy way to do it in from php.

Thanks in advanced