MS SharePoint / SQL vs. OpenText Magellan

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MS SharePoint / SQL
Score 8.5 out of 10
N/A
MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.N/A
OpenText Magellan
Score 9.0 out of 10
N/A
OpenText Magellan Analytics Suite leverages a comprehensive set of data analytics software to identify patterns, relationships and trends through data visualizations and interactive dashboards.N/A
Pricing
MS SharePoint / SQLOpenText Magellan
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
MS SharePoint / SQLOpenText Magellan
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
MS SharePoint / SQLOpenText Magellan
Features
MS SharePoint / SQLOpenText Magellan
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
MS SharePoint / SQL
7.7
Ratings
6% below category average
OpenText Magellan
7.0
Ratings
15% below category average
Pixel Perfect reports8.70 Ratings00 Ratings
Customizable dashboards7.00 Ratings7.00 Ratings
Report Formatting Templates7.30 Ratings7.00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
MS SharePoint / SQL
8.2
Ratings
2% above category average
OpenText Magellan
8.3
Ratings
3% above category average
Drill-down analysis7.80 Ratings8.00 Ratings
Formatting capabilities8.30 Ratings8.00 Ratings
Integration with R or other statistical packages8.00 Ratings9.00 Ratings
Report sharing and collaboration8.60 Ratings8.00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
MS SharePoint / SQL
8.9
Ratings
7% above category average
OpenText Magellan
8.3
Ratings
0% below category average
Publish to Web8.70 Ratings8.00 Ratings
Publish to PDF9.40 Ratings8.00 Ratings
Report Versioning8.30 Ratings9.00 Ratings
Report Delivery Scheduling9.00 Ratings8.00 Ratings
Delivery to Remote Servers9.00 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
MS SharePoint / SQL
8.6
Ratings
8% above category average
OpenText Magellan
8.0
Ratings
0% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)8.70 Ratings9.00 Ratings
Location Analytics / Geographic Visualization8.00 Ratings00 Ratings
Predictive Analytics9.30 Ratings7.00 Ratings
Pattern Recognition and Data Mining8.40 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
MS SharePoint / SQL
8.2
Ratings
3% below category average
OpenText Magellan
9.0
Ratings
6% above category average
Multi-User Support (named login)7.90 Ratings00 Ratings
Role-Based Security Model8.10 Ratings9.00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.20 Ratings9.00 Ratings
Report-Level Access Control7.80 Ratings00 Ratings
Single Sign-On (SSO)8.70 Ratings9.00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
MS SharePoint / SQL
9.4
Ratings
18% above category average
OpenText Magellan
7.0
Ratings
12% below category average
Responsive Design for Web Access9.40 Ratings7.00 Ratings
Mobile Application9.40 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.70 Ratings7.00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
MS SharePoint / SQL
8.8
Ratings
12% above category average
OpenText Magellan
6.2
Ratings
23% below category average
REST API9.30 Ratings5.00 Ratings
Javascript API9.30 Ratings9.00 Ratings
iFrames9.00 Ratings00 Ratings
Java API9.00 Ratings5.00 Ratings
Themeable User Interface (UI)8.00 Ratings7.00 Ratings
Customizable Platform (Open Source)8.00 Ratings5.00 Ratings
Best Alternatives
MS SharePoint / SQLOpenText Magellan
Small Businesses
BrightGauge
BrightGauge
Score 9.1 out of 10
BrightGauge
BrightGauge
Score 9.1 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MS SharePoint / SQLOpenText Magellan
Likelihood to Recommend
8.8
(0 ratings)
9.0
(0 ratings)
Likelihood to Renew
8.8
(0 ratings)
3.9
(0 ratings)
Usability
8.9
(0 ratings)
9.0
(0 ratings)
Support Rating
8.8
(0 ratings)
9.0
(0 ratings)
Implementation Rating
7.0
(0 ratings)
-
(0 ratings)
User Testimonials
MS SharePoint / SQLOpenText Magellan
Likelihood to Recommend
As I mentioned in my previous answers, MS SharePoint is very useful as a shared drive for the organization and is very easy to manage. It also helps us import data from SharePoint directly into PowerBI for creating reports. According to my understanding, only share link features should be improved.
Read full review
It depends on extensibility, set-up, access & style. Actuate performs fairly well, but has performance issues because it sits on top of eclipse, which sits on top of Java. Extensibility usually comes at that price. Set-up is fairly straightforward and it can be secured.
Read full review
Pros
  • Flexible - able to make any changes we would like vs traditional service desk system.
  • ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
  • Easy to use for end users.
Read full review
  • Ability to connect to different kinds of sources, including web services, and customize those queries to the extend needed
  • Provide tools to customize the look & feel of the reports as much as needed, even being able to choose different appearances for different outputs
  • Allowing scripting in the reports extends the functionality available
  • Allowing to embed reports without further licensing and maintaining all the functionality
Read full review
Cons
  • It is hard to setup and nightmare
  • It requires a of infrastructure, thus it could be costly because of requirement and licensing required for everything to run smoothly
  • If it is not setup and organized properly from the beginning it could be maintenance nightmare
  • It is hard to have "test" environment to do patches or similar
Read full review
  • Report rendering can take a long time for large reports (250,000+ pages) - we run these in batch over night
  • The deployment of production code from development to test to production enviroments can be complex due to the number of components that must compile
Read full review
Likelihood to Renew
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
Read full review
I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite
Read full review
Usability
I gave this rating due to MS SharePoint being a big help with our userbase. We have a lot of users that are just old enough to not have much technical skills or they have been in this industry long enough to where they haven't really needed to utilize much technology. MS SharePoint helped us move beyond that barrier without too many bumps and bruises.
Read full review
It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.
Read full review
Support Rating
I've only had to call in to support on one occasion but they were able to work though our issue and find a solution that did fully resolve the issue in a timely manner. I can't always say the same about support from other companies so it was a refreshing change to have support that did help.
Read full review
Always there on the front and backend for us and the client.
Read full review
Implementation Rating
Mo major insight regarding the implementation if very well documented for standard products.
Read full review
No answers on this topic
Alternatives Considered
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.
Read full review
It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.
Read full review
Return on Investment
  • ROI for ms SharePoint/SQL considering that is the best database engine with excellent features that help you to have all information in your hand.
  • Something negative could be license format.
  • These are the best relational databases in the market with powerful features that complement your system.
Read full review
  • Actuate can handle 50 to 60 sub reports inside a report very well.
  • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
Read full review
ScreenShots

OpenText Magellan Screenshots

Screenshot of A Magellan BI & Reporting dashboard that an individual can interact with and personalize to their needs, such as changing chart types or computations.Screenshot of Magellan Data Discovery provides a Smart User Interface, designed to equip new users and users seeking a more streamlined set of features for insightsScreenshot of Magellan Data Discovery provides an Advanced User Interface that allows data analytics pros to leverage its breadth of sophisticated capabilities for insightsScreenshot of Magellan Text Mining insights can be displayed within easy-to-use dashboards.Screenshot of Data scientists can create visualizations within the Magellan Notebook and see it dynamically update as they write changes to it.