I have modified the odbc.ini file in "...instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini" with the following entries and restarted all the services:
Driver = /usr/lib64/libmyodbc5w.so
Description = Connector ODBC 3.51 Driver DSN
SERVER = <server_name>
PORT = 3306
USER = <username>
Password = <password>
Database = <dbname>
OPTION = 3
But still no help. Is there anything else I need to do?
have you tried the creation of DSN in Administrative tools.
Control panel--> Administrative tools--> ODBC --> file dsn (second tab)
use the connection details over ther and try once.
It works in Windows without any problem. Then I took the same rpd and deployed it in linux environment and it's not working. Neither I can Import Metadata because Import Type selected is grayed out with Local Machine option in Administration Tool. I have done all the steps mentioned at the link below to setup the dsn/odbc, etc in linux box.