Teradata Data Warehouse - IntelliCloud

Same full-feature data warehouse software powering analytics at many of the world's greatest companies. Customers get quick time to value and low total cost of ownership. Applications are portable across cloud and on-premises deployments with no re-training required. Teradata provides industry-leading features, and the world's most advanced hybrid row/column database.


  • Designed from the ground up for decision support
  • Integrates with nearly all ETL and BI tools
  • Flexible and fast Scale-up and Scale-out options
  • Available on AWS, Azure or Private Cloud
  • ANSI standard SQL
  • Industry’s most intelligent Cost Based Optimizer
  • Sophisticated workload management
  • Highest ranked Gartner vendor on critical capabilities for data management
  • Excellent Reliability, Availability, Serviceability, and Recoverability
  • On demand or reserved configurations


  • Flexible cloud configurations
  • Teradata Database is easy to administer
  • Performance guarantees on SLAs
  • Lower cost fully managed PaaS
  • Unparalleled performance
  • Launch in Minutes, not Months
  • Rapid and easy procurement for quick proofs of concept
  • Embed your favourite script language - Python, R etc
  • Choose your favourite ETL or BI tool


£2700 per instance per month

Service documents

G-Cloud 9



Tony Walsh



Service scope

Service scope
Service constraints Short monthly maintenance window for patching and updates. Negotiated and scheduled with business stakeholders to cause minimum disruption.
System requirements No additional software required

User support

User support
Email or online ticketing support Email or online ticketing
Support response times Varies depending on severity of ticket:
P1 Critical - 24x7 logging, acknowledgement within 2 hours, updates every 2 hours
P2 Significant - 9am-8pmx5 logging, acknowledgement next business day, daily updates
P3 Minor - 9am-8pmx5 logging, acknowledgement next business day, weekly updates
User can manage status and priority of support tickets Yes
Online ticketing support accessibility None or don’t know
Phone support Yes
Phone support availability 24 hours, 7 days a week
Web chat support No
Onsite support Yes, at extra cost
Support levels Standard support is included at zero cost. In addition to standard support Teradata also provides an additional Critical Systems Management support, Costs are dependent on customer requirements and can include a Technical Account Manager (TAM)
Support available to third parties Yes

Onboarding and offboarding

Onboarding and offboarding
Getting started On-boarding services included, with optional consulting and training if required.
Service documentation Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction By mutual arrangement, typically on a storage device
End-of-contract process In the event of termination of an Order for any reason, Customer’s access and use of Teradata Cloud and Customer’s rights shall cease forty-five days following termination and Teradata will cooperate with Customer in good faith to work out a schedule and the associated costs to transition the Customer Data to Customer or another service, at Customer’s option, during such time, and, following such transition, will promptly destroy all remaining Customer Data on the Teradata Cloud.

Using the service

Using the service
Web browser interface Yes
Using the web interface This service provides customers with self-service management and monitoring capabilities for Teradata IntelliCloud and is designed for Teradata IntelliCloud customers to manage and drill into detailed status of their support tickets and configuration details including security configurations of their Teradata IntelliCloud services and for Teradata IntelliCloud service operators to efficiently solve the problems of or operate the customers’ Teradata IntelliCloud environments.

After purchasing a Teradata IntelliCloud service, new customers receive credentials for the console, and existing Teradata IntelliCloud users can login with their credentials of the Teradata IntelliCloud Support, ServiceNow. Teradata IntelliCloud service operators can monitor and operate all customers’ environments without an access to customers’ data. All Teradata IntelliCloud customers’ console users can monitor and manage their own Teradata IntelliCloud environments. There are built-in database and system metrics exposed for each of these databases including Service Availability, Active Sessions, Memory failures and CPU/Memory/Disk-Space utilization. Customers can also set alert thresholds on each metrics to receive notification for certain conditions. With the console, users can view the configuration of their databases and initiate change requests
Web interface accessibility standard None or don’t know
How the web interface is accessible None
Web interface accessibility testing None
Command line interface No


Scaling available No
Independence of resources Everybody wants to run queries on the Teradata database at the same time - from the boardroom, to marketing, to front-line customer service - and they all want answers as close to real-time as possible. Teradata Workload Management prioritises the work as per your specifications and assigns resources to make sure everything gets done on time to meet business demands.

Because there's no such thing as a "typical day" when it comes to your data warehouse, Teradata Workload Management automatically manages resources during peak periods. This maximises utilisation of resources and ensures that the most important workload gets done first.
Usage notifications Yes
Usage reporting
  • API
  • Email


Infrastructure or application metrics Yes
Metrics types
  • CPU
  • Disk
  • Memory
  • Network
  • Number of active instances
  • Other
Other metrics
  • Query response times
  • Database lock monitor
Reporting types
  • API access
  • Real-time dashboards


Supplier type Not a reseller

Staff security

Staff security
Staff security clearance Other security clearance
Government security clearance Up to Baseline Personnel Security Standard (BPSS)

Asset protection

Asset protection
Knowledge of data storage and processing locations Yes
Data storage and processing locations
  • United Kingdom
  • European Economic Area (EEA)
User control over data storage and processing locations Yes
Datacentre security standards Managed by a third party
Penetration testing frequency At least once a year
Penetration testing approach Another external penetration testing organisation
Protecting data at rest Encryption of all physical media
Data sanitisation process Yes
Data sanitisation type
  • Explicit overwriting of storage before reallocation
  • Deleted data can’t be directly accessed
Equipment disposal approach A third-party destruction service

Backup and recovery

Backup and recovery
Backup and recovery Yes
What’s backed up Database backup
Backup controls Daily full database backups are provided as part of the service. If different backup requirements are required for different databases this can be scheduled with the support team, or users can develop and deploy backup scripts themselves as long as they have the correct level of database authorisation.
Datacentre setup
  • Multiple datacentres with disaster recovery
  • Multiple datacentres
Scheduling backups Users contact the support team to schedule backups
Backup recovery
  • Users can recover backups themselves, for example through a web interface
  • Users contact the support team

Data-in-transit protection

Data-in-transit protection
Data protection between buyer and supplier networks
  • Private network or public sector network
  • IPsec or TLS VPN gateway
Data protection within supplier network
  • IPsec or TLS VPN gateway
  • Other
Other protection within supplier network Private WAN Service

Availability and resilience

Availability and resilience
Guaranteed availability Teradata will use commercially reasonable efforts to make the Teradata IntelliCloud service generally available 7 x 24 x 365. Teradata will target a Service Level Agreement (SLA) for IntelliCloud Platform Availability (excluding planned downtime) of 99.9% measured on a monthly basis.
Approach to resilience All nodes for IntelliCloud (Teradata Database) are configured using RAID 1 protection, which provides redundancy at the hardware/disk-drive level. If a single drive fails, 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 node (for Teradata systems with two or more nodes). 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.
Outage reporting Email alerts. Requirements gathered during onboarding

Identity and authentication

Identity and authentication
User authentication
  • Limited access network (for example PSN)
  • Dedicated link (for example VPN)
  • Username or password
Access restrictions in management interfaces and support channels Role based access following best practices e.g. separation of duties. Also, 2 factor authentication.
Access restriction testing frequency At least every 6 months
Management access authentication
  • 2-factor authentication
  • Dedicated link (for example VPN)
  • Username or password
Devices users manage the service through
  • Dedicated device on a segregated network (providers own provision)
  • Any device but through a bastion host (a bastion host is a server that provides access to a private network from an external network such as the internet)

Audit information for users

Audit information for users
Access to user activity audit information Users have access to real-time audit information
How long user audit data is stored for User-defined
Access to supplier activity audit information Users have access to real-time audit information
How long supplier audit data is stored for User-defined
How long system logs are stored for User-defined

Standards and certifications

Standards and certifications
ISO/IEC 27001 certification Yes
Who accredited the ISO/IEC 27001 Coalfire ISO Inc
ISO/IEC 27001 accreditation date 10th August 2015
What the ISO/IEC 27001 doesn’t cover .
ISO 28000:2007 certification No
CSA STAR certification No
PCI certification No
Other security accreditations Yes
Any other security accreditations
  • SOC 1 Type 2 Examination
  • SOC 2 Type 2 Examination

Security governance

Security governance
Named board-level person responsible for service security Yes
Security governance accreditation Yes
Security governance standards ISO/IEC 27001
Information security policies and processes As part of our access protection policy we assign a risk designation to every Teradata Cloud Operations position and establish screening criteria for individuals who fill those posts. Our program screens individuals prior to authorizing access and makes sure signed agreements are in place before access is assigned. Teradata IntelliCloud services also enforce password complexity, stores and transmits only encrypted password representations, and sets minimum and maximum lifetime restrictions on those passwords.
Additionally, we offer a stringent re-approval process that includes:

-Creating, enabling, modifying, disabling, and removing Teradata IntelliCloud Directory accounts in accordance with account management procedures
-Approving all account management actions
Monitoring account management operations for any unauthorized actions
-Disabling appropriate Teradata IntelliCloud Directory accounts whenever an individual is terminated or transferred
-Modifying role-based access whenever an individual’s system usage or need-to-know requirements change
-Automatically disabling inactive accounts after 90 days

Operational security

Operational security
Configuration and change management standard Supplier-defined controls
Configuration and change management approach The Production environment is the operational Teradata Cloud. It is physically isolated from the Development/Test and QA environments. The Teradata Cloud Change Review Board (CRB) is established as a formal approval authority for changes. The boards function is to control changes to the approved Cloud architecture (e.g., deployment of a new piece of hardware, software, or device); however, any issue with significant impact to the Teradata Cloud baseline or architecture should involve this board. Proposed changes to any Teradata Cloud system, application, or service are to be submitted via the Cloud Service Portal and routed to the CRB for approval.
Vulnerability management type Supplier-defined controls
Vulnerability management approach Vulnerability management process is executed monthly. It begins with security performing a vulnerability scan (using the latest vulnerability scanner configuration) of all Teradata Cloud Internet Protocol (IP) addresses as well as an ASV vulnerability scan of all Teradata Cloud Internet Protocol (IP) addresses in PCI DSS scope. The scan results are reviewed and risk assessed to only include Critical, High and Medium risk vulnerabilities and vulnerabilities failing PCI compliance. The vulnerabilities identified via the scans are assessed in terms of risk to Teradata Cloud customers. High-risk vulnerabilities are mitigated within 30 days.
Protective monitoring type Supplier-defined controls
Protective monitoring approach Teradata Cloud Security operations monitor a wide-range of security-related events to detect potential security incidents. These events range from those reported by customers, operations personnel and others via the 24x7x365 Teradata Cloud Help Desk, to events detected by the Teradata Cloud Security Information and Event Management (SIEM) System to facility security events. The Teradata Cloud Help Desk is the primary mechanism for people to report any events that may indicate a security incident. The quickest and most effective way to report a potential security incident is via the Help Desk number.
Incident management type Supplier-defined controls
Incident management approach The priorities of any Teradata Cloud Security Incident Response (in order) are as follows:
1. Prevent an attack from occurring
2. Contain attack to limit customer, and Teradata damage
3. Terminate attack
4. Eradicate cause of attack
5. Enable resumption of customer services
6. Gather evidence to be used in law enforcement

Based on these priorities, Teradata Cloud will prioritize the prevention of an attack over the continuity of customer services. This means that in an imminent attack, Teradata Cloud will take actions (e.g. disabling customer access) that may be required to avoid the potential damage resulting from an attack.

Secure development

Secure development
Approach to secure software development best practice Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v3.0)

Separation between users

Separation between users
Virtualisation technology used to keep applications and users sharing the same infrastructure apart No

Energy efficiency

Energy efficiency
Energy-efficient datacentres Yes


Price £2700 per instance per month
Discount for educational organisations No
Free trial available Yes
Description of free trial The Teradata Database Developer (Single Node) with SSD local storage on AWS Marketplace is the same full-feature data warehouse software that powers analytics at many of the world's greatest companies. 30 day free trial.
Link to free trial https://aws.amazon.com/marketplace/pp/B01DLD4UZI?qid=1491495051360&sr=0-2&ref_=srh_res_product_title#product-description


Pricing document View uploaded document
Skills Framework for the Information Age rate card View uploaded document
Service definition document View uploaded document
Terms and conditions document View uploaded document
Return to top ↑