alternate text required

Helpful Information and FAQ

Learn about Teradata software on AWS: Overview, Products, Product Details, Getting Started, Services, Use Cases, Support, and Resources

 

Resources for Teradata Database on AWS

Here are links to additional information to make your experience with Teradata Database on AWS as productive as possible:

 

 

Partner Ecosystem Software

Customers subscribing to use Teradata Database on AWS will likely have need to use best-of-breed partner software in combination with the Teradata database for services such as:

  • Business Intelligence
  • Visualization
  • Advanced Analytics
  • Horizontal & Industry Analytics
  • Web Analytics
  • Data Security
  • Data Acquisition / Integration
  • ETL / ELT
  • Data Management & Replication
  • Data Quality
  • Data Mining
  • Performance Analysis
 

Numerous options exist to provision and deploy ISV partner software in combination with the Teradata Database on AWS. Many of our partners offer their software on AWS, making it easy for both Teradata and ISV software to be deployed in the same AWS environment. Other options include on-premises partner software connected to Teradata Database on AWS and cloud-to-cloud connectivity between partner cloud environments and Teradata Database on AWS.

When planning to deploy Teradata software in conjunction with partner software on AWS, customers should first find the Teradata ISV partner in the Teradata partner network directory and check compatibility with the Teradata 15.10 database. Fortunately, Teradata has many best-of-breed partners that have validated and optimized their software to take advantage of the advanced features of the Teradata 15.10 database.

If there is any question about compatibility of ISV software in the Teradata partner network with Teradata's AWS solution, please contact us today and we will help you find the right solutions to meet your needs and answer your questions. Teradata also has a large suite of Consulting Services that can help you get started using Teradata Datatbase on AWS as well as services to utilize a wide variety of our ISV partner software along with Teradata Database on AWS.

 

Frequently Asked Questions

1. What is being offered?
Teradata Database, the market’s leading data warehousing and analytic solution, is now available for cloud deployment on Amazon Web Services. Teradata Database on AWS is offered on a variety of multi-terabyte EC2 (Elastic Compute Cloud) instances via listings in the AWS Marketplace. By incorporating AWS for deploying a production Teradata Database, Teradata makes it easier for companies of all sizes to become data-driven with best-in-class data warehousing and analytics.

The following table shows the Teradata software products being offered for Teradata Database on AWS:

Product Description
Teradata Database Version 15.10 with Columnar, Temporal, and more
Teradata Data Mover Data movement: AWS to AWS or on-premises to AWS
Teradata Data Stream Controller Back up Teradata Database to network attached storage
Teradata Ecosystem Manager Multi-Teradata system monitoring
Teradata Presto SQL-on-Hadoop capability
Teradata QueryGrid Connects queries to other data repositories
Teradata REST Services RESTful interface to Teradata Database
Teradata Server Management Teradata system server management
Teradata Studio GUI for administration and query development
Teradata Tools and Utilities GUIs for integrating Teradata into your enterprise systems
Teradata Viewpoint Portal for either single or multiple Teradata systems

 

2. Who are the intended customers?
Literally any organization of any size can use and benefit from Teradata Database on AWS, which combines the power of Teradata data warehousing and analytics with the convenience of AWS for a win-win value proposition. Large, existing customers of Teradata on-premises products will find it just as agile, flexible, and capable as small, new-to-Teradata customers. The ability to self-provision, launch quickly, pay-as-you-go, and integrate with a wide variety of complementary software tools are all key benefits.

3. What are the expected use cases?
The use cases for Teradata Database on AWS are the same as those for other enterprise-class Teradata products: production data warehousing and analytics, test and development, quality assurance, data marts, sandboxes, and disaster recovery. Please see the Use Cases tab for more detailed information on these different scenarios.

4. What is AWS Marketplace?
AWS Marketplace is an online store that helps customers find, buy, and immediately start using the software and services they need to build products and run their businesses. Visitors to the marketplace can use AWS Marketplace’s 1-Click deployment to quickly launch pre-configured software and pay only for what they use by the hour or subscribe to an annual term. AWS handles billing and payments, and software charges appear on your AWS bill.

5. What is an AMI?
AMI is the acronym for Amazon Machine Image. An AMI is an image of a server – including an operating system and often additional software – which runs on AWS. An AMI is like a template of a computer's root volume. A Teradata AMI contains all the information necessary to boot an Amazon EC2 instance with Teradata software.

6. What is Amazon EC2?
Amazon EC2 (Elastic Compute Cloud) presents a true virtual computing environment, allowing customers to use web service interfaces to launch instances with a variety of operating systems, load them with a custom application environment, manage network access permissions, and run an image using as many or few systems as desired.

To use Teradata software with Amazon EC2, you simply:

  • Select a pre-configured, templated AMI in AWS Marketplace to get up and running immediately.
  • Configure security and network access on the Amazon EC2 instance.
  • Choose which instance type(s), then start, terminate, and monitor as many instances of the AMI as needed, using the web service APIs or the variety of management tools provided.
  • Determine whether to run in multiple locations, utilize static IP endpoints, or attach persistent block storage to the instances.
  • Pay only for the resources actually consumed, such as instance-hours or data transfer.

7. What do I need to buy software on AWS Marketplace?
Any customer eligible to use AWS products is also able to shop on AWS Marketplace. Customers must have an Amazon EC2 account. Software charges appear on the same monthly bill as AWS infrastructure charges.

8. How am I billed for AWS Marketplace software?
If you are using a Teradata AMI product that has an hourly fee, you will be billed by AWS for your use of this software. At the beginning of the month, you will receive a bill from AWS for your AWS Marketplace charges, which will include one or both of these types of charges:

  • The hourly fee for the software multiplied by the number of hours an instance with this software was running.
  • Your infrastructure charges such as EC2 usage, EBS usage, and Bandwidth usage.

For EC2 resources, each instance will run until one of the following occurs: you terminate the instance, the instance shuts itself down, or the host terminates due to software or hardware failure. Partial instance hours consumed are billed as full hours.

9. Where is Teradata Database on AWS available?
Teradata Database on AWS is available in all AWS Marketplace regions except for those in China. Amazon EC2 locations are composed of Regions and Availability Zones. Availability Zones are distinct locations that are engineered to be insulated from failures in other Availability Zones and provide inexpensive, low latency network connectivity to other Availability Zones in the same Region. By launching instances in separate Availability Zones, customers can protect their applications from failure of a single location. Regions consist of one or more Availability Zones, are geographically dispersed, and will be in separate geographic areas or countries.

10. Is Teradata Database on AWS secure?
Yes. Teradata Database on AWS offers all of the same security options that exist for any EC2-hosted offering. For example, EC2 compute instances are located in a Virtual Private Cloud (VPC) with an IP range that you specify. You decide which instances are exposed to the Internet and which remain private. Security Groups and networks access control lists (ACLs) allow you to control inbound and outbound network access to and from the instances. You can connect your existing IT infrastructure to resources in the VPC using industry-standard encrypted IPsec VPN connections

Furthermore, you can provision your EC2 resources as Dedicated Instances, which are Amazon EC2 Instances that run on hardware dedicated to a single customer for additional isolation. We refer you to AWS for details. For more information on Amazon EC2 security, refer to the Amazon Web Services: Overview of Security Process document.

11. What is Amazon VPC?
Amazon Virtual Private Cloud (VPC) lets customers provision a logically isolated section of the AWS Cloud where AWS resources may be launched in a virtual network that the customer defines. The customer has complete control over the virtual networking environment, including selection of IP address range, creation of subnets, and configuration of route tables and network gateways. Customers can also create a Hardware Virtual Private Network (VPN) connection between a corporate datacenter and a VPC and leverage the AWS cloud as an extension of the corporate datacenter.

12. Will I be able to use AWS private (dedicated) cloud instances?
Yes, customers may use Teradata Database on AWS software on dedicated EC2 instances.

13. How do I get support?
Included with your Teradata AMI subscriptions on AWS Marketplace is Teradata’s Premier Cloud Support which provides 24x7 incident creation for problem resolutions, coverage and response times by customer-defined severity levels, and entitlement to software updates. Teradata at Your Service (TaYS) is the service portal for Teradata Database on AWS.

Authorized users with Premier Cloud Support have access to Teradata Customer Service’s 24x7 Service Portal to engage in community forums for sharing ideas and discovering solutions, searching knowledge articles for relevant product & service information, downloading software updates, and accessing the Teradata Support Team for problem resolution. 

You must have a TaYS account to:

  • Request support from Teradata regarding an incident
  • Download software releases
  • Access educational materials

Note: Every Teradata Database on AWS customer must register their AWS account for a Teradata at Your Service account.

14. What Service Offerings are available?
The Teradata services team has created a broad set of AWS-specific service offerings to assist customers in their migration to, and use of, Teradata Database on AWS. The selection of advisory, training, architectural, implementation, and production services spanning is available at www.teradata.com/AWS/Services.

15. How does Teradata Database on AWS compare to other Teradata products?
Teradata offers a range of products supporting a broad swath of customer requirements. In general our on-premises products, such as IntelliFlex and the 6000 series Enterprise Data Warehouse, have the highest performance and concurrency metrics while our cloud products, such as Teradata Database on AWS, have the greatest agility and flexibility while offering superior value. The hybrid combination of on-premises, IntelliCloud, and public cloud offerings – all using the same Teradata database software – is central to Teradata’s strategy of making it easy for customers to extract the most value from their data.

16. Is it single-node or multi-node (i.e., SMP or MPP)?
Teradata Database on AWS is multi-node (MPP, massively parallel processing) and currently scalable up to 64 nodes. Higher levels of scalability will be available in the future.

17. What partner software is available?
Numerous options exist to provision and deploy ISV partner software in combination with the Teradata solutions on AWS. Many of our partners offer their software on AWS, making it easy for both Teradata and ISV software to be deployed in the same AWS environment. Other options include on-premises partner software connected to Teradata Database on AWS and cloud-to-cloud connectivity between partner cloud environments and Teradata Database on AWS. When planning to deploy Teradata software in conjunction with partner software on AWS, customers should first find the Teradata ISV partner in the Teradata partner network directory and check compatibility with Teradata Database 15.10.

18. How can I do a proof of concept (POC)?
The Teradata Services team is available to assist customers in determining the right architecture, configurations, and parameters to address the requirements of their specific use cases – and we encourage prospective users to reach out to their Teradata account team. For new-to-Teradata customers, there are a variety of options available to assist you in your evaluation and section process; please contact us for more information.

19. Can Teradata Database on AWS be used as a Disaster Recovery solution?
Yes, customers may choose to use their Teradata Database on AWS instance(s) as primary or secondary environments in conjunction with other Teradata Database environments. Customers may configure these environments for disaster recovery on their own or contract with the Teradata Services team for assistance.

20. Can I transfer data back-and-forth between this and other Teradata systems?
Yes, customers are able to transfer data between on-premises, IntelliCloud, and public cloud instances of Teradata. Customers should take note of any AWS-related data transfer fees associated with this activity.

21. Will the same monitoring tool be able to monitor this and other Teradata systems?
Yes, Teradata Viewpoint may be used to monitor multiple instances of Teradata regardless of deployment option. Be sure to choose the multi-instance version of Viewpoint rather than a single instance version if you wish to take advantage of this capability.

22. What happens when Teradata updates its products?
When Teradata publishes an AMI with an update to a product you are subscribed to, you should receive a notification email from AWS Marketplace that contains information about the latest version provided by Teradata.

23. What compliance levels are in place?
The same compliance levels that exist for all AWS-deployed software are in place for Teradata Database on AWS. We refer you to AWS for those specifics. Ultimately customers are responsible for ensuring that they meet whatever requirements are applicable for their industry, operating environment, and end-user expectations.

24. What service level can I expect?
Teradata Database on AWS offers all of the same service levels that exist for any EC2-hosted offering. We refer you to AWS for details.

25. What AWS resource monitoring capabilities are available?
Amazon CloudWatch is a web service that provides monitoring for AWS cloud resources and applications, starting with Amazon EC2. It provides customers with visibility into resource utilization, operational performance, and overall demand patterns – including metrics such as CPU utilization, disk reads and writes, and network traffic. Customers can get statistics, view graphs, and set alarms for metric data. Amazon CloudWatch aggregates and stores monitoring data that can be accessed using web service APIs or Command Line Tools.

26. What is Automatic Node Failure Recovery?
Teradata Database on AWS includes automatic node failure recovery, which applies to MPP instances using Elastic Block Store (EBS). Node failures may be related to hardware, software, or the operating system. When a node fails, Node Failure Recovery:

  • Automatically spins up a virtual hot standby node instance
  • Detaches the EBS storage of the failed node
  • Configures a new instance
  • Reattaches the EBS storage to the new instance
  • Reinstates the configuration

The replacement node is based off an image recorded when the system is first launched, or an updated image if the proper tools are run after a software upgrade. The replacement node has the same secondary IP, elastic IP, and identifiers as the replaced node. By default, the downed node continues running and can be used for diagnostic purposes.

27. May I backup and restore to/from Amazon S3?
Yes. In addition to using Elastic Block Store (EBS), customers may directly backup and restore to and from Amazon Simple Storage Service (S3). Using Teradata Data Stream Controller, this capability applies whether the source is a cloud or on-premises Teradata system and also whether the restore target is a cloud or on-premises Teradata system.

The benefit of using low-cost Amazon S3 is that customers pay only for what they use and storage scales automatically. It is easy to create and manage jobs in Viewpoint for backup and restore at the database or object level, and incremental backup means that only changed blocks are streamed from the database. Multiple parallel data streams between each Teradata node and the Amazon S3 storage bucket minimizes backup and restore windows.

28. May I directly query data in Amazon S3?
Yes. Customers may optionally directly query data in Amazon S3, which is a welcome feature addition because it helps save time and money by avoiding egress charges and effort when moving data from S3 to Teradata Database.

Direct querying of Amazon S3 is achieved by using the Teradata-to-Presto QueryGrid Connector, which interfaces with the Teradata distribution of Presto running on Amazon Elastic MapReduce (EMR), the AWS Hadoop-as-a-Service offering, or either Hortonworks (HDP) or Cloudera (CDH) on Elastic Compute Cloud (EC2) instances.

The Teradata distribution of Presto is open source (and thus free of charge), but to get support for Teradata Presto nodes customers must engage Teradata Customer Services. Teradata QueryGrid is licensed separately for use with Teradata Database.

29. Are there automated deployment options via AWS CloudFormation?
Yes. Teradata has harnessed AWS CloudFormation templates to help streamline the provisioning process for bringing up the numerous Amazon Machine Images (AMIs) involved in a Teradata ecosystem.

We’ve established three ecosystems: Test and Development, Minimum Production, and Full Production, each of which contains increasing quantities of Teradata software. To use the launch templates, customers first subscribe to the AMIs in their desired ecosystem. Once they do and once they launch the Teradata Ecosystem template, it’s a straightforward fill-in-the-blank step-by-step process to bring up the AMIs much easier than doing so manually.

30. What are the EC2 deployment considerations between choosing Local Storage or EBS?
AWS offers Elastic Compute Cloud (EC2) instances with local storage (SSD and HDD) as well as network attached storage (i.e., Elastic Block Store, or EBS, which is always SSD). Storage type should be selected carefully according to the intended use case because there are tradeoffs involved with each choice:
Local Storage (SSD)

  • Highest performance
  • Highest cost per vCPU / TB
  • Lower reliability than EBS
  • Up to 6.4TB storage per EC2 instance
  • Storage is ephemeral (e.g., requires running instance)
  • Potential for data loss if EC2 instance fails
  • Data protection via DSU Backup

Local Storage (HDD)

  • Lower performance than SSD
  • Lower cost per vCPU / TB than SSD
  • Lower reliability than SSD
  • Up to 48TB storage per EC2 instance
  • Storage is ephemeral (e.g., requires running instance)
  • Potential for data loss if EC2 instance fails
  • Data protection via DSU Backup

Elastic Block Store (EBS)

  • Highest reliability
  • Lower performance (network-attached) than local storage
  • Lowest cost per vCPU /TB (even with extra charges for EBS)
  • Up to 30TB storage (pre-provisioned) per EC2 instance
  • Storage expandable by attaching additional EBS volumes
  • Data persists independent of running instance which provides option to shut down instance between sessions in order to reduce EC2 costs (lower TCO)

31. FEATURE UPDATES: What are the latest feature updates for Teradata Database on AWS?
The most recent feature updates for Teradata Database on AWS are outlined below.

Highlights:

  • Added support for four Teradata Database tiers: Developer, Base, Advanced, and Enterprise.
  • Added 15TB and 30TB as additional storage options in CloudFormation Templates
  • Added support for South America (Sao Paulo) region
  • Added support for multi-node Server Management (CMIC)

Other Items:

  • Fixed bug where Node Failure Recovery did not properly handle multiple AMPs per volume.
  • Fixed bug where Node Failure Recovery did not sync the time of the replacement node with the rest of the system fast enough.
  • Fixed bug where Node Failure Recovery improperly assumed the DISKID of a pdisk matches the pdisk name in the vconfig GDO.
  • Fixed bug where tdc-rebuild needs to wait for all AMPs being booted to go to the UTILITY state before running the rebuild utility.
  • Added additional image customization for Developer tier.
  • Added the -n option to the tdc-rebuild utility to allow Fallback rebuild with the DBS OFFLINE and logons being re-enabled once Fallback recovery is complete.
  • Added the new tdc-securezones command to allow the user to enable the secure zones feature easily.
  • Added the new tdc-rlsecurity command to allow the user to enable the row level security feature easily. The row level security feature is now disabled by default.

Products

Teradata Database on AWS offers quick time to value. Convenient bundles enable workload portability between cloud and on-premises systems.

Getting Started

AWS offers many powerful options. We provide intuitive instructions for launching and configuring Teradata software help you get going right away.

Contact Us

Learn more about Teradata Hybrid Cloud options. Our product and services experts can help you get the most value from your data.