Likelihood to Recommend TV is well suited for high speed, which is a great for large tables. The workload functionality is very good when in Viewpoint. The BAR functionality could use a little work. QueryGrid is very useful as well. The client handlers are still a work in progress, as I keep hearing that they continue to fail. There are also many restarts on the systems as well.
Read full review Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review Pros ETL (Extract - Transfor - Load) NOS to send data from Teradata Vantage to S3 and from S3 to Teradata Vantage Teradata GeoSpacial feature Bulk reading and writing in huge tables MPP capacity already mature Temporal Capacity more mature that other solutions TASM Read full review Export data into excel. Export data into excel using a pivot table functionality. Navigation between windows is intuitive and easy to understand. Good for SQL novices and experts alike. Read full review Cons Teradata is an excellent option but only for a massive amount of data warehousing or analysis. If your data is not that big then it could be a misfit for your company and cost you a lot. The cost associated is quite extensive as compared to some other alternative RDBMS systems available in the market. Migration of data from Teradata to some other RDBMS systems is quite painful as the transition is not that smooth and you need to follow many steps and even if one of them fails. You need to start from the beginning almost. Last but not least the UI is pretty outdated and needs a revamp. Though it is simple, it needs to be presented in a much better way and more advanced options need to bee presented on the front page itself. Read full review The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now. Would be nice if the 'Automate' feature was a bit easier to use. Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release). Would be nice if there were fewer releases. Read full review Likelihood to Renew Teradata is a mature RDBMS system that expands its functionality towards the current cloud capabilities like object storage and flexible compute scale.
Read full review Usability It has helped our project to save time, effort and give accurate results in the quickest possible time. The diagnostics feature is also outstanding giving us a detailed report of the error which occurred, when it occurred and the likely cause and resolution of the same as well. The support of SQL is inherited which makes it easy to work on it because you don't need to learn any new language for this.
Read full review I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review Support Rating 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.
Read full review Alternatives Considered 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
Read full review Although Toad and
UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review Return on Investment Saving time and cost through its stable integration tools which helps import and export a huge amount of different data. Providing analytics for the different data is easy and quick. Securing all the data processes across the entire company. Great Cloud solution for effective data quality management. Read full review It is the least common denominator - not particularly optimized for our environment or workflows. Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.) Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands. It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality. Read full review ScreenShots Teradata Vantage Screenshots