Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Access Database Connection (ODBC) & OData

Question
21
Views
0
Comments
mrmmickle1
mrmmickle1 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

Access Database Connection (ODBC) & OData

Content

Hello-

I'm new to the Data Visualizer forum.  I was hoping someone may be able to steer me in the correct direction.  I would like to connect to two different data sources and I am having some trouble.

1. Sharepoint List - I need to connect to a Sharepoint List.

DV_ODATA.png

2. I need to connect to an Access Database that resides on my Desktop

I tried to set up an odbc connection via Control Panel > Administrative Tools > Set up ODBC data sources.  However, after completing the process I am still unable to connect to the databse.  Can someone please provide me some guidance on what exactly needs to be put into these fields?

DV_ODBC.png

Do I need special credentials to use these connection?  I.E. Administrator privileges?  Or can a regular user connect to these?