Big Data Analytics Solution for Azure SQL Data Warehouse
Combining the latest in-memory BI technologies, combined with Microsoft's scalable Azure SQL Data Warehouse, our solution delivers cross module analytical reporting at a fraction of the time and cost of traditional business warehouse solutions. Deployed in the cloud, you have no hardware to buy. Clouds Supported: Microsoft Azure
Features
- On demand Big Data Analytics
- Business Intelligence (BI) Analytics: QlikSense , Tableau, PowerBI
- Data Warehouse: Azure SQL Data Warehouse
- ETL: Lavastorm, Azure Data Factory, Matillion
- Real time ingestion: Azure Event Hubs
- Supports the Hadoop ecosystem including Spark, HDFS, HBase, Storm
- REST API. Powerful Integrations with legacy systems
- Pay as you go
- Payments in GBP
Benefits
- No on-premise installation. Get up and running straight away
- Gives power back to your users
- Reduced cost vs. traditional Business Warehouse Solutions
- Improved forecasting ability reducing lost sales
- Secure, accesible from anywhere
- Access from all devices, PC, Tablet, IOS, Android
Pricing
£1.24 an instance an hour
Service documents
Request an accessible format
Framework
G-Cloud 13
Service ID
8 2 5 4 1 0 7 3 2 9 2 3 7 6 1
Contact
The Server Labs Ltd.
Dolores Saiz
Telephone: 07914163683
Email: sales@theserverlabs.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
- Various
- Cloud deployment model
- Public cloud
- Service constraints
- None
- System requirements
- N/A
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
- S1 The production system cannot be used. No users are able to work in the production system. 24x7x365 <= 30 mins <= 2 h 95% 1,2 S2 Users can access the production system but a critical part of the application is unavailable or degraded.24x7x365 <=60 mins. <= 4 h 90% 1,2 S3 Users can access the production system and work but experience periodic problems. S4 Low impact for the user.The users can work normaly. <= 24 h <= 48 h 90% 1,2
- 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
- 9 to 5 (UK time), Monday to Friday
- Web chat support
- No
- Onsite support
- Yes, at extra cost
- Support levels
- We offer support in either 24x7 and 9x5 modes. Cost varies by the amount of services deployed The service has a preventative component, with periodic maintenance, monthly reporting and continuous improvement of the infrastructure, and a corrective component, when problems occur in the system covered by this support contract. Once an issue has been received by The Server Labs, the procedure takes the following steps. • Verification of the issue and escalation to second level support. • Communication to customer of the solution to be undertaken. • Restoration of any service lost working with the DBA and or engineer assigned to the project. • Restoration of any data lost working with the DBA assigned to the project. • Update of the system documentation if necessary. • Closeout of the issue with description of actions undertaken.
- Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
- Onboarding consulting is required in order to get the best out of the solution.
- Service documentation
- Yes
- Documentation formats
-
- HTML
- End-of-contract data extraction
- The data is fully available at all times. After the customer has extracted the data, we will ensure that the disks are wiped securely.
- End-of-contract process
-
After the customer has extracted their data, we will ensure that the disks are wiped securely.
There is no early termination penalty.
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Internet Explorer 11
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Opera
- Application to install
- No
- Designed for use on mobile devices
- Yes
- Differences between the mobile and desktop service
- Not all features are available on mobile devices. Some BI features are limited. QlikSense provides an app for the iPAD
- Service interface
- No
- User support accessibility
- WCAG 2.1 AA or EN 301 549
- API
- Yes
- What users can and can't do using the API
- Most of the tools in the solution, e.g. JIRA, Conflunce, etc. provide an API that provides most functionality available through the web interface.
- API documentation
- Yes
- API documentation formats
- HTML
- API sandbox or test environment
- No
- Customisation available
- Yes
- Description of customisation
- Additional products can be configured on request. Many of the tools in the solution offer the possibility to install add-ons without any support involvement.
Scaling
- Independence of resources
- This is handled by the underlying cloud provider
Analytics
- Service usage metrics
- Yes
- Metrics types
-
Some of the tools provide user access metrics
We can supply infrastructure metrics on request. - Reporting types
-
- Real-time dashboards
- Regular reports
- Reports on request
Resellers
- Supplier type
- Not a reseller
Staff security
- Staff security clearance
- Conforms to BS7858:2019
- Government security clearance
- Up to Developed Vetting (DV)
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
- Managed by a third party
- Penetration testing frequency
- At least every 6 months
- Penetration testing approach
- In-house
- Protecting data at rest
- Other
- Other data at rest protection approach
-
Data isolation is handled by the underlying cloud provider.
On customer request we can provide volume encryption. - Data sanitisation process
- Yes
- Data sanitisation type
- Explicit overwriting of storage before reallocation
- Equipment disposal approach
- A third-party destruction service
Data importing and exporting
- Data export approach
- Data can be exported via the web interface or via command line tools, depending upon the product within the solution.
- Data export formats
- Other
- Other data export formats
- Tar, zip
- Data import formats
- Other
- Other data import formats
- Tar,zip
Data-in-transit protection
- Data protection between buyer and supplier networks
-
- Private network or public sector network
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
- Data protection within supplier network
- TLS (version 1.2 or above)
Availability and resilience
- Guaranteed availability
- 99.99% SLA
- Approach to resilience
-
Handled by the underlying cloud provider.
The Server Labs can provide Disaster Recovery solutions on request. - Outage reporting
- Email alerts
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- 2-factor authentication
- Identity federation with existing provider (for example Google Apps)
- Username or password
- Access restrictions in management interfaces and support channels
- Handled by the underlying cloud provider
- Access restriction testing frequency
- At least every 6 months
- Management access authentication
- 2-factor authentication
Audit information for users
- Access to user activity audit information
- Users contact the support team to get audit information
- How long user audit data is stored for
- At least 12 months
- Access to supplier activity audit information
- Users contact the support team to get audit information
- How long supplier audit data is stored for
- At least 12 months
- How long system logs are stored for
- At least 12 months
Standards and certifications
- ISO/IEC 27001 certification
- Yes
- Who accredited the ISO/IEC 27001
- UKAS
- ISO/IEC 27001 accreditation date
- 01/07/21
- What the ISO/IEC 27001 doesn’t cover
- TSL ISO 27001 certification covers all information TSL has access to, it does not cover information that TSL does not have access or control over
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Cyber essentials plus
- 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 working towards attaining ISO27001
- Information security policies and processes
- We are working towards attaining ISO27001 and ISO9001
Operational security
- Configuration and change management standard
- Supplier-defined controls
- Configuration and change management approach
- ITIL compliant
- Vulnerability management type
- Undisclosed
- Vulnerability management approach
- Regular scans and Intrusion tests.
- Protective monitoring type
- Undisclosed
- Protective monitoring approach
-
We use standard IDS mechanisms
Any compromise found would be reported to the customer immediately. - 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
- We offer support in either 24x7 and 9x5 modes. Cost varies by the amount of services deployed The service has a preventative component and a corrective component, when problems occur covered by this support contract. Once an issue has been received by The Server Labs, the procedure takes the following steps. • Verification of the issue and escalation to second level support. • Communication to customer of the solution to be undertaken. • Restoration of any service lost working with the DBA and or engineer assigned to the project. • Closeout of the issue with description of actions undertaken
Secure development
- Approach to secure software development best practice
- Supplier-defined process
Public sector networks
- Connection to public sector networks
- No
Social Value
- Fighting climate change
-
Fighting climate change
TSL is a pure cloud and virtual organisation, we do not have offices, and we perform all work as much as is possible remotely, with face to face meetings involving transportation kept to an absolute minimum. This is our contribution to fight climate change - Covid-19 recovery
-
Covid-19 recovery
TSL are a pure cloud, virtual organisation, as such we have not been touched by Covid restrictions, we have not had to accept any government Covid support, and we respect the rights of our employees and clients in their desire to minimised direct contact and office working to avoid the potential exposure to Covid-19 - Tackling economic inequality
-
Tackling economic inequality
All TSL staff require technical expertise, however, we do not have a focus on specific academic institutes and we employ staff based on their technical competence and no other criteria. - Equal opportunity
-
Equal opportunity
We are an equal opportunity employer, as an example our CEO and 33% of core staff overall being female. - Wellbeing
-
Wellbeing
TSL value the wellbeing of our staff, which is why we allow staff to choose were they work from, with all staff working from Home and with flexible working condition, including part time working encouraged.
Pricing
- Price
- £1.24 an instance an hour
- Discount for educational organisations
- No
- Free trial available
- No