TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    SAP IQ

    Score5.5 out of 10
    N/ASAP IQ (formerly SAP Sybase IQ) is a columnar relational database management system (RDBMS) optimized for Big Data analytics.N/A

    Valentina

    Score7 out of 10
    N/AValentina is a relational database software solution offered by Paradigma Software.N/A
    Pricing
    SAP IQValentina
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    SAP IQValentina
    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
    Best Alternatives
    SAP IQValentina
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    SingleStore
    Score8.2 out of 10
    Enterprises
    Db2
    Score8.6 out of 10
    SAP IQ
    Score5.5 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    SAP IQValentina
    Likelihood to Recommend
    8.0
    (3 ratings)
    7.0
    (1 ratings)
    Support Rating
    10.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    SAP IQValentina
    Likelihood to Recommend
    SAP
    Does data compression very well, produces query results very quickly, ability to scale up as data volume/size grow in an organization, row level versioning is in memory and hence the speed. It is a very stable product for large enterprises. More detailed documentation on how to use this product in the initial stages would be really welcome.
    Incentivized
    Read full review
    Paradigma Software
    If you have to manage a lot of different databases from different vendors, you could do well by standardizing on this product. It checks all the boxes for a proper database management studio. You would only have to learn one product to manage them all. However, if you are looking to find a good product for a single database vendor, you might be better off finding a tool that was designed specifically for that vendor product.
    Incentivized
    Read full review
    Pros
    SAP
    • Inserting millions of rows of data takes seconds.
    • Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).
    Incentivized
    Read full review
    Paradigma Software
    • Foreign Key Constraint data viewer! This was a tremendously helpful feature that not many other products have. Just pick a constraint and see the data in the child tables! No setup required!
    • Supports any and every database imaginable.
    Incentivized
    Read full review
    Cons
    SAP
    • The pricing schedule is a bit expensive and cumbersome.
    • Licensing for a virtual machine is difficult to understand.
    Incentivized
    Read full review
    Paradigma Software
    • Somewhat laggy performance. Boot up speed was on the slow side and connecting to our database servers was also a little slower than other products.
    • User interface can be a little clunky. Instead of the usual tree view of servers, databases, and schemas, you are presented with lists that you click on and get new windows to pick the new list of data from. Not organized efficiently.
    Incentivized
    Read full review
    Support Rating
    SAP
    SAP IQ support is top-notch. I prefer starting all my SAP IQ support tickets with their Instant Messenger, where the majority of our issues are resolved. If it makes it to their ticketing system, they are very prompt at responding and very knowledgeable in the platform.
    Incentivized
    Read full review
    Paradigma Software
    No answers on this topic
    Alternatives Considered
    SAP
    SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much faster in Sybase IQ and this gave the confidence to go for this product.
    Incentivized
    Read full review
    Paradigma Software
    Compared to Microsoft's SQL Management Studio, Valentina studio was comparable, just harder to get used to in the UI department. It ran slightly slower than other products but did save some time with neat features they baked into the product. However, in using DBeaver Community and DBForge Studio for PostgreSQL from Devart, we found different products that the team ultimately decided to use. DBeaver has all of the features we needed most (minus the constraint data viewer) and a more intuitive UI that we were used to. DBForge Studio for PostgreSQL has a very standard Windows look and feel and lacks some features, like database/table designers, but makes up for those shortcomings in the much easier filtering and sorting options right in the data grids. You can even write a query and edit the data returned, which is something we don't see in many of these tools. Our team ultimately settled on the developers using DBeaver and the support team that needs data viewing/editing capabilities using DBForge Studio.
    Incentivized
    Read full review
    Return on Investment
    SAP
    • The ROI over a number of years has been good. Seeing as how we use it for billing, it has an obvious ROI to us.
    • As they have been modifying their licensing structure, it's been difficult to keep up and understand how they work.
    Incentivized
    Read full review
    Paradigma Software
    • It saved time in some areas of finding child data by not having to write queries to find it.
    • The user interface caused some extra training for some users and ultimately caused them to not like using it.
    Incentivized
    Read full review
    ScreenShots