Find out what your peers are saying about Oracle, Micro Focus, Teradata and others in Data Warehouse.
279,075 professionals have used our research since 2012.
Find out what your peers are saying about Oracle, Micro Focus, Teradata and others in Data Warehouse.
279,075 professionals have used our research since 2012.
Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score. The score is calculated as follows: The product with the highest count in each area gets the highest available score. (20 points for Reviews; 16 points for Views, Comparisons, and Followers.) Every other product gets assigned points based on its total in proportion to the #1 product in that area. For example, if a product has 80% of the number of reviews compared to the product with the most reviews then the product's score for reviews would be 20% (weighting factor) * 80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our rating scale of 1-10. If a product has fewer than ten reviews, the point contribution for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews; two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old, as well as those written by resellers, are completely excluded from the ranking algorithm.
Most Views
From IT Central Station visitors
Most Followed
By IT Central Station users
Most Compared
From IT Central Station visitors

What is Data Warehouse?

A Data Warehouse, sometimes categorized as an Enterprise Data Warehouse, (DW or DWH) is a data analysis and reporting system. Data Warehouses are fundamental storehouses of integrated data from single, or multiple sources, storing historical or current data in one location where data is utilized, creating reports for designated Enterprise users.

A DW is considered an integral component of business intelligence and describes a system used to analyze an organization's raw data. The Data Warehouse oversees the performance of a business database and monitors its agility when loading and retrieving data.

IT professionals on IT Central Station have certain core requirements when looking at the integration of a Data Warehouse. Some of these include which analytical capabilities are supported. For example, support of SAP HANA is viewed as a plus because it has necessary, analytical layers built within the Data Warehouse.

Other important criteria include the variety of supported data, structured and unstructured, and how they co-exist among various big data solutions. There are options where a Data Warehouse would have the capability to integrate or support other data management solutions. The inclusion of ETL tools, with extensibility, is always a preference in the Data Warehousing solution.

Some IT and DevOps professionals see Data Warehousing address both business and technical requirements because of the evolution from high-powered databases, with storage locally or in the cloud, (enhanced storage) to significant Enterprise information management solutions. Certain warehouse data is transferred from dedicated systems, such as Sales or Marketing. Data may be cleansed to ensure the quality of data before using it for reporting purposes.

Hence, ease of using in finding and retrieving data is essential. For Data Warehousing, IT and DevOps are focused on the total cost of ownership, scalability and performance features such as in-memory architecture, and row-based optics versus columnar or parallel processing. Storage optimization is key for data compression capability and caching. Of course, security and compliance for regulated organizations need support for data access control, masking, and auditing.


Best Data Warehouse Solutions, Comparisons and Vendors

Read reviews of Data Warehouse that are trending in the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
Real User
Applications And Database Operations Manager at a tech services company with 51-200 employees
Jun 14 2017

What is most valuable?

* Backup/Restore performance: Fast backups, fast restores. * Decrease in I/O. * Decrease in database size and decrease in I/O: Due to Exadata specific compression techniques, database size decreases. In addition, the amount of I/O that is... more»

How has it helped my organization?

We have implemented Oracle EBS on Exadata several times. We mostly used Exadata as the data layer. The most significant gain was in the area of performance. Performance increased significantly both for OLTP and batch works. In addition to the... more»

What needs improvement?

Product specific documentation is satisfactory, but the interoperability documents should be improved. For example, there should be a step-by-step installation document for installing EBS on Exadata. Similarly, the documentation should be... more»
Real User
Database Architect at a tech services company with 1,001-5,000 employees
Jan 11 2017

What is most valuable?

Exadata has been very great for us in terms of database consolidation. We have been using Exadata because we have been upgrading our technology every single year. In the past, we were using a Sun server and managing that as an active-passive... more»

How has it helped my organization?

The high availability of the database improved a lot. Our customers who are using it seem to be very happy with the response times. We also have a hot standby in case you need to migrate or do an upgrade. Overall, the company itself was very... more»

What needs improvement?

The mix and match of hardware is always a problem. If you start with a product here and you want to migrate it two years later, you don't get the same version of the hardware. It's always different when you mix and match hardware. For... more»
Find out what your peers are saying about Oracle, Micro Focus, Teradata and others in Data Warehouse.
279,075 professionals have used our research since 2012.
Micro Focus
Real User
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees
Jun 23 2016

What is most valuable?

I have found great use out of many features, most notably the Management Console and the Database Designer. Many people with lots of experience creating table projections can get frustrated trying to optimize some complex queries, however, in... more»

How has it helped my organization?

The fast columnar store database structure allows our query times to be at least 10x faster than on any other database. This enables us to get answers to data questions as well as numerous analytics on our data out to our internal and... more»

What needs improvement?

Documentation has become much better, but can always use some improvement. Love the tech support, but hoping Micro Focus will invest in some additional training for the Level 1 responders so they are much more familiar with more areas of the... more»
Consultant
Technical Director at a consultancy with 51-200 employees
Jun 18 2018

What is most valuable?

We primarily run OLTP with some reporting. With that being said, the feature that provides us the most performance gains is the Smart Flash Cache for the OLTP databases. The "offloading" capabilities provide the biggest performance gains for... more»

How has it helped my organization?

We have a number of statistics collected before cutover on our legacy environment compared to Exadata. Without doing anything other than copying the data across, we saw significant performance gains for most key processes. We receive feedback... more»

What needs improvement?

My biggest gripe has been patches which has dramatically improved since our initial Exadata was delivered (January 2011). The only issues we periodically experience are with non-default RPMs on the database nodes. These may fail during the... more»
Consultant
DBA at a consultancy with 1,001-5,000 employees
Dec 22 2016

What is most valuable?

The number one feature is the speed; it's InfiniBand. We're serving almost 3.2 million people; it's an eligibility system. We add on 80 TB of data that needs to be churned and processed. Previously, we used Sun Solaris, and then we moved to a Windows platform. It was really bad. We started the load on Tuesday, and sometime around noon on Wednesday it finished.... more»

What needs improvement?

Pretty much whatever we need from the database side, it is there. There are specific things from the application side. I do not have a list; they do have a list of what you can't see from the database side. Pretty much what we are looking for is part of the 12c that is coming out. Most developers are used to Microsoft .NET and SQL Server. We are all cutting out... more»
Consultant
Managing Director at a tech services company with 1,001-5,000 employees
Jun 17 2017

What is most valuable?

Stability, high ROI and low TCO. Plus performance, of course. Being able to compress the data, especially in big size databases, has been extremely useful as HCC can deliver quite high compression rates. The business benefits of OES are as... more»

How has it helped my organization?

In the past, Infrastructure units were mostly organized in teams like the Database team, the Storage team, the Backup team, the Unix team, the Monitoring team, etc. Now, with Exadata, they have become sort of obsolete. Only one unit is needed... more»

What needs improvement?

The Initial investment price could use improvement. It is often the stumbling block. Many organizations have limited or small budgets for the initial investment. This has somehow changed with X5 when the entire Exadata configuration no longer... more»
Kognitio
Real User
ETL Developer at a music company with 501-1,000 employees
Jun 27 2017

What is most valuable?

* Slabs and memory management * Users' privileges management * Real time monitor: performance charts and graphs * WX2 Console's "Analyse Problem Queries" * Multi Parallel Processing capability: able to specify number of threads to use, number... more»

How has it helped my organization?

Analysts were able to develop complex queries and analyse huge amounts of data returned, in the same breath, as how one would define big data; within minutes if not seconds.

What needs improvement?

Although they already have patches to address the instability of CORV (Create or Replace Views) CASCADE, I believe this is the area that should receive most attention. I am, however, still not sure if the patch has officially been recognised... more»
Real User
Senior DBA at a tech services company with 1,001-5,000 employees
Nov 22 2016

What is most valuable?

Its most valuable feature is the smart scan functionality. It allows for the queries to work faster. It offloads the stuff to the cell server, so it provides better performance.

How has it helped my organization?

I like the consolidation of all the components in one feature. I like the fact that it's very specialized and you can go ahead and utilize it, out of the box. It is intuitively different than a normal database solution; you have to actually... more»

What needs improvement?

A lot of the extra features they're adding are wonderful, but they're always putting a price on it, for example, the in-memory thing. For certain things, such as Exadata, we're going to stay with on-premises because of regulations. It feels... more»
Consultant
Technology Lead at a tech services company with 1,001-5,000 employees
Aug 31 2017

What is most valuable?

The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution. It's two things: * Highest performance on query. This is very notable. Let's say, yesterday I was doing some of the... more»

How has it helped my organization?

Instead of having a PNO process at the end of the day, which was running forever (six hours) I moved the process into SAP IQ. Now, I am giving real time, or near real time, PNO. The portal runs for four minutes, rather than running for six... more»

What needs improvement?

Yes. The room for improvement would be the marketing of the product, because this product is much better than advertised. One of my colleagues was working with Adobe, where the Product Management team was using Hadoop. Hadoop was doing a... more»
Real User
CEO
Mar 18 2018

What is most valuable?

HDFS and Kafka: Ingestion of huge volumes and variety of unstructured/semi-structured data is feasible, and it helps us to quickly onboard a new Big Data analytics prospect.

How has it helped my organization?

Initially, with RDBMS alone, we had a lot of work and few servers running on-premise and on cloud for the PoC and incubation. With the use of Hadoop and ecosystem components and tools, and managing it in Amazon EC2, we have created a Big Data... more»

What needs improvement?

Based on our needs, we would like to see a tool for data visualization and enhanced Ambari for management, plus a pre-built IoT hub/model. These would reduce our efforts and the time needed to prove to a customer that this will help them.
Real User
Lead Business Intelligence Analyst at a logistics company with 1,001-5,000 employees
Mar 19 2018

How has it helped my organization?

The big benefit that we've had is, in the past with the legacy data warehouse solution, we've been limited to having just a nightly batch, running on SQL Server. It's a slower batch process, so throughout the day we would be limited to stuff that happened as of some time in the evening. So the benefit is really because of the additional speed that we have and,... more»
Micro Focus
Consultant
Vertica Database Architect at a tech consulting company with 51-200 employees
Jun 23 2016

What is most valuable?

* Speed * Parallelization * SQL language * High Availability

How has it helped my organization?

I have seen queries that take over 24 hours on MS SQL Server to complete, complete in less than 10 minutes on Vertica. I have seen queries that take several minutes, up to an hour, on MS SQL Server, complete in less than 10 seconds, sometime... more»

What needs improvement?

While the documentation is very extensive and relatively complete, it’s poorly organized and there are way too few examples. It’s come a long way since the first version I saw, but it still has a long way to go. Plus, there is very little... more»
Real User
Business Intelligence Solution Architect at a financial services firm with 5,001-10,000 employees
Jan 30 2018

What is most valuable?

High performance RDBMS appliance optimized for data warehousing and enterprise reporting. Very simple to manage huge volumes of data without having to worry about indexing and partitioning. Automated compression of tables without any custom... more»

How has it helped my organization?

Reports which used to take between 30 to 60 minutes or would time out on an Oracle database, which was previously used for the enterprise DWH, now run consistently in seconds or in less than five minutes.

What needs improvement?

Could do better to support more concurrent update queries. We had to stagger our ETL.
Micro Focus
Consultant
Associate at a tech services company with 501-1,000 employees
Sep 14 2016

What is most valuable?

The biggest, most valuable feature for us is the clustering aspect with a share-nothing mentality. Most clusters usually require their own shared storage, shared subnet, etc. and this becomes a pain and a nightmare to maintain. The second... more»

How has it helped my organization?

Loading raw data and leveraging column store to quickly aggregate the values as well as run a general analysis were the biggest improvements we found. Before, we had to scrub the data or reformat, load it, possibly scrub it some more, and... more»

What needs improvement?

Developer Tools - Vertica really needs some kind of IDE plugin for a system such as Eclipse or IntelliJ. Developing external functions in Vertica can kind of be like shooting in the dark sometimes. Also, an improved monitor or monitoring with... more»
Real User
Technical Support Unit
Dec 03 2017

What is most valuable?

In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution.

How has it helped my organization?

We had been using a separate server, separate storage, and a separate switch for our Oracle Database, which was costing us a lot of money, because you have to have licenses for each of those devices. But now we have all of them in just one... more»

What needs improvement?

Currently in Ghana, where I work, there are just a few companies that can afford it, because the price is a little bit high. Even though for the private sector it's not that high, if this would come in much smaller boxes, and much cheaper, it... more»
Consultant
Head of Oracle Exadata Centre of Excellence at a tech services company with 1,001-5,000 employees
May 11 2018

What is most valuable?

Ksplice, Prevalidated Oracle RPMS , the testing done with Oracle database and weblogic and the UEK kernel have made Oracle linux systems best for running large oracle databases and other packaged applications.

How has it helped my organization?

Ability to patch with no downtime and the ability to ensure all the prerequisites are satisfied without manual interventian saves time and effort and makes systems we deploy for our clients more secure. Licensing costs too are less for Oracle... more»

What needs improvement?

we do have a little trepidation with systemd as it does have a learning cirve . Also changing o a binary logging format for us feels like retrograde motion , but sadly almost all linux varients have moved in this direction.
Real User
Senior DBA and Architect at a tech services company with 501-1,000 employees
Aug 16 2016

What is most valuable?

The system is engineered to run both databases and enterprise applications unlike other engineered systems, which are either tailored only for databases or only for applications. The ability to consolidate all of the databases is a big plus.... more»

How has it helped my organization?

With SuperCluster and Exadata, all of the servers and storage are integrated within the same rack. This reduces the configuration and setup time, increases performance, and makes maintenance and patching easy. We are able to consolidate all... more»

What needs improvement?

In the area of Solaris zone-level virtualization, it would be good to have memory capping as a tool for memory management. Currently for 11g databases running on Exadata with smart scan against hybrid columnar compressed (HCC), tables could... more»
Micro Focus
Real User
Senior Data Warehouse Architect at a media company
Jun 24 2016

What is most valuable?

Storage abstraction through projections. It gives you the possibility to react to any kind of query with an optimal performance. The Workload Analyzer helps you easily to analyze your database workloads and recommends tuning opportunities to... more»

How has it helped my organization?

We are now able to procde real-time insights into our tracking data, and with that show how our customers are using the products that we have. Furthermore, it is now possible for our Data Science department to easily, and quickly train their... more»

What needs improvement?

I would love to see direct connections to other DMSs. Something like a direct connector to Oracle, MySQL, MS SQL, MongoDB, etc. so that you can copy data between Vertica and other vendors directly and more easily without an ETL tool, dump,... more»
Ignite Technologies
Real User
Senior System Architect - Resiliency Engineering at a comms service provider with 10,001+ employees
Dec 05 2017

What is most valuable?

A valuable feature was the use of a columnar database for large, ever-growing, big datasets. It also have very amazing smart grid query feature for very fast aggregate queries across millions of rows

How has it helped my organization?

When working properly, the ability to continually insert large datasets, millions of records per minute, while simultaneously querying the same data tables, was very impressive. But it almost never was able to run continually without errors.

What needs improvement?

This version of Infobright has zero support for distributed scalability. The internal smart grid employed for each table has a major flaw in that the data size cannot be expunged until 2GB of data is reached at the column-level. This is a... more»
Real User
Statistics Analyst at a government with 1,001-5,000 employees
Apr 06 2017

What is most valuable?

Workload offloading to the cell layer : Exadata is Oracle's engineered system which SW and HW are compatible and contains many layers (compute nodes – networking – storage or cells), so compute nodes receives request or transactions then... more»

How has it helped my organization?

* Exadata accelerates the performance to whole applications in the environment at least by 2-3x times than the old hardware. * One consolidated environment for all Oracle databases.

What needs improvement?

* The integration between Exadata and Enterprise Cloud Manager should be included out of the box by default and should be agent-less, just discovery only; or, add an embedded and dedicated monitoring and management UBI tool for all HW and SW... more»
Find out what your peers are saying about Oracle, Micro Focus, Teradata and others in Data Warehouse.
279,075 professionals have used our research since 2012.

Data Warehouse Articles

Content and Community Manager
IT Central Station
Which data warehouse tools are users most satisfied with? What do BI analysts and big data professionals need to consider when choosing an ETL tool?  With all the software options on the cloud computing market, which data warehouse tools are users most satisfied with? At IT Central Station,... more»
1,170

2
Head of Oracle Exadata Centre of Excellence
I love technology ... I love opening up stuff and fiddling with the guts. I don't promise that I can put everything back together again or that it will work if I do but as the chinese proverb goes it is better to travel hopefully than to arrive....
3,582

5
TOP 5POPULAR
Technical Director
With over 17 years of professional IT experience, Chris is a certified expert in managing and implementing technology solutions resulting in optimized and scalable operational environments. In one role, he provided direction of daily operations while managing special projects to include: data... more>>
3,349

5
TOP 5POPULAR
An experienced and ambitious BI Lead, with experience in the Financial Services and Technology industries. With advanced analytical skills developed in Banking & Insurance, coupled with leadership of data warehousing programmes. I specialise in transforming information into value adding... more>>
3,496
Siempre innovador! Empresario, con la mirada fija en cumplir mis metas siempre ayudando a los demás y compartiendo conocimiento.....con el afán de hacer crecer el Software Libre en el país... Experto en Inteligencia de Negocios, Data Warehousing y Big Data
Reviewed Vertica: A Good Option for Big Data
294
Experience in design, development and deployment of applications build on Client/Server Systems, Data warehousing ,Big Data,Business Intelligence applications. Extensive experience Knowledge on MPP database including Netezza Twinfin/Striper Appliance,Teradata and AsterData. Good experience... more>>
780
Owner - Consultant
Oracle DBA with more than 15 years of experience in technical leadership, computer technologies and critical missions. Expertise in Oracle Database Management and setup, high availability, critical recovery scenarios, server and application tuning. Proven advanced diagnostic abilities.... more>>
Reviewed Oracle Database Appliance: It’s very easy to deploy. Once received, you can...
36
TOP 5
Professional Services Senior Consultant
• Más de 24 años de experiencia en Consultoría, de los cuales los últimos 14 años he trabajado en Teradata Iberia SLU. • Profundo conocimiento en bases de datos y Teradata Data Warehouse, en particular en implantaciones Teradata para Industrias de Telecomunicaciones, Retail y... more>>
1,889
Managing Director
Julian Dontcheff is a Managing Director at Accenture and has more than 25 years of database experience (Oracle v4 -->). He is the first Oracle Certified Master in Europe (back in 2002) and he is also an Oracle ACE Director.
1,615
Enterprise DWH Architect - Oracle ACE Director
• Honored as Oracle ACE Director on Business Intelligence expertise. • Awarded as Oracle Excellence Awards, Technologist of the Year 2011 : Enterprise Architect. (formerly known as - Oracle Magazine's Editors' Choice of Awards : Enterprise Architect of the Year 2011) • Presented at Oracle Open... more>>
1,108
TOP 5
Technical computer science engineer. Nowadays DW and BI consultant with 5 years experience in Data Warehousing and Business Intelligence. Good knowledge in processes of a BI/DW project. Specialties:Designing, developing and maintaining data marts. Design and build ETL processes, OLAP... more>>
45
Creative and proactive approach of work distinguishes me. Whenever I solve a task, I try to follow the principles: - To minimize defects and improve the quality - To seek every day a new more effective approach to work - To communicate issues on early stage
721
Nitin Vengurlekar is the co-founder and CTO of Viscosity North America, a leader in virtualization, Oracle Engineered Systems, Private Database Cloud and RAC implementations. At Viscosity Nitin is responsible for partner relationship and end-2-end solution deployment. Prior to joining... more>>
384
Team Leader of I&O Team in Bridge Consulting (Florence, Italy). Main activities: project management, coordination/planning, installation/problem solving. Trainer of new colleagues. Everyday involved with big customers such as Gucci, Unicoop Firenze, Ferragamo and so on. Oracle CAB: 2014... more>>
1,034
TOP 5
Professional Experience: * Greenplum Database handling * Greenplum Database design * Agile and Scrum * Data-modeling * MPP Database * Worked with companies to set up a Database Development and a Web design portal * Base frame work for a R Route Firewall * Advance leveler for Ad-hoc... more>>
16
Software Architect
Understand the depth and complexities of eCommerce applications and platforms for data-intensive processing, engineering efficiency (turn-around time, design philosophy, architectural acumen, operational efficiency, et al.) and modernization. Architected eCommerce applications for platform... more>>
1
TOP 5
Database/Middleware Consultant (Currently at U.S. Department of Labor)
Working experience in the areas of Technical Architecture, Solutions Management, Database Administration and Oracle Fusion Middle-ware Administration by providing proactive Configuration, database management, database design, development, security change/release management, performance tuning and... more>>
37
Teradata DBA / Parallel datawarehouse DBA
Subramanian Kaushik Gurumoorthy is a Senior Database Administrator with 8 years and 3 months of experience in Banking, Financial Services, retail and Insurance Domain. He has an in-depth knowledge in Database administration activities with Teradata / Parallel data warehouse. He has also exposure... more>>
Reviewed Microsoft Parallel Data Warehouse: Concurrency issues forced the customer to use the...
5
TOP 10
Associate Consultant
Mr. Cifuentes has a 40 year experience in a wide range of Information Technology areas. He has been involved in Unix Support as well as in the architecture, design and implementation of different types of applications, ranging from messaging systems to data warehouses. His education includes an... more>>
3,841
TOP 20POPULAR
 Passionately believe that Information Technology provides the best opportunity to improve the competitive advantage be it from reduced operating costs, improved communications, better and consistent information, reliable and accurate source of data or improving research and fostering growth in... more>>
Reviewed Oracle Exadata: It's not "one size fits all"
664
Technology Architect
Expertise in designing & developing solutions in Greenplum which is a distributed and massively parallel processing (MPP) database engine. Expertise in performance tuning Greenplum design for extracting best performance leveraging MPP capabilities. Expertise in data modelling (Conceptual,... more>>
3,539
TOP 20POPULAR
Senior business Intelligence consultant
Freelance MicroStrategy Professional. Author of the book: "Business Intelligence with MicroStrategy" I've been doing Business Intelligence projects with MicroStrategy and SQL Server/Oracle for the last 10 years now. I have experience in several sectors including Healthcare, Agriculture and... more>>
1,695
Founder and President
Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, Certified Exadata Specialist, and a Certified RAC Expert. Charles specializes in RAC, and Virtualization and authored 7 books: 1. Oracle Database 11g New Features for DBA and Developers 2. Linux... more>>
1,368
Business Intelligence Consultant
Experienced Business Intelligence specialist with diversified knowledge and expertise in maintaining analytical environments, providing technical support and creating solutions in alignment with business targets. Technological experience in diversified business areas: Entertainment,... more>>
96
Technology Consultant (Netezza/Big Data)
Varun is an astute professional with 7+ years’ of qualitative experience in the areas of Big data processing, ETL/ELT, data visualization, massive parallel processing (MPP), effective data storage, server monitoring (Netezza). Varun comes with vast exposure in Client handling and Onsite... more>>
171
Management Consultant
Program Manager, R&D, Microsoft Corporation Director, Search Business Consulting, Fast Search & Transfer ASA. Specialties: Product innovation & development, business development, and search technology

Sign Up with Email