• Teradata Database as a Service

    Subscribe to the Industry's Leading Data Warehouse

  • Teradata Database as a Service

    Hosted in the secure Teradata Managed Cloud environment, Teradata Database as a Service lets customers focus on business value rather than managing infrastructure – while enjoying flexible pricing that fits within the budget.

    Featuring the same industry-leading Teradata Database software as in our engineered systems, key cloud use cases include:

    • Production Data Warehousing
    • Test & Development
    • Quality Assurance
    • Sandboxes
    • Data Marts
    • Disaster Recovery

    Read this white paper to learn how nine different customers are using Teradata Managed Cloud – and read this case study to understand how firms are using it in hybrid deployment scenarios.

    Teradata Database as a Service is comprehensive; it includes core database functionality, system administration and monitoring, system maintenance, cloud service portal, integrated workload management, daily backups, and a full range of tools and utilities link to – all delivered with 99.9% guaranteed service availability.

    cloud as service diagram

    With Teradata Database as a Service, companies can start driving smart business decisions right away – in days versus months – while reducing upfront hardware cost and aligning flexible service expenses with operational budgets.

    Unlike alternatives that leave you fending for yourself to assemble analytic capabilities in piece-meal fashion, Teradata Database as a Service was designed from the start with a “total solutions” approach. The result is less administrative time spent creating a secure working environment and faster productivity with award-winning Teradata tools.

    Strong Foundation with Optional Services

    Teradata Database as a Service provides these powerful capabilities:

    Cloud Foundation: includes infrastructure functions such as hardware and software, monitoring, system and access management, service management (support portal, onboarding, incident management, etc.), 99.9% platform availability service level agreement, 100 Mbps network connectivity, Teradata tools and utilities, security, backup and recovery, and capacity management.

    Enhanced Services: optional services for implementation of advanced database features (such as temporal), enhanced security (e.g., sensitive data encryption and encrypted backups), passive disaster recovery, additional site-to-site Virtual Private Networks (VPNs), and 1 Gbps or 10 Gbps network connectivity.

    Production & Advisory Services: Teradata Consulting Services can provide optional services for advising on analytic best practices, security, migrating from existing databases, data quality, implementing applications (Teradata and 3rd party), and providing analytic access to business intelligence applications. Similarly, this group can also provide optional operational support such as Database Administrator (DBA) Assist, DBA Admin as a Service, and more.

    td database value add

    Bare-Metal Performance

    The basic building block of Teradata Database as a Service is called a Cloud Compute Unit (CCU). A CCU consists of bare-metal hardware, storage, database software, and system management utilities specifically engineered for cloud computing. The advantage of bare-metal resources is that there is no reduction in speed or performance due to the overhead of virtualization software.

    Each Teradata Database as a Service customer receives dedicated, private CCUs that are securely and physically segregated from other Teradata Managed Cloud customers. With complete isolation, there is absolutely no sharing of CCU resources.

    The customer data space capacity of a CCU for Teradata Database as a Service is approximately 4TB. This capacity amount takes 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 Managed Cloud systems. Actual compression rates will vary depending on data demographics, but rates of 3X or higher are common.

    For resiliency and failover protection, the minimum order for Teradata Database as a Service served from North American data centers is two CCUs. A single-CCU system is available for customers that have non-mission-critical use cases such as test / development, sandboxes, and data marts. Systems configured with only one CCU, however, do not provide failover capacity in the event of a CCU failure. As such, a single-CCU configuration will not have the standard 99.9% service availability guarantee.

    Systems for Teradata Database as a Service may be scaled up to 36 CCUs (approximately 144TB of customer data space).

    Hybrid Row and Columnar Functionality

    All Teradata Database as a Service CCUs are pre-configured with SuSE Linux and Teradata Database software version 15.10 or 15.00 including Integrated Workload Management (IWM). From a feature set perspective, the Teradata Database bundle used is Teradata Base Edition.

    Teradata Columnar is included with each Teradata Database as a Service CCU. Teradata Columnar is a hybrid row and column database that fully integrates columnar and row-based tables, establishing new levels of flexibility, performance, and compression and strengthening your data warehouse and analytics capabilities.

    Benefits include:

    • Improves data warehouse performance by only reading the data absolutely required for each query
    • Allows you to respond to more queries faster while storing more data
    • Integrated solution can mix and match the storage formats in hybrid row and column storage, thereby delivering the highest performance
    • Simple to use; minimal DBA effort required, and no changes necessary to existing applications or queries
    • Distinct architectural approach creates containers within each column so data can be compressed more efficiently, thus enabling storage of larger amounts of data in the same footprint
    • Dynamically adjusts compression mechanisms for optimal storage as data evolves over time

    Optional QueryGrid Functionality

    Teradata Database as a Service can be enhanced with QueryGrid, an optional feature that lets your business work with a seamless data fabric across all of your data and analytical engines for no-hassle analytics. Users get the most value out of all your data – including Teradata Database, Teradata Aster Database, open-source Hadoop, Oracle Database, and powerful languages such as SAS, Perl, Python, Ruby, and R – by taking advantage of specialized processing engines operating as a cohesive analytic environment.

    QueryGrid takes a unique approach to multi-system analytics by giving users a seamless, self-service experience in accessing all their data and analytics across systems through SQL. Users can continue using their existing SQL skills and tools, which enables a whole new class of analytics without retraining.

    Teradata Database’s Adaptive Optimizer ensures high performance query plans using data from other sources while special features when using systems within the Teradata Unified Data Architecture such as passing workload priorities makes the best use of available resources.

    QueryGrid lets you automate and optimize use of your analytic systems through “push-down” processing across platforms. Benefits include:

    • Minimizes data movement and processes data where it resides
    • Minimizes data duplication
    • Transparently automates analytic processing and data movement between systems
    • Enables easy bi-directional data movement

    By transparently harnessing the combined power of multiple analytic engines to address a business question, Teradata QueryGrid delivers the most comprehensive analytic solution to businesses.

    Optional Temporal Capability

    Teradata Database as a Service offers temporal capability, an optional Enhanced Service that enables the time dimension to be added to data management and query processing. Temporal lets the data warehouse track not just transactions over time, but also how data and the business change and evolve over time. Rather than simply changing data as updates are made, a temporal database retains the history represented by the old value and allows users to use that history to look at the business attribute as of any point in time. This is a powerful feature that can significantly enhance the insight available from your data.

    Optional Data Lab Capability

    Teradata Data Lab is an optional dedicated workspace (sandbox) within a production data warehouse where users have the freedom to explore, analyze new data, and test theories. Data labs enable self-service business intelligence and analytics by simplifying provisioning and automating the management of the analytic workspace so there is no risk to production data or to the warehouse performance. Once a business user has been allocated space in a Teradata Data Lab, they then have the self-serviceability to load data from their desktop, join with live production data using their favorite tools, and collaborate with co-workers by sharing their data and analyses.

    Complete Solution

    Teradata Database as a Service customers get three servers along with the Teradata-provisioned CCUs:

    • A load server running Teradata 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 Managed 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 client tools for data access, database management, and load/unload functions.

    td-database-feature-table

    Easy to Use

    Teradata Managed Cloud load servers support SFTP (Secure File Transfer Protocol) to move data files into the cloud. All necessary load/unload utilities are provided on the Teradata Managed Cloud load server.

    Data loads into Teradata Database as a Service CCUs are accomplished via:

    • 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)
      • FastLoad
      • FastExport
      • MultiLoad
      • TPump (enhanced option)

    Secure Connection

    The default method for connecting to Teradata Database as a Service is a site-to-site VPN (Virtual Private Network) 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, the Teradata Cloud operations team can provide you an enhanced option called Teradata Direct Connect which offers either a 1 Gbps or 10 Gbps direct connect port.

    Database access to Teradata Database as a Service 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

    Security is such an important consideration for any cloud service that we’ve dedicated an entire page to it. Read more here as well as the press release on 3rd party audits for security and compliance.

    Reliable Performance

    All CCUs for Teradata Database as a Service 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 Teradata 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 two 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.

    Scalable Resources

    For Teradata Database as a Service served from North American data centers, resources can be scaled up or down in minimum increments of one (1) CCU.

    During scaling operations, Teradata Database as a Service systems are available for read-only operations while a new system is created; 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.

    Protection and Disaster Recovery

    Teradata has built out the cloud infrastructure across two diverse and secure data center locations in the United States – one data center each in the Western and Eastern time zones. The two data centers are network connected to allow for cross-data center data replication

    By default, customer data for Teradata Database as a Service is backed up daily and customers have the option to change the backup frequency to occur on a weekly or monthly basis. Backups are retained for two days at the primary data center and are automatically replicated to a remote data center within the same country. Customers also have the option to purchase encrypted backups.

    Furthermore, Teradata has set special, discounted pricing for systems used exclusively for disaster recovery purposes. Disaster Recovery CCUs are “standby” systems – i.e., used only if there is a production system outage. See the Cloud FAQ for more information.

    Expert Customer Support

    Complete hardware and software support is provided by the Teradata Cloud Operations team. This group also performs activities such as provisioning, onboarding, and software patching while continually monitoring and administering the CCU environment.

    The Teradata Cloud Operations team does not have visibility or access to customers’ data.

    Where Do I Go from Here?

     

    Contact Us  
    »