I need to connect MySQL to SAP IQ as remote database and use data from MySQL tables Data to transfer to SAPIQ. I need some help with the connection . Points will be rewarded. Please help.
I had already gon through your link, which was very helpful for me.
I just wanted to check on few things. I am not able to find .odbc.ini file. I have downloaded the MySQL Connector as you had suggested, So I could not modify it to access the MySQL DB.
I apologize, if the question seems naive, but I am new to both MySQL and SAP IQ and in need of desperate help.
You will need to install unixodbc driver also, odbc.ini should be created by unixodbc driver in /etc/
instructions for downloading unixodbc driver are in the SCN doc. Once driver have been installed, Add MySQL server and IQ server entry in the odbc.ini . You can set ODBCHOME and ODBCINI environment variables in IQ.csh /sh and restart IQ server after setting these environment variables.
Set LD_LIBRARY_PATH environment variable to MySQL libraries in IQ.csh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.