The intention is for the company to utilize Microsoft Azure Synapse Analytics for analytics purposes. The team manages numerous databases and utilizes them to handle multiple tasks.
The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well.
The support and price could improve.
I have been using Microsoft Azure Synapse Analytics for approximately six months.
The stability is great.
I rate the stability of Microsoft Azure Synapse Analytics a ten out of ten.
The solution is scalable.
We use the solution intermittently, approximately 50 percent of the time.
We have approximately 1,500 users using the solution.
I rate the scalability of Microsoft Azure Synapse Analytics a ten out of ten.
The level of support from Microsoft Azure Synapse Analytics is average because it takes some time to reach the appropriate person, causing delays. Although we eventually connect with the right person, the initial representative assigned to the call is often unqualified to provide the necessary assistance. They simply repeat what is already available on the website, which we are capable of accessing ourselves. Our goal is to obtain a reliable technical solution, and the turnaround time from the point of contact to receiving a response is longer than ideal. This delay applies to both L1 and L2 support.
I rate the support of Microsoft Azure Synapse Analytics a five out of ten.
The initial setup took us two weeks at the beginning and now we can do it in less than one week.
The initial setup of Microsoft Azure Synapse Analytics is straightforward.
We accomplished the deployment of the solution by ourselves with the assistance of two architects and four DevOps professionals.
Microsoft Azure Synapse Analytics is an expensive solution and there is a license needed to use it. My company has an enterprise license.
I rate the price of Microsoft Azure Synapse Analytics
We have four DevOp engineers that do the maintenance of the solution.
If your data models are not accurate, and if you are not well-versed in data transformation and model security, the process will be extremely challenging. Thorough planning is essential for the data to be properly managed. You cannot simply execute or implement the process by reading about it. A significant amount of planning is required, including how the data flows will access the data, data security measures, data flow processes, and transformation requirements. All of these aspects must be carefully examined and planned beforehand to avoid complications later on.
I rate Microsoft Azure Synapse Analytics a ten out of ten.