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
Considered Both Products
MS SharePoint / SQL
Chose MS SharePoint / SQL
1. Cost affective as it comes with MS 365 Tenant 2. Natively interactive with tools such MS 365 Dynamics ERP, Power Platform etc
Chose MS SharePoint / SQL
Ease of use being the biggest benefit, speed and availability are right there behind ease of use.
Chose MS SharePoint / SQL
SharePoint is more reliable in terms of data storage, security, and accessibility by only required users compared to ClickUp. Also, SharePoint is easier to learn and use for any user, as tutorials are easily available online. Also, SharePoint is a product of Microsoft, which …
Chose MS SharePoint / SQL
Simple: MS Sharepoint/SQL is the best and robust databases motor now are incorporating some features in order to improve users and DB admins experience.
Chose MS SharePoint / SQL
The user interface and search elements are much better than our outgoing data storage method.
Chose MS SharePoint / SQL
Box is a content storing portal where you can host and share documents/files to others. But it does not have [Sharepoint's] capabilities like... versions, automation, email approvals, etc. And Microsoft Exchange is a mailing database that can be used for exchanging data using …
Chose MS SharePoint / SQL
Has better support than MySQL and more developers are familiar with it. Oracle syntax is more cumbersome and less developers are experienced these days with Oracle.
Chose MS SharePoint / SQL
I have heard that the one that comes close is a tool called Apex. Some of the leading companies are using it instead of SQL.
Chose MS SharePoint / SQL
If you are looking for a document management and collaboration tool to use as a web portal that comes with SQL data base and easy to manage and something you can learn very quick, look no further than SharePoint but if you need a pure database then this is not for you.
Chose MS SharePoint / SQL
We use MS SQL more just because of how widely it's used and how popular it is. It's easier to install, maintain, and support compared to the other ones we've tried.
Chose MS SharePoint / SQL
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 …
Chose MS SharePoint / SQL
At its core, MS SharePoint (with SQL) is for managing document-based content. It falls just short of being a best in class records manager (it does offer some features for this though), and it isn't the easiest to solution to make great looking modern and engaging web sites. …
Chose MS SharePoint / SQL
We looked at Google Drive but it didn't have the API and integration that SharePoint has with 3rd party software providers. Also, Google Drive has basic functionality compared to MS SharePoint and how you can customize and build-out.
Chose MS SharePoint / SQL
I haven't used any other products that compete with it. I started my career at Microsoft and the two subsequent locations have also been Microsoft shops.
Chose MS SharePoint / SQL
Dropbox is a user-friendly product, but Sharepoint is a native Microsoft product that can be implemented into any Microsoft products, which are used mostly in our environment. Finding solutions on the internet is much easier, as it is used commonly by other organizations as …
Chose MS SharePoint / SQL
I am not familiar with any other products similar to SharePoint, so I am unable to compare.
Chose MS SharePoint / SQL
Mostly, we are a Microsoft shop, and SharePoint and SQL integrate with our other applications. They're easy to use, and not too hard to manage.
Chose MS SharePoint / SQL
I have used both Google Drive and Zoho Docs which seem similar to MS SharePoint. The main differences I noticed as a user is that the user interfaces in both Google Drive and Zoho Docs were much more intuitive and they were much easier to navigate than MS SharePoint. There …
Chose MS SharePoint / SQL
We had staff resources able to create, configure, and mange our sharepoint environment, so it made sense for us and gave us greater flexibility than these turnkey solutions. Certainly each solution has its merits and each are completely different price points. We already had …
Chose MS SharePoint / SQL
Most of the applications used within our company have a SharePoint back end therefore I have not used anything other than SharePoint.
Chose MS SharePoint / SQL
We evaluated Atlassian Confluence and compared it to our current SharePoint implementation. We felt that the two products were quite similar in the user experience but we chose to keep our SharePoint farms up and running. This was mainly due to the cost of switching and the …
Chose MS SharePoint / SQL
Actually i didnt work with other than ms sharepoint so i cant say how it is stand for others
OpenText Magellan
Chose OpenText Magellan
There is multiple software available in the market to do the reporting and text analytics. Generally, analysts prefer using Python or R. Or we try to use any API available. This software can fulfill almost 80% of those needs without writing the codes. It has the integration …
Chose OpenText Magellan
OpenText Magellan can produce reports that are much more elaborate than PowerBI, which is ideal for users that just need to see a report. On the other hand, PowerBI seems to be better at allowing users to interact with data.
Chose OpenText Magellan
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 …
Chose OpenText Magellan
Actuate has been in the industry a while and the open source community make going with Actuate's BIRT a stable decision. Changing report engines can be expensive, so going with a company with a good reputation helps long-term.
Chose OpenText Magellan
I've used JReports and Actuate is very similar but seems to have a lot more customization features for the end user of BIRT reports.
Chose OpenText Magellan
Actuate has a HUGE number of features that can tie nicely into almost any ERP but it takes some time to learn and the development community was relatively small compared to the Crystal Reports alternative. Crystal was far easier to learn and had a massive support base. Probably …
Chose OpenText Magellan
We looked at a few other competitor's products but based on value for features chose Actuate for its total cost of ownership.
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.40 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.90 Ratings8.00 Ratings
Formatting capabilities8.40 Ratings8.00 Ratings
Integration with R or other statistical packages8.00 Ratings9.00 Ratings
Report sharing and collaboration8.70 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.20 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)8.00 Ratings00 Ratings
Role-Based Security Model8.10 Ratings9.00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)8.30 Ratings9.00 Ratings
Report-Level Access Control7.90 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
19% above category average
OpenText Magellan
7.0
Ratings
11% below category average
Responsive Design for Web Access9.50 Ratings7.00 Ratings
Mobile Application9.50 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.10 Ratings5.00 Ratings
Best Alternatives
MS SharePoint / SQLOpenText Magellan
Small Businesses
BrightGauge
BrightGauge
Score 9.0 out of 10
BrightGauge
BrightGauge
Score 9.0 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
9.0
(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.