Acuma Solutions Limited

Extraction Load and Transformation (ELT) software as a service

Acuma offers Extract Load and Transform as a service for extracting and loading large data sets into target sources and transform data for big data analytics. The Extract Load and Transform as a service enables ingestion of structured, semi-structured, unstructured data from various sources into Data Lake and data transformation.

Features

  • Data uploaded in raw data format
  • Data lake for bringing data from various sources
  • Ingestion via bulk upload, real-time streaming and ReSTful APIs
  • Structured data ingested using Sqoop or Nifi
  • Semis-structured data ingested using ReSTful APIs or Kafka Streams
  • Unstructured data ingested using Kafka Streams with Spark Streams
  • Right scripts for loading data from sources to HDL
  • Spark streaming leveraged for data cleansing
  • Transformation in Data Lake

Benefits

  • Faster ingestion process
  • Supports structured, unstructured and semi-structured data
  • Flexible for running transformations on raw data
  • Speedy transformation of big data
  • Low maintenance costs
  • Promote cost-effective analytics
  • Additional security and performance
  • Agile and flexible for usage
  • Low cost of ownership

Pricing

£3540 per unit per month

Service documents

G-Cloud 10

270270219525941

Acuma Solutions Limited

Jonathan Eeley

0161 241 4321

bid_team@acuma.co.uk

Service scope

Service scope
Software add-on or extension No
Cloud deployment model Public cloud
Service constraints No
System requirements
  • Browsers – IE 8+, Chrome, FireFox or Safari 9+ (any)
  • 8 GB RAM and 100 MB available space

User support

User support
Email or online ticketing support Email or online ticketing
Support response times Standard incident management SLAs are as follows: Priority: Critical - Mission Critical Response time: 1 hour. Resolution time: within 1 working day. Priority: 1 - Urgent issue affecting the whole user community Response time: 1 hour. Resolution time: 24 working hours. Priority: 2 – Issue inhibits a user. Initial response time: 4 hours. Target resolution time: 3 working days. Priority: 3 - Issue is not seriously affecting a user. Initial response time: 8 hours. Target resolution time: 5 working days. Priority: 4 - Cosmetic issues and information. Initial response time: 24 hours. Target resolution time: agreed at time of call.
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 The service includes a standard level of Service Management with the following features: -Acuma Service Desk – available at standard England & Wales working hours - Incident management including liaison with SCC and agreed escalation routes - Agreed SLAs - Agreed maintenance windows - Agreed change control process - Publication and implementation of service roadmap Standard SLAs are as follows: Priority: Critical - Mission Critical Initial response time: 1 hour. Target resolution time: within 1 working day. Priority: 1 - Urgent issue affecting the whole user community, requires immediate action. Initial response time: 1 hour. Target resolution time: 24 working hours. Priority: 2 – Issue inhibits a user. Initial response time: 4 hours. Target resolution time: 3 working days. Priority: 3 - Issue is not seriously affecting a user, does not require immediate attention. Initial response time: 8 hours. Target resolution time: 5 working days. Priority: 4 - Cosmetic issues and information only queries. Initial response time: 24 hours. Target resolution time: as agreed at time of call. Enhanced Service Management is also available including:- -24x7 support - Out of hours support - Weekend support - Peak period support (e.g. month end)
Support available to third parties Yes

Onboarding and offboarding

Onboarding and offboarding
Getting started Our consultancy expertise facilitates onboarding of users while the engagement gets initiated. Acuma services range from user training, and support to documentation.
Service documentation Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction The Off Boarding process includes full data extraction and removal. All customer –generated data will be returned to the customer according to customer preferences and subject to requirements of the service Impact Level. Once the extract is verified by the customer, customer data is purged and destroyed and the service instance removed. Off Boarding costs are agreed on a customer-by-customer basis depending on data volumes, preferred media, security constraints etc.
End-of-contract process The standard set of procedures for closing the service is summarized below: Back up all customer data (including routines) to portable storage -Securely transfer data to customer - Customer validation of transferred data -Remove service instance (i.e. no trace of customer components) - Customer verification of service instance removal.

Using the service

Using the service
Web browser interface Yes
Supported browsers
  • Internet Explorer 10
  • Firefox
  • Chrome
  • Safari 9+
Application to install No
Designed for use on mobile devices No
Accessibility standards None or don’t know
Description of accessibility The system can be accessed through an user interface via supported web browsers.
Accessibility testing None
API Yes
What users can and can't do using the API Users need to make service call by including the URL along with the required parameters. While there are no limitations, users will have to follow the API document for the acceptable formats
API documentation Yes
API documentation formats
  • HTML
  • PDF
API sandbox or test environment Yes
Customisation available Yes
Description of customisation Users can customise services such as configuring integration with external systems. Customisations can also be performed in the way integration mechanism is configured, as that of data frequency and ELT rules.

Scaling

Scaling
Independence of resources This service is based upon some of the most scalable-based architecture providers like AWS and Hadoop. We also follow a micro-service based architecture that ensures that inter-dependencies like shared databases and other architecture scaling issues do not exist.

Analytics

Analytics
Service usage metrics Yes
Metrics types To be decided once the contract is drawn.
Reporting types
  • API access
  • Real-time dashboards
  • Regular reports

Resellers

Resellers
Supplier type Not a reseller

Staff security

Staff security
Staff security clearance Other security clearance
Government security clearance Up to Developed Vetting (DV)

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 No
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 Physical access control, complying with another standard
Data sanitisation process Yes
Data sanitisation type Deleted data can’t be directly accessed
Equipment disposal approach A third-party destruction service

Data importing and exporting

Data importing and exporting
Data export approach Acuma enables data export through a REST API.
Data export formats
  • CSV
  • ODF
  • Other
Data import formats
  • CSV
  • ODF
  • Other

Data-in-transit protection

Data-in-transit protection
Data protection between buyer and supplier networks IPsec or TLS VPN gateway
Data protection within supplier network IPsec or TLS VPN gateway

Availability and resilience

Availability and resilience
Guaranteed availability We have 99% availability during normal business hours.
Approach to resilience Information available on request.
Outage reporting Email alerts

Identity and authentication

Identity and authentication
User authentication needed Yes
User authentication
  • 2-factor authentication
  • Dedicated link (for example VPN)
  • Username or password
Access restrictions in management interfaces and support channels User access is controlled by enabling role-based access where only authorized individuals can access the solution account.
Access restriction testing frequency At least every 6 months
Management access authentication
  • 2-factor authentication
  • Dedicated link (for example VPN)
  • Username or password

Audit information for users

Audit information for users
Access to user activity audit information Users receive audit information on a regular basis
How long user audit data is stored for User-defined
Access to supplier activity audit information Users receive audit information on a regular basis
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 Acuma is proactive in securing and managing information adhering to ISO 27001/2005 standards. Our information security program includes appropriate standards, policies and guidelines, robust technical security controls, security compliance program, clearly defined security strategy as well as a security incident management program to control and re-mediate security-related incidents.
Information security policies and processes We take cues from ISO/IEC 27001:2005 specification. We follow disaster recovery, business continuity, incident response, password management, patch management, access control and firewall management processes.

Operational security

Operational security
Configuration and change management standard Supplier-defined controls
Configuration and change management approach Our configuration and change management approach embraces version control for all software components, processes and documentation. Assessment of changes are made against design documentation and threat intelligence, and potential security impacts are identified.
Vulnerability management type Supplier-defined controls
Vulnerability management approach We leverage internally defined processes to monitor potential threats
proactively through various sources, including external repositories.
Protective monitoring type Supplier-defined controls
Protective monitoring approach We leverage robust techniques, technologies and tools for identifying
threats and rolling out relevant measures depending on the complexity, nature and severity as a specific case may demand.
Incident management type Supplier-defined controls
Incident management approach Our incident management processes adhere to industry standard best practice to capture as well as manage events. Users can make use of channels including email and phone for reporting incidents.

Secure development

Secure development
Approach to secure software development best practice Conforms to a recognised standard, but self-assessed

Public sector networks

Public sector networks
Connection to public sector networks No

Pricing

Pricing
Price £3540 per unit per month
Discount for educational organisations No
Free trial available No

Service documents

pdf document: Pricing document pdf document: Skills Framework for the Information Age rate card pdf document: Service definition document pdf document: Terms and conditions
Service documents
Return to top ↑