Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Administration Tool ODBC issue

Hi All,
I am trying to create Connection pool in my repository for MS Excel Files so i am trying to create ODBC System DNS connection,
but when i run ODBC wizard i can NOT See MS Excel Driver.
Once i check, I found out BI Admin tool is takeing ODBC from "C:\Windows\System32" BUT MS Excel Driver is available in "C:\Windows\SysWOW64"
So how am i going to direct BI Admin Tool to take ODBC from "C:\Windows\SysWOW64" NOT from "C:\Windows\System32"
Windows Registry:
Regards
Answers
-
Not a fault of the OBIEE tool ... https://support.microsoft.com/en-us/kb/2721825
0 -
Hi Thomas,
Thanks i tired but problem is that BI Admin Tool is by default picking DNS Connection from "Windows\System32\odbcad32.exe"
I want to tell BI Tool to Pick DNS Connection from here "windowns\SysWOW64\odbcad32.exe"
Regards
sher
0 -
Did you try something like this? http://hostilecoding.blogspot.com/2012/10/obiee-how-to-import-data-from-excel-on.html
0 -
Thanks Thoms this resolved my issue. A followup question, Do i need to perform any Configuration on Linux Server to read Excel File ? i saw some blogs but couldn't understand them well.
Thanks agian
0