Infobright DB vs Microsoft Parallel Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Infobright DB and Microsoft Parallel Data Warehouse based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
To learn more, read our detailed Data Warehouse Report (Updated: March 2024).
763,955 professionals have used our research since 2012.
Q&A Highlights
Question: Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
Answer: I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It has very amazing smart grid query feature for very fast aggregate queries across millions of rows"

More Infobright DB Pros →

"Tools like the BI and SAS are excellent.""The most valuable features are the performance and usability.""It is not a pricey product compared to other data warehouse solutions.""​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​""I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.""The solution's integration is good.""The most valuable feature of this solution is performance.""The solution has been reliable."

More Microsoft Parallel Data Warehouse Pros →

Cons
"Only the data from the columns that reached 2GB will actually decrease. Other columns below 2GB in size do not leave the disk."

More Infobright DB Cons →

"I think that the error messages need to be made more specific.""We find the cost of the solution to be a little high.""I would like to see better visualization features.""SQL installation is pretty tricky. The scalability and customer support also should be improved.""I would like the tool to support different operating systems.""Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.""I would like the ability to do more real-time type updates instead of batch-oriented updates.""In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."

More Microsoft Parallel Data Warehouse Cons →

Pricing and Cost Advice
  • "Our pricing was based on server instances and it was actually very cheap compared to Oracle. I guess you get what you pay for."
  • More Infobright DB Pricing and Cost Advice →

  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Answers from the Community
    Anonymous User
    it_user3309 - PeerSpot reviewerit_user3309 (Presenter at a consultancy)
    Consultant

    You are asking about front end tools but you do not mention which ones. What you have are "database backends" and each has different features. The utilization will depend on what kind of expertise you have available else you will end up trying to implement say, Teradata on Exadata which may not give you the best solution. What are your criteria for success? Based on these you will have to evaluate each solution -- I am sure each vendor will be happy to set up the environment and work with your set of sampl,e data to show you have they evaluate against your criteria.

    it_user89046 - PeerSpot reviewerit_user89046 (Sales at a tech vendor with 1,001-5,000 employees)
    Real User

    Given we partner with many or all of the above, or can get to them as we access all data, I have the following opinion - InfoBright is very new and probable to be sold long term. It is also an expensive subscription so presents highest risk to me. Exidata is Oracle - if you like Oracle and their style, it maybe ok, but then it is Oracle. Microsoft is Microsoft - tends to be cheap to acquire and expensive to implement and maintain. Teradata is pricey but of the group presents the least risk and the greatest number of front end partners. The product I represent is unique as it is designed for high complexity large numbers of users and data and runs inside Teradata taking better advantage of the architecture.

    Disclosure: I work for Information Builders

    Questions from the Community
    Ask a question

    Earn 20 points

    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    Ranking
    27th
    out of 33 in Data Warehouse
    Views
    64
    Comparisons
    48
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    8th
    out of 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    Comparisons
    Also Known As
    Infobright
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview

    Infobright's high performance analytic database is designed for analyzing large volumes of machine-generated data

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    Sample Customers
    REZ-1, SonicWALL, IntegriChain, Fuseforward International Inc., Polystar, Live Rail, Mavenir Systems, JDSU Partners, Bango
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Top Industries
    No Data Available
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    Company Size
    REVIEWERS
    Small Business70%
    Midsize Enterprise10%
    Large Enterprise20%
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    Buyer's Guide
    Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Infobright DB is ranked 27th in Data Warehouse while Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 12 reviews. Infobright DB is rated 7.6, while Microsoft Parallel Data Warehouse is rated 7.6. On the other hand, the top reviewer of Microsoft Parallel Data Warehouse writes "User-friendly UI and good support". Infobright DB is most compared with MySQL and LocalDB, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum.

    See our list of best Data Warehouse vendors.

    We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.