Octopus Deploy holds the deployment part of the solution. In our company, we develop solutions, and we can deploy them with Octopus Deploy. In our team, we have eight developers, and we can do the deployment at the same time, but Octopus Deploy does the deployment one by one, in the order starting from the first person who applied for the deployment.

Regarding ETL tools, I have used SSIS and some experience in OBIEE. I have experience with multiple other solutions, including some from Microsoft. I have heard of Informatica, but I am not really sure how good it is overall.

Considering that I have just started using Azure and everything is shifting to the cloud, I will recommend Microsoft Parallel Data Warehouse since it is easy to use and feasible.

Overall, I rate the solution an eight out of ten.

View full review »

I rate Microsoft Parallel Data Warehouse eight out of 10. I would recommend it. 

View full review »

Our organization has a partnership with Microsoft right now.

I'd rate the solution a nine out of ten. I do find that, when it comes to comparing it to Oracle and other tools, there are some better things available on other products. Oracle, for example, manages a large set of data, so, and it is more optimized and a bit faster. 

View full review »

We are client-based, and 50% of our clients use Azure and SSIS data warehouse, MSBI. Anyone planning to choose Microsoft Parallel Data Warehouse can go for it. I rate the solution an eight out of ten.

View full review »

I rate this solution a five out of ten. I would advise anyone using this solution to find a good DBI.

View full review »

Microsoft Parallel Data Warehouse is beneficial from a data analysis perspective. It has been in the market for a long time. It is a very stable and robust product for the on-premise version.

I rate it a nine out of ten.

View full review »

I recommend the product to others. Overall, I rate the product a ten out of ten.

View full review »

Overall, I rate Microsoft Parallel Data Warehouse a seven or eight out of ten.

View full review »

I give the solution an eight out of ten.

View full review »

I am an end-user.

I'd rate the solution seven out of ten. 

I like that, with Microsoft, I can access the cloud easily. However, it would be ideal if the solution could offer more features, like DB2.

View full review »

This is a solution that has good performance and I recommend it. The support from Microsoft is also another thing that makes the Parallel Data Warehouse a good option.

The biggest lesson that we have learned from using this solution is that customers are most interested in a quick project turnaround time, which is something that Parallel Data Warehouse provides.

This is a good solution but there is always room for improvement.

I would rate this solution a seven out of ten.

View full review »

All of the components related to the pipeline are included in Synapse. We have some ETL tools based on Data Factory and other advanced functions based on Databricks. Not all of the functionality is included in Synapse. It makes no sense to have the product without all of the functionality.

It is tricky to manage the storage mode of the data because if we don't read the documentation and don't create a good distribution of the data, we will have problems in the performance. If we do it, we will have no problem. 

Overall, I rate the solution an eight out of ten.

View full review »

My advice for anybody who is implementing this solution is not to overload your server with all of the data that you don't use on a day-to-day basis. It is very easy to pull the data that you need whenever it is required. You will have to decide how to store the data and how easy it is for your client to send new data. Neither of these things should be difficult to do, even for newcomers to SQL. Sometimes, you will have to have a senior person demonstrate something basic, like how to pull data, and then people usually pick it up.

I would rate this solution an eight out of ten.

View full review »

We're just a customer. We don't have a business relationship with the product.

I'd rate the solution eight out of ten overall. It's never given us issues in terms of scaling or stability. Technical support is quite good. It offers some great features.

View full review »

My advice to anybody who is implementing this solution is to design the databases as well as they can because it is difficult to make changes in the future. It is also important to have a time field in your data in case you want to use it in the future as a reference.

This is a good solution but all software can be improved and made better.

I would rate this solution an eight out of ten.

View full review »

On a scale from one to 10, I rate this solution a nine. 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.

The biggest part that we battle with in terms of costing, and explaining to people why it takes so long to develop some of those things, is just to get the data into the actual data warehouse and automating that. It's purely an integration layer to actually get the data into the data warehouses.

People need to do their research very well to understand the terminology and the technology when they speak to people that are technically inclined, because there's a lot of miscommunication in terms of what they expect from the program and what's delivered at the end of the day.

The biggest lessons I've learned through the years are that Microsoft is probably the largest research company there is. So people should stick to people that know what they're doing, and Microsoft definitely has some very, very capable people designing these products.

And that's probably why I've stayed with Microsoft so long. I've actually tried out a few other suppliers, but I always go back to Microsoft.

View full review »

For a small-sized company like ours, I really recommend this product. It can handle a big workload. I would say other products could not be better than Microsoft for small businesses with a lesser budget.  

On a scale from one to ten where one is the worst and ten is the best. I would rate Microsoft SQL Server Parallel Data Warehouse as a seven-out-of-ten.  

View full review »

This is a great product for big data analytics as it can challenge other MPPs quite well.

View full review »

We have had a good experience working with this tool.

If you don't have a problem with memory and have good processors, then you won't have an issue. However, depending on your needs, you may want to go check out other tools.

I would rate the tool as an eight out of 10.

View full review »

My advice for anybody who is implementing Microsoft Parallel Data Warehouse is to be aware of how big the data is. You have to be sure of how to secure and take care of the data. You have to think about scalability.

I would rate this solution a seven out of ten.

View full review »

I am not comfortable with the Microsoft Parallel Data Warehouse at the moment.

I would rate this solution a six out of ten.

View full review »

Make sure your data volumes are very large: At least 60 million rows per table.

View full review »

Both hardware and software support is provided by Microsoft. View full review »

• It comes as a special tool of cleaning data through the data transformation process where data is extracted from many sources before it is assembled and consolidated to form a single database. This is the main factor that led my company to choose SQL Data Warehouse as the special tool to consolidate relational databases. Close examination was done on SAP Data Warehouse and IBM Data Warehouse but SQL Data Warehouse provided a more extensive way of integrating data. I personally value the role that SQL Data Warehouse has contributed in achieving the goals of business intelligence. Users will to generate timely reports from huge databases as well as database cleaning should embrace this provision. View full review »

We use the on-premises deployment model.

I'd rate the solution eight out of ten.

View full review »