entimICE Mapping

Mission

entimICE Mapping is a cutting-edge solution for creating mapping specifications and programs based on metadata that eliminates tedious manual maintenance of spreadsheets and programs separately. The tool offers a metadata-driven user interface to define mapping algorithms. It generates executable mapping programs and provides full traceability of metadata and results. All metadata, algorithms and mappings are managed in a central repository under version control and lifecycle management. Audit trail and signatures guarantee regulatory compliance. Built-in consistency checks help detect structural problems.

Benefits

1. Minimal required SAS skills free experts for critical activities: An intuitive graphical user interface makes the mapping task quick and easy.

2. Specification and programs with a single mouse click: Creation of mapping specifications and mapping programs from mapping definitions is consistent and eliminates tedious maintenance of spreadsheets and programs separately.

3.Improved collaboration: Configurable lifecycles, workflows, versioning and automatic notifications ensure a controlled mapping process across the entire organization.          

What's new?

Entimo continuously develops and improves its products. The current release of the mapping tool contains the following enhancements:

  • Dynamic access to codelists
  • Visualizing applied SAS formats
  • Algorithms for metadata access
  • Definition of repeat groups
  • Improved re-usability of tasks
  • Enhanced consistency checks
  • Direct load of data elements

 

Contact us for more information about Entimo's products, release information and roadmaps.

Mapping Highlights

Intuitive and comfortable mapping definition

The user-friendly and intuitive user interface allows maintenance of metadata and creation of mapping definitions with minimal programming skills. The mapping tool follows a metadata-driven approach: Available metadata (e.g. SDTM domain templates) is loaded from the repository tree into mapping definitions with a mouse click and is ready to be used in the mapping process. Users can comfortably create new and edit existing metadata. It is possible to define metadata at multiple levels such as company, projects, therapeutic areas and studies. Existing datasets can be imported into the tool from the local file system (when received from CROs, for example) or directly accessed in external databases via views using dedicated database wizards. Corresponding metadata is automatically created during the import procedure. Due to such flexibility, the tool supports handling of standardized metadata items like CDISC models as well as company-specific entities.

Central metadata repository

The central repository provides robust tools to manage standard metadata, codelists, data, programs, even mappings for all authorized system users.

Central library of conversion algorithms

The mapping tool provides a large, extensible pool of built-in conversion algorithms for standard data transformations. These can be easily assigned to attributes in the mapping definition. Moreover, users can create user-defined standard actions encompassing repeating transformations, thus reducing redundant work. Even complex transformation algorithms and complete mapping definitions can be stored as templates in the repository. This allows for creation of a company-wide mapping standard library containing all possible data sources and algorithms. The templates can be made available to the users in a central area and then used for mappings at the study level. This minimizes the mapping efforts for the user as far as possible, saves valuable time and frees expert resources for more critical activities.

Mapping specification one click away

The mapping tool delivers a cutting-edge solution for generating mapping specifications and programs, and replaces tedious manual maintenance of spreadsheets and programs separately. The generated mapping specification contains the full overview of mapping definitions including sources, targets, transformation steps, algorithms, conditions, types and formats and can be exported in different formats. All of this is just "one click away".

One-click mapping program generation

Executable mapping programs can be generated from the mapping definitions with a single button click. The resultant mapping programs are automatically well documented in the code with time stamp, user name etc. The programs are stored in the repository and are subject to version control and other traceability means. An enormous advantage is the fact that the mapping programs can run in third party products and require only SAS Base for SAS programs. Syntax of target languages other than SAS is also supported.

 

Improved data quality

The mapping tool offers a number of built-in validation checks for data sources. The code for selected checks is automatically included in each generated mapping program and executed at run-time prior to data conversion. In this manner, conformance of source datasets with corresponding source metadata is guaranteed.

Controlled data conversion

Datasets to be converted are assigned to generated mapping programs via parameters at run-time. If the conversion is carried out within the mapping tool, datasets can be comfortably selected from the repository tree. All parameter values are stored and can be reused in later runs.

Standard terminology management

entimICE Mapping is able to manage controlled terminologies, codelists and external dictionaries including CDISC codelists in a consistent way. The mapping tool not only handles version control, audit trail and other traceability features for codelists stored in the repository, but also allows direct loading of codelists into mapping definitions for mapping purposes. Codelists stored in a central area can be accessed via search paths and don’t need to be copied.

Full traceability and regulatory compliance

To fulfil regulatory requirements (e.g. 21 CFR part 11 compliance) all system activities are tracked, audited and documented along the entire mapping process. Entimo's mapping tool provides a broad spectrum of traceability from the data source through the transformation process to the output data and reports: the system saves change history and audit trails, logs user activities and allows the restoration of past states. In addition, the tool reports dependencies between metadata, mapping programs, program runs as well as input and output data, thus significantly reducing information complexity.

Semantic search engine

By using the robust search facility, users can define, store and edit simple and complex retrieval queries. They can search over parts or over the full range of object types, their metadata, workflow states, history and values within the repository. Users can even define recursive queries and can integrate queries and their search results into automation processes. A highlight of the search engine is its ability to search through links and dependencies - entimICE search provides a shortcut to required results.

Security and access rights administration

Entimo takes security seriously and provides tools to make administration easy. The environment provides a user-friendly interface to manage access rights in the organizational scope. Role-based access rights can be granularly defined for user groups and/or single users on every object area, object type and even actions. The flexible role-based concept makes the administration of user rights very easy: New users are simply assigned to a certain role or group and automatically possess all derived access rights. For organizations and their departments, specific password rules can be defined or, alternatively, they can be pulled via LDAP.


   Download the fact sheet: entimICE Mapping

 

Intuitive definition

<img src="images/entimo/content/mapping/target.png" alt="Mapping rules defined per variable" />

One-click specifications

Automatic generation of mapping specifications

Executable programs

Generated stand-alone and executable mapping programs

Re-usable tasks

Re-usable task and action templates

Algorithm library

Central library of standard algorithms