Microsoft Access vs. Oracle Analytics

As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome. It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.

Incentivized

Oracle Data Visualization is very effective if used in an enterprise context with huge volumes of data coming from different systems. It supports dashboard and reporting capabilities and is easy to scale. It also allows you to leverage machine learning capabilities to extract hidden data trends. Visualization capabilities are powerful but not so various if compared to other solutions on the market. If you want to present a dashboard to an executive audience and you want to make your dashboards beautiful you must adapt them through PowerPoint.

Incentivized

• Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
• Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
• It is really fast when joining multiple tables no matter what type of join.
• Works on pretty much same SQL scripts so no need to learn a new language!

Incentivized

• Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
• We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
• OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
• OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.

Incentivized

• Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
• The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
• Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
• I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.

Incentivized

• More AI but with human back up.
• Less mumbo jumbo so even IT guys/gals can more easily work.
• More statistics (math) and orientation for those not familiar with it.
• More live as well as virtual (live) show casing of real situations in business.

Incentivized

I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.

Scalability and rich integration capabilities. In the future, if we go with Hyperion for the Financial Consolidation and planning purposes -BI integration with Hyperion is going to be much simpler as it has native interface connectivity and even integration capabilities with well known CRM products (Siebel) and ERP Products (Oracle EBS, Peoplesoft, SAP) is going to be easy and straight forward.

Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.

Incentivized

Great, if you are limited to using it along with other Oracle products; sadly, not if you are integrating with other products, which can be a challenge. It is a great product with tons of functionality and great integration with other in-house platforms. Great visuals and customization for data and analytics to provide decision-making data and analysis.

Incentivized

I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.

Incentivized

No problems, it's that simple.

Incentivized

Other than anomalies or expected quirks, there were never any earth-shattering delays.

Incentivized

While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.

Incentivized

Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.

Incentivized

Oracle University offers very in-depth training.

It was a private training site.

Incentivized

there is no key idea, since it is easy to implement Microsoft Access

A properly implemented Endeca solution performs extremely well on the largest of datasets and it positions your organization to immediately achieve your ROI.

Excel is a fantastic - robust application that can do so much so easily. Its easy to train and understand. However - excel does not provide a reporting function and that is typically where we will suggest a move to [Microsoft] Access. [Microsoft] Access requires a little more knowledge of data manipulation.

Incentivized

Oracle Analytics Cloud, is one of the most agile and secure data analysis platforms that according to the budget and the amount of use, you can use the resources you need under the cloud. The Oracle brand is also very well known in this field and can meet all the needs of an organization or industry in any sector.

We have seen the results of this in our initial research and are not surprised that Oracle does this like it does soo many other things in this area, so well.

Incentivized

• Not having to recreate queries or reports every time you want to use them.
• Once an item is created and saved as part of the database, you save manpower by not having to recreate them.
• ROI from a usability standpoint is great. Solid product with great functionality that requires low maintenance usually.

Incentivized

• We've used OBIEE (or it's previous named product) for over 13 years and it's still the most used tool for BI by the business.
• We moved our largest business system off of Business Object into OBI so we could gain improved performance, reliability, and easier management of metadata.