The HCL Actian Data Platform (formerly Actian Avalanche) hybrid cloud data warehouse is a fully managed service that aims to deliver high performance and scale across all dimensions – data volume, concurrent user, and query complexity – at a lower cost than alternative solutions. Avalanche has built-in self-service data integration that can be deployed on-premises as well as on multiple clouds, including AWS, Azure, and Google Cloud, enabling users to migrate or offload applications and data to…
N/A
Teradata Vantage
Score 8.3 out of 10
N/A
Teradata Vantage is presented as a modern analytics cloud platform that unifies everything—data lakes, data warehouses, analytics, and new data sources and types. Supports hybrid multi-cloud environments and priced for flexibility, Vantage delivers unlimited intelligence to build the future of business.
Users can deploy Vantage on public clouds (such as AWS, Azure, and GCP), hybrid multi-cloud environments, on-premises with Teradata IntelliFlex, or on commodity hardware with VMware.
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.
Teradata Vantage is well suited for large scale ETL pipelines like the ones we developed for anti money laundering risk matrices. It handles heavy joins, aggregations, and transformations on transactional data efficiently. We generate alert variables, adjust for inflation, and monitor establishments monthly with it, all integrated with Python and Control-M for a centralised automation across the company. For less appropriate, I would say that heavy resource demands might slow down experimentation for iterative work.
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.
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.
Teradata can improve by supporting more native AWS cloud features. Currently if a node goes down the EC2 instance must be restarted. It isn't something that happens frequently but more tight integration with cloud providers like AWS and Azure will allow Teradata to offer truly dynamic scaling.
Some Teradata features are oversold before they are ready for prime-time. Teradata is not unique in this but if something is sold as an integrated product stack it should really be integrated not something that requires an extensive development cycle to be integrated at a customer's expense. If something is supported it should've really be tested and QAed thoroughly before a customer touches it.
Teradata is a mature RDBMS system that expands its functionality towards the current cloud capabilities like object storage and flexible compute scale.
Teradata Vantage allows us to create a scalable infrastructure to support our strategic initiatives. The dedicated compute power ensures reliable performance with isolated workloads and dedicated resources, optimizing workflows for faster, more efficient data transfers. The compute clusters support ETL processes and OSF’s developers and data science team with the flexibility to create self-service analytics, to spin up/down at any time, driving better performance and minimizing costs.
We have meetings at the beginning with the technical team to explain our requirements to them and they were really putting in a lot of effort to come up with a solution which will address all our needs. They implemented the software and also trained a few of our resources on the same too. We can get in touch with them now as well whenever we run into a roadblock but it's very less now.
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.
Teradata is way ahead of its competitor because of its unique features of ensuring data privacy and data never gets corrupted even in worst case scenario. In most cases, the data corruption is a major issue if left unused and it leads to important data being wiped off which in ideal case should be stored for 3 years
Teradata is been absolutely phenomenal for our project because we feed huge chunks of data to it and get back the desired results in no time which earlier used to take hours to process and then also sometimes timeout.
We don't have to do any manual intervention for resource or task allocation, it is all taken care by Teradata internally and all the AMP's are given equal amount of work and have their own resources to complete them with no sharing with another.
