TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    S&P Capital IQ

    Score7.5 out of 10
    N/ACapital IQ is a market intelligence software solution offered by S&P Global Market Intelligence, which is the result of McGraw Hill Financial's acquisition of SNL Financial.N/A

    Elasticsearch

    Score8.5 out of 10
    N/AElasticsearch is an enterprise search tool from Elastic in Mountain View, California.

    $16

    per month

    Pricing
    S&P Capital IQElasticsearch
    Editions & Modules
    No answers on this topic
    Standard
    $16.00
    per month
    Gold
    $19.00
    per month
    Platinum
    $22.00
    per month
    Enterprise
    Contact Sales
    Offerings
    Pricing Offerings
    S&P Capital IQElasticsearch
    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
    S&P Capital IQElasticsearch
    Considered Both Products
    S&P Global Inc.
    No answer on this topic
    Elastic
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    82%
    Would buy again
    14 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    16 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    17 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    100%
    Lived up to sales and marketing promises
    13 Answers
    Implementation went as expected
    No answers on this topic
    87%
    Implementation went as expected
    13 Answers
    Features
    S&P Capital IQElasticsearch
    Financial Research
    Comparison of Financial Research features of S&P Capital IQ and Elasticsearch
    Feature
    S&P Capital IQ
    6.4
    3 Ratings
    14% below category average
    Elasticsearch
    -
    Ratings
    Private Company Data6.03 Ratings00 Ratings
    Industry-Specific Information7.83 Ratings00 Ratings
    Independent Research Access8.52 Ratings00 Ratings
    M&A Analysis5.33 Ratings00 Ratings
    Supply Chain Data5.01 Ratings00 Ratings
    ESG Data5.52 Ratings00 Ratings
    Credit Ratings Reports7.33 Ratings00 Ratings
    Macroeconomic News6.33 Ratings00 Ratings
    Search Tools6.23 Ratings00 Ratings
    Best Alternatives
    S&P Capital IQElasticsearch
    Small Businesses
    No answers on this topic
    Apache Solr
    Score7.9 out of 10
    Medium-sized Companies
    No answers on this topic
    IBM Watson Discovery
    Score9 out of 10
    Enterprises
    No answers on this topic
    Amazon CloudSearch
    Score8.5 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    S&P Capital IQElasticsearch
    Likelihood to Recommend
    7.1
    (10 ratings)
    9.0
    (48 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    10.0
    (1 ratings)
    Usability
    7.0
    (3 ratings)
    10.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    7.8
    (9 ratings)
    Implementation Rating
    -
    (0 ratings)
    9.0
    (1 ratings)
    User Testimonials
    S&P Capital IQElasticsearch
    Likelihood to Recommend
    S&P Global Inc.
    Cap IQ is well suited for analyzing security pricing and valuation, tracking stock performance over time, looking up comparable transactions, and analyzing valuations on an industry basis. The service is also well suited for charting and data analysis purposes.
    Incentivized
    Read full review
    Elastic
    Elasticsearch is a really scalable solution that can fit a lot of needs, but the bigger and/or those needs become, the more understanding & infrastructure you will need for your instance to be running correctly. Elasticsearch is not problem-free - you can get yourself in a lot of trouble if you are not following good practices and/or if are not managing the cluster correctly. Licensing is a big decision point here as Elasticsearch is a middleware component - be sure to read the licensing agreement of the version you want to try before you commit to it. Same goes for long-term support - be sure to keep yourself in the know for this aspect you may end up stuck with an unpatched version for years.
    Incentivized
    Read full review
    Pros
    S&P Global Inc.
    • On-demand reliable financial data either through the platform or through the Excel Plug-In
    • Great user interface, intuitive to use
    • Great help desk function, quick and responsive
    • Excellent auditability of financial data with easy traceback to source documents
    Incentivized
    Read full review
    Elastic
    • As I mentioned before, Elasticsearch's flexible data model is unparalleled. You can nest fields as deeply as you want, have as many fields as you want, but whatever you want in those fields (as long as it stays the same type), and all of it will be searchable and you don't need to even declare a schema beforehand!
    • Elastic, the company behind Elasticsearch, is super strong financially and they have a great team of devs and product managers working on Elasticsearch. When I first started using ES 3 years ago, I was 90% impressed and knew it would be a good fit. 3 years later, I am 200% impressed and blown away by how far it has come and gotten even better. If there are features that are missing or you don't think it's fast enough right now, I bet it'll be suitable next year because the team behind it is so dang fast!
    • Elasticsearch is really, really stable. It takes a lot to bring down a cluster. It's self-balancing algorithms, leader-election system, self-healing properties are state of the art. We've never seen network failures or hard-drive corruption or CPU bugs bring down an ES cluster.
    Incentivized
    Read full review
    Cons
    S&P Global Inc.
    • The scope and depth of the collected data can be increased.
    • The UI with little icons and buttons may be difficult at first but may become intuitive. The UI isn't horrible but might be better.
    • Global data coverage, but US and UK markets have the greatest details. MENA and APAC lack.
    Incentivized
    Read full review
    Elastic
    • Joining data requires duplicate de-normalized documents that make parent child relationships. It is hard and requires a lot of synchronizations
    • Tracking errors in the data in the logs can be hard, and sometimes recurring errors blow up the error logs
    • Schema changes require complete reindexing of an index
    Incentivized
    Read full review
    Likelihood to Renew
    S&P Global Inc.
    [It's the] best ever.
    Incentivized
    Read full review
    Elastic
    We're pretty heavily invested in ElasticSearch at this point, and there aren't any obvious negatives that would make us reconsider this decision.
    Incentivized
    Read full review
    Usability
    S&P Global Inc.
    S&P CIQ Pro has great data, however, the new pro version is currently difficult to use given how slow the data is to process
    Incentivized
    Read full review
    Elastic
    To get started with Elasticsearch, you don't have to get very involved in configuring what really is an incredibly complex system under the hood. You simply install the package, run the service, and you're immediately able to begin using it. You don't need to learn any sort of query language to add data to Elasticsearch or perform some basic searching. If you're used to any sort of RESTful API, getting started with Elasticsearch is a breeze. If you've never interacted with a RESTful API directly, the journey may be a little more bumpy. Overall, though, it's incredibly simple to use for what it's doing under the covers.
    Incentivized
    Read full review
    Support Rating
    S&P Global Inc.
    No answers on this topic
    Elastic
    We've only used it as an opensource tooling. We did not purchase any additional support to roll out the elasticsearch software. When rolling out the application on our platform we've used the documentation which was available online. During our test phases we did not experience any bugs or issues so we did not rely on support at all.
    Incentivized
    Read full review
    Implementation Rating
    S&P Global Inc.
    No answers on this topic
    Elastic
    Do not mix data and master roles. Dedicate at least 3 nodes just for Master
    Incentivized
    Read full review
    Alternatives Considered
    S&P Global Inc.
    We had Capital IQ in addition to Bloomberg. It was much easier for a new person to use Capital IQ than Bloomberg. The ease of use was a huge selling point for us. Yahoo finance on the other hand is free, but you cannot gather all the data you may need in one location like you can in Capital IQ.
    Incentivized
    Read full review
    Elastic
    As far as we are concerned, Elasticsearch is the gold standard and we have barely evaluated any alternatives. You could consider it an alternative to a relational or NoSQL database, so in cases where those suffice, you don't need Elasticsearch. But if you want powerful text-based search capabilities across large data sets, Elasticsearch is the way to go.
    Incentivized
    Read full review
    Return on Investment
    S&P Global Inc.
    • S&P Capital IQ contributes to a more comprehensive analysis of companies when making decisions on how best to market them to potential buyers.
    • S&P Capital IQ has enabled my company to be more efficient in learning about and valuing companies.
    • Due to the quality and reliability of information S&P Capital IQ has, it is saving my company large amounts of time.
    Incentivized
    Read full review
    Elastic
    • We have had great luck with implementing Elasticsearch for our search and analytics use cases.
    • While the operational burden is not minimal, operating a cluster of servers, using a custom query language, writing Elasticsearch-specific bulk insert code, the performance and the relative operational ease of Elasticsearch are unparalleled.
    • We've easily saved hundreds of thousands of dollars implementing Elasticsearch vs. RDBMS vs. other no-SQL solutions for our specific set of problems.
    Incentivized
    Read full review
    ScreenShots