Reading Excel Files in UNIX Servers
Posted: Tue Apr 02, 2013 12:48 am
Hi,
I've gone through the forum and not found an answer that pertains to our situation.
Our DataStage server sits on a UNIX machine. We are faced with a requirement where we have to read Excel files (.xls/.xlsx) from the server.
I understand that the solution is largely simplified if the server were a Windows server but I am not too sure if there are drivers available for UNIX. If there are, kindly point to a reference on how to install it in the UNIX server.
Also, once installed what is the process of using the ODBC connector to read the files.
Thanks in advance.
I've gone through the forum and not found an answer that pertains to our situation.
Our DataStage server sits on a UNIX machine. We are faced with a requirement where we have to read Excel files (.xls/.xlsx) from the server.
I understand that the solution is largely simplified if the server were a Windows server but I am not too sure if there are drivers available for UNIX. If there are, kindly point to a reference on how to install it in the UNIX server.
Also, once installed what is the process of using the ODBC connector to read the files.
Thanks in advance.