I want to read excel file to insert Oracle DB.I know On windows system I should ODBC data server using Microsoft exel driver.But On linux server How can I do that?
I have read and downloaded this document.
and this one ODI reading Excel via ODBC on Linux
Bu Maybe it can be problem that copy JDBC excel jar file to agent file in linux server odi.(in odiexpert.com.it is written so)
İs there any solution read excel file on linux server?
Can anyone help me?
There is no other way as this is a os specific issue. Better you go for JDBC drivers processing excel file like Dev has developed or some other vendors are selling it.
Another option could be create one agent in the windows system where you are getting excel files and process them using that agent.