Teradata Data Warehouse Integration - Locus IT Services

Teradata Data Warehouse Integration

Locus IT ServicesData WarehousingTeradata Data Warehouse Integration

Teradata Data Warehouse Integration

Teradata Data Warehouse Integration Solutions is for actionable insights and decision-based analytics.

Performing Teradata Data Warehouse Integration for your analytics infrastructure to Teradata from IBM DB2, Oracle, Netezza, or other platforms which can improve your analytical environment scalability, performance, and manageability.

Teradata Data Warehouse Integration solutions platform creates improvements in data duplication, and general complexity for our customers and can experience faster load times, improved query response times and less infrastructure complexity and maintenance costs.

Feature Highlights of Teradata Data Warehouse Integration

Maximize Value From Your Data

The world’s most powerful database plus it has wide variety of deployment options and consulting to deliver maximum value from your data.

Integrated and Comprehensive Data

A 360-degree look of your entire business is integrated from all data sources and provides richer insights.

High-Speed Parallel Data Fabric

A gateway to actionable large data insights with Teradata QueryGrid

Intelligent-Memory Processing

The performance of in memory databases without the cost is done by automatically storing most frequently used data in memory.


Lowest total cost of ownership, optimized business analytic engine

High Availablity

Mission-critical availability and performance

Deployment Flexibility

Deploy on-premises using Teradata IntelliCloud in a public (AWS or Azure) cloud that is in private cloud or hybrid cloud environment

Flexible Platform Options

The Teradata Active EDW 6800 is available in multiple configurations, depending on your performance and capacity requirements. The Active EDW 6800H utilizes hybrid storage (HDD and SSD) while the Active EDW 6800C is HDD-only.

The highest performing Active EDW 6800H configuration is designed for the most demanding customers with a tremendous need for high data volumes, scalability, performance, and concurrency.

The Teradata Active EDW also supports a wide variety of processing and storage elements integrated into the system cabinets for the flexibility to meet customer needs. These include:

  • Teradata Node – The initial processing element for the Teradata Database.
  • Hot Standby Node – A redundant Teradata node added to a clique to provide full performance continuity during node failure.
  • Data Storage Arrays – Multiple storage arrays that provide both the RAID controllers and data storage drives. The storage drives can be SSD and/or HDD drive types.
  • Teradata BYNET InfiniBand Switches – It will supports the high-performance BYNET system interconnect with high availability, fault tolerant, dual networks that ensure highly scalable, error-free MPP communication. For big sized systems, a separate switch cabinet is used to scale out the BYNET-based InfiniBand fabric to the required number of nodes.
  • Channel Node – A dedicated Teradata node that’ll supports Teradata Database’s unique capability for mainframe connectivity. Also, the Extended Channel Server allows connection to a remotely located mainframe.
  • Teradata Managed Server – It applies enterprise-level Teradata system management capabilities to a commodity
    server for applications that support Teradata Database. A base model of the server can be perfectly configured to meet your needs and supports the Linux operating system. Pre-configured models are available for specific Teradata tools and applications, such as Teradata Unity, BAR (Backup and Restore), and others.
  • Virtual Management Server (VMS) – It is based on the Teradata Managed Servers and virtualization technology, this server virtualizes multiple key system functions into a single physical server. These functions include Teradata Viewpoint, the cabinet management functions, and the Teradata Customer Services Workstation for remote access to the system. The VMS saves valuable cabinet rack space by eliminating the need for separate physical servers for each of these functions.
  • Platform Framework Cabinet (PFC) – Provides a flexible approach to the packaging and management of all of the platform elements described above that are not Teradata node or storage related.

Robust Workload Management

  • Teradata Workload Management provides capabilities to classify, manage, and prioritize workload so the database resources (CPU and I/O) are distributed fairly and according to the predefined priorities.
  • Teradata Integrated Workload Management is built into all Teradata platforms and provides the necessary features to manage and prioritize the workload.
  • Teradata Active System Management (TASM) is optional for the Teradata Active EDW 6800 and provides additional workload management and prioritization capabilities suitable for heavy mixed workload or active environments.

Teradata data solutions and products remove limitations in concurrency, flexibility, and the ability to handle diverse workloads while providing the simplicity and scalability.

We at Locus IT use Teradata products and provide Warehousing  services like Teradata Data Warehouse training, Teradata Data Warehouse support, Teradata Warehouse Customization. For more details please  contact us.

Locus IT Project Management Office
What’s it?