Teradata - one size fits all, really.
June 08, 2017
Teradata - one size fits all, really.
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Teradata Vantage Advanced SQL Engine (Teradata Database)
Terdata is currently used as the main database application for a majority if not all departments across the organisation, containing both the enterprise data warehouse(s) and group data warehouse(s).
- Scalability, where it's able to house magnitudes more data compared to a standard SQL database while still retaining good performance.
- Performance, able to quickly retrieve millions of rows with ease.
- Adaptability, able to connect to the likes of Tableau desktop to enable quick analysis.
- Interface is outdated
- Some syntax slightly different to standard SQL
- Needs expertise to best create tables so as to not 'skew' database
- Positive - allowing multiple departments to use and access fewer versions of the 'truth' which results in the least variance in data across the organisation
Using Teradata Vantage Advanced SQL Engine (Teradata Database)
5000 - Finance, Human Resources, Workforce Management, Business Performance Analytics, Strategy and Analytics, Network Transformation.
20 - DBA with expertise in maintaining large amounts of data/tables.
- Repository for entire organisation's data needs
- Connect with tableau to directly initiate analysis
Evaluating Teradata Vantage Advanced SQL Engine (Teradata Database) and Competitors
- Product Features
- Product Usability
- Product Reputation
- Vendor Reputation
Competitors all use this product.
No change, as this is the standard application used in the banking industry in Australia.
Using Teradata Vantage Advanced SQL Engine (Teradata Database)
| Pros | Cons |
|---|---|
Like to use Technical support not required Feel confident using | Difficult to use Lots to learn |
- Standard SQL style queries
- Queries not sharing same syntax as SQL