This G-Cloud 10 service is no longer available to buy.

The G-Cloud 10 framework expired on Tuesday 2 July 2019. Any existing contracts with Integris Solutions are still valid.
Integris Solutions

Data Warehouse

The Integris Datawarehouse has been based on the NHS Data Model and Dictionary to ensure ease of use by NHS teams and provide consistency with current systems and reporting. It is designed to output CDS extracts in a flat file format ready for translation and submission to SUS.

Features

  • Data quality
  • NHS Data warehouse
  • CDS submission
  • Data Validation
  • Extract, Transform and Load (ETL) processes
  • Import data from multiple source systems,
  • NHS Data Dictionary architecture

Benefits

  • One stop destination for all of an organisation’s reporting
  • CDS validation and submission
  • Open source with no black box coding
  • Import data from multiple source systems
  • Modular build to allow expansion in functionality

Pricing

£25,000 to £90,000 a unit

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 info@integrisltd.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 10

Service ID

7 0 2 8 4 0 5 8 8 6 7 6 9 7 8

Contact

Integris Solutions Damian Pearce
Telephone: 07773773721
Email: info@integrisltd.com

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
The Date Warehouse can be used as part of a data migration programme for a new EPR solution.
Cloud deployment model
Public cloud
Service constraints
No
System requirements
  • Server hosting on N3 network
  • Hosting on physical or virtual server

User support

Email or online ticketing support
Email or online ticketing
Support response times
We have a scale of response times based on severity of incident. For Severe incidence this is typically fix within 4 hrs.
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
We provide a service model based on severity of issue with different response times for each level. For critical issues we respond within 4 hrs. this can be 9-5 or 24/7 depending on Trust requirements.
Support available to third parties
No

Onboarding and offboarding

Getting started
We provide training on the structure of the DW and how reports and extracts can be produced.
Service documentation
Yes
Documentation formats
PDF
End-of-contract data extraction
The DW is opensource and hosted on the Trust network and our fees include licencing in perpetuity. Once the Trust has complete using the DW all data can be extracted
End-of-contract process
We leave the DW with the Trust who are then free to use it or remove it from the hosted server.

Using the service

Web browser interface
No
Application to install
No
Designed for use on mobile devices
No
Accessibility standards
None or don’t know
Description of accessibility
The Data Ware house can be accessed from the Trust Network (on N3) by end users with experience of using an SQL database. or through SSRS reports which can be configured by users with required experience.
Accessibility testing
None
API
No
Customisation available
Yes
Description of customisation
Our DW is open source and the Trust Informatics team can develop new functionality or change existing as required.

Scaling

Independence of resources
We provide dedicated resources to configure the data warehouse which are not conflicted by other projects. The DW can be hosted on a dedicated server to ensure that resource is not restricted by competition from other applications.

Analytics

Service usage metrics
No

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Conforms to BS7858:2012
Government security clearance
Up to Security Clearance (SC)

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
Supplier-defined controls
Penetration testing frequency
Never
Protecting data at rest
Encryption of all physical media
Data sanitisation process
Yes
Data sanitisation type
Explicit overwriting of storage before reallocation
Equipment disposal approach
In-house destruction process

Data importing and exporting

Data export approach
The DW has a range of standard reports and produced a CDS file. New reports can be developed by Trust team. SQL queries can also be used to produce extracts.
Data export formats
  • CSV
  • ODF
Data import formats
  • CSV
  • ODF

Data-in-transit protection

Data protection between buyer and supplier networks
Private network or public sector network
Data protection within supplier network
Other
Other protection within supplier network
We never take data away from the NHS Trust site and the DW remains on the Trust network.

Availability and resilience

Guaranteed availability
Our DW is hosted on Trust servers and is located in Trust datacentre and as such the SLAs are defined by the Trusts own standards.
Approach to resilience
We use standard Microsoft SQL technology which is industry standard. Our service is hosted on the Trust network and the SLAs for these are defined by the NHS organisation responsible.
Outage reporting
This can be configured for each Trust

Identity and authentication

User authentication needed
No
Access restrictions in management interfaces and support channels
The SQL server requires username and password to access it, access to the Server hosted in the Trust datacentre is controlled by Trust policy
Access restriction testing frequency
Never
Management access authentication
Username or password

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 have access to real-time 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
Other security certifications
No

Security governance

Named board-level person responsible for service security
Yes
Security governance certified
No
Security governance approach
We are NHS IG Toolkit level 2 complaint and have policies for security in line with this.
Information security policies and processes
NHS IG toolkit level 2

Operational security

Configuration and change management standard
Supplier-defined controls
Configuration and change management approach
Our DW is open source and all changes are tracked and recorded. We make changes in line with the individual Trust policy.
Vulnerability management type
Supplier-defined controls
Vulnerability management approach
Our DW is hosted on the Trust network and we conform with local standards.
Protective monitoring type
Supplier-defined controls
Protective monitoring approach
Our DW is hosted locally on Trust network and as such we work in line with local Trust policy
Incident management type
Supplier-defined controls
Incident management approach
We follow Trust policy

Secure development

Approach to secure software development best practice
Supplier-defined process

Public sector networks

Connection to public sector networks
Yes
Connected networks
New NHS Network (N3)

Pricing

Price
£25,000 to £90,000 a unit
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 info@integrisltd.com. Tell them what format you need. It will help if you say what assistive technology you use.