What is our primary use case?
Our company uses the solution to develop a certain sort of products for our internal companies. We have some child or franchise companies and are developing software for them.
We use the solution where transactions display to provide views or reports for the console. We also use the solution for an online learning application or portal.
We have 20,000 to 30,000 users across multiple products, franchise companies, and customers at the backend. Centralized data is global and accessed from all over the world including India, the US, South America, and Asia.
We have several new projects with the same backend, so our user volume will definitely increase day by day.
What is most valuable?
The solution's read capacity and write access functions are very fast so users don't have to wait when fetching or displaying data on a screen. The main feature of an application is how it behaves toward the user. Users get uncomfortable when having to wait a long time. The solution's high-value data processing helps application performance data.
The solution easily integrates with the Microsoft cloud and other Microsoft products like Azure Active Directory. We use cloud storage for databases so this integration is very beneficial.
What needs improvement?
The solution cannot join two databases like Oracle or SQL Server. Joins have to be done programmatically through our sysHUB. We use .NET code so need the middleware to join databases.
There are certain restrictions for inner classes or employee roles.
Data retrieval is slightly more difficult than in SQL Server or other SQL databases.
Documentation needs some improvement to help end users. Documentation for joining includes some generic or peculiar cases but needs to be more comprehensive. It should lay out how to join databases and what procedures to use.
For how long have I used the solution?
I have been using the solution for more than three years.
What do I think about the stability of the solution?
The solution is stable. We haven't received news of any issues with platforms.
Stability is rated a nine out of ten.
What do I think about the scalability of the solution?
There are a lot of things we still have to fight out such as joining databases. Most probably for the high-transactional use cases, the solution cannot be used at all.
Currently, scalability is a seven out of ten.
How are customer service and support?
Our infrastructure team handles all communication with support and reports that they are good. We have a premium account with Microsoft so support always helps us.
Which solution did I use previously and why did I switch?
From 2009 to 2018, we used Oracle at our company. We switched to the solution for various projects due to the needs of users. We needed a product that met our business and users' requirements with the lowest cost possible.
How was the initial setup?
The setup is very easy so I rate it a nine out of ten.
In the initial days in 2018, setup was uncertain and coding was needed from our side. Now, we use the library to access the database or read and write. Things become so much easier over time.
What about the implementation team?
Two members of our core infrastructure team handle all implementations.
On average, deployments take three to five hours. We have to deploy the DevOps side and the data backup. If we consider all things, deployments hardly take a full day.
The solution doesn't require any ongoing maintenance.
What was our ROI?
Obviously, we want to be on the profit side as a business or we can't grow. Money and usability are the most important things for us.
The solution has already realized some ROI. The pay-as-you-go usage methodology helps us because it saves money.
At this point, I rate ROI a six out of ten.
What's my experience with pricing, setup cost, and licensing?
Pricing is one of the solution's main features because it is based on usage, scales automatically, and is not too costly. As usage scales up or down, the price moves accordingly.
For example, we might have 30,000 users and the requirement is high so the solution automatically scales up. If the requirement lowers because the application isn't being used all the time, then the usage automatically grades down and so do our costs.
Technical support is included as a free service.
I rate pricing a seven out of ten.
Which other solutions did I evaluate?
We still use Oracle for some projects but it is costly to acquire.
We are using SQL Server for an ongoing project.
The solution is less expensive than Oracle, especially with all of our DLLs. It is easier to work on from a developer's perspective and we realize a good cost savings.
We choose the best database based on a customer's budget and need.
What other advice do I have?
Everyone can use the solution where the database hits or the transactional data is placed.
The solution is not a good fit for companies in the banking industry who have a high volume of transactions every second. The solution always needs a proper SQL database like Oracle.
Companies with non-transactional applications must use the solution because it helps users and achieves a lot of success in terms database costs.
I rate the 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?
Microsoft Azure
*Disclosure: My company does not have a business relationship with this vendor other than being a customer.