Teradata Reviews

We implement Teradata in financial sectors, which include banks in India and Canada.

Technically, it has made data processing much faster than other SMP databases.

The most valuable features are the Shared-nothing architecture and data protection functionality.

The user interface needs to be improved.

The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space.

Our primary use case is for retail and customer behavior modeling. We handle a billion records from different sources to create a consolidated feed for KXEN analysis and customer behavior modeling.

It has allowed our organization, a retail company, to focus on timely marketing campaigns for the proper customers.

It handles large amounts of information with a linear performance increase, in relation to a HW investment. It has a solid set of tools and consulting services.

• A more transparent integration with Aster solutions.
• An even deeper focus in data sciences.
• A teaching web site with more training on third-party tools used for BI (data sciences).

I am using Teradata Vantage Express and I'm using Teradata Studio along with it.

The most valuable feature of Teradata is the quick processing of large data.

The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud.

I have been using Teradata for approximately one week.

The solution is stable.

Teradata has high scalability.

I am the only one testing the solution in my company.

I rate the scalability of Teradata a ten out of ten.

I have not used the support.

The initial setup was done with the free Teradata Express. I downloaded and installed it. The implementation process was not easy to do and there are many steps involved. Other data warehousing tools are plug-and-play. It is a three to four-step process.

We followed some useful YouTube videos.

I rate the initial setup of Teradata a five out of ten.

I am using the free version of Teradata.

I rate Teradata a ten out of ten.

We have improved our daily/monthly reporting, campaign management, and behavior analysis.

Performance when processing terabytes of data.

• Licensing
• Architecture openness
• Integration with other tools

No stability issues.

Teradata's key strength is it's scalability.

Excellent. The support covers all aspects of hardware/software usage.

Oracle's performance in processing large amounts of data is very poor and we had to choose new technology.

Complex. The process requires multiple meetings and all teams working together.

Teradata is expensive but gives value for money, especially if you don't want to move your data to the cloud.

IBM, Oracle.

If you have purchased the hardware/software, focus on architecture and the design of data layers.

As a contractor for various companies working in various industries, we usually find Teradata in financial organizations. It is often being used for relational data storage for huge data warehouses (usually built on Inmon principles) or as storage for building analytical data marts. Teradata is positioned as a high-performance solution for heavy analytical queries and, in fact, it is. Moreover, Teradata is typically supplied with the whole ecosystem of its tools (like Viewpoint), but I have not extensively used them.

• Cuts time to process huge amounts of data with analytical queries
• A conventional and easily defined way to build a data warehouse or a layer of data marts
• Better development time - Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools

Efficiency of running analytical queries. Teradata was mainly invented for that purpose and it really does it well. We were able to migrate the code from SAS analytical platforms to pure Teradata and got an order of magnitude of performance growth (taking into account that the hardware was similar).

Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required).

Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect.

We have not experienced any stability issues.

No. Teradata is positioned as a rather scalable system, and we have not seen any issues with it.

I was not impressed by tech support. We made several requests regarding performance issues we had with our applications but did not get helpful answers.

It is hard to say what our clients had been using before. It is safe to say that this was their first option for analytical data warehouse implementation.

I cannot say for sure. We have not taken part in deployment activities. As it is an appliance, I expect it is a bit complex.

Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world.

Usual alternatives in the same segment for our clients are Oracle Exadata, SAP HANA, and Hadoop.

I rate it an eight out of 10. It is definitely the best RDBMS I have ever worked with, in the sense of building a data warehouse. It is fast, and easy to use in terms of writing queries. However, you have to understand the specifics of the data storage and its technical architecture, which is not typical for an RDBMS.

In terms of advice, I would suggest your provide training for your personnel, because it is rather important to understand the technical specifics of Teradata to create efficient solutions with it. Other RDBMS's usually requires knowledge  of generic theory, but that will not work with Teradata.

I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable.

Vodafone Spain tried to migrate a very populated data mart platform from Sybase IQ to Oracle. Unfortunately, they failed at this job. But more than 20 Sybase IQ database engines (with their respective licence, support costs, etc.) were successfully integrated into one single Teradata ecosystem.

The cloud is the new challenge and the new opportunity.

I have designed Teradata EDWH solutions for more than 16 years.

I did not encounter any issues at all.

I did not encounter any issues at all.

I would rate the level of technical support 10/10.

I have previous experience with Oracle/Informix/Sybase. For large EDWH solutions, Teradata is the best. Oracle solutions are multipurpose oriented and Td is EDWH oriented from the beginning.

The initial cost may seem high, but the TCO is low.

I mainly evaluated Oracle.

I recommend starting with a clean and normalized business model that is capable of addressing business questions. Teratada (and its consultants) will do the rest.

• It is simple for me as a developer
• Query tuning is simple.

It's simple to use and scalable.

I've used it for eight years.

No issues encountered.

No issues encountered.

No issues encountered.

We used a vendor team who were 7/10.

The speed has been increased.

We also looked at Hadoop.

It's simple but costly. However, this doesn't concern me as I have to develop applications. My employer can give me any product and I will learn and develop with it.  Almost all database products are 80% same.

We use it as a data warehouse.

I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.

The scalability could be better. The on-premises solution is always more complicated to scale.

The flexibility could be improved. The product is good if you know what you're planning to do. If you're designing as well, upfront, then it's fine. However, if you've made a mistake in the design work or your system, then it could be quite complex and expensive, and it may not preform well.

I've been using Teradata for around four years.

Teradata is a stable solution.

I've worked on the on-premises solution, and it is always more complicated to scale. We currently have hundreds of users.

We used Oracle Database before Teradata.

Teradata is quite a specific tool, so if you have suitable use cases, then I would recommend it. On a scale from one to ten, I would rate this tool at seven.