Categories
- All Categories
- Oracle Analytics Learning Hub
- 26 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Report from MS Access
Srikanth Mandadi
Rank 3 - Community Apprentice
Summary
BI Publisher Report from MS Access
Content
Team,
Need info on ways to connect to MS Access to develop a Oracle BI Publisher report (OBI 11g).
Looks like one way is to use Oracle DB Gateway for ODBC, Would like to know if we have any other options.
Regards,
Srikanth
0
Answers
-
Hi Srikanth,
I know that oracle can connect to any data sources, but in real time we used txt,csv,excel, xml file data sources. but not with ms access. try like excel file. it should work.
https://docs.oracle.com/cd/E23943_01/bi.1111/e22255/data_sources.htm#BIPAD295
Thanks
MM
0