Endeca (discontinued) vs. Microsoft BI (MSBI) vs. Oracle Analytics

Best fit for this product: - Advanced or Sophisticated Enterprise Search platform: If you spend effort on your search capabilities, Endeca is the tool. - If you are looking for capabilities to search and navigate similar to a relational-database system, then Endeca is not the best fit. - If you are spending effort to drive customer experience, especially around customer interaction with your web application, Endeca can help with that in a multichannel environment.

Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.

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

• Provides exact, correct counts of items in its dimensions.
• Allows for flexible, out-of-the-box boosting of content (based on combo of any/all of: user profile, date, dimension being browsed and search keyword).
• It has a reasonably good admin interface for the administration of boosting/promotion rules for the business user.

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

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

• Endeca's page builder is not fit to be an enterprise product - it is just BAD!
• It is not easy for a non-user to understand Endeca quickly
• Multi-index search (or any complex search implementation) is not easy to setup in Endeca

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• 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

If the solution is implemented well and the business understands the purpose of the Endeca stack, it offers a great way for a business to explore and benefit from its existing data. From my experience, the Endeca solution has exposed data patterns to a business that were not thought about or explored before because of the lack of available tools to properly expose these patterns

Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.

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.

The system itself is very usable, and with proper training is very sensible in its organization and method of operation. There are some downsides in initial setup in the way things are imported (or not in some cases) in setting up properties and dimensions. Overall however it's amazingly flexible in terms of the content it can index and make available for search.

The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.

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

The product has been reliable.

No problems, it's that simple.

Incentivized

SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.

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

Incentivized

Support has been very good, and the trainers for the various Endeca courses have all been very willing to help long after the classes have been completed, so in the instances where we're waiting on support from Oracle, it's often that the members of their training arm can help us out as well.

MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.

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

The training is actually really good, and absolutely necessary - although this is software that has great documentation, the documentation itself is so vast, that it would be difficult to learn haphazardly, not to mention being incredibly time consuming to do so. Online training probably would have been fine except for the fact that having someone look over your shoulder to see where you're going wrong is helpful. This also allowed our team to sit in a single room and converse about functionality, etc. that would have been difficult to facilitate via an online class.

This training was more directed toward what the product was capable of rather than actual programming.

Oracle University offers very in-depth training.

We did some online Q&A with the Oracle team, but I would definitely recommend doing an in person class if you have a large team that will be attending - there's definitely no replacements for a large class of technically oriented staff members who can drive conversation about specific topics that might surface.

I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.

It was a private training site.

Incentivized

There were some features we were hoping to get implemented in this particular release of Endeca, but were unable to facilitate those requirements due mostly to timeline. Having seen several other implementations, we will definitely have future iterations to add functionality and improve upon our implementation of Endeca. For the time being, we are satisfied with our implementation as it turned out.

We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.

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

Oracle Endeca was the best option that we evaluated by far. It gave us the most flexibility and ability to meet our objectives and had features that were not offered by the competing products we evaluated, but which we very much wanted, and this was why we decided to go with Oracle Endeca versus another platform

Incentivized

We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.

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

• It is a searching tool, and hard to estimate its impact on conversion.
• It does its job regarding better searching; In terms of efficiency, it's hard to say: it has big learning curve. It requires a dedicated Endeca developer to work on it.
• Compared to Solr, it is way too complicated.

• As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
• However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.

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.