Matillion
Matillion offers cloud-based data integration platforms either as PaaS (Matillion ETL) or as SaaS (Data Productivity Cloud),that help businesses move data to cloud warehouses and transform it (ETL/ELT). It offers drag-and-drop UI, pre-built connectors,and data transformation components to get data ready for analysis,data quality improvements and improves time to insights.
Features
- Drag and drop interface
- Multisource integration including legacy systems
- Workflow automation
- Multi-cloud connectivity
- Reverse ETL
- End-to-end data workflows including extraction and data cleansing and transformation
- Version control
- Pre-built connectors
Benefits
- Visual interface
- Modern cloud data stack
- Automated data pipelines
- Easier to develop and maintain
- Collaborative workspace
- Seamless integration
Pricing
£1.60 to £2.50 a unit an hour
Service documents
Request an accessible format
Framework
G-Cloud 14
Service ID
7 5 4 6 0 6 3 1 2 4 8 0 2 0 4
Contact
Billigence
Michael Evans
Telephone: 07951 391 823
Email: michael.evans@billigence.com
Service scope
- Software add-on or extension
- No
- Cloud deployment model
-
- Public cloud
- Hybrid cloud
- Service constraints
-
Matillion ETL can run on GCP, Azure or AWS. For each cloud provider there are recommended instance requirements. For specifics and more details please see documentations:
https://docs.matillion.com/data-productivity-cloud/hub/docs/hub-instance-sizes/
Both Matillion ETL and DPC are limited to the following cloud data warehouses: Snowflake, Redshift, BigQuery, Synapse - System requirements
-
- Up to date internet browsers (Chrome, Chromium, Firefox, Edge)
- Specification for each cloud provider is defined separately.
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
-
Mon - Fri 9am - 5pm - response time is 4 hours.
24/7 service is available on request at an additional cost depending on size of environment - User can manage status and priority of support tickets
- No
- Phone support
- No
- Web chat support
- No
- Onsite support
- Yes, at extra cost
- Support levels
-
There is 3 levels of Matillion support provided - Standard (included), Mission Critical (At extra cost) and Mission Critical Plus(at extra cost).
For more details, please refer to: https://support.matillion.com/s/matillion-support - Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
- We support by setting up the environment and by enabling users. We provide online / onsite training (at extra cost), share user documentation and best practices on how to rapidly and correctly start with Matillion.
- Service documentation
- Yes
- Documentation formats
-
- Other
- Other documentation formats
-
- Word
- OneNote
- End-of-contract data extraction
-
Matillion doesn't store data. It's instead used as an integration tool between source systems and a cloud data warehouse.
Jobs can either be migrated or refactored depending on their complexity and new end software. - End-of-contract process
-
Both Matillion products can follow either a PAYG (Pay As You Go) agreement or a fixed-year contract.
At the end of the contract, the client can choose to renew it or to end it.
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Application to install
- No
- Designed for use on mobile devices
- No
- Service interface
- Yes
- User support accessibility
- None or don’t know
- Description of service interface
- The Matillion Hub is the online interface to all the Matillion services. From where the user can spin-up the Matillion products.
- Accessibility standards
- None or don’t know
- Description of accessibility
- NA
- Accessibility testing
- NA
- API
- Yes
- What users can and can't do using the API
- The Matillion ETL API is available on standard REST-based APIs that uses HTTP or HTTPS request to GET, POST, and DELETE data. The API service is accessed through the Uniform Resource Identifier (URI).
- API documentation
- Yes
- API documentation formats
- HTML
- API sandbox or test environment
- No
- Customisation available
- Yes
- Description of customisation
-
Service is extendable, users can create and use custom drivers, custom APIs, custom scripting libraries (for eg. Python).
Use of customisation is permitted via admin-level access.
Scaling
- Independence of resources
-
Matillion DPC doesn't have a user limitation.
Matillion ETL depends on the instance (virtual hardware) size. The number of registered users doesn't impact resources but instead the number of logged users at a specific point in time. Matillion (either product) is rarely used for end-user access, making this an unusual issue.
Concurrency and demand on resources can be impacted by the resources on the Cloud DWH, as it's where the compute power lies. We follow different strategies to avoid production impact.
Analytics
- Service usage metrics
- Yes
- Metrics types
-
Matillion ETL comes with Product Improvement Metrics, a system that can gather data seamlessly in the background of the application.
Data collected are with reagards to System information, Command usage, Component usage each with defined metrics to understand its active installations, which client and server functions are being called and which components are being used, and their efficiency.
For more information please see:
https://docs.matillion.com/metl/docs/2971426/
Resellers
- Supplier type
- Not a reseller
Staff security
- Staff security clearance
- Staff screening not performed
- 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
- European Economic Area (EEA)
- Other locations
- User control over data storage and processing locations
- Yes
- Datacentre security standards
- Complies with a recognised standard (for example CSA CCM version 3.0)
- Penetration testing frequency
- At least once a year
- Penetration testing approach
- Another external penetration testing organisation
- Protecting data at rest
-
- Physical access control, complying with CSA CCM v3.0
- Encryption of all physical media
- Data sanitisation process
- Yes
- Data sanitisation type
-
- Explicit overwriting of storage before reallocation
- Deleted data can’t be directly accessed
- Equipment disposal approach
- Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001
Data importing and exporting
- Data export approach
-
Matillion does not store user data - it servers for transferring and transforming the data between source systems and targeted DW database.
Matillion holds metadata of both source systems and target systems, access data and definitions of the orchestration jobs - those are exportable via UI as well as API. - Data export formats
- Other
- Other data export formats
- JSON
- Data import formats
- Other
- Other data import formats
- JSON
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
- Legacy SSL and TLS (under version 1.2)
- Data protection within supplier network
-
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
- Legacy SSL and TLS (under version 1.2)
Availability and resilience
- Guaranteed availability
-
Matillion SLA is applicable for customers with a valid annual subscription.
If the Monthly Availability Percentage is below 99.0% (the “Termination Level”) for any 3 consecutive Billing Months , Customers may issue written notice to Matillion to terminate the Agreement provided that it has provided Timely Notice of Termination.
More information on Matillion SLAs can be found here - https://www.matillion.com/service-level-agreement-sla
For Matillion ETL, SLAs are also backed by the chosen cloud provider (Azure, AWS, GCP), which guarantee a 99.99% monthly uptime percentage, with service credit for missing SLAs - Approach to resilience
-
Matillion ETL - backed and provided by the cloud provider (AWS, GCP, Azure)
Matillion DPC - available on request - Outage reporting
-
By enabling specific integration tools/options from the chosen cloud provider. For example CloudWatch for AWS or Virtual Machine Alerts from Azure.
More information on scheduled maintenance windows and current uptime for Matillion products can be found here - https://status.matillion.com/
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- Identity federation with existing provider (for example Google Apps)
- Dedicated link (for example VPN)
- Username or password
- Other
- Other user authentication
- AD, SAML, Kerberoos, OpenID
- Access restrictions in management interfaces and support channels
-
Interfaces and support channels are driven by roles applied to users which drives the accesses and ability of users to alter authentication and authorisation. The system is designed to allow only specific and very few (necessary) users to have the ability for that.
Default permission for new users is always set to deny all access until granted by administrative account. - Access restriction testing frequency
- At least every 6 months
- Management access authentication
-
- Public key authentication (including by TLS client certificate)
- Identity federation with existing provider (for example Google Apps)
- Dedicated link (for example VPN)
- 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
- Yes
- Who accredited the ISO/IEC 27001
- CFA
- ISO/IEC 27001 accreditation date
- 20/2/2024
- What the ISO/IEC 27001 doesn’t cover
- N/A - Matillion passed and compliant with ISO/IEC 27001
- ISO 28000:2007 certification
- No
- CSA STAR certification
- Yes
- CSA STAR accreditation date
- 3/9/2021
- CSA STAR certification level
- Level 1: CSA STAR Self-Assessment
- What the CSA STAR doesn’t cover
-
Please see details:
https://trust.matillion.com/?itemUid=0a28ddf2-a4a5-4fad-8e51-f0fb7a5f7551&source=click - PCI certification
- No
- Cyber essentials
- No
- Cyber essentials plus
- No
- Other security certifications
- Yes
- Any other security certifications
-
- SOC 2
- PCI DSS
- HIPPA
- GDPR
- CCPA
Security governance
- Named board-level person responsible for service security
- Yes
- Security governance certified
- Yes
- Security governance standards
- ISO/IEC 27001
- Information security policies and processes
-
As an example ISO 27001, GDPR - Matillion follow the standard re-certification process and actively works towards adhering the standards.
For rest of the policies and standard please see: Standard and certifications part.
Operational security
- Configuration and change management standard
- Supplier-defined controls
- Configuration and change management approach
-
There are few level of configuration and change management systems which are followed:
Matillion with any larger release provides release notes which list down fixes and general changes to the systems - since last release. As well there are configuration management processes which help ensure consistency, accuracy, and control different platform environments and deployments across organisation.
Other controls involve: Change management, version control, testing and validation, documentation and communication, compliance and auditing. - Vulnerability management type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Vulnerability management approach
- All major cloud providers, provide assurance that they take responsibility for identifying potential compromises and alert users on discovery. Response times for such incidents are managed by the underlying cloud provider's team. Therefore may vary.
- Protective monitoring type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Protective monitoring approach
- All major cloud providers, provide assurance that they take responsibility for identifying potential compromises and alert users on discovery. Response times for such incidents are managed by the underlying cloud provider's team. Therefore may vary.
- Incident management type
- Supplier-defined controls
- Incident management approach
-
Users report incidents via email.
They go to service desk and get escalated accordingly to a specialist after triage
Secure development
- Approach to secure software development best practice
- Conforms to a recognised standard, but self-assessed
Public sector networks
- Connection to public sector networks
- No
Social Value
- Social Value
-
Social Value
- Fighting climate change
- Equal opportunity
Fighting climate change
We endeavour to do our best in fighting climate change and have made an active effort to switch our delivery to remote working vs onsite delivery where possible, thus reducing our travel & impact on the environment.Equal opportunity
Being an equal opportunity employer cultivates a workplace where diversity is embraced and valued. It fosters inclusivity, ensuring all individuals have fair opportunities for employment and advancement regardless of race, gender, age, religion, or background. By prioritizing diversity and inclusion, organizations harness the full spectrum of human potential, driving innovation, creativity, and problem-solving. Embracing equality in employment not only reflects ethical responsibility but also enriches company culture, improves employee morale, and enhances productivity. Ultimately, as a social value, being an equal opportunity employer promotes fairness, equity, and respect, contributing to a more just and harmonious society.
Pricing
- Price
- £1.60 to £2.50 a unit an hour
- Discount for educational organisations
- No
- Free trial available
- Yes
- Description of free trial
-
Free 14 days trial which grants account-wide access to the full Enterprise edition offering, including 500 Matillion credits, which are allocated for use across the Data Productivity Cloud and Matillion ETL.
Once credits expired, you will need to upgrade to a paid subscription on an edition that suits your needs. - Link to free trial
- https://hub.matillion.com/register