<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
50 Ratings
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8 out of 100

SingleStore

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100

Attribute Ratings

  • SingleStore is rated higher in 2 areas: Likelihood to Recommend, Support Rating

Likelihood to Recommend

7.0

SAP Manufacturing Integration and Intelligence

70%
2 Ratings
9.2

SingleStore

92%
34 Ratings

Likelihood to Renew

SAP Manufacturing Integration and Intelligence

N/A
0 Ratings
10.0

SingleStore

100%
3 Ratings

Usability

SAP Manufacturing Integration and Intelligence

N/A
0 Ratings
7.5

SingleStore

75%
6 Ratings

Performance

SAP Manufacturing Integration and Intelligence

N/A
0 Ratings
9.3

SingleStore

93%
8 Ratings

Support Rating

6.2

SAP Manufacturing Integration and Intelligence

62%
4 Ratings
7.7

SingleStore

77%
6 Ratings

Likelihood to Recommend

SAP

SAP Manufacturing Integration and Intelligence as a stand-alone platform seems to be quite powerful with a wide range of capabilities and integration options. The integration itself proved to be challenging which was mentioned before. We also had some issues with delays in data queries which resulted in delays of the visual representation on the SSCE dashboards.
Read full review

SingleStore

SingleStore environment is easy to adapt, it is extremely fast on collecting data from different sources (AWS, GCP or Azure), provides monitoring of activities and easy use multiple databases. It is good for analytical and recommendation based scenarios, and provides fast results on complex queries. In SingleStore platform queries execution open new tab result for each run, which makes it difficult to navigate over the results.
Read full review

Pros

SAP

  • MII is particularly good at providing and customizing dashboards for quick analysis of industrial IoT data.
  • MII also has built-in analysis functionality to make more sense of all the IoT data being streamed.
  • MII (and ME) are particularly effective at identifying outliers and problems with equipment/processes before they cause delays or other cascading issues. This allows for effective preventative maintenance.
Read full review

SingleStore

  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
Read full review

Cons

SAP

  • Using the plant connector and setting up a proper stable connection proved challenging.
  • Defining the tags and subscription aliases in the workbench took a lot of time.
  • Documentation is somewhat outdated and difficult to come by.
Read full review

SingleStore

  • We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
  • More tools for debugging issues such as high memory usage would be good.
  • The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.
Read full review

Pricing Details

SAP Manufacturing Integration and Intelligence

Starting Price

Editions & Modules

SAP Manufacturing Integration and Intelligence editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    SingleStore

    Starting Price

    $69 per hour

    Editions & Modules

    SingleStore editions and modules pricing
    EditionModules
    OnDemand0.691

    Footnotes

    1. per hour

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    Optional

    Additional Details

    Pricing Info

    Likelihood to Renew

    SAP

    No answers on this topic

    SingleStore

    We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
    Read full review

    Usability

    SAP

    No answers on this topic

    SingleStore

    [Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
    Read full review

    Performance

    SAP

    No answers on this topic

    SingleStore

    I have used alot of ETL tools I have even built spark based ETL scripts but using singlestoreDB's PIPELINE function makes it all easy. Ingestion of data already present at file storage systems like S3 or GCS or Azure Blob is much much easier. The set-up of a pipeline is really is easy to do and you can even set it to run in intervals with the requirements of your system
    Read full review

    Support Rating

    SAP

    We required a bit of support setting this product up and as always the representative was both knowledgeable and helpful. The landscape we had (ME, PCo, ERP, MII, SolMan) made it a little more complicated and they were very good at finding the answers we needed. They also replied in a timely fashion. We have not needed any further support.
    Read full review

    SingleStore

    Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
    Read full review

    Alternatives Considered

    SAP

    SAP MII is a robust platform for data visualization and data integration. It isn't very intuitive and has the shortcomings explained throughout the review. It still uses old Java versions which is incompatible with updated versions. The SAP ME and SAP CP provide cloud-based solutions that seem to provide a more innovative approach.
    Read full review

    SingleStore

    Vertica, Snowflake, SQL Server, Azure Data Warehouse, PowerBI, Aerospike, etc. From what I've seen MemSQL is well worth the cost when latency and data freshness needs are high, i.e. you need a lot of queries to run with UI latency (the query itself takes less than a second or so), with very fresh streaming fact and dimensional data. It will be more expensive per "unit of performance" but if you need that performance then it'll get the job done.
    • On-prem Vertica (note, not Eon) provides more knobs for optimizing a particular data set and set of queries against it and performs as well or better in a single table, fact table queries. It will also scale to data size more cheaply due to its on-disk model. For large queries against large data sets where data freshness isn't as important (and latency either is or isn't), I'd take Vertica, although if you need to do a lot of joins that will struggle). However, as they still are exclusively columnar, dimension table updates, and recalls based on them, can only be tuned to happen so fast (we could do much better than 10 seconds with 10-100 updates per second for raw replication, and Vertica's joins are always slow so recalls were worse).
    • Snowflake suffers similarly to Vertica in the data freshness, replication, and re-calc area; SF also doesn't give as many knobs to turn as Vertica for data set optimization but seems to be better at joins. If you have a lot of queries to run against a lot of data and joins are limited, you need query latency low and consistent but you don't need a ton of freshness, I'd stick with Vertica. If joins matter more, or you can accept notably-but-not-terribly worse performance, then Snowflake is fine and cheaper from what we've seen. (Again, I can't speak to SF vs Vertica Eon).
    • SQL Server and ADW we couldn't get to perform as well as the other options, but I'll say we didn't try that hard on those.
    • Aerospike is amazing as a KV store; however for OLAP use cases where you want to balance performance against the flexibility of queries against general event (time series) data (i.e. be able to roll up to different grains) then KV becomes challenging.
    • PBI is great if you want an integrated BI tool, but if you want an OLAP solution to build against, with some particular scale or performance needs to be mentioned above, I'd go with one of these other solutions. It really can be great for letting non-tech folks build relatively small data sets and quick insights for customers (internal or external), great leverage in that case.
    Read full review

    Return on Investment

    SAP

    • SAP MII is a more robust, feature-rich solution than any in-house application would be.
    • Our experiments have granted us the skills necessary to help our clients with their own industrial IoT journey.
    Read full review

    SingleStore

    • As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
    • Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
    Read full review

    Add comparison