Astera ReportMiner vs. Endeca (discontinued) vs. Microsoft BI (MSBI)

Astera ReportMiner is well suited for those who work with EMR Data or business operations data where different platforms may report on similar data but not everything is the same between the different systems and how they export their data. It works especially well when systems can't edit their exports so you need to clean up data a lot before they are combined into a single file. It is less appropriate a solution when you are trying to combine large data, let's say thousands of files and need some sort of platform to deduce analytic patterns out of it. This is more used for data preparedness rather than big data analysis. This may have changed with recent updates, however they do not do a good job of updating customers on new releases so keeping track of their developments is something worth doing if data management is an important part of your/your company's role.

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

• ReportMiner's OCR accuracy is flawless to my experience. I use the program to pull values from check details, and have yet to find an error.
• ReportMiner's interface is easy to learn. I never even got formal training on the program. I watched some YouTube videos and learned as I went.
• ReportMiner training personnel is very knowledgeable and quick to respond. Anytime I ran into a problem I could not figure out on my own, they would get back with me within a half a day.

• 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

• Could provide some features to help with advanced analytics for big data. (i.e. larger data sets)
• Too much clutter on their Youtube page, they should highlight the tutorials so they are easier to find for new users. Get rid of old tutorial video playlists so the organization is clean and up to date.
• Have sales rep follow up with customers to offer product updates, new product releases, and do check ins to see if customers have suggestions for feature improvement.

• 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

It is the best way to get a multi line record from pdf to Excel in one row.

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.

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

The product has been reliable.

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.

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

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.

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.

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.

I have never actually used another program like ReportMiner. Before I was just using PDF viewers such as Adobe that had OCR capabilities. I would have to select a range of numbers and copy and paste to Excel. It was tedious, slow, and sometimes error prone. I chose to learn ReportMiner because it saves me at least 4 times the amount of time I would have to use by copy and pasting.

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

• Efficient and automated data extraction. Saves time and resources.
• User-friendly interface and good documentation. It is therefore easiest to learn and apply in a short time.
• Documents, which have various formats of data tables or arrangement, needed a lot of manual fixing. So it required a lot of time for validation and quality control.

• 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