Skip to Content
0

IDT ODBC connection to EXcel

Oct 20, 2016 at 11:39 AM

110

avatar image
Former Member

We have set up a DSN on the BO server to connect to a spreadsheet which is stored on the server , the connection uses Excel version 12 . This works and a universe can be created of this spreadsheet . When I create a data foundation using this connection I can see all the excel workbooks in the folder not just the one named in the DSN . What I am trying to find out is if I can use this connection with any of these workbooks in this folder or if each workbook needs its own DSN .

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

4 Answers

AMIT KUMAR
Oct 20, 2016 at 01:28 PM
1

I don't have much idea with excel source but in DSN you can select only the excel file not specific tab.

if you can see all workbooks in the Data Foundation then no need to create individual connection.

Why are you not using excel directly in webi report?

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Oct 21, 2016 at 01:25 PM
0

you can store all excel files in shared location where the BO account has an access. That will be much easier.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 21, 2016 at 01:19 PM
0

I've tried it and as Amit says there is no need for an individual connection although I would still like to understand why when the DSN selects one named file . The reason for not using excel directly in the webi report is because the refreshing is less flexible in webi direct .

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Oct 21, 2016 at 03:37 PM
0

Only drawback of using excel in webi is you can not create the prompts in webi. otherwise it much easy to use in webi.

No need to create extra Universe layer for excel data source for webi reporting.in both the cases you need to place the excel file at server but for universe you need to create DSN then Data Foundation,Business layer and then reporting.

Share
10 |10000 characters needed characters left characters exceeded