IBM United Kingdom Ltd

IBM DB2 Warehouse on Cloud

IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options and with a Common SQL engine across all deployment options. Users choose either transactional or analytic workloads, and IBM delivers an environment designed to meet those needs.

Features

  • Available pre-configured to optimally support analytic or transactional workloads
  • Load & Go functionality gives fast time to value
  • Can scale up (bigger servers) or scale out (multiple servers).
  • Oracle PL/SQL compatibility. Supports numerous data connectivity methods & types
  • Contains embedded Netezza analytics, R support and massively parallel processing.
  • Easy-to-use web console to quickly load or migrate data
  • Enterprise grade security
  • Data encrypted at rest and in motion
  • Tools provided for loading structured, semi-structured, or unstructured data

Benefits

  • Start analytic projects without waiting for IT infrastructure
  • Quickly load data or migrate data from other sources
  • Run Netezza & open source algorithms against data in place
  • Data automatically transformed into structured format for analysis (Twitter data)
  • Integrated R development and deployment

Pricing

£1701 per instance per month

  • Free trial available

Service documents

G-Cloud 10

545591388509994

IBM United Kingdom Ltd

Alice Griffin

+44-07387-134406

gcloud@uk.ibm.com

Service scope

Service scope
Software add-on or extension Yes, but can also be used as a standalone service
What software services is the service an extension to IBM dashDB, as part of the IBM Bluemix cloud platform, helps you solve real problems and drive business value with applications, infrastructure and services. It weaves together the services, infrastructure and data to rapidly bring ideas to production. Scale is managed to your business and building systems is simplified.
Cloud deployment model Hybrid cloud
Service constraints Maintenance is typically scheduled in advance and occurs approximately every four weeks at a predefined time. This includes updates to the environment and the database software. If urgent fixes are required, then maintenance may need
to be scheduled outside of the regular schedule.
The service is not available while maintenance is applied. Maintenance is typically scheduled for 1-4 hours, but IBM makes all efforts to minimize the outage time and actual outage time is usually much less. For environments using
the HA plan, maintenance is typically applied in a rolling fashion and the outage is generally only a few minutes.
System requirements
  • Requires one or more enabling software downloads to facilitate use
  • IBM Data Server Driver Package v11.1
  • IBM Data Server Manager Enterprise v2.1
  • IBM Data Studio v4.1
  • IBM Database Conversion Workbench v4.0
  • IBM InfoSphere Data Architect v9.1

User support

User support
Email or online ticketing support Yes, at extra cost
Support response times Please see section 5 of the attached T&C's document for this offering for details.
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 Free Support: All trial customers of Bluemix receive ticketed support, but no response time objectives are offered. Ticket severity is limited to severity 4.
Basic Support: All customers who have purchased Bluemix but have not purchased support receive ticketed support, but no response time objectives are offered. Ticket severity is limited to severity 4.
Standard Support: All customers in a Bluemix account that have purchased Standard Support receive ticketed, technical support with the response time objectives defined below. Those who purchased Bluemix Dedicated or Bluemix Local receive this support as part of the offering.
Premium Support: Any customers in a Bluemix account who have purchased Premium
Support receive ticketed support with improved response times, priority handling, and a Client Success Manager assigned to your account. A Client Success Manager will be made available for up to 8 hours a week to provide a rapid route into the Bluemix organization, providing proactive and focused attention to help clients achieve maximum value from the environment quickly.

Note: All customers are provided free technical support through our community support at:
https://developer.ibm.com/bluemix/ or on Stack Overflow at:
http://stackoverflow.com/questions/tagged/bluemix
Our Development staff monitors both forums.
Support available to third parties Yes

Onboarding and offboarding

Onboarding and offboarding
Getting started This is mainly provided through online training and documentation which users can access for free. IBM Bluemix contains a wealth of material to help customers gain value from their dashDB environment quickly and easily. This includes Getting Started guides, videos, Youtube channel tutorials, showcases, sample data, etc. etc.. Examples of how to get started can be found at
https://developer.ibm.com/clouddataservices/docs/dashdb/get-started/ and at
https://developer.ibm.com/bluemix/
Service documentation Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction IBM will return the Client Data within a reasonable period in a reasonable and common format upon receiving written instructions from the Client prior to termination or expiration.
End-of-contract process T
he Proof of Entitlement(PoE)
will specify whether the IBM SaaS renews
automatically, proceeds on a continuous use basis, or terminates at the end of
the term. For automatic renewal, unless Client provides written notice not to
renew at least 90 days prior to the term expiration date,
the IBM SaaS will
automatically renew for the term specified in the PoE. For continuous use, the
IBM SaaS will continue to be available on a month to month basis until Client provides 90 days written notice of termination. The IBM SaaS will remain available to the end of the calendar month after such 90 day period.

Using the service

Using the service
Web browser interface Yes
Supported browsers
  • Internet Explorer 10
  • Internet Explorer 11
  • Firefox
  • Chrome
  • Safari 9+
Application to install No
Designed for use on mobile devices Yes
Differences between the mobile and desktop service As the web console is accessed via a browser, there are no differences in functionality when accessed via a fully compatible browser on a mobile device eg tablet).
Accessibility standards None or don’t know
Description of accessibility DashDB uses the latest W3C Standard, WAI-ARIA 1.0 (US Section 508 , and Web Content Accessibility Guidelines (WCAG) 2.0.

Documentation is provided in HTML so that it is easily accessible through assistive technology.
With the accessibility features of IBM Knowledge Center, you can do the following tasks:
Use screen-reader software and digital speech synthesizers to hear what is displayed on the screen. Consult the product documentation of the assistive technology for details on using assistive technologies with HTML-based information.
Use screen magnifiers to magnify what is displayed on the screen.
Operate specific or equivalent features by using only the keyboard.
Accessibility testing The dashDB web console is accessed via a standard browser and accessibility features are provided via whichever browser the customer elects to use.
Recommended browsers are Internet Explorer 11 or the latest versions of Firefox or Chrome.
API Yes
What users can and can't do using the API There are 2 APIs supported:
1. The service creation APIs provided by IBM Bluemix.
For a tutorial on provisioning dashDB automatically, see the following developerWorks article:
Provision dashDB for Analytics and Transactions SQL database for your move to the cloud

2. IBM dashDB specific APIs.
IBM dashDB for transactions supports all load APIs, but does not support r-script APIs. Only dashDB for analytics supports r-script APIs at this time.
The API reference can be found here:
https://developer.ibm.com/static/site-id/85/api/dashdb-analytics/#database
API documentation Yes
API documentation formats HTML
API sandbox or test environment No
Customisation available No

Scaling

Scaling
Independence of resources The architecture of IBM cloud services maintains logical separation of client data. Internal rules and measures separate data processing, such as inserting, modifying, deleting, and transferring data, according to the contracted purposes.

Analytics

Analytics
Service usage metrics Yes
Metrics types As an account owner or a billing manager, you can use the Usage Dashboard page to see the real-time charges for the runtimes and services that are used per month in your organizations. You can see the runtime GB-hours and service consumption in all regions, or you can select to see a particular region and space, for the past 12 months. Click a particular month to see the usage for that month. The charges shown represent the amount that you, as the account owner, are billed for that month.
Reporting types
  • API access
  • Real-time dashboards
  • Regular reports
  • Reports on request

Resellers

Resellers
Supplier type Not a reseller

Staff security

Staff security
Staff security clearance Other security clearance
Government security clearance Up to Developed Vetting (DV)

Asset protection

Asset protection
Knowledge of data storage and processing locations Yes
Data storage and processing locations
  • United Kingdom
  • European Economic Area (EEA)
  • EU-US Privacy Shield agreement locations
User control over data storage and processing locations Yes
Datacentre security standards Complies with a recognised standard (for example CSA CCM version 3.0)
Penetration testing frequency At least once a year
Penetration testing approach ‘IT Health Check’ performed by a Tigerscheme qualified provider or a CREST-approved service provider
Protecting data at rest
  • Physical access control, complying with CSA CCM v3.0
  • Physical access control, complying with SSAE-16 / ISAE 3402
  • Physical access control, complying with another standard
  • Encryption of all physical media
  • Scale, obfuscating techniques, or data storage sharding
Data sanitisation process Yes
Data sanitisation type Explicit overwriting of storage before reallocation
Equipment disposal approach Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001

Data importing and exporting

Data importing and exporting
Data export approach IBM dashDB Enterprise data can be easily exported through standard utilities available to users via the web console. The link points to a tutorial demonstrating just how simple this is.
https://developer.ibm.com/clouddataservices/docs/dashdb/analyze/extract-and-export-dashdb-data-to-a-csv-file/
You can connect IBM dashDB to Microsoft Excel so that you can easily move data between the two tools
Data export formats CSV
Data import formats
  • CSV
  • Other
Other data import formats
  • Data file from local network
  • Object Store (Amazon S3 or Swift)
  • DashDB Server
  • .CSV Excel Spreadsheet
  • Cloudant database
  • Load process from application (InfoSphere, DataStage)

Data-in-transit protection

Data-in-transit protection
Data protection between buyer and supplier networks
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Other
Other protection between networks IBM will encrypt content not intended for public or unauthenticated viewing when transferring content over public networks. Further, unless excluded by a TD, IBM will enable use of a cryptographic protocol, such as HTTPS, SFTP, and FTPS, for Client’s secure transfer of content to and from the Cloud Service over public networks.
Data protection within supplier network
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway

Availability and resilience

Availability and resilience
Guaranteed availability IBM provides a 99.95% availability SLA for Platform Services
i) configured for high availability and distributed across multiple Bluemix public regions;
or
ii) provisioned across multiple dedicated or local environments in geographically separated data-centers

In addition, IBM provides a 99.5% availability service level for multiple instances of a Platform Service provisioned within a single dedicated or local environment.
Approach to resilience Available at request.
Outage reporting The current health and status for Bluemix and the dashDB service can be found here: https://developer.ibm.com/bluemix/support/#status. Status updates, including notifications for upcoming maintenance, can be found on the right hand side of the panel. Notifications specific to dashDB can be shown by entering "dashdb" as a filter. There is also an RSS feed for these notifications which customers can subscribe to. These updates for upcoming maintenance are typically provided about 48 hours prior to the maintenance event -- although it may be a shorter amount of time for more urgent, unexpected updates (such as applying an important security fix).

Identity and authentication

Identity and authentication
User authentication needed Yes
User authentication Other
Other user authentication DashDB authenticates users against a local OpenLDAP repository. Clients have full control over who is granted access. Client access is via dashDB web administration console UI, or through connections to one of dashDB’s
external ports. No direct command line or SSH access is allowed by end users. Users are authenticated based on a local LDAP repository that is managed alongside dashDB. Management and monitoring roles come predefined for assignment to client users
and do not include any access to the database’s data. User data access can be defined at a fine grained level. Permissions can be granted to a group.
Access restrictions in management interfaces and support channels IBM maintains individual role-based authorization of privileged accounts that is subject to regular validation. A privileged account is a duly authorized IBM user identity with administrative access to a Cloud Service, including associated infrastructure, networks, systems, applications, databases and file systems.
Access restriction testing frequency At least every 6 months
Management access authentication 2-factor authentication

Audit information for users

Audit information for users
Access to user activity audit information Users contact the support team to get audit information
How long user audit data is stored for Between 1 month and 6 months
Access to supplier activity audit information Users contact the support team to get audit information
How long supplier audit data is stored for Between 1 month and 6 months
How long system logs are stored for Between 1 month and 6 months

Standards and certifications

Standards and certifications
ISO/IEC 27001 certification Yes
Who accredited the ISO/IEC 27001 Bureau Veritas
ISO/IEC 27001 accreditation date 11/12/2015
What the ISO/IEC 27001 doesn’t cover The infrastructure and platform this offering is run on is ISO/IEC 27001 compliant. The current SaaS application is also compliant.
ISO 28000:2007 certification No
CSA STAR certification Yes
CSA STAR accreditation date 20/04/2016
CSA STAR certification level Level 1: CSA STAR Self-Assessment
What the CSA STAR doesn’t cover The infrastructure and platform this offering is run on has a CSA STAR Self-Assessment certificate. The SaaS side of this offering currently does not have this. The IBM CSA Star Self-Assessment can be viewed here https://cloudsecurityalliance.org/star-registrant/softlayer/
PCI certification No
Other security certifications No

Security governance

Security governance
Named board-level person responsible for service security Yes
Security governance certified Yes
Security governance standards ISO/IEC 27001
Information security policies and processes IBM has an Information Technology (IT) Security policy that establishes the requirements for the protection of IBM's worldwide IT systems and the information assets they contain, including networks and computing devices such as servers, workstations, host computers, application programs, web services, and telephone systems within the IBM infrastructure. IBM’s IT Security policy is supplemented by standards and guidelines, such as the Security Standards for IBM's Infrastructure, the Security and Use Standards for IBM Employees and the Security Guidelines for Outsourced Business Services. Such are reviewed by a cross-company team led by the IT Risk organization every six months.

IBM has a dedicated Vice President of IT Security who leads a team responsible for IBM's own enterprise data security standards and practices. Responsibility and accountability for executing internal security programs is established through formal documented policies. IBM Services teams also have dedicated executives and teams who are responsible for information and physical security in the delivery of our client services.

Operational security

Operational security
Configuration and change management standard Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Configuration and change management approach IBM maintains policies and procedures to manage risks associated with the application of changes to its Cloud Services. Prior to implementation, all changes to a Cloud Service, including its systems, networks and underlying components, will be documented in a registered change request that includes a description and reason for the change, implementation details and schedule, a risk statement addressing impact to the Cloud Service and its clients, expected outcome, rollback plan, and documented approval by IBM management or its authorized delegate.
Vulnerability management type Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Vulnerability management approach With each Cloud Service, as applicable and commercially reasonable, IBM will a) perform penetration testing and vulnerability assessments before production release and routinely thereafter, b) enlist a qualified and reputable independent third-party to perform penetration testing and ethical hacking at least annually, c) perform automated management and routine verification of underlying components’ compliance with security configuration requirements, and d) remediate any identified vulnerability or noncompliance with its security configuration requirements based on associated risk, exploitability, and impact. IBM takes reasonable care to avoid Cloud Service disruption when performing its tests, assessments, scans, and execution of remediation activities.
Protective monitoring type Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Protective monitoring approach IBM maintains and follows policies requiring administrative access and activity in its Cloud Services’ computing environments to be logged and monitored, and the logs to be archived and retained in compliance with IBM’s worldwide records management plan. IBM monitors privileged account use and maintain security information and event management policies and measures designed to a) identify unauthorized administrative access and activity, b) facilitate a timely and appropriate response, and c) enable internal and independent third party audits of compliance with such policies. IBM systematically monitors the health and availability of production Cloud Service systems and infrastructure at all times.
Incident management type Conforms to a recognised standard, for example, CSA CCM v3.0 or ISO/IEC 27035:2011 or SSAE-16 / ISAE 3402
Incident management approach IBM:
-maintains and follows incident response policies aligned with NIST guidelines for computer security incident handling, and will comply with data breach notification requirements under applicable law.
-investigates security incidents, including unauthorised access or use of content or the Cloud Service, of which IBM becomes aware, and, if warranted, define and execute an appropriate response plan.
-promptly notifies Client upon determining that a security incident known or reasonably suspected by IBM to affect Client has occurred.
-provides Client with reasonably requested information about such security incident and status of applicable remediation and restoration activities performed or directed by IBM.

Secure development

Secure development
Approach to secure software development best practice Supplier-defined process

Public sector networks

Public sector networks
Connection to public sector networks No

Pricing

Pricing
Price £1701 per instance per month
Discount for educational organisations No
Free trial available Yes
Description of free trial The free trial is fully functional but it is limited to 30 days.

Documents

Documents
Pricing document View uploaded document
Terms and conditions document View uploaded document
Return to top ↑