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 :
jdbc:mysql://10.1.1.100/mysql_db?capitalizeTypeNames=FALSE&sessionVariables=sql_mode=ANSI_QUOTES
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
