Skip to Content

DSN to an Excel file on AIX server

Jan 06, 2017 at 11:00 AM


avatar image
Former Member


We are on BO 4.1 sp6, and the BO server is installed on AIX. I have to create a Universe from Excel file.

How do I check the driver manager on AIX, for creating a DSN to Excel file.

What should be the parameters to be put on odbc.ini file for the dsn, and is there any specific location to put the Excel file?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Stéphane DUPONT Jan 06, 2017 at 11:05 AM


It's Unix, not Windows, you can't connect to Excel.

See for other features unsupported

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Stephane.

The link is really helpful.

Is there any other way to create Universe from excel in my case? Can I load data in a table and transport to some database to use?