TrustRadius: an HG Insights company

Infor Birst vs. Informatica Cloud Data Quality vs. SAP Adaptive Server Enterprise (ASE)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Infor Birst

    Score6.4 out of 10
    N/AInfor Birst offers multi-tenant cloud BI for deployment in a public or private cloud, or on-premises. It provides an in-memory columnar data store and a BI layer comprising a reporting engine, predictive analytics tools, mobile native apps, dashboards, discovery tools, and an open client interface.N/A

    Informatica Cloud Data Quality

    Score6.9 out of 10
    N/AThe vendor states that Informatica Data Quality empowers companies to take a holistic approach to managing data quality across the entire organization, and that with Informatica Data Quality, users are able to ensure the success of data-driven digital transformation initiatives and projects across users, types, and scale, while also automating mission-critical tasks.N/A

    SAP Adaptive Server Enterprise (ASE)

    Score8 out of 10
    N/ASAP Adaptive Server Enterprise (ASE) is a transactional relational database, boasting fast, reliable online transaction processing (OLTP). SAP ASE is the company's transactional database within the SAP Business Technology Platform portfolio.N/A
    Pricing
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    Free Trial
    NoNoNo
    Free/Freemium Version
    NoNoNo
    Premium Consulting/Integration Services
    YesNoNo
    Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Features
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    7.4
    77 Ratings
    10% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Pixel Perfect reports7.068 Ratings00 Ratings00 Ratings
    Customizable dashboards8.077 Ratings00 Ratings00 Ratings
    Report Formatting Templates7.159 Ratings00 Ratings00 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    7.0
    78 Ratings
    13% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Drill-down analysis8.078 Ratings00 Ratings00 Ratings
    Formatting capabilities7.077 Ratings00 Ratings00 Ratings
    Integration with R or other statistical packages6.127 Ratings00 Ratings00 Ratings
    Report sharing and collaboration7.068 Ratings00 Ratings00 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    8.0
    75 Ratings
    3% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Publish to Web8.052 Ratings00 Ratings00 Ratings
    Publish to PDF8.067 Ratings00 Ratings00 Ratings
    Report Versioning7.28 Ratings00 Ratings00 Ratings
    Report Delivery Scheduling9.066 Ratings00 Ratings00 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    6.9
    72 Ratings
    15% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)8.072 Ratings00 Ratings00 Ratings
    Location Analytics / Geographic Visualization7.058 Ratings00 Ratings00 Ratings
    Predictive Analytics5.833 Ratings00 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    8.3
    72 Ratings
    2% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Multi-User Support (named login)9.070 Ratings00 Ratings00 Ratings
    Role-Based Security Model8.068 Ratings00 Ratings00 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)8.069 Ratings00 Ratings00 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    5.0
    54 Ratings
    43% below category average
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Responsive Design for Web Access7.052 Ratings00 Ratings00 Ratings
    Mobile Application3.034 Ratings00 Ratings00 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile3.042 Ratings00 Ratings00 Ratings
    Data Quality
    Comparison of Data Quality features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    -
    Ratings
    Informatica Cloud Data Quality
    8.2
    4 Ratings
    4% below category average
    SAP Adaptive Server Enterprise (ASE)
    -
    Ratings
    Data source connectivity00 Ratings8.94 Ratings00 Ratings
    Data profiling00 Ratings8.74 Ratings00 Ratings
    Master data management (MDM) integration00 Ratings8.24 Ratings00 Ratings
    Data element standardization00 Ratings7.14 Ratings00 Ratings
    Match and merge00 Ratings7.94 Ratings00 Ratings
    Address verification00 Ratings8.44 Ratings00 Ratings
    Relational Databases
    Comparison of Relational Databases features of Infor Birst and Informatica Cloud Data Quality and SAP Adaptive Server Enterprise (ASE)
    Feature
    Infor Birst
    -
    Ratings
    Informatica Cloud Data Quality
    -
    Ratings
    SAP Adaptive Server Enterprise (ASE)
    8.3
    1 Ratings
    2% above category average
    ACID compliance00 Ratings00 Ratings9.01 Ratings
    Database monitoring00 Ratings00 Ratings10.01 Ratings
    Database locking00 Ratings00 Ratings8.01 Ratings
    Encryption00 Ratings00 Ratings9.01 Ratings
    Disaster recovery00 Ratings00 Ratings8.01 Ratings
    Flexible deployment00 Ratings00 Ratings6.01 Ratings
    Multiple datatypes00 Ratings00 Ratings8.01 Ratings
    Best Alternatives
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    Small Businesses
    Cyfe
    Score4 out of 10
    No answers on this topic
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    Qlik Cloud Analytics (Qlik Sense)
    Score8.2 out of 10
    No answers on this topic
    SingleStore
    Score8.2 out of 10
    Enterprises
    Jaspersoft Community Edition
    Score7 out of 10
    SAP Data Services
    Score7.8 out of 10
    SAP IQ
    Score5.5 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    Likelihood to Recommend
    7.5
    (99 ratings)
    9.0
    (19 ratings)
    8.0
    (3 ratings)
    Likelihood to Renew
    9.0
    (35 ratings)
    6.6
    (14 ratings)
    10.0
    (1 ratings)
    Usability
    9.0
    (12 ratings)
    8.0
    (1 ratings)
    8.0
    (2 ratings)
    Availability
    4.1
    (6 ratings)
    9.0
    (2 ratings)
    -
    (0 ratings)
    Performance
    7.5
    (6 ratings)
    9.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    6.0
    (19 ratings)
    -
    (0 ratings)
    9.7
    (2 ratings)
    In-Person Training
    9.1
    (4 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Online Training
    8.0
    (2 ratings)
    10.0
    (1 ratings)
    -
    (0 ratings)
    Implementation Rating
    5.3
    (6 ratings)
    10.0
    (1 ratings)
    -
    (0 ratings)
    Configurability
    7.0
    (2 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    6.0
    (24 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Data Sources
    7.6
    (76 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Ease of integration
    5.0
    (2 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Product Scalability
    6.0
    (2 ratings)
    9.0
    (1 ratings)
    -
    (0 ratings)
    Vendor post-sale
    5.0
    (2 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    7.0
    (2 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    User Testimonials
    Infor BirstInformatica Cloud Data QualitySAP Adaptive Server Enterprise (ASE)
    Likelihood to Recommend
    Infor
    Infor Birst OEM and embedded analytics are well suited for advanced analytics and business intelligence. It has flexible deployment features and a lot of configuration ability with low code - no coding ability. Ability to ingest data from multiple live data sources. Source data from multiple sources can be segregated into multiple sections based on business criteria. Easily searchable business terms (metadata) across all enterprise analytic content.
    Read full review
    Informatica
    For effective data collaboration, systematic verification of customer information, and address, among others, Informatica Data Quality is a fruitful application to consider. Besides, Informatica Data Quality controls quality through a cleansing process, giving the company a professional outline of candid data profiling and reputable analytics. Finally, Informatica Data Quality allows the simplistic navigation of content, with a dashboard that supports predictability.
    Incentivized
    Read full review
    SAP
    We use this for an inbuilt security management system, where it performs well in a scaled setup with a large volume of live data with high availability. Also, the performance is up to the mark for the large statement flow. From a DBA perspective, a lot of parameters need to be fine-tuned for the specific environment needs, which can cause overhead. Expertise is limited, and the learning curve is steep for the SAP ASE.
    Incentivized
    Read full review
    Pros
    Infor
    • End-to-end solution, from raw source data, ETL, warehousing and reporting, Birst is able to do everything we need in one package instead of needing to develop and maintain multiple technologies
    • Intuitive report development. The drag and drop creation of reports is simple. More complicated queries are easy to generate.
    • Very user-friendly and interactive. A lot of nice features are available both for developers and end users to streamline the process of preparing and consuming data
    • Rich API which allows us to programmatically interact with Birst
    Incentivized
    Read full review
    Informatica
    • The matching algorithms in IDQ are very powerful if you understand the different types that they offer (e.g., Hamming Distance, Jaro, Bigram, etc..). We had to play around with it to see which best suit our own needs of identifying and eliminating duplicate customers. Setting up the whole process (e.g., creating the KeyGenerator Transformation, setting up the matching threshold, etc..) can be somewhat time consuming and a challenge if you don't first standardize your data.
    • The integration with PowerCenter is great if you have both. You can either import your mappings directly to PowerCenter or to an XML file. The only downside is that some of the transformations are unique to IDQ, so you are not really able to edit them once in PowerCenter.
    • The standardizer transformation was key in helping us standardize our customer data (e.g., names, addresses, etc..). It was helpful due to having create a reference table containing the standardized value and the associated unstandardized values. What was great was that if you used Informatica Analyst, a business analyst could login and correct any of the values.
    Read full review
    SAP
    • High availability and reliability.
    • High performance.
    • Monitoring of threshold based events.
    • Security at multiple levels.
    • Query plan optimization.
    • Lock management.
    • Access to HANA.
    Incentivized
    Read full review
    Cons
    Infor
    • Birst prices are fairly expensive. License plus cost of users can add up pretty quickly
    • Depending on the size of data, rendering of reports can take a little bit. Need faster processing of data
    • Takes a little time to understand how to build reports, not the most intuitive UI
    Incentivized
    Read full review
    Informatica
    • Several partnerships diminishing the value of technologies
    • Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
    • Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
    Read full review
    SAP
    • A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
    • Licensing is far too complicated. Simplify pricing.
    Incentivized
    Read full review
    Likelihood to Renew
    Infor
    We have been able to overcome any of the drawbacks we've found with Birst easily and it has fulfilled almost all of our analytic needs to date. Having seen their roadmap it would be highly unlikely we would move away from this platform any time soon. You simply can't beat the functionality that Birst provides for the price and the things I see coming out of the company solidify that our decision to choose Birst was the best possible choice. We have never regretted the decision.
    Read full review
    Informatica
    As pointed out earlier, due all the robust features IDQ has, our use f the product is successful and stable. IDQ is being used in multiple sources (from CRM application and in batch mode). As this is an iterative process, we are looking to improve our system efficiency using IDQ.
    Read full review
    SAP
    Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.
    Incentivized
    Read full review
    Usability
    Infor
    I would like to see additional usability put into the ETL scripting. Recently, Birst added a nice function reference inline to formula creation which has kept me from having to return to documentation so much. The same in ETL would be very beneficial. The interface problems related to the Flex framework are being addressed in a rewrite to HTML 5, but for now they are still a hindrance to a higher usability rating.
    Read full review
    Informatica
    Easy to use not only for developers but also business users
    Incentivized
    Read full review
    SAP
    Well-suited in the security domain, high performance, and low latency of the DBMS. In terms of the DBA perspective, a dedicated monitoring tool (Cockpit) helps a lot in terms of managing the database, which helps in identifying bottlenecks during performance issues. Also, it helps us to send custom alerts related to Database activities.
    Incentivized
    Read full review
    Reliability and Availability
    Infor
    We frequently experience -103 errors due to us using the Live Connect functionality, which does not seem to handle even minor interruptions in connectivity, and treats all future connection attempts or data requests as errors, even if the issue does not exist any longer
    Read full review
    Informatica
    The application works well except an occasional error out while using the system. It usually gets fixed when restarting the Infa server
    Incentivized
    Read full review
    SAP
    No answers on this topic
    Performance
    Infor
    Everything runs very fast and smoothly. The only process that I wish was faster would be processing the data after uploading new data or making changes to the existing data model. It can take 15-20 minutes (roughly) to upload and process new data once you start getting into 10's of millions of rows. Given my experience with how long it takes me to pull the same data using SQL Server Management Studio, I don't think Birst is unreasonably slow - but for me to give a higher rating, I would want it to be unreasonably fast
    Read full review
    Informatica
    Performance works just fine. It was able to load 200+ business terms, 150+ DQ automation, etc. very well.
    Incentivized
    Read full review
    SAP
    No answers on this topic
    Support Rating
    Infor
    • Poor turnaround time
    • Low response rate when the problem at hand are large
    • Lack of infrastructural knowledge when it comes to scaling solutions
    • Lack of inter team work noticed
    • Most of the tickets are open for a long period of time
    Incentivized
    Read full review
    Informatica
    No answers on this topic
    SAP
    Incredibly responsive, saving us countless hours in troubleshooting.
    Incentivized
    Read full review
    In-Person Training
    Infor
    I have attended two different training sessions. The first one was my initial training on the system. It was well paced, clear and concise. If there were questions that were not able to be answered by the instructor, he took down the question and actually followed up and provided us a response quickly. The second session was specific to the dashboard and report design components. This training was very good though there were some attendants who had little or no experience and their questions slowed the class.
    Read full review
    Informatica
    No answers on this topic
    SAP
    No answers on this topic
    Online Training
    Infor
    Although I found the online resources helpful, a lack of appropriate examples for certain tasks key to report creation and advanced modeling make the online training/documentation less than perfect. For an inexperienced BI professional, the online training would not enable a streamlined launch of the product.
    Read full review
    Informatica
    No answers on this topic
    SAP
    No answers on this topic
    Implementation Rating
    Infor
    Have clean data! Birst flexibility allows - Start small, then introduce functionality and complexity along the way. If you try to present all the functionality [bells and whistles] and wow them, but bad data is uncovered, the end user blames the new application and turns away.
    Read full review
    Informatica
    No answers on this topic
    SAP
    No answers on this topic
    Alternatives Considered
    Infor
    Birst was better than Domo for our needs because we could get in and tinker with it. Our impression of Domo was that it had a lot of connectors and ready to go reports, but it made too many assumptions about applications we use. We customize too much to use a "ready to go" solution like that. When we looked at Tableau, we liked its visualization capabilities, but it wasn't going to help us do the extractions, ETL, and warehousing of data. It may have come some distance since then.
    Incentivized
    Read full review
    Informatica
    IDQ is used by a department at my organisation to ensure and enhance the data quality.
    The usage was started with address standardization and now it had been brought to altogether a next level of quality check where it fixes duplicates, junk characters, standardize the names, streets, product descriptions.
    In the past we had issues mainly with duplicate customers and products and this were affecting the sales projection and estimates.
    Read full review
    SAP
    Incentivized
    Read full review
    Scalability
    Infor
    we can see that loading a lot of data can cause a noticable slow down in performance. Birst support indicated that they don't really consider anything less than 30 seconds to be an issue, but that is not the case for our customers, so we have had to change some of implementation to address this
    Read full review
    Informatica
    Scalability works as expected and it is truly an enterprise system.
    Incentivized
    Read full review
    SAP
    No answers on this topic
    Return on Investment
    Infor
    • Being a manufacturing company we tend to lag behind technologically. But having all the data for different ERP systems in one place has been an eye opener for the executives. It has lessened the need to convert some legacy ERP systems.
    • Having such a simple reporting tool is a great asset to some of our sites that have traditionally had trouble gathering data from AS400 systems.
    Incentivized
    Read full review
    Informatica
    • Integration with tools like PowerCenter helped faster delivery of product, and at the same time conversion
    • Reduce overall project cost due to bad data , bad quality, exceptions identified nearing go-live and post production
    • Employee efficiency is increased exponentially due to more automated, customized tool
    Read full review
    SAP
    • Positive ROI.
    • Ease of use with minimal training required to write high performance SQL (assumes a knowledge of SQL already).
    • Ease of database administration.
    • Sometimes upgrades can be difficult.
    • Changing platforms can be difficult (changing say from SPARC to Intel).
    • Changing operating systems can be difficult (changing from Solaris to linux).
    Incentivized
    Read full review
    ScreenShots

    Infor Birst Screenshots

    Product screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshot