- This is the Brightwork Research & Analysis software rating series.
- We rate both the software and estimate the risk of implementing each application.
MUFI Rating & Risk for Teradata
MUFI: Maintainability, Usability, Functionality, Implement ability
Vendor: Teradata (Select For Vendor Profile)
Teradata is the goto business intelligence platform for heavy-duty data requirements. Teradata routinely has the largest data warehouses in the world, and it has had this through some years. Teradata has put a great deal of development effort into what it refers to as MPP, or massively parallel processing, and as a result, Teradata is a difficult software vendor for others to compete against when the data volumes get large. Teradata’s purchase of Aster Data Systems, a specialist in “big data” provides more capabilities in this area. Teradata’s capabilities with large data volumes are impressive enough that they are one of the few vendors we have ever seen that published a paper on how to keep from getting snowed by other software vendors during benchmarking. Some of their recommendations are the following:
- Don’t let the vendor dictate how to run the benchmark or what to include or exclude.
- Make sure all the vendors play by the same rules.
- Make sure you have the right team mix in terms of expertise and objectivity.
- Don’t use a subset of your data or projected volumes and then try to extrapolate. You cannot assume that performance will be linear.
- If your goal is an EDW, include multiple subject areas and have the benchmark demonstrate integration of these subject areas.
- Use real and representative data. – Enterprise Data Warehouse Benchmarks
As we note in our Honest Vendor Rating of Teradata, they provide accurate information to clients, but they also provide very detailed information. This link takes prospective buyers to videos which both explain their products and show the hardware specification for each application.
In fact, Teradata has so many videos, which is taking quite a while to get through all of them.
Teradata offers a high-quality BI platform but faces the common issues concerning high maintenance with platforms in the BI Heavy category. Teradata has been a long time supporter of the Bill Inmon “Corporate Information Factory” approach, which means high degrees of structure as well as overhead. While the research in this area is lacking, as expressed in the article link above, we think this approach has lost out and will lose out more in the future to a less structured and lower maintenance solution. The evidence we can point to for this is the fact that that the BI Light vendors.
This is less about data warehousing and infrastructure and more about the front end, and connecting to any data source are growing much faster than the BI Heavy software vendors. That the open source and unstructured Apache Hadoop is gaining a large number of converts (Amazon S3, Computer Cloud, Yahoo, Google Computer Engine). This is not to say Kimball’s approach is the best all the time, and it is also true that Teradata is quite flexible, and can be implemented any number of ways.
Teradata is a challenging application to implement due to its complexity. However, it is not unnecessarily challenging as with applications such as SAP BI/BW or IBM Cognos. Teradata is simply tackling the most challenging problems in the BI/data warehousing space. But it also offers applications and functionalities that have far-ranging benefits to data warehousing. For instance, it has a very sophisticated set of applications that are focused on controlling the prioritization of queries places upon the data warehouse.
Teradata is quite focused on using intelligence to control how resources are managed.
One of the benefits of Teradata is once the data warehouse in installed, Teradata has some applications which can leverage this data warehouse in a variety of dimensions– in this case, marketing automation shown below.
In the Teradata Selection Manager, the database of contacts can be selected for a communication plan. After the contacts are selected, the communication plan can be created.
Teradata’s add-on applications range from geospatial applications, health care, marketing analytics to supply chain applications. In fact, the many ready to go applications that can be attached to Teradata’s data warehouse applications is a major benefit of going with Teradata. We do not cover another BI software vendor that has so many additional data warehouse extensions in this way.
A primary weakness of BI Heavy platforms/applications is their high maintenance. This cuts in two directions. First, it means high long-term expenses. Second, it means that to stay away from more costs, buyers often develop a tendency to limit the user of the BI Heavy platform/applications that it does own. We consider this to be the number one issue concerning BI management, so buyers should be extremely focused on having software vendors demonstrate the maintainability functions of their applications during the sales process. We recall a conversation with one buyer who stated that “Anytime that we do anything in SAP BI/BW, it’s extremely expensive for us.” This should be completely plain to those who work in the applications, but of course, it is far more difficult to determine from simply seeing demos during a sales presentation. BI Heavy vendors have tended to focus more on the bells and whistles of BI functionality rather than usability and maintainability – and this is due primarily to sales pressure. That is “this or that client is requesting XYZ functionality, so let’s focus on that.” However, maintainability issues often determine the long-term viability and ROI of an application, and of course the limits which are placed upon its use. Some applications start off small, but grow in usage, while for others the reverse is true. The most obvious example of this is the common cutting of reports that the business would like to have, but that is not affordable to be developed. However, there are also many other examples that are less obvious that reduce the degree to which the buyer leverages the BI Heavy platforms/applications. Teradata is frequently criticized during sales proposals for its higher upfront costs – however, this is not an apple to apple comparison. IT analysts like Gartner reinforce this comparison by ranking Oracle and IBM along with Teradata in “Completeness of Vision,” on their magic quadrant – which is essentially a proxy for the vendor’s technology (how this works is explained in the book following book link). The implication being the following:
Look, Teradata only has slightly better technology than Oracle or IBM, and they have a higher up front cost, so why not save some money up front and go with a bigger brand name?
However, this ranking has more to do with how more money IBM and Oracle can afford to pay Gartner than an actual reflection of their these vendors relative BI merits. This is something which is understood, but not acted upon by executive decision makers – Gartner is a “sponsored” media outlet, and they adjust their methodology to place the vendors with the ability to pay the highest. This is explained in detail in the SCM Focus Press book Gartner and the Magic Quadrant: A Guide for Buyers, Vendors, Investors. In truth, neither IBM nor Oracle are anywhere close to Teradata in their technology.
Teradata is selling a differentiated product which has been built for the most significant data requirements. This means that their platform/applications can more easily handle any data volumes. Some of the marketing of competing vendors makes it appear as if they are offering the same product — but these comparisons are often related to specifications, and they are not benchmarks — they merely state a quantity of data processed. This does not speak to efficiency, and a great deal of this marketing is directed towards lower information buyers. Many competing software vendors have shown a disinclination to provide performance benchmarks, but Teradata routinely does. The benefit of working in the biggest data environments has lead Teradata to develop some innovations and approaches that result in times savings over the long term – and to better sustainability. Parallel processing and query prioritization are just a few examples of these innovations. A large percentage of the overall innovation in data warehousing can be attributed to Teradata. There are the reasons why we rate Teradata as the maintenance leader in the BI Heavy software category. This is reflected in our TCO Calculation for Teradata.
All scores out of a possible 10.
- Ma. = Maintainability
- Us. = Usability
- Fu. = Functionality
- Im. = Implementability
|Average Score for Big ERP||5.1||4.8||5.2||5.4||Big ERP|
|Average Score for CRM||6.2||6.2||5.1||5.9||CRM|
|Average Score for Small and Medium ERP||8.3||8||6.7||8.5||Small and Medium ERP|
|Average Score for Finance||8.8||8.8||8||8.8||Finance|
|Average Score for Demand Planning||7.6||7.2||7||7.1||Demand Planning|
|Average Score for Supply Planning||6.7||6.9||7||6.8||Supply Planning|
|Average Score for Production Planning||6.8||6.9||7||6.9||Production Planning|
|Average Score for BI Heavy||5.5||5.3||6.9||5.3||BI Heavy|
|Average Score for PLM||7||7.2||6.8||7.3||PLM|
|Average Score for BI Light||7.7||8.7||9||8.3||BI Light|
|Arena Solutions Arena PLM||10||10||10||10||PLM|
|AspenTech AspenOne||4||8||10||7||Production Planning|
|ERPNext||10||10||7.5||10||Small and Medium ERP|
|Delfoi Planner||8||6||6.5||7||Production Planning|
|Demand Works Smoothie SP||9||10||7||10||Supply Planning|
|Hamilton Grant RM||10||9||8.5||9||PLM|
|IBM Cognos||2.7||3||1.5||3||BI Heavy|
|Infor Lawson||8||7||6||7||Big ERP|
|Intuit QuickBooks Enterprise Solutions||9||9||5||9||Finance|
|JDA DM||9||7.5||8||8||Demand Planning|
|Microsoft Dynamics CRM||2||3||2||2||CRM|
|Netsuite OneWorld||7||7||8||8||Big ERP|
|Oracle BI||4||4||3||6||BI Heavy|
|Oracle CRM On Demand||4||5||3||5||CRM|
|Oracle Demantra||5||3||3.5||4.5||Demand Planning|
|Oracle JD Edwards World||4||1||3||6||Big ERP|
|PlanetTogether Galaxy APS||10||10||10||10||Production Planning|
|QlikTech QlikView||9||9||10||9||BI Light|
|Rootstock||9||8||9||9||Small and Medium ERP|
|Sage X3||8||8||7||8||Big ERP|
|SAP APO DP||3||4||3||2||Demand Planning|
|SAP APO PP/DS||2||2||4||3||Production Planning|
|SAP APO SNP||3||4||8||4||Supply Planning|
|SAP BI/BW||1.5||2||4||2||BI Heavy|
|SAP Business Objects||3||2.5||7||3||BI Heavy|
|SAP ECC||3||3||6.5||3||Big ERP|
|SAP SmartOps||4||4||7||5.5||Supply Planning|
|SAS BI||6.5||7||9||6||BI Heavy|
|SAS Demand Driven Forecasting||7||8||9||7||Demand Planning|
|Tableau (BI)||9||10||10||10||BI Light|
|Tableau (Forecasting)||10||8||5||9||Demand Planning|
|ToolsGroup SO99 (Forecasting)||7||8||9||7||Demand Planning|
|ToolsGroup SO99 (Supply)||5||6||10||7||Supply Planning|
Vendor and Application Risk
Software Decisions Risk Defined: (See This Link for Our Categorization of Risk)
Like Birst, Teradata offers a very good combination of a highly rated product along with a highly rated consulting service. Teradata has one of the best-rated consulting entities in enterprise software, and Teradata consultants can serve as more than simply implementation consultants, but also as solution architects and they can be expected to provide effective practices. These capable consultants are required because Teradata has so much depth to offer, and so many applications and functionalities that one of the risks of a Teradata implementation is getting lost in Teradata’s solution. In our view, Teradata does a very capable of job of not only selling to prospects but in educating them. The fact is, they deal with a complex set of solutions.
Likelihood of Implementation Success
This accounts for both the application and vendor-specific risk. In our formula, the total implementation risk is application + vendor + buyer risk. The buyer specific risk could increase or decrease this overall likelihood and adjust the values that you see below.
Likelihood of Application Implementation Success and Failure
Search for the application in this table using the search bar in the upper right of the table.
|Application||Prob of Implementation Success||Prob of Implementation Failure|
|SAP Crystal Reports||0.46||0.54|
|Microsoft Dynamics CRM||0.26||0.74|
|Oracle RightNow CRM||0.41||0.59|
|Oracle CRM On Demand||0.36||0.64|
|SAP Business Objects||0.32||0.68|
|Hamilton Grant RM||0.89||0.11|
|PlanetTogether Galaxy APS||0.96||0.04|
|SAP APO PP/DS||0.27||0.73|
|Demand Works Smoothie SP||0.93||0.07|
|ToolsGroup SO99 (Supply)||0.82||0.18|
|Demand Works Smoothie||0.96||0.04|
|SAS Demand Driven Forecasting||0.82||0.18|
|ToolsGroup SO99 (Forecasting)||0.86||0.14|
|SAP APO DP||0.28||0.72|
|Intuit QB Enterprise||0.8||0.2|
|Microsoft Dynamics AX||0.4||0.6|
|SAP Business One||0.49||0.51|
|Oracle JD Edwards World||0.31||0.69|
|Oracle JD Edwards EnterpriseOne||0.36||0.64|
|SAP ERP ECC/R/3||0.32||0.68|
Risk Management Approach
Buyers are in a good position to have a successful implementation after a Teradata purchase. The implementation is low risk, and unlike some other competitors in the BI Heavy space, Teradata does not in any way pretend it is anything but a BI Heavy solution.
Finished With Your Analysis?
Adelman, Sid. Enterprise Data Warehouse Benchmarks: How to Make an Informed Decision, Minimize Risk, and Measure More Than Performance. Teradata.