Friday, October 21, 2016

Oracle DV - Connecting to MS Access

Visualize data present in MS Access database and draw meaningful insights using Oracle DV. New Oracle DV can connect to MS Access and fetch the data by selecting the tables they want to analyze. Users can also fetch the data using Custom SQL. Data fetched from MS Access can be wrangled/prepared in Oracle DV and can be mashed up with data from other data sources seamlessly.

How to connect to MS Access from Oracle DV? It’s as simple as choosing the access database files on which you want to perform Analysis. Oracle DV supports multiple file formats of MS Access db files like .accdb & .mdb. Users have to mention the File Name along with Path information and Username, password (if any) to access the files. Viola! They have their MS Access data ready for Analysis in Oracle DV.


Take a look at this video to see how to connect to MS Access from Oracle DV:



Are you an Oracle Analytics customer or user?

We want to hear your story!

Please voice your experience and provide feedback with a quick product review for Oracle Analytics Cloud!
 

2 comments:

lost_in_woods said...

nice blog , very helpful and visit us for VISUALIZATION SERVICES in USA

Unknown said...

Unable to create connection for MS Access.

Failed to save the connection.
Error Occurred while processing the query.

Post a Comment