We just raised a $30M Series A: Read our story

Teradata Cloud Data Warehouse Competitors and Alternatives

Get our free report covering Snowflake Computing, Microsoft, Amazon, and other competitors of Teradata Cloud Data Warehouse. Updated: September 2021.
542,267 professionals have used our research since 2012.

Read reviews of Teradata Cloud Data Warehouse competitors and alternatives

SS
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
Sarfraz Nawaz
Chief Executive Officer at Ampcome
Real User
Top 10
Scales according to our needs, which saves a lot in terms of upfront costs

Pros and Cons

  • "The most valuable feature is the scalability, as it grows according to our needs."
  • "The OLAP slide and dice features need to be improved."

What is our primary use case?

We are a digital transformation services company, and we are using Amazon Redshift for one of our clients. They are a logistics company that has transportation and other needs.

Their first requirement is for financial reporting, where we pull financial data from their many ERP systems and can provide a corporate-level view.

There is also an operations standpoint, where they are looking for operational insights. For this, we again pull different information from their ERPs, bring it into Redshift, and then model it in such a way that they will be able to see a consolidated view in terms of operational success across lines of business.

How has it helped my organization?

I've been working with data warehouses for a long time and it has always been the case that we had to invest quite a bit on infrastructure, upfront. We are used to dealing with Teradata, and the cost of setting up the data center and getting the appropriate licenses was a big deal. Now, we are able to spin up some clusters and then start using it, allowing us to incrementally pay as we expand.

This has become a big shift in how we spend because there is no capital cost upfront. Moreover, this works with startups as well as with enterprise, and they provide an equal footing. This means that even the advanced capabilities and insights that are available with a data warehouse are no longer limited to the larger clients. Even a startup can use these features, immediately.

What is most valuable?

The most valuable feature is the scalability, as it grows according to our needs.

The part that I like best is that you only pay for what you are using.

What needs improvement?

The OLAP slide and dice features need to be improved. For example, if a business wants to bring in a general ledger from an ERP, they want to slice and dice the data. What we have found is that they have a lot of formulas that are used to calculate metrics, so what we do is use SQL Server Analysis Services. The question then becomes one of adopting a single vendor and transitioning to Azure. If Redshift had similar capabilities then it would be very good.

For how long have I used the solution?

We have been using Amazon Redshift for about five years.

What do I think about the stability of the solution?

The stability is awesome. We have been using it for quite a while and haven't faced any issues.

What do I think about the scalability of the solution?

The scalability is very good. You can start at a very low scale and just keep expanding as required. It is the type of product that fits organizations of all sizes.

How are customer service and technical support?

We have contacted support on several occasions. With our most recent customer, they are pretty large and we were directly in touch with the regional account manager, who is the head of database analytics for India. This person was directly involved in our calls and helped with the evaluation, so the support has been pretty good.

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

We have worked with Teradata and more recently, have been working with Azure SQL Warehouse. Teradata is an on-premises solution and the upfront costs are high. Comparing Azure SQL Warehouse and Amazon Redshift, in terms of features I think that they are pretty much on par.

The SQL Data Warehouse does have better OLAP capabilities, and they also offer a level of serverless capability where they have split the compute and the storage. This means that they can operate at a lower cost in the development environment.

Many of our clients have begun to adopt Power BI, and once they start using it, they tend to lean towards Azure and the Azure SQL Data Warehouse. The fact that Power BI is free, makes quite an impact.

How was the initial setup?

The initial setup is straightforward, once you get used to it. There is a lot of documentation available.

What about the implementation team?

We handle the implementation and deployment of Redshift for our clients.

What other advice do I have?

I am interested in seeing a split between compute and storage, which is something that they are currently working on. We plan to start leveraging it at some point in the future.

In summary, I think that Amazon Redshift is a very good data warehouse and we really like it a lot.

I would rate this solution an eight out 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.
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
Real User
Top 5Leaderboard
Easy to use, flexible, and very stable

Pros and Cons

  • "The solution is very easy to use."
  • "The solution needs more connectors."

What is our primary use case?

The solution is primarily used as a data warehouse.

What is most valuable?

The solution is very easy to use.

The product is very stable and flexible. The performance is good.

The product is quite scalable.

What needs improvement?

The solution needs to offer more functionality related to machine learning and artificial intelligence.

The solution needs more connectors.

For how long have I used the solution?

I've been using the solution for close to two years.

What do I think about the stability of the solution?

The solution is very stable and extremely reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is very good.

What do I think about the scalability of the solution?

The scalability of the solution is very good. If a company needs to expand it, it can do so with ease.

We have about 100 people on the product currently.

How are customer service and technical support?

Technical support overall has been good. They are helpful and responsive. We have no complaints. 

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

I have some experience with Teradata.

How was the initial setup?

There is no installation process, as it is run as software as a service on the cloud.

For deployment, I would say two to five people would be enough. It depends on the size of the project and can have from one person to 20 people supporting it. It really depends on the implementation. The people would likely be admins, engineers, and managers.

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

The product requires the purchase of an annual license.

Which other solutions did I evaluate?

Before choosing this solution, we looked at SQL Server and Teradata.

What other advice do I have?

We're customers and end-users.

We're using the latest version of the solution. I can't speak to the exact version number.

I'd rate the solution at a nine out of ten. We've been mostly very happy with its capabilities.

I'd recommend the solution to other users and companies.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Get our free report covering Snowflake Computing, Microsoft, Amazon, and other competitors of Teradata Cloud Data Warehouse. Updated: September 2021.
542,267 professionals have used our research since 2012.