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:
nice blog , very helpful and visit us for VISUALIZATION SERVICES in USA
Unable to create connection for MS Access.
Failed to save the connection.
Error Occurred while processing the query.
Post a Comment