8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8 out of 100

Likelihood to Recommend

Actian Avalanche

This is a tool geared for smaller to mid-sized business that has disparate sources of data from different platforms in varying incarnations. It’s a great ETL tool to solve the problems a scenario like that causes, but you can also achieve that with good BI Tools like Qlik Sense. So be careful that you really need an ETL tool, as opposed to an end-use tool with a built-in ETL component. If you are going ELT and have a lot of data an not a lot of corporate resources, this is a better option than Microsoft or Informatica
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

It is highly applicable for large, corporate companies with data coming from multiple sources. Teradata can be used as an ODS (Operational Data Store) to merge the source data, then it can also be used to create development/UAT databases, and production databases under the same server. It is capable of processing billions of records per day. It is less appropriate for companies with a single source of data.
Anonymous | TrustRadius Reviewer

Pros

Actian Avalanche

  • 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.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

  • Can query multiple databases within one server and view all results in one window. Helps speed up analysis.
  • Teradata uses AMPs (Access Module Processors) to increase speed of data processing/queries. You must use 'COLLECT STATISTICS' properly to efficiently use the AMPs.
  • Most standard SQL practices work on Teradata. Also, Teradata formats the query in a nice colored structure.
  • Can search for tablenames or specific columnnames across the entire server. Helps when changing a specific column or table structure.
Anonymous | TrustRadius Reviewer

Cons

Actian Avalanche

  • 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.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

  • Errors on compiling a procedure are sometimes hard to decipher. Teradata provides a line number of the error but this number does not always match the line number of the procedure in the query window.
  • Teradata won't run a query if I copy and paste from my internal company chat. Something with the formatting from the chat creates a syntax error, so I have to take time to rewrite the query.
  • I haven't been able to insert multiple new rows into a table with 1 insert. Other SQL programs allow this with a comma, but Teradata makes you create separate inserts for each row.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Actian Avalanche

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.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

No answers on this topic

Return on Investment

Actian Avalanche

No answers on this topic

Teradata Data Warehouse Appliance 2850

  • Enabled next-day reporting.
  • Better customer service as field technicians can see instant performance.
  • Needed to hire more employees for overnight support.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian Avalanche

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Teradata Data Warehouse Appliance 2850

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison