Clarity Tech Ltd

Data warehousing

We use Microsoft Azure SQL Data Warehouses, hosted on a cloud data warehouse platform. This tool supports online analytical processing (OLAP) and helps users gain insight into business operations through querying data. The Data Warehouse is accessed over the internet, and does not require hardware at the client site.

Features

  • Allows you to run a single T-SQL query
  • Market leading SLA guaranteeing 99.9% uptime
  • Fully managed, perabyte-scale cloud data warehouse
  • Enterprise ready with 99.9% SLA
  • Global availability with 23 regions
  • Customisable
  • Truly elastic with decoupled compute and storage
  • Built-in intelligence
  • Automatic threat detection

Benefits

  • Scale in seconds
  • Automatic
  • Data protection and security
  • 99.9% uptime
  • Continue to use familiar SQL language
  • Reduced cost
  • Extensive experience and deep technology expertise
  • Enterprise integration experience

Pricing

£500 to £1200 per person

Service documents

G-Cloud 9

991051347566013

Clarity Tech Ltd

Faiz Ahmad

02030062813

faiz@claritytech.org

Service scope

Service scope
Service constraints All Microsoft Azure constraints and limits will be applicable e.g. Virtual Machine Scale Sets limits, Networking limits, DNS limits, Storage limits etc
System requirements
  • May need software licences
  • May need anti-virus software
  • Reliable Internet connection in place
  • Computer meets the minimum system requirements for the service

User support

User support
Email or online ticketing support Yes, at extra cost
Support response times Week Days - 1st line support Within two hour of business hours
Weekend - 1st line support Within two hour of business hours
User can manage status and priority of support tickets No
Phone support Yes
Phone support availability 9 to 5 (UK time), Monday to Friday
Web chat support No
Onsite support Yes, at extra cost
Support levels We provide 1st, 2nd and 3rd Level support.
1st Line: £120/day
2nd Line: £280/day
3rd Line: £400/day
We will provide technical account manager
Support available to third parties No

Onboarding and offboarding

Onboarding and offboarding
Getting started Will provide user documentation.
Service documentation Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction All Virtual Machine Images and Data Storage are available in a Azure Data Warehouse, which cab be downloaded from these storage account.
It depends upon user's retention policy.
End-of-contract process Fully managed handover process

Using the service

Using the service
Web browser interface Yes
Using the web interface Will provide access to Azure Web Interface and Portal to manage service
User will be provided access to Azure Dashboard to carry out changes
Based on changes required Price and cost limitation will apply.
Web interface accessibility standard WCAG 2.0 AA or EN 301 549
Web interface accessibility testing Basic Testing
API Yes
What users can and can't do using the API https://azure.microsoft.com/en-gb/services/api-management/
API automation tools Puppet
API documentation Yes
API documentation formats
  • HTML
  • PDF
Command line interface Yes
Command line interface compatibility
  • Linux or Unix
  • Windows
  • MacOS
Using the command line interface https://docs.microsoft.com/en-us/cli/azure/overview

Using Azure CLI 2.0, which is Azure's new command-line experience for managing Azure resources. It can be used on macOS, Linux, and Windows.

Details of using CLI2.0 is available
https://docs.microsoft.com/en-us/cli/azure/overview

Scaling

Scaling
Scaling available Yes
Scaling type Manual
Independence of resources Using Azure Resource Manager and Monitoring within Azure Portal, which will enables us to keep track of demand.
Usage notifications Yes
Usage reporting
  • API
  • Email

Analytics

Analytics
Infrastructure or application metrics Yes
Metrics types
  • CPU
  • Disk
  • HTTP request and response status
  • Memory
  • Network
  • Number of active instances
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
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 every 6 months
Penetration testing approach In-house
Protecting data at rest
  • Physical access control, complying with CSA CCM v3.0
  • Physical access control, complying with SSAE-16 / ISAE 3402
Data sanitisation process Yes
Data sanitisation type
  • Explicit overwriting of storage before reallocation
  • Deleted data can’t be directly accessed
  • Hardware containing data is completely destroyed
Equipment disposal approach A third-party destruction service

Backup and recovery

Backup and recovery
Backup and recovery Yes
What’s backed up
  • Files
  • Virtual Machines
  • Databases
Backup controls User will use Azure Scheduler that lets them create jobs in the cloud that reliably invoke services inside and outside of Azure – such as calling HTTP/S endpoints or posting messages to Azure Storage queues, Azure Service Bus queues or Azure Service Bus topics. User can choose to run jobs straight away, on a recurring schedule or at some point in the future.
Scheduler allows users to create, update, delete, view, and manage jobs and job collections programmatically, by using scripts, and in the portal.
Datacentre setup
  • Multiple datacentres with disaster recovery
  • Multiple datacentres
  • Single datacentre with multiple copies
  • Single datacentre
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
  • Legacy SSL and TLS (under version 1.2)
Data protection within supplier network Legacy SSL and TLS (under version 1.2)

Availability and resilience

Availability and resilience
Guaranteed availability 99.9% - Will be covered by Microsoft SLA
Approach to resilience Using Azure
Outage reporting Email alerts

Identity and authentication

Identity and authentication
User authentication
  • 2-factor authentication
  • Dedicated link (for example VPN)
  • Username or password
Access restrictions in management interfaces and support channels Will use Azure identity management and access control security best practices include:
Centralize your identity management
Enable Single Sign-On (SSO)
Deploy password management
Enforce multi-factor authentication (MFA) for users
Use role based access control (RBAC)
Control locations where resources are created using resource manager
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 Directly from any device which may also be used for normal business (for example web browsing or viewing external email)

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 contact the support team to get 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 No
ISO 28000:2007 certification No
CSA STAR certification No
PCI certification No
Other security accreditations No

Security governance

Security governance
Named board-level person responsible for service security Yes
Security governance accreditation No
Security governance approach Information Governance Training
Information security policies and processes ISO 270001
ISO 90001

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 We use Microsoft Visual Services tool as well as Azure Monitoring dashboard to track components of our services.
We use Azure Cloud to simulate testing environment which is similar to the operating environment. Testing including performance and security is carried out prior to release.
Vulnerability management type Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Vulnerability management approach Will use Azure Security Center which offers integrated vulnerability assessment with Qualys cloud agents as part of the Virtual Machine. The solution can be deployed to multiple VMs at one time and once deployed, the Qualys agent will start reporting vulnerability data to the Qualys management platform, which in turn provides vulnerability and health monitoring data back to Security Center. Users can quickly identify vulnerable VMs from the Security Center dashboard. Additional reports and information are available in the Qualys management console, which is linked directly from Security Center.
Protective monitoring type Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Protective monitoring approach Using Microsoft global 24x7 incident response service that works to mitigate the effects of attacks and malicious activity. The incident response team follows established procedures for incident management, communication, and recovery, and uses discoverable and predictable interfaces with internal and external partners alike.
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 Will use following process phases:

• Identification – Events will be investigated and will be assigned a severity classification.
• Containment – The escalation team will evaluates the scope and impact of an incident.
• Eradication – After the situation is contained, the escalation team moves toward eradicating any damage caused by the security breach, and identifies the root cause for why the security issue occurred.
• Recovery – System and services will be returned to a full working capacity.
• Customer’s notified if data breaches or unauthorized access.

Secure development

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

Separation between users

Separation between users
Virtualisation technology used to keep applications and users sharing the same infrastructure apart Yes
Who implements virtualisation Third-party
Third-party virtualisation provider Microsoft
How shared infrastructure is kept separate Depending on organisation structure, there are different options available in Azure e.g. can use Virtual Network. It will also depend on architectural design as well.

Energy efficiency

Energy efficiency
Energy-efficient datacentres Yes

Pricing

Pricing
Price £500 to £1200 per person
Discount for educational organisations No
Free trial available No

Documents

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