Platform
General
Platform Overview
A secure, user-friendly system designed to meet evolving needs
Modular Architecture
A smarter, more controlled, more efficient way to work
Microsoft Azure
Integrate and Augment our services with the latest Microsoft Azure technologies
Integrations
Connection and integration for every data source
Machine Learning and AI
Better decision-making using the latest Artificial Intelligence and Machine Learning products
Security
Experienced handling of personal and sensitive data and a ‘Data Protection by Design’ approach
End-to-End Features
Extract and Load
Collect, read and migrate data from multiple data sources or structures
Matching and Golden Record
Individual, Asset, Family or Group based matching with Golden Record generation
Portals and Analytics
Portals to meet your needs, including analytics, Power BI reporting and visualisations
Transformations
Fully configurable transformations plus over 100 out-the-box functions
Profile
Gain valuable insights of individuals or assets from large sets of data
Solutions
General
Solutions Overview
Build the solution that works for you
Master Data Management
Industry-leading MDM Technology
Single View
Integrated data driving joined-up service delivery
Industries
Local Authority
Helping Local Authorities meet their goals and serve the most vulnerable in society
Housing
Transform your housing operations with Single View solutions for customers and assets
Business
Industry-leading MDM, Single View and Fraud Prevention solutions
Services
Enabling Data Governance
A powerful toolset to measure and enforce Data Governance requirements
Data Migration Services
An effective combination of our Data Management Platform and our consulting expertise
Data Consultancy & Expertise
Specialist data consultants with expertise across a number of businesses
Data Integration
Integration of multiple data sources into a single unified view
Data Masking
Fast and flexible masking of large amounts of personal and sensitive data for UAT
Business Data Transformation
Migration, Integration, Hybrid and Added Value transformation approaches to suit your business’ needs
Customers
Company
General
About Us
Our background and expertise in providing software solutions that bring information together and enhance understanding
Our Approach
Our working philosophy and approach to better data for better outcomes
Quality and Compliance
Details and accreditations of our methods', systems', and technologies' compliance and security
Frameworks
CCS and private procurement frameworks on which we are proud to be a named supplier
Latest from us
News
The latest news about company developments and our data partners' successes
Blogs
Useful information, customer success stories, collaborations, and details of our latest innovations
Contact us
Search

Transformations

All data transformations are fully configurable and transparent.

Data transformation is an important part of data migration and integration. When integrating data from disparate sources, or moving data from a legacy system to new, some changes are almost always required. These could be changing data types, or reworking source values to match the values in a target system’s config.

With the Sentinel Data Platform, you can manage and control the transformations and quickly respond to changing requirements. All data transformations are fully configurable and transparent.

The Sentinel Data Platform provides 100 out the box transformation functions for your data.

The Platform also comes with 200 out of the box and fully configurable rules – allowing you to add clauses to your changes.

Enrich your data with our powerful data transformation tools

Our pre-built and configurable transformation tools allow you to enhance the quality of your data. From names and addresses through to complex transformations of source values to match target configurations. Sentinel is uniquely placed to; add detail to make records more complete, cleanse a variety of data errors or even change data formatting to suit requirements.

Data Structure

Transformations can work across multiple fields, enabling you to change and tailor data structures to suit your requirements.

Data Quality

Information format can be improved, errors removed, and data types can be changed to suit system requirements. Our transformations can be a powerful tool in cleansing poor quality data.

Enrich your data with our powerful data validation rules

Validation rules allow you to check and cross check the data you pull through, an extra layer in ensuring quality is improved and the changes you apply are the ones you need.

Transformation features and scenarios include:

Fix and validate postcodes
Removal of spurious characters and empty values
Add structure to single field addresses
Prototype rules prior to applying to live data
Rationalization of data – standardizing data from mis-used fields
Extracting names from email
Separating AKA from name into Alias Field
Data functions such as regular expressions
List of values mapping
Rejection criteria based upon field content
Enhancing and standardizing for abbreviated or non-standard names.
Data quality and cleansing monitoring and reporting – in support of manual source system cleansing
Automated data cleansing of field content in the Platform for distribution

Controlled and managed transformation of data can improve data quality, as data is migrated or integrated improvements in accuracy, consistency and format can be achieved. Address discrepancies can be ironed out, mis-used fields can be remedied, and erroneous information can be omitted. Our suite of out of the box transformations and the ability to configure and set new custom transformations means data can be rationalised and standardised, optimising quality for its purpose once integrated or migrated.

Our Platform provides 100 out the box transformation functions including:

Empty Values
Check Data Types
Check value matches (LOV)
Regex (Format)
Remove unwanted characters (Spaces and Special)
Min and max length of data
Highest and lowest numeric values
Capitalise upper and lower text
Default Values
Replace old value with another
Structure address fields

Transform data use in your organisation

Book your free data assessment today, and find out how much of an impact Sentinel's Master Data Management tools can have on your business.

Strict control and monitoring of data quality
and completeness
Built using the ICO's "data protection by design"
approach
Trusted by public sector organisations and local authorities
Experienced, dedicated team of data integration and data sharing specialists

Take the hassle out of data management. Call us on +44(0)800 612 2116 or email us [email protected].