HCL Actian Data Platform vs. Azure SQL Database

VectorWise is suitable to be a departmental data mart database or an operational data store (ODS). It is not suitable for enterprise data warehouse database.

Incentivized

Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.

Incentivized

• The support community was not as robust as you would find in a Mulesoft or Informatica environment. Given time and growth, it’s possible it will blossom, but for now it is minimal.
• Training is always a big thing for us, and the tool was not expansive enough for us to implement our own internal training program. There was some online training, and we acquired an expert when we brought on the new company, but some additional training tools would have helped the tool grown its user base internally.
• Not a lot to set it apart from the competition. Most of the features are available with other more established tools, but for a small company that maybe grew too quickly and needs to get its arms around many different data sources, I can see the appeal. Not really geared for larger firms.

Incentivized

• Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
• All the tools simply work after you are on Azure SQL Database.
• The applications do not need changes in order to start using Azure SQL Database.
• Hybrid Cloud scenarios will work.
• Clustering and failover - already there.
• You can start monitoring the use and extract performance insights in a new way in Azure.

Incentivized

• As I said before, more training or greater visibility to training tools/options would be a plus. It’s easy to publish YouTube videos these days, I think they should make more of them.
• Differentiation would help, there’s not a lot out there to drive you to buy the product if you are well informed in the market. If you know the market, you steer towards the large or trendy products. It’s a good product, but lost in the noise of the field I think.
• Hitching the wagon to a major software brand (like Mule did to Salesforce) would help grow the user base, and thus increase the activity in the support community. More users also translates into product champions.

Incentivized

• A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
• Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
• Price can always be improved as well. It’s not bad, but room for improvement.

Incentivized

This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.

Incentivized

It just works!

We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.

Incentivized

We didn’t actually choose Actian, it arrived as part of an acquisition, and really served its purpose both when it was used by the smaller firm we acquired as well as afterwards when we were extracting data and folding the company into our own data and analytics culture. The included hundreds of pre-built connectors gave us lots of options, but in the end, we were just too large of a company to rely on the product and needed a big-name player to address our wide-ranging needs. Powerful for its size, but not sized enough to address big businesses.

Incentivized

Oracle Database is "the" serious database. There really is no competition in that field. SQL Database would be a serious competitor through the ease of implementation and the "no maintenance," but since it's too expensive for "normal" use (medium to small applications), it just priced itself out of the market, so to speak. Nevertheless, we do have 2 or 3 large applications that are highly integrated in azure, and for those it's just too easy to use SQL Database instead of the on premise Oracle Database with VPN gateways etcetera.

Incentivized

• We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.

Incentivized

• We don't need a dedicated SQL dba because so many of the database maintenance operations are managed. A huge positive not only in budget but time constraints.
• The ability to scale quickly is the biggest positive as our data needs change constantly.
• Easy to migrate from legacy tools and systems, saving us on the need for redevelopment.

Incentivized