TrustRadius: an HG Insights company

Informatica Intelligent Data Management Cloud vs. OpenText Magellan vs. Phocas Business Intelligence

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Informatica Intelligent Data Management Cloud

    Score7 out of 10
    N/AThe Informatica® Intelligent Data Management Cloud™ (IDMC) is designed to help businesses efficiently handle the complex challenges of dispersed and fragmented data to innovate with their data on virtually any platform, any cloud, multi-cloud and multi-hybrid.N/A

    OpenText Magellan

    Score9 out of 10
    N/AOpenText 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

    Phocas Business Intelligence

    Score9.3 out of 10
    N/APhocas helps users discover data and provides results in real time.  It is designed for non-technical users and delivers a simple yet powerful analytical capability that quickly turns data into a chart, graph or map.  It brings up data on local, regional or global sales, inventory, forecasts, prices, profit margins, budgets and more. Phocas, based in the United Kingdom, is a business intelligence firm with offices in…N/A
    Pricing
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Editions & Modules
    No answers on this topic
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Free Trial
    NoNoYes
    Free/Freemium Version
    NoNoNo
    Premium Consulting/Integration Services
    NoNoYes
    Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
    Additional Details——Phocas has built its business model on exceeding customer expectations. We’ve operated on a subscription basis from the start and in the words of Phocas Group chairman and co-founder Paul Magee: ‘That puts the onus on us to perform’. And we like that. In fact, our whole company ecosystem is built around that ‘light bulb moment’ when customers achieve a breakthrough by seeing their business through fresh eyes.
    More Pricing Information
    Community Pulse
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Considered Multiple Products
    Informatica
    No answer on this topic
    OpenText
    No answer on this topic
    Phocas
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    6 Answers
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    6 Answers
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    100%
    Happy with the feature set
    6 Answers
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    100%
    Implementation went as expected
    5 Answers
    No answers on this topic
    No answers on this topic
    Features
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    7.0
    2 Ratings
    15% below category average
    Phocas Business Intelligence
    9.0
    4 Ratings
    10% above category average
    Customizable dashboards00 Ratings7.02 Ratings9.04 Ratings
    Report Formatting Templates00 Ratings7.01 Ratings9.04 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    8.3
    3 Ratings
    4% above category average
    Phocas Business Intelligence
    9.6
    4 Ratings
    18% above category average
    Drill-down analysis00 Ratings8.03 Ratings10.04 Ratings
    Formatting capabilities00 Ratings8.03 Ratings9.04 Ratings
    Integration with R or other statistical packages00 Ratings9.01 Ratings00 Ratings
    Report sharing and collaboration00 Ratings8.02 Ratings10.04 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    8.3
    2 Ratings
    1% above category average
    Phocas Business Intelligence
    9.3
    4 Ratings
    12% above category average
    Publish to Web00 Ratings8.02 Ratings00 Ratings
    Publish to PDF00 Ratings8.02 Ratings10.04 Ratings
    Report Versioning00 Ratings9.02 Ratings8.03 Ratings
    Report Delivery Scheduling00 Ratings8.02 Ratings9.94 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    8.0
    1 Ratings
    0% above category average
    Phocas Business Intelligence
    8.3
    4 Ratings
    4% above category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings9.01 Ratings8.04 Ratings
    Predictive Analytics00 Ratings7.01 Ratings8.04 Ratings
    Location Analytics / Geographic Visualization00 Ratings00 Ratings9.03 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    9.0
    2 Ratings
    6% above category average
    Phocas Business Intelligence
    9.9
    4 Ratings
    15% above category average
    Role-Based Security Model00 Ratings9.02 Ratings9.94 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings9.02 Ratings9.93 Ratings
    Single Sign-On (SSO)00 Ratings9.02 Ratings00 Ratings
    Multi-User Support (named login)00 Ratings00 Ratings9.94 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    7.0
    2 Ratings
    10% below category average
    Phocas Business Intelligence
    9.5
    3 Ratings
    21% above category average
    Responsive Design for Web Access00 Ratings7.02 Ratings9.03 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings7.02 Ratings10.03 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Informatica Intelligent Data Management Cloud and OpenText Magellan and Phocas Business Intelligence
    Feature
    Informatica Intelligent Data Management Cloud
    -
    Ratings
    OpenText Magellan
    6.2
    1 Ratings
    22% below category average
    Phocas Business Intelligence
    -
    Ratings
    REST API00 Ratings5.01 Ratings00 Ratings
    Javascript API00 Ratings9.01 Ratings00 Ratings
    Java API00 Ratings5.01 Ratings00 Ratings
    Themeable User Interface (UI)00 Ratings7.01 Ratings00 Ratings
    Customizable Platform (Open Source)00 Ratings5.01 Ratings00 Ratings
    Best Alternatives
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Small Businesses
    Skyvia
    Score10 out of 10
    Cyfe
    Score4 out of 10
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Likelihood to Recommend
    8.3
    (13 ratings)
    9.0
    (11 ratings)
    8.1
    (4 ratings)
    Likelihood to Renew
    9.0
    (1 ratings)
    3.9
    (9 ratings)
    -
    (0 ratings)
    Usability
    -
    (0 ratings)
    9.0
    (1 ratings)
    9.0
    (1 ratings)
    Support Rating
    8.0
    (3 ratings)
    9.0
    (2 ratings)
    9.0
    (1 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    9.0
    (8 ratings)
    8.0
    (3 ratings)
    Data Sources
    -
    (0 ratings)
    8.0
    (8 ratings)
    10.0
    (3 ratings)
    User Testimonials
    Informatica Intelligent Data Management CloudOpenText MagellanPhocas Business Intelligence
    Likelihood to Recommend
    Informatica
    Informatica Cloud is a great tool for use when data must be formatted consistently. Once configured, it is very robust and reliable. It is also well-suited for an organization without a robust IT staff to maintain a full server infrastructure. It offers a cost-effective approach to high-quality data integration for even the largest organizations. Organizations without staff experienced in data analytics may find it challenging to take advantage of the more complex results of this tool.
    Incentivized
    Read full review
    OpenText
    If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
    Read full review
    Phocas
    If you would like your data in one place with easy access, this is the software for you. You can have data from multiple systems and bring it into one view so that you have a quick and easily visible dashboard for the data you wish to see.
    Incentivized
    Read full review
    Pros
    Informatica
    • Once the secure connection is established it’s quite easy to operate and create new jobs. The controls are simple, and we appreciate the fact there are not a lot of complex fine-tunings required. Navigation is also easy, and we enjoy the ability to open multiple tabs in the browser to work on multiple projects.
    • The monitoring functionality works well to help track the progress of the jobs, again, without too much complication. In a fast dev environment, speed is essential and we quickly seeing the status/progress of jobs as well as any errors if the jobs fail helps us maintain speed.
    • The web interface is a lot easier to interact with than the client/on-prem version. Putting much of the heavy lifting of interacting with the tool onto the shoulders of the browser makes it easier to keep multiple sessions open and get in/out quickly without having to VPN into the office.
    Incentivized
    Read full review
    OpenText
    • The report outputs can vary across different types such as HTML, PDF, and Excel
    • Their open source offering is very sufficient
    • There are great boards and blogs for developers and engineers to expand and use their features.
    • The people from the company that I've worked with are professional and courteous.
    Incentivized
    Read full review
    Phocas
    • Custom reports are simple to create.
    • The ability to manage users and their dashboards is solid.
    • Easy to navigate web interface makes the software accessible from anywhere.
    Incentivized
    Read full review
    Cons
    Informatica
    • The User Interface can be a bit difficult to get in initial stages.
    • Error messages are hard to understand which sometimes takes a lot of time for the resolution
    • Cannot Implement complex SQL queries which should be fixed in future release.
    Incentivized
    Read full review
    OpenText
    • The documentation on all the available features, but most importantly on the scripting side, can be improved
    • The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
    • The server portal needs to provide better tools
    • More integration is needed with other OpenText products
    Incentivized
    Read full review
    Phocas
    • Phocas needs to make it easier to connect to different types of databases.
    • The data in Phocas needs to be updated faster in some cases.
    • It needs to provide functions to create better charts and graphs.
    Incentivized
    Read full review
    Likelihood to Renew
    Informatica
    No answers on this topic
    OpenText
    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
    Incentivized
    Read full review
    Phocas
    No answers on this topic
    Usability
    Informatica
    No answers on this topic
    OpenText
    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.
    Incentivized
    Read full review
    Phocas
    It is a very user-friendly product and is easy to understand. You can get your data from just a quick click and the dashboard loads. You can take the data and drill down easy to find what you are looking for.
    Incentivized
    Read full review
    Support Rating
    Informatica
    I've never had trouble getting into contact with Informatica's support for technical help. I give it a nine because it does pretty well for mid to enterprise-scale workflows.
    Incentivized
    Read full review
    OpenText
    Always there on the front and backend for us and the client.
    Read full review
    Phocas
    Support is responsive. You log a call and they will respond quickly and resolve your issues. We have only had great experiences with the support team.
    Incentivized
    Read full review
    Alternatives Considered
    Informatica
    First, the wizard is easy to use making the learning curve for simple ETL tasks nice. Second, since Informatica is mature there are a good variety of connectors available. Finally, we have driven some fairly complex ETL solutions using only the cloud.
    Incentivized
    Read full review
    OpenText
    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
    Phocas
    Phocas is easy to use for end users and can be used on desktops, laptops, and phones.
    Incentivized
    Read full review
    Return on Investment
    Informatica
    • Cut costs on the number of staff we need for data import.
    • Cut costs for automation that can be done for data that no longer has to be manually imported.
    • We've saved countless dollars by eliminating duplicates in our system with this tool.
    Incentivized
    Read full review
    OpenText
    • 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
    Phocas
    • It has given our business a view on data
    • We can access it from anywhere
    • You can have multiple dashboards for different information
    Incentivized
    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.

    Phocas Business Intelligence Screenshots

    Screenshot of Phocas Dashboard on iPadScreenshot of Phocas Dashboard on Laptop