Moving data from one system to another is a key part of your analytical ecosystem operations. Well-planned monitored, and managed data movement is essential to the effective operation of your overall ecosystem.
Whether your goal is to complete a onetime copy of data from your enterprise data warehouse (EDW) to your test system or to regularly and continuously synchronize a dual system environment, you need confidence that the data will be in the right place at the right time while causing the smallest possible impact on the data warehouse‘s mission of serving your business.
The decision about the best way to copy data between Teradata systems depends on many factors, including the data model and indexes present, other workloads in your system, and additional load jobs underway
What you need is a solution that automates the data movement process, a solution that also accommodates the many situations found within your comprehensive analytical ecosystem. And that‘s exactly what Teradata® Data Mover delivers to you and your business: all the supporting capabilities you need to easily, effectively – and affordably –meet your data movement demands
Teradata Data Mover is a utility designed specifically to copy data and objects such as tables and statistics from one Teradata system to another. It takes advantage of the built-in underlying technologies already in your Teradata system. And it understands the available techniques you have for extracting data from or loading data into your Teradata Database, as well as our various load utilities, backup/restore products, and the JDBC driver.
Desired to gain proficiency on Teradata? Explore the blog post on Teradata Training in Bangalore
to become a pro in Teradata.
Leverage Existing Technologies
Teradata Data Mover leverages all of the established data loading protocols and technologies to meet your needs and environment best.
You can use the utility for:
> Regular periodic tasks including populating a dependent data mart from an EDW.
> Special one-time tasks such as moving data to a test system.
The utility also works with every member of our Teradata Purpose-Built Platform Family.
In addition, it supports Teradata Database V2R6.1 and higher and runs on a Teradata Managed Server for high availability and comprehensive monitoring.
An End-to-End Management Solution
You can also integrate data movement within your comprehensive ecosystem management and load jobs and automate.
Teradata Data Mover for your production execution needs. That‘s because the utility can be tightly integrated with Teradata Multi-System Manager for end-to-end management of changes to your environment.
The utility works with Teradata Multi-System Manager to support these commands and status messages:
> Send event for the start of a job.
> Send event for the end of a job.
> Send event for a job in progress.
And Teradata Data Mover can be integrated with load processes to copy data to a second system. That means you can copy data from an EDW to a data mart as soon as the data are loaded into the EDW.
Teradata Data Mover also provides safeguards to force the direction of data movement and eliminate any possibility of copying data in the wrong direction. Teradata Data Mover not only copies data, but reduces operational cost and complexity and improves your overall data management capabilities by copying an array of objects, including Tables, PPI tables, Global Temp Tables, Tables with LOB columns, Statistics, Triggers, Join Indexes, Hash Indexes, Tables with UDT columns, and Users.
Check out the top Teradata Interview Questions now!
Swift, Simple Data Movement
Your analytical ecosystem uses multiple Teradata systems, each with different roles.
For example, you may have a Teradata Active Enterprise Data Warehouse serving as an EDW, a Teradata Extreme Data Warehouse for deep history web click analysis, and a Teradata Data Mart Appliance as a test and development system.
As part of your critical ongoing maintenance, you must be able to move or copy data from one system to another. Teradata Data Mover simplifies data movement and enables process automation, control, and monitoring. It also provides a point-and-click user interface to enable powerful data movement commands.
Flexible, Powerful, Easy-to-Use
The value of any analytical system rests heavily on having the right data in the system. In fact, the very success of your enterprise can depend on the smooth operation of the data movement. That's why it's so vital that data be moved quickly and reliably between your Teradata systems. And you can add more value – and reduce operational costs – when you use production-quality tools to create standardized jobs, monitor status, and progress, and handle exceptions. Teradata Data Mover offers you a complete solution to improve your processes and reduce the cost involved in maintaining the analytical ecosystem. Take advantage of its scope of data movement technologies and breadth of control mechanisms. Whether it's event-driven for automatically moving newly loaded data or ad-hoc DBA-initiated copies for exception processing, Teradata Data Mover gives you the power and flexibility to strengthen your analytical environment and deliver even more value from your data.
For In-depth knowledge on Teradata click on:
- BTEQ Features in Teradata
- Secondary Index in TeraData
- Memory Management in TeraData
- Types of OLAP’s in TeraData
- TPUMP Structure and Process In TeraData