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

Likelihood to Recommend

Db2 Warehouse on Cloud

Db2 is not a solution that I recommend. We have a lot of experience and we are not satisfied with the product or the support that we received. Because of the way our environment works, serving branches, it becomes a challenge to satisfy the customers or users.
Ankur Varshney | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

Teradata is most suited when needing to get data for a specific purpose. If you need to report data and display it, this application is not as well suited. It should only be used to store and access data. It does a good job of organizing the data. You can get your dataset at a place where little to no additional tweaking would be needed in other applications.
Anonymous | TrustRadius Reviewer

Pros

Db2 Warehouse on Cloud

  • You can size dashDB to your current needs and expand its capability later on as the needed.
  • I like the way dashDB allow for connecting to the cloud that my network engineer to set things up quickly.
  • IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it a real winner for me.
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

Db2 Warehouse on Cloud

  • We have been facing some challenges with Db2 when scaling up the operations in terms of availability. It becomes a single point of failure and it pollutes the whole system, leaving us challenges in serving the traffic. This is the reason that we are considering migrating to Oracle.
  • Scalability has been a problem area. We have traffic on the order of gigabytes per second and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on make-shift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
Ankur Varshney | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

  • Sometimes it isn’t clear the reason an error will occur in the query. More detailed responses would be helpful
  • It can be slow at times when pulling large data amounts
  • Sometimes spool space will run out when trying to run certain queries
Anonymous | TrustRadius Reviewer

Alternatives Considered

Db2 Warehouse on Cloud

IBM dashDB stacks up well against both on-premise (SQL Server and DB2), but it was a tough choice to go with over AzureDB. Ultimately, the deep discount by IBM led us to go with dashDB with the understanding that we could back out of the technology at a later date.
Anonymous | TrustRadius Reviewer

Teradata Data Warehouse Appliance 2850

To be fair, I didn’t select Teradata. I do think that they are comparable. There are some things SQL server does better than Teradata and vice versa. For example, sql server will underline potential errors while you are coding. It also will auto-populate table and column names so you don’t need to have the exact name before submitting your query.
Anonymous | TrustRadius Reviewer

Return on Investment

Db2 Warehouse on Cloud

  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on makeshift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
  • Scalability has been a problem area. We have traffic on the order of gigabytes and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
Ankur Varshney | TrustRadius Reviewer

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

Screenshots

Teradata Data Warehouse Appliance 2850

Pricing Details

Db2 Warehouse on Cloud

General

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

Db2 Warehouse on Cloud Editions & Modules

Edition
dashDB Entry50 / month1
dashDB EnterpriseVaries
dashDB Enterprise MPPVaries
dashDB Entry (Free)$03
  1. Per instance
  2. none
  3. Up to 50 GB
Additional Pricing Details

Teradata Data Warehouse Appliance 2850

General

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

Teradata Data Warehouse Appliance 2850 Editions & Modules

Additional Pricing Details

Add comparison