Summary
OBIEE 11 : Configure MySQL JDBC datasource
Content
Hello,
In BI Publisher ( OBIEE 11.1.1.7 ) , we need to configure Datasource JDBC MySQL:
We configure it in Administration tab :
Driver Type : com.mysql.jdbc.Driver
Connection String : jdbc:mysql://[host]:[port]/[database]
I test a connection, it’s established successfully. But when a create a new data set (SQL Query) in Data Model
Select *
From table1
It failed with error message : Failed to load SQL. With Mysql Client, it’s work fine. Maybe we need to add a library
I need your help to fix this please ;-)
Regards
Djam
