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

£25000 to £90000 per unit

Service documents

G-Cloud 10

702840588676978

Integris Solutions

Damian Pearce

07773773721

info@integrisltd.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 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

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

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

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

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

Analytics
Service usage metrics No

Resellers

Resellers
Supplier type Not a reseller

Staff security

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

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

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

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

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

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

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

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

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

Public sector networks

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

Pricing

Pricing
Price £25000 to £90000 per unit
Discount for educational organisations No
Free trial available No

Service documents

pdf document: Pricing document pdf document: Terms and conditions
Service documents
Return to top ↑