Friday, June 4, 2010

connecting to mysql from warehouse builder




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

No comments: