Question & Answer
Question
How can we access MS Excel spreadsheet on Information Server on Unix?
Answer
Here are the steps to configure the third party odbc driver - Data Direct SequeLink:
- Contact DataDirect and purchase SequeLink ODBC driver for Excel and SequeLink server for Windows.
- Install Excel drivers and add the lib path to Library path in the dsenv. Also set the SQLNK_ODBC_HOME to same library path.
- Create the Excel DSN in the odbc.ini. Here is an example:
[Excel] Driver=/IBM/ODBCForExcel/ExcelDrivers/6_00_00/lib64/ivslk22.so
Full path Description=DataDirect SequeLink 6.0
Host=999.99.99.99 -- Modify to reflect IP address of SequeLink ODBC Socket Server on Windows
Port=19997 -- Port number where SLSocket60 service is running on ServerDataSource=Default
UseLDAP=0
DistinguishedName=
Encrypted=0
LoadBalancing=0
AlternateServers=
ConnectionRetryCount=0
ConnectionRetryDelay=3
To support international code pages like UTF8 you can set the
IANAAppCodePage=106 (this is for UTF-8)
[ODBC]
IANAAppCodePage=106 -- 106 is for UTF-8 encoding.
InstallDir=/IBM/Infoserver/Server/branded_odbc
Trace=0
TraceDll=/IBM/Infoserver/Server/branded_odbc/lib/odbctrac.so
TraceFile=/tmp/odbctrace.out
UseCursorLib=0
- Next, you need to install SequeLink Server on Windows - sl600socket.zip and select SequeLink 6.0 ODBC Socket servive (enhanced code page support) (for International code page support).
- Once installed, you need to register the service and add Data Source Setting attribute DataSourceSOCODBCConnStr and set to the DSN=Excel (defined on Windows).
- Start service.
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.5;8.1;8.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21441629