I found an excellent article of David Allan explaining how to connect to a mysql database from Oracle Warehouse builder 11G r2.
His solution worked like charm however when I tried to display data out of the imported tables,Owb returned me an error.
When I started to digg deeper and enabled tracing for the owb client I noticed that OWB put double quotes around the query :
Sql Stmt =SELECT * FROM “Address”
mysql didn’t appreciate this. I fixed this by adding following to the connection URL of the location :


after which the error dissappeared and I could see the data in the table

there are more parameters that could be given to the open source jdbc driver i used

Leave a Reply