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

£550 to £1,250 a person

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at faiz@claritytech.org. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 13

Service ID

6 0 7 1 5 0 5 0 7 3 8 0 6 1 9

Contact

Clarity Tech Ltd Faiz Ahmad
Telephone: 02030062813
Email: faiz@claritytech.org

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

Email or online ticketing support
Email or online ticketing
Support response times
Clarity Tech JIRA Service Tool

Priority 1
We will acknowledge the issue within 4 working hour and provide a response including an action plan for resolution or cause within 8 working hours.

Priority 2
We will acknowledge the issue within 6 working hours and provide a response including an action plan for resolution or cause within 10 working hours.

Priority 3
We will respond within 1 working day and will aim to provide a fix within 5 working days of the incident being reported.

Priority 4
Where applicable, we will provide a solution as part of the next release.
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
Yes

Onboarding and offboarding

Getting started
Will provide user documentation.
Service documentation
Yes
Documentation formats
  • HTML
  • PDF
  • Other
Other documentation formats
MS Word
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

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.1 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 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

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

Supplier type
Reseller providing extra support
Organisation whose services are being resold
Microsoft/Rackspace/UKCloud/Fusionex

Staff security

Staff security clearance
Conforms to BS7858:2019
Government security clearance
Up to Baseline Personnel Security Standard (BPSS)

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
No
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
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 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

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

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

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

ISO/IEC 27001 certification
No
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Cyber essentials
Yes
Cyber essentials plus
No
Other security certifications
Yes
Any other security certifications
  • Cyber Security Essential
  • IASME Governance

Security governance

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

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

Approach to secure software development best practice
Supplier-defined process

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-efficient datacentres
Yes
Description of energy efficient datacentres
We use Microsoft Data Centers which adheres to the EU Code of Conduct for Energy Efficient datacentres. For full details please refer to the following link.

https://blogs.microsoft.com/on-the-issues/2018/05/17/microsoft-cloud-delivers-when-it-comes-to-energy-efficiency-and-carbon-emission-reductions-study-finds/

Social Value

Fighting climate change

Fighting climate change

As a part of our Social Value (SV) and Corporate Social Responsibility policy, we have incorporated Social Value development into our company's business model, which incorporates our long term and ongoing commitment to doing better by individuals, communities, and the planet. It will have a positive impact on Social Value like Justice, Freedom, Respect, Community, and Responsibility especially for young people. We are determined to deliver value
which results in benefits above and beyond the value derived from our exceptional service delivery.

Environmental Initiatives
Our Commitments:
• Reducing energy and fuel consumption
• Incorporating sustainability considerations into our supply chain
• Saving energy e.g., using energy efficient lighting and equipment
As a part of our Environmental Policy and Procedure, we have adapted and encouraged remote and flexible working environments, and have also adopted tools like MS Team, Zoom and Basecamp to reduce face to face meetings. This has resulted in carbon footprint reduction, which is good for both the company and society. We use energy saving bulbs, and hybrid transport, and as a result are efficient in energy usage.
We are committed to digital transformation, and have fully digitised our business.
Some of our sustainability targets include:
• Moving more services and data into the cloud to improve cost efficiency.
We have achieved 90%, and target is 100% by March 2023
• Establishing guidelines for monitoring environmental compliance.

We are also working towards environmental accreditations ISO14001.
Covid-19 recovery

Covid-19 recovery

As a part of our Social Value (SV) and Corporate Social Responsibility policy, we have incorporated Social Value development into our company's business model, which incorporates our long term and ongoing commitment to doing better by individuals, communities, and the planet. We are determined to deliver value which results in benefits above and beyond the value derived from our exceptional service delivery.

Social Initiatives
Our Commitments:
• COVID-19 Recovery
• Diversity and Equality
• Helping local charities/community
• Health and well-being-outcome=increased wellbeing

We support the COVID-19 recovery effort, and have adapted best practices of remote working and sustainable travel solutions. It includes use of MS Team and other technologies to achieve the desired outcome. We also engage and collaborate with businesses to manage and recover from the impacts of COVID-19, including new and flexible ways of working to deliver value added services.
We are committed to Equality and Diversity, and encourage greater diversity within the Tech sector e.g., we will offer work experience to at least one woman in 2022/23 for three months. We will also be signing up to the Disability Confident employer scheme. Clarity Tech has links and donate regularly to Charities, and will continue to donate this year to “Royal Marsden Cancer Charity” and “Humanity First”.
We always promote equality, diversity and inclusion, and are working towards providing work experience to young people with previous convictions. We have also adopted a flexible and digital working environment, and as a result looked after employees’ health, well-being and facilitate a work-life balance. For example, adopting this approach in our contracts has helped us in meeting our goal of improving Health and well-being and a result increased company performance, increased job satisfaction, an improved work/life balance and an increase in staff morale & motivation which resulted in positive social impact.
Tackling economic inequality

Tackling economic inequality

As a part of our Social Value (SV) and Corporate Social Responsibility policy, we have incorporated Social Value development into our company's business model, which incorporates our long term and ongoing commitment to doing better by individuals, communities, and the planet. It will have a positive impact on Social Value like Justice, Freedom, Respect, Community, and Responsibility especially for young people. We are determined to deliver value which results in benefits above and beyond the value derived from our exceptional service delivery.

Social Initiatives
Our Commitments:
• Diversity and Equality
• Helping local charities and community groups
• Health and well-being - outcome = increased wellbeing
We are committed to Equality and Diversity, and encourage greater diversity within the Tech sector e.g., we will offer work experience to at least one woman in 2022/23 for three months. We will also be signing up to the Disability Confident employer scheme. Clarity Tech has links and donate regularly to Charities, and will continue to donate this year to “Royal Marsden Cancer Charity” and “Humanity First”, who serves disaster struck and socially disadvantaged individuals and families in the poorer communities of the world in 52 countries across 6 continents.
We always promote equality, diversity and inclusion, and are working towards providing work experience to young people with previous convictions. We have also adopted a flexible and digital working environment, and as a result looked after employees’ health, well-being and facilitate a work-life balance. For example, adopting this approach in our existing contract has helped us in meeting our goal of improving Health and well-being and a result increased company performance, increased job satisfaction, an improved work/life balance and an increase in staff morale & motivation which resulted in positive social impact.
Equal opportunity

Equal opportunity

As a part of our Social Value (SV) and Corporate Social Responsibility policy, we have incorporated Social Value development into our company's business model, which incorporates our long term and ongoing commitment to doing better by individuals, communities, and the planet. It will have a positive impact on Social Value like Justice, Freedom, Respect, Community, and Responsibility especially for young people. We are determined to deliver value which results in benefits above and beyond the value derived from our exceptional service delivery.

Social Initiatives
Our Commitments:
• Diversity and Equality
• Helping local charities and community groups
• Health and well-being - outcome = increased wellbeing
We are committed to Equality and Diversity, and encourage greater diversity within the Tech sector e.g., we will offer work experience to at least one woman in 2022/23 for three months. We will also be signing up to the Disability Confident employer scheme. Clarity Tech has links and donate regularly to Charities, and will continue to donate this year to “Royal Marsden Cancer Charity” and “Humanity First”, who serves disaster struck and socially disadvantaged individuals and families in the poorer communities of the world in 52 countries across 6 continents.
We always promote equality, diversity and inclusion, and are working towards providing work experience to young people with previous convictions. We have also adopted a flexible and digital working environment, and as a result looked after employees’ health, well-being and facilitate a work-life balance. For example, adopting this approach in our existing contract has helped us in meeting our goal of improving Health and well-being and a result increased company performance, increased job satisfaction, an improved work/life balance and an increase in staff morale & motivation which resulted in positive social impact.
Wellbeing

Wellbeing

As a part of our Social Value (SV) and Corporate Social Responsibility policy, we have incorporated Social Value development into our company's business model, which incorporates our long term and ongoing commitment to doing better by individuals, communities, and the planet. It will have a positive impact on Social Value like Justice, Freedom, Respect, Community, and Responsibility especially for young people. We are determined to deliver value which results in benefits above and beyond the value derived from our exceptional service delivery.

Social Initiatives
Our Commitments:
• Diversity and Equality
• Helping local charities and community groups
• Health and well-being - outcome = increased wellbeing
We are committed to Equality and Diversity, and encourage greater diversity within the Tech sector e.g., we will offer work experience to at least one woman in 2022/23 for three months. We will also be signing up to the Disability Confident employer scheme. Clarity Tech has links and donate regularly to Charities, and will continue to donate this year to “Royal Marsden Cancer Charity” and “Humanity First”, who serves disaster struck and socially disadvantaged individuals and families in the poorer communities of the world in 52 countries across 6 continents.
We always promote equality, diversity and inclusion, and are working towards providing work experience to young people with previous convictions. We have also adopted a flexible and digital working environment, and as a result looked after employees’ health, well-being and facilitate a work-life balance. For example, adopting this approach in our existing contract has helped us in meeting our goal of improving Health and well-being and a result increased company performance, increased job satisfaction, an improved work/life balance and an increase in staff morale & motivation which resulted in positive social impact.

Pricing

Price
£550 to £1,250 a person
Discount for educational organisations
No
Free trial available
No

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at faiz@claritytech.org. Tell them what format you need. It will help if you say what assistive technology you use.