I'm having issues connecting to MySQL server through rpd. When I try to Import Metadata, Import Type option is set to Local Machine and is grayed out and therefore, Remote Server option is not available.
I have OBIEE 11g 184.108.40.206 running on Linux box and have already installed the ODBC Driver from http://dev.mysql.com/downloads/connector/odbc/%23downloads
I've also made changes to odbc.ini file at ...instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup
Can someone please help?
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.