Teradata Unity provides the tools to take the data warehouse environment to a whole new level.
Organizations collect, store and analyze a wide diversity of data, which has increased the requirement for various types of analytical platforms. The Teradata Analytical Ecosystem, through its Teradata workload-specific platform family, comprises a multi-system environment to satisfy an ever-expanding range of analytical needs.
Any multi-system environment demands a way to handle all aspects of the analytical ecosystem—from the hardware and software components to the process and flow of data. Teradata® Unity delivers a rich portfolio to satisfy those demands while delivering numerous benefits.
Teradata Unity features all the technology needed to manage, monitor and control the Teradata Analytical Ecosystem. Moreover, it simplifies tasks for database and system administrators, offering them a seamless user experience.
The latest release brings additional capabilities, an enhanced level of integration between the products in the Teradata Unity portfolio and new names. (See Table 1.)
Click to enlarge
Unity Ecosystem Manager
For end-to-end monitoring and control, Unity Ecosystem Manager replaces Teradata Multi-System Manager. It monitors dependencies between components, processes and tables, and it allows administrators to set threshold alerts and automated actions to help organizations deliver on service level agreements.
Supporting data and database synchronization, user and query routing, Unity Director uses patented SQL Multicast technology to intelligently and selectively deliver database instructions to all affected Teradata systems. It can automatically route queries between the systems, based on the query's SQL syntax, to create a "plug-and-play" solution without requiring a query routing setup. As the replacement for Teradata Query Director and most functions of Teradata Replication Services, Unity Director can route users' sessions like Query Director did, giving administrators direct control over specific system access.
In the same way that it routes queries based on SQL syntax, Unity Director also maintains data synchronization across systems when SQL update queries are run or when external data updates come through SQL-based load utilities. The queries and updates are intelligently routed and applied to the appropriate systems.
Unity Director has additional functionality that maintains database synchronization across systems by routing and applying data definition language changes to the appropriate systems—greatly reducing the workload for administrators in a multi-system environment.
Data and database updates, which were handled through change data capture (CDC) using Teradata Replication Services, can now be applied directly to the appropriate Teradata systems using Unity Director.
"Coordinated analytical ecosystems don't just happen; they are the result of applying proven architecture principles and sound design. The analytic architecture framework from Teradata Professional Services provides the structure for building easy-to-manage, simple-to-grow integrated data warehouse environments. Working closely with the client, Teradata consultants explore the business, information, application and system aspects of a project and use the framework to transform business needs into a logical architecture that becomes the blueprint for a ready-to-run analytic solution."
—Lori Valone, senior product manager, Global Professional Services, Teradata
Intelligent data loading is enabled by Unity Loader replacing custom-built "dual load" solutions. It applies the underlying capabilities of SQL Multicast to Teradata Parallel Transporter bulk load utilities—intelligently and selectively routing the loads to the appropriate Teradata system or systems with no additional effort required by administrators. Plus, it replaces a common use of the former Teradata Replication Services in which data is bulk loaded into a table on one system, then copied over to the other systems using CDC.
Unity Data Mover
Teradata Data Mover is replaced by Unity Data Mover for fast and efficient data movement between Teradata systems. It allows administrators to focus on the purpose and intent of the movement rather than the specific utility and syntax being used.
Myriad Support Capabilities
Multi-system environments can introduce challenges to both IT and the business as workload-specific platforms are added. Teradata Unity eases the burden and allows organizations to embrace the full benefits of having more than one system. Teradata Unity's automated management functions, architectural flexibility and enablement of diverse analytic capabilities support:
- High availability. Teradata systems are often considered business critical and require continuous access by end users. A dual active architecture delivers continuous availability through planned and unplanned outages. This is a good solution for Teradata systems that run full production workloads and need to avoid down time.
- Disaster recovery. Many organizations choose a dedicated system that's geographically separated from the primary production system and can be used if there's a loss of the production system or facility. In those cases, user access and data updates are quickly rerouted to run on this secondary system.
- Deep history archives. An increasing number of companies are choosing to build a secondary system to house their historic data. This second system enables rapid access using existing tools rather than restoring data from tape when the information is needed. This archive system stores all of the data warehouse history at a lower cost, lower performance profile than the primary production system.
- Specialized applications. Many organizations have dependent data marts to house applications that serve special needs for performance, privacy, security, government restrictions or even internal politics. These systems must stay in sync with the primary warehouse and may even provide failover capability for high availability.
- Mixed uses. Some companies place their combined needs in a single system that serves multiple purposes, such as bringing together deep history and disaster recovery. This allows the primary production system to failover, in a disaster, to the secondary system, which has current and historic data. Or, as another example, organizations can combine data mining with deep history, which lets them run the resource-intensive workloads on the secondary rather than the primary production system.
Enabling a Holistic Ecosystem
The integrated Teradata Unity portfolio enables the management, monitoring and control of the Teradata Analytical Ecosystem. It simplifies tasks for administrators and provides a seamless experience for users performing business analytics. Working in concert, these unique products turn a multi-system environment into a well-orchestrated analytical ecosystem.