October 21, 2014 | PARTNERS CONFERENCE & EXPO Nashville, Nashville, TN

Teradata Data Integration Optimization Service Enhances Performance in the Big Data Era

New consulting service helps customers achieve greater analytic performance at a lower cost

Teradata Corp. (NYSE: TDC), the big data analytics and marketing applications company, today announced the expansion of its global Teradata Consulting Services to include Data Integration Optimization (DIO) services. Teradata Consulting Services teams offer guidance on how to improve performance and reduce costs by using the right platforms for the right jobs.






The proliferation of new data sources and analytic technologies has rendered existing data integration architectures inadequate to properly manage the balance between data management tasks and analytics workloads. As the complexity increases organizations are struggling to find answers. Teradata can assist organizations with the evaluation of all options, including: deciding whether to modify their extract, transform and load (ETL) code, re-architect ETL processes, or extend the Teradata® Unified Data Architecture® with systems such as Hadoop or a Teradata appliance.
“Successful execution is not only about technology, it’s also about people, the right people, with lots of experience and proven methodologies,” said Dan Harrington, executive vice president, Global Consulting and Support Services. “Teradata’s world class consulting services ensures that customers are constantly able to save a considerable amount of money and maximize resources across the entire analytic ecosystem.”
Teradata can assist customers with the evaluation of system performance across the Teradata Unified Data Architecture and offer guidance on the multiple approaches to optimizing their analytic platforms. Some successful engagements are described below.
  • Modify ETL Code
    A large international telecommunications customer wanted to extend their Unified Data Architecture with Hadoop to offload ETL processes from the Teradata Integrated Data Warehouse. However, after Teradata teams assessed the ETL code and analytic environment, they found a significant amount of ETL code was inefficient and recommended the company modify it. This approach freed up capacity for additional analytics.

  • Re-Architect Processes
    Some Teradata customers have built a data lake repository on Hadoop as part of their Unified Data Architecture. For example, a major computer manufacturer wanted to identify specific ETL processes that could be re-architected and run on a Hadoop data lake to avoid complex, costly data modeling and data integration efforts. Teradata helped configure the data lake by segmenting a portion for a data-landing zone, and a portion for ETL processing. This allowed users to access specific data for discovery, while leveraging the power of Hadoop to streamline some of the ETL processing. The customer was able to cost effectively use the data stored in Hadoop to enrich analytic insights.

  • Extend UDA with Appliance
    A U.S. telecommunications company optimized data in their ecosystem by assigning workloads to the most appropriate systems. Based on recommendation from Teradata consultants, the company added a Teradata Appliance for specific workloads requiring cost-effective system performance and scalability. This transfer was made easily, because Teradata platforms run the identical Teradata Database, which allows for portability of all software. As a result of these efforts, the company is better able to perform high-value analytics to supply business users with insights.

  • Modify Code, Re-Architect Processes, and Extend System
    A major high-tech manufacturer had maximized the utilization of its Teradata Integrated Data Warehouse and was concerned about possible inefficiencies in the ETL code and data loading jobs. Initially, Teradata identified data integration processes to offload to a lower cost Teradata appliance, allowing for code portability between Teradata systems. Next, Teradata’s focus shifted to high-value ETL jobs and tuned inefficient code and modified ETL process jobs. Finally, Hadoop was leveraged for specific ETL jobs. The adoption of all three approaches helped the customer implement a tiered solution to resolve the issues of inefficiencies in the ETL code and data loading jobs.

"By leveraging the best systems optimization plan for data integration tasks, organizations can get more value out of their data and analytic ecosystem," said Dan Vesset, program vice president, Business Analytics and Big Data, IDC. "Teradata DIO services can demonstrate how best to improve performance and free up capacity for business analytics – all while lowering the overall total cost of ownership."
Teradata Consulting Services
From best practices developed during global engagements, Teradata Consulting Services uses a patented methodology for the planning, design, implementation, and management of the most advanced business analytic systems for market-leading companies. Teradata Consulting addresses the business, information, application, and systems components that are needed to deliver an effective Unified Data Architecture™. Teradata consultants, with an average of 10 or more years of experience, combine deep technical and industry expertise to reduce risk and ensure rapid realization of business value. Teradata consultants and customers are further supported by seven Global Development Centers that provide a full spectrum of data management and analytic expertise.
Teradata’s DIO services are now available to organizations worldwide.

About Teradata

Teradata empowers companies to achieve high-impact business outcomes. Our focus on business solutions for analytics, coupled with our industry leading technology and architecture expertise, can unleash the potential of great companies. Visit teradata.com.

Teradata and the Teradata logo are trademarks or registered trademarks of Teradata Corporation and/or its affiliates in the U.S. and worldwide.
MEDIA CONTACT:
Mike O'Sullivan
Teradata Corporation
Telephone: (937) 242-4786
E‑mail: mike.osullivan@teradata.com