Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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