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