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