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:

No comments:

Post a Comment