• Teradata Cloud FAQs

    Frequently Asked Questions



    What is Teradata Cloud?

    With Teradata Cloud our customers gain the gold standard for analytics with market leading Teradata Database for Data Warehousing, Teradata Aster Discovery Platform, and Hadoop in a secure and hosted infrastructure. Teradata offers customers fast and flexible provisioning options and scalability as needed. Teradata Cloud services are available in monthly, annual or three year pricing agreements. However, “custom cloud” or hosted offers (based on Teradata’s Workload Specific Platforms) are available via a three year pricing agreement only.

    Teradata Cloud provides Data Warehouse, Discovery, and Hadoop environments:

    • Data Warehouse as a Service (with Teradata Database)
      • Availability in the United States
      • Includes core database functionality, Integrated Workload Management and Teradata tools and utilities
    • Discovery as a Service (with Teradata Aster Discovery Platform)
      • Availability in the United States
      • Includes Aster MR (Map Reduce) Analytical Foundation, Aster MR Analytical Premium (Path/Pattern, Statistics, Relationship), and Aster Graph Analytics

    Each “as a service” offer includes the following components:

    • Cloud Foundation: for cloud infrastructure functions such as hardware and software monitoring and maintenance, backup and recovery, and resource provisioning.

    • Enhanced Services: optional services for implementation of advanced database features (such as temporal, SQL-H etc.) and added network bandwidth options.

    • Consulting Services: optional services for advising on analytic best practices, migrating from existing databases, database administration, data quality, implementing applications (Teradata and 3rd party) and providing analytic access to BI applications. Teradata Managed Services, which provide operational and development support, are also a critical component of our consulting service capabilities.

    What is a Cloud Compute Unit?

    Teradata has developed a new cloud platform—the Cloud Compute Unit (CCU)—which is hardware, storage, software and system management utilities specifically engineered for cloud computing.

    What is the storage capacity per CCU?

    For Teradata Database, the usable storage capacity per CCU is 4TB (before compression). For Teradata Aster Database, the usable storage capacity per CCU is 5.5 TB (before compression). These capacity amounts take into account the Teradata Fallback feature, which keeps a second copy of data for data protection and availability.

    Compression is enabled by default for all user tables on Teradata Cloud systems. Actual compression rates will vary depending on data demographics; however rates of 3X or higher compression are common.

    What is the minimum amount of CCUs I can specify in a single Teradata and/or Teradata Aster system?

    For Teradata Database:

    • For failover protection, we recommend a minimum of 2 CCUs. However, a single CCU system is also available for smaller data requirements. Please note that single CCU systems have lower availability than multi-CCU configurations because Fallback protection will not be available.

    For Teradata Aster Platform:  

    • Minimum CCUs required (2 queens and 6 workers).


    What other systems are provided during provisioning of Data Warehouse or Discovery as a Service?

    As a Teradata Cloud customer you gain three servers along with your Teradata or Teradata Aster provisioned CCUs:

    • A load server running Teradata/Teradata Aster load utilities with 100GB of staging space

    • Preconfigured Viewpoint server for management of database resources including predefined views:
      • Dashboard with a high level view of Teradata Cloud systems
      • Current activity for monitoring active sessions
      • Capacity view for managing space and resource utilization trends over time

    • Utility server (via remote desktop access) which is preconfigured with Teradata and/or Teradata Aster client tools for data access, database management and load/unload functions.

    What database releases are supported at this time?

    Teradata 14.10 and Teradata Aster 6.00 releases are currently supported.

    I’m ready to get started. What’s my next step?

    Contact your Teradata Account Manager or submit the information on this form to get started. A Teradata Solution Architect will then work directly with you to help obtain a quote or place an order for Teradata Cloud.

    back to top

    Data Connectivity and Loading

    What are connectivity options for my cloud system/s?

    The default method of connectivity to Teradata Cloud provisioned systems is site-to-site VPN from your data center. This access method uses IPSec communication to keep data transmissions secure and provides network access—through the Internet—with bandwidth of up to 100 Mbps.

    If a larger and dedicated network port is required, Teradata Cloud can provide you an enhanced option called Teradata Direct Connect which offers either a 1 Gbps or 10 Gbps direct connect port. With this option, you are responsible for procuring WAN bandwidth via your preferred telecommunications provider.


    Is 100Mbps over VPN enough for my data movement needs?

    Teradata Cloud includes VPN access over the Internet up to 100Mbps as part of our standard cloud offer. Will you need more? The answer depends on how much data you plan on moving back and forth between your data center and Teradata Cloud. Follow this link for a simple calculator to help you better understand your data transfer bandwidth needs. Also note that while site-to -site VPN connections over the Internet are secure, actual bandwidth will vary. If you need guaranteed bandwidth you will need to use a dedicated private circuit available from various telecommunication providers.

    What is needed to setup site-to-site VPN?

    A Teradata Cloud site-to-site VPN form must be filled before a VPN tunnel can be established. This form will be given to you by our Cloud Operations team. A global public IP is required for routing return traffic on the site-to-site VPN.

    What’s the best way to access my Teradata and/or Teradata Aster cloud system?

    Upon provisioning a Teradata or Teradata Aster system, instructions will be provided on how to access your cloud environment.  As a customer, you will get a list of IP addresses to your database systems, load server, Viewpoint server and utilities server along with instructions on how to access each one.  The load, Viewpoint and utility servers will be preconfigured to access your database system(s) from within the Teradata Cloud.
    External IP addresses will be provided to access database systems directly from servers or desktops within your own network, and you can download Teradata Tools & Utilities

    Database access to Teradata is available through any of the following drivers and utilities:

    • ODBC, JDBC, OLE DB Drivers
    • .Net Data Provider
    • Teradata CLIv2
    • Teradata Plug-in for Eclipse
    • BTEQ – Command line query tool
    • Teradata Studio – Eclipse based database query tool

    Database access to Teradata Aster is available through the following drivers and utilities:

    • JDBC, ODBC, .Net Provider

    Will I be provided a load server for loading my data?

    A load server with 100GB of staging space will be provisioned with your Teradata Cloud environment.  This server can be used for loading when data volumes are smaller than 100GB per batch. 

    I need to load large and concurrent data volumes.  What’s the difference between the load server included in the base price of Teradata Cloud and an enhanced load server?

    Included in Teradata Cloud base package is a load server with 100GB of staging space for Teradata Data Warehouse or Teradata Aster Discovery Platform instances. The load server will have Secure File Transfer Protocal (SFTP) service running, allowing a direct upload of data files. If you expect to have large load volumes on a regular basis, Teradata Cloud provides an option to provision an “Enhanced Load Server”.  This load server is configured with 3.6 TB of staging space. Teradata tools and utilities version 14.10 are included with both load servers.

    How do I integrate (i.e. load) data into Teradata Cloud? 

    Teradata Cloud load servers supports SFTP to move data files into the cloud. All necessary load/unload utilities are provided on the Teradata Cloud load server.

    Data loads into CCUs are accomplished in the following ways:

    For Teradata Database:

    • Teradata Parallel Transporter – (recommended)
      • Load Operator to insert data into empty tables (Fastest)
      • Update Operator to insert/update data into populated tables
      • Stream Operator to insert data into tables concurrently (enhanced option)
      • Inserter Operator to insert BLOB data
    • Legacy stand-alone tools – (for support of legacy scripts)
      • Fast Load
      • Fast Export
      • Multi Load
      • TPump (enhanced option)

    For Teradata Aster Database:

    • Teradata Aster Loader Tool
    • Teradata Aster Export Tool

    What’s the best way to load large files to Teradata Cloud? 

    Portable storage devices can be used to transfer large amounts of data into the Teradata Cloud. Please review the Teradata Cloud Import/Export document available on our cloud service desk for further details. Teradata Parallel Transporter can load data files in delimited or fixed width formats. Customers with an existing Teradata system can use ARC (ARCMAIN utility) to create a copy of data to load into the external device by using an ARCHIVE command for each source database.

    Another option is “Teradata Direct Connect” for initiating a connection from your datacenter to Teradata Cloud. Optional 1 Gbps or 10 Gbps connection ports are available for data transfer.

    back to top

    Data Security

    Data security is really important. How does Teradata Cloud tackle security?

    Teradata Cloud supports secure connections for data transmission. Your cloud systems are only accessible via Ipsec VPN tunnels between your premise/data center and the Teradata Cloud, providing an additional layer of security. All traffic is encrypted.

    To keep “data at rest” secure, Teradata utilizes self-encrypting drives on dedicated database servers.

    What authentication methods are available?

    Teradata/Teradata Aster cloud systems are LDAP ready. By default systems will use a native database authentication method.

    In Teradata, users DBC (superuser), SYSDBA (database management) and SECADM (security administration) are provided with TD2 authentication and default passwords.  It is important to change passwords for these users as soon as you can access the system. User SYSBACK is created on all Teradata systems and its password is secured by Cloud Operations. The SYSBACK user’s password should not be changed because it is used to execute daily backup operations on the system.

    In the Teradata Aster database, users DB_SUPERUSER and BEEHIVE are provided with native authentication and default passwords which should be changed as soon as you can access the system.

    back to top


    What availability techniques does Teradata Cloud utilize?

    All CCUs, for both Teradata and Aster databases, are configured using RAID 1 protection. RAID-1 provides redundancy at the hardware/disk-drive level. 

    Teradata Database

    On the chance of a single drive failure, Teradata Database will continue to function without interruption. The failed drive will be replaced by Cloud Operations as soon as possible and the drive will rebuild automatically.

    In the unlikely event that both copies of a RAID 1 pair fail, the Teradata database has been configured to use Fallback protection on all tables. Fallback provides a layer of protection that extends beyond just a loss of redundant hardware. With Fallback, a secondary copy of your data exists on a different CCU (for Teradata systems with 2 or more CCUs). The database will go through a restart and continue to function with a reduction in performance. Once the failed drives are replaced, the Teradata database will rebuild the new drives using the fallback data copies.

    Teradata Aster Database

    In the unlikely event that two drives within of a RAID 1 set fail, the Teradata Aster Database has been configured to use a Replication Factor of 2. This means that a secondary copy of your data exists on a different CCU. In this instance, the database will continue to function with a reduction in performance. Once the failed drives are replaced the Teradata Aster Database will rebuild the new drives using replicated copies of your data.

    back to top


    I need more CCUs. How do I scale my Teradata/Aster System?

    Please work directly with your Teradata Solution Architect to place an order to increase the size of your system.  Provisioning of CCUs will take 24-48 hours. Teradata systems can be scaled up or down in minimum increments of one CCU.  Teradata Aster systems can be scaled up in minimum increments of one CCU but cannot be scaled down.

    Will I have access to my Teradata/Aster system during scaling?

    A Teradata Database system will be available for read only operations while a new system is created during scaling operations.  During this time, customers cannot load or change data, but can continue to run queries and reports.  When the new resources are ready, there will be a few minutes of scheduled downtime to transition from the former to new resources.

    A Teradata Aster system will have an outage when growing the system while data are balanced across CCUs.

    back to top


    How often are my data backed up in Teradata Cloud?

    For Teradata Database, we provide a daily backup of customer data. Each backup will also be replicated to a secondary site. Future releases of Teradata Cloud will include a backup solution for Teradata Aster systems.

    Are backups automatically configured?

    As part of provisioning, two backups copies are maintained at the primary site and an off-site replication copy is maintained at a secondary site. The “sysback” user in Teradata Database is used to perform backups. If you want to change passwords for the “sysback” account, you must coordinate with Teradata Cloud Operations via a change management ticket in the Teradata Cloud Service Portal to ensure uninterrupted backups.

    Does Teradata Cloud retain backups?

    By default, Teradata Data Warehouse as a Service (with Teradata Database) maintains two generations of daily backup copies on disk at primary site and replicated copies at a secondary site. 


    What if I need my data restored—how is this process accomplished?

    Customers will place a request for restore (either at table, database, or full system level) via the Teradata Cloud Service Portal.

    back to top


    Who performs hardware/software maintenance on my Teradata/Teradata Aster systems?

    Complete hardware and software support is provided by the Teradata Cloud operations team. Cloud operations will inform you when updates to Teradata software or operating systems are recommended. Cloud Operations will coordinate incidents, and change control with you (for implementation of software updates) as required. Testing of software updates is still your responsibility.

    During software maintenance, will my Teradata/Teradata Aster system be available?

    The Teradata/Teradata Aster database system will not be available when software maintenance is performed on CCUs during a planned maintenance window.

    back to top


    How do I monitor the performance of my Teradata/ Teradata Aster system?

    A Viewpoint server is provisioned as part of a Teradata/Teradata Aster system. Teradata Viewpoint is your single operational view into Teradata and Teradata Aster system management and monitoring.  This instance of Viewpoint can only monitor your Cloud-based systems.

    What does Teradata Cloud Operations monitor for me?

    Cloud Foundation Services include platform availability, backup, security monitoring and availability monitoring of the Teradata Cloud environment. 

    back to top


    Who are Teradata Cloud Operations and what do they do?

    Teradata’s Cloud Operations team performs activities such as provisioning, onboarding, back-ups and software patching for your Teradata or Teradata Aster system. Our Cloud Operations team continually monitors and administers the CCU environment to help ensure availability and data recovery and provides daily backups to a remote location.

    What are the support hours for Teradata Cloud?

    Teradata will deliver Cloud Service Desk services, seven days a week, twenty four hours a day.

    The Cloud Service portal will be available seven days a week, twenty four hours a day, three hundred and sixty five days a year (7 x 24 x 365) for the submission of incidents, changes and requests for information. 

    What can I expect for Teradata Cloud Service Availability?

    Teradata will use commercially reasonable efforts to make the Teradata Cloud service generally available twenty four (24) hours per day, seven (7) days per week, three hundred, sixty five (365) days per year.   Teradata will target a Service Level Agreement (SLA) for Teradata Cloud Platform Availability (excluding planned downtime) of 99.9% measured on a monthly basis.

    NOTE: Systems configured with only one (1) CCU, do not provide failover capacity in the event of a CCU failure. Therefore, a one (1) CCU configuration will have no service availability/guarantee.


    Service Feature

    Cloud Premier Support

    Cloud Incident Creation

    • Cloud Service Portal for Incident creation
    • Telephone (P1 Only)
    • Automatic Incident Creation – generated by Teradata Systems

    Cloud Request for Information

    • Cloud Service Portal

    Cloud Request for Change

    • Cloud Service Portal

    Incident Coverage Hours




    Cloud Operations

    On-call for P1 incidents

    9x5  Local Time Zone

    9x5  Local Time Zone

    Hardware/Software Incidents




    Engineering Changes (FRO)




    Response Times

    2 hours

    Next Business Day

    Next Business Day

    How do I request support on my Teradata Cloud systems?

    Up to five customer users will be provided with access to the Teradata Cloud Service portal (https://support.teradatacloud.com) for submitting requests for information, and tracking incidents and changes.

    back to top


  • Sign Up for Teradata Cloud

    Connect with a Teradata Cloud expert.

    Get Started