Teradata Reviews

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.

Throttle

Columnar

Faster query response time.

Concurrency is still a challenge, pricing is still high.

Three years.

No.

None.

Yes.

6/10

6/10

Oracle. We switched because of TD distributed architecture and it is the best product for EDW.

Done by Teradata PS.

Teradata PS.

Stats, QueryGrid Autostats with collecting stats automatically with the threshold values assigned, QueryGrid has multiple new features i.e data migration, extraction, tool loading, other utilities.

Business, Analytics, Hybrid.

It should be compatible and free on CLOUD/ AWS. Currently many DB's on AWS are free , Teradata is also on Amazon Web Services, but its charged and no documentation available to practice those LABS .

5 years.

No issues.

No issues.

No issues.

8/10

Larger data warehouse / reporting and compatibility to analytics.

It was straightforward.

It architects the databases well. Right from data modelling, the correction appliance to be chosen, the queries hitting the system, strategic, tactical etc, and that business knowledge should be easy to understand to end developers.

The optimizer is the most valuable feature for us.

We are into DWBI (Data Warehousing and Business Intelligence) and Teradata is number one in the market for these solutions. They stood on top even for changing business needs and beat other competitors in benchmarking.

The Query Response time needs improving.

We have been using the solution for 12 years.

We did not encounter any issues with stability.

We did not encounter any issues with scalability.

I would rate the technical support at 9/10.

We never used a previous solution. In fact we migrated straight to Teradata.

There were a few ups and down with the initial setup but it's only one time during the initial phase.

Go for it.

It's already proven so we did not evaluate other industry solutions.

Go for it.