We changed our name from IT Central Station: Here's why
Get our free report covering Microsoft, Snowflake Computing, Oracle, and other competitors of Oracle Autonomous Data Warehouse. Updated: January 2022.
565,689 professionals have used our research since 2012.

Read reviews of Oracle Autonomous Data Warehouse alternatives and competitors

Sr. Teradata Consultant at a tech services company with 201-500 employees
Consultant
Top 20
Easily scalable with lots of features and good encryption
Pros and Cons
  • "Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
  • "The performance needs to improve in future releases."

What is our primary use case?

We primarily use the solution for analytic purposes. It allows us to store data for years and then go back and look up information to learn things like how users function, react, follow trends, etc. It allows us to follow past and recent demands for products as well so that we might be able to find the reasoning behind the action or trend.

What is most valuable?

With this solution, I can better understand buying patterns and user habits. I can tell in real-time a customer's review and purchase based on that. I can tell that from the cloud data of Azure Data Warehouse.

The solution offers a variety of different features.

There are two layers, so data storage and computation are separated.

For the customer, there aren't any storage limitations, so you are able to explore and size of data including megabytes and terabytes. Once you have stored the data you can analyze the data that if you have in order to write some complex queries. After that, the solution makes it possible to visualize that data itself. 

The computation makes it so that you can run scenarios without an impact on your storage location.

If you compare the product to other solutions, you'll notice it takes less time for less cost. All other vendors have different architecture so their pricing is a little bit different and they are charging pricing per second. Microsoft charges per unit, or DTU, Data Transfer Unit. It will charge based on how much data you are consuming and how much data you are doing transactions with. It is monthly not daily.

Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task.

The solution is consistently improving a lot of things, including security features. There are eight or nine different security features there. You can even encrypt your data.

What needs improvement?

There are features coming int he next few quarters that will be helpful. Soon, Power BI will be directly integrated into Azure. We need to have some Spark tools also available so we can directly select customers and don't need to install everything.

There will be features added that relate to application development. There's hopefully going to be more flexibility with the XML. Right now, for example, Data Warehouse is not able to give XML files and your file put is not correct. The feature will hopefully allow us to read XML.

The performance needs to improve in future releases.

We're hoping that Microsoft will add integration with the Amazon AWS platform.

For how long have I used the solution?

I've been using the solution for four years.

What do I think about the stability of the solution?

The solution is quite stable. We haven't had any issues with it in terms of experiencing bugs and glitches.

What do I think about the scalability of the solution?

Microsoft has different sizing options that comes at different price points. It's easy to scale up or down. If you find, after a few years, your needs are growing, you can increase your BTU size the maximum may be about 13,000. 

With this solution, we can actually automate scalability, which makes it very easy to scale. If you require more data, it will automatically increase your DP size and process the data. We have the flexibility we need so that, whenever a node gets filled, we never have to worry. Another node will pick up and process the data.

With Snowflake, in comparison, if your system is not running, then Snowflake will go into an auto suspend mode. You can sync the time, and, within the 10 minutes, if the system is not running, it will go to an automatic suspended mode. There is no charge in this mode. In that case, we have to manually find what we need to virtualize the function. 

Azure has other mechanisms in place. We can write Azure functions and we can schedule the Azure functions in order to automate them. We can do similar kinds of functionality, however, we have some additional coding we require for Snowflake. 

How are customer service and technical support?

We've had no need for support. Everything is automated and pretty much taken care of. We need to configure everything and the Azure portal will get us to the dashboard. In that dashboard, you'll get all of your current information including information on how the system and the cluster is running. 

The backend is very nice. There are a lot of additional features that help you manage the product. As users, you will get the visualization dashboard. It is very easy to see, which nodes are running and how much data is processed. We can see everything on the portal, and that makes everything very easy to handle.

Which solution did I use previously and why did I switch?

I've had prior data warehouse experience with traditional systems like the Oracle, Superserver, or Teradata.

Snowflake is the only provider with no cloud platform. You have to buy a platform in order to adopt it. Microsoft Azure, AWS, and Google Cloud all have their own dedicated platform. They have their own dedicated data centers.

How was the initial setup?

The initial setup is not difficult. If you have access to the subscription you can start using Azure Data Warehouse and being to create the services. There are security features also. You can give someone full access, and you can set access for others too. Developers will need access so that they can develop it out. It's a pretty straightforward process.

What's my experience with pricing, setup cost, and licensing?

In comparison, I find that AWS is much more costly.

What other advice do I have?

We're a Microsoft partner.

I have experience with the Microsoft Cloud Data Warehouse specifically within the Unix cloud environment.

We're using the latest version of the solution.

It's important for organizations considering the solution to consider their business requirements and expectations. They need to be clear about what type of cloud solution they are looking for. We help our clients do this and interview them to find out what their needs are so that the best platform can be chosen for them. It may be Azure. It may be Snowflake. It depends on the company's needs.

At the end of the day, the customer will always want the best possible pricing. They'll typically ask how they can save money but have high throughput or more input with less price. If that's the case, Microsoft may be the perfect solution.

I'd rate the solution eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
SAP BusinessObjects Consultant at a tech company with 10,001+ employees
Consultant
Good for reporting, but has poor technical support and lacks many important features
Pros and Cons
  • "In terms of stability, comparatively, the solution is quite stable."
  • "We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."

What is our primary use case?

We have end-to-end SAP. Therefore, we have the operations system, which is ECC6, which is the ERP. This is used for day-to-day data consolidating of purchase orders, finances, etc. We have 16 business lines. 

When the data comes, we need the reports for the management and we need consolidated and aggregated data. For that, we use Business Warehouse. NetWeaver is a platform, however, on top of it, you use different products. Therefore, on top of NetWeaver, we have BW overlayed for aggregated data for its management. It can be displayed as necessary in data visualization tools, like Business Objects, Excel, Tableau, Power BI, etc. 

The main purpose of our BW is to consolidate data and show the trends for the last, I would estimate, ten years.

What is most valuable?

BW is our bread and butter. We use it every day for reporting, for analysis, data consolidation and aggregation, drag and drop queries, etc.

What needs improvement?

There are a lot of things that could be improved especially in terms of data cleansing, data management, data lineage, etc. The solution needs to offer more flexibility in terms of formulas and the query designer. 

The solution has very limited options, so we have to mix and match some functionality formulas we create in Business Warehouse. The rest of the formulas and functionality we try to deliver on the front end via direct objects. Therefore, there's a lot of improvement needed. 

My understanding is that they are going to discontinue Business Warehouse so that they can push HANA, including Native HANA, S4 HANA, and BW/4HANA.

This platform has reached its limitation. In order for SAP to improve it, they have to provide a new product, which they have: BW/4HANA. 

BW/HANA is much better than the native standard Business Warehouse. It has new options, new functionality, is faster, has pre-built processes, etc. It has all the data processes from a different company's best practices, and they give it to you by default, just out of the box. This is what Business Warehouse should have been, and it's good they are pushing HANA instead of BW.

For how long have I used the solution?

I've been using the solution for six years.

What do I think about the stability of the solution?

In terms of stability, comparatively, the solution is quite stable.

What do I think about the scalability of the solution?

The solution isn't that scalable. It depends on a lot of factors like what the budget of the company is. If it's scalable in terms of hardware, then we'll have to acquire new hardware and new costs start to pile up. We are not scaling it. If we go overboard with the size, then we just try to reduce the size. We haven't ever tried to scale it. We don't want to spend more to do so.

How are customer service and technical support?

We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least.

Which solution did I use previously and why did I switch?

I cannot recall if we previously used another solution or what it was. Before SAP, the company was using a third-party tool on Oracle or some other SQL database. We have been running SAP for the last 10 years, and I joined the company in the past six years. I wasn't here when SAP was originally implemented.

How was the initial setup?

Initial set up is pretty easy. You just install it and connect it to ECC. The tables are already there as well as the business content. If your company has a lot of customized processes, then you have to adjust a few things. 

Otherwise, if it's a fairly new company, then you just have to connect ECC and the data will start coming in. You can do batch jobs and create aggregation. The initial implementation is fairly easy in that scenario. 

What other advice do I have?

Our solution is strictly on-premises due to our company policy to not place anything on the cloud. 

Consultants with technical experience are helpful. They need to understand the processes, as well, however, because designing is the key. Designing right from the start is the very important if you want the product to work for you. 

There are multiple teams within our company. In my team, we are only concerned with BW and BO. With other teams, there are probably many other instances where someone that is using the solution is connected to other data sources and may be providing the data to the suppliers outside SAP using the portal. I don't know much about it because I'm not involved in this process.

I'd rate the solution six out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees
Reseller
Top 5
Low cost, high performance with large scale queries, and integrates well in an enterprise setting
Pros and Cons
  • "For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
  • "Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."

What is our primary use case?

We are resellers and we provide products for our customers.

Our clients are using this solution in two ways; one is for a data warehouse, and the second is for analytics in the database.

What is most valuable?

The data warehouse has exceedingly high performance and has the ability to do large scale queries very effectively. It fits well in large enterprises.

All features are valuable. It's a combination of capabilities that's all in one place, which is incredibly powerful.

For me, it's performance, scalability, low cost, and it's integrated into enterprise and big data environments.

What needs improvement?

Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint. They don't currently offer this as a platform as a service. Snowflake is offering this capability.

They're available in the cloud. They're available on every cloud, but they're not available as a managed platform as a service offering.

For how long have I used the solution?

We have been dealing with Vertica for two years. 

We use both version 9.3 and version 10. Version 10 is the latest one.

What do I think about the stability of the solution?

Vertica is a stable solution, it's rock solid. Production workloads being run on it are super steady. It's high availability, massively parallel processing. Nodes go down and you don't even notice.

What do I think about the scalability of the solution?

This is a scalable solution. For example, if we look at Uber drivers, they are able to monitor the position and availability of the drivers and match that against the number of customers for every customer and every driver worldwide globally.

They do a geospatial analysis and calculate their search pricing. They are defined by geographical boundaries, they are defined by where the people are and where the drivers are. This is done for every city in the world for every driver. That gives you an idea of the scale they are able to do in this particular use case.

This gives you the idea of the scale, the performance, and the ability to do analytics in the database. They do this so much more cost-effectively than they would on any other platform.

How are customer service and technical support?

Technical support is extremely good. They know the product and they're very good.
I don't have any complaints regarding technical support.

How was the initial setup?

Vertica is known for its ease of administration. I would say that the initial setup is easier than most.

What's my experience with pricing, setup cost, and licensing?

The price varies completely. Cost information is available publically where you can compare with other solutions.

From a cost perspective, the software is less than most of its competitors.

Customers save money by a smaller hardware footprint, fewer nodes, less storage, lower-cost storage, and no appliances. So it is typically a lot less money than an Oracle, Teradata, or Snowflake. 

Overall, they are highly competitive when it comes to pricing.

What other advice do I have?

The customers love them. They absolutely love them.

Before implementing this solution, make sure that it is on the list and that you evaluate it.

I would rate Vertica a ten out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Eli Misael Manjarrez
DBA at Kimetrics
Real User
Top 20
Costs less than Oracle Cloud or Microsoft Azure solutions
Pros and Cons
  • "Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
  • "There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."

What is most valuable?

Amazon Redshift is very fast. It has really good response times. It's very user-friendly.

What needs improvement?

Redshift is a multi-tier engine that works like a calculator. There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity. Sometimes I'd like for them to support some special features or some special installations because we need automatic populations. I would like to see more programming outside of the cloud. I would like to see more functionalities under JSON files. the only functionality that they have now with JSON is reports. I would also like to see other data sources like MongoDB.

For how long have I used the solution?

I have used Amazon Redshift for three years. I use the latest version because it is on Amazon's public cloud.

What do I think about the stability of the solution?

The management of the dates for what we can deliver to it, it's always specific to the form that's defined to Amazon Redshift.

How are customer service and technical support?

I have used their technical support only a few times. Before talking to support I usually try to troubleshoot things myself and I'm usually able to resolve any issues. 

Which solution did I use previously and why did I switch?

In the past year, we have used Azure, but the committee has chosen Amazon Redshift because it is better than Azure for our company needs. We have grown around Amazon Redshift and other AWS solutions.

How was the initial setup?

Amazon Redshift is not as straightforward as other AWS tools but it is not that difficult.

What's my experience with pricing, setup cost, and licensing?

Amazon Redshift costs less than Oracle Cloud or Microsoft Azure.

Which other solutions did I evaluate?

I started using Amazon Redshift because I started working for this company that was working with both Azure and Amazon. The company eventually moved all to Amazon. I wasn't sure why they didn't continue to use Azure. My experience was more with Microsoft technology so I prefer Azure. But, there are some interesting features in Amazon Redshift that works better. I have also used Oracle Cloud.

What other advice do I have?

I would recommend Amazon Redshift as it is part of the AWS platform and they are the biggest in the world.

I would give Amazon Redshift a rating of eight on a scale of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Ankur Varshney
Digital System Architect at a financial services firm with 10,001+ employees
Real User
Top 10
Good performance but poor scalability, and the technical support needs improvement
Pros and Cons
  • "The performance is okay as long as the volume of queries is not too high."
  • "Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."

What is our primary use case?

This is part of our Data Warehouse solution and it is set up as a two-node cluster.

What is most valuable?

The performance is okay as long as the volume of queries is not too high.

What needs improvement?

We have been facing some challenges with Db2 when scaling up the operations in terms of availability. It becomes a single point of failure and it pollutes the whole system, leaving us challenges in serving the traffic. This is the reason that we are considering migrating to Oracle.

For how long have I used the solution?

We have been using Db2 Warehouse for three years.

What do I think about the scalability of the solution?

Scalability has been a problem area. We have traffic on the order of gigabytes and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.

How are customer service and technical support?

We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on make-shift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.

How was the initial setup?

Our deployment cycle was approximately six to seven months.

What about the implementation team?

We worked with our technology solutions provider to implement Db2, and we have an in-house team as well. We received assistance from IBM and the team faced a lot of challenges with the full IBM stack.

Which other solutions did I evaluate?

We are currently in the process of evaluating migration from Db2 to Oracle.

What other advice do I have?

Db2 is not a solution that I recommend. We have a lot of experience and we are not satisfied with the product or the support that we received. Because of the way our environment works, serving branches, it becomes a challenge to satisfy the customers or users.

I would rate this solution a five out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Get our free report covering Microsoft, Snowflake Computing, Oracle, and other competitors of Oracle Autonomous Data Warehouse. Updated: January 2022.
565,689 professionals have used our research since 2012.