MedDataXtract   Data-Integration at its simplicity
   
 

What is MedDataXtract ?

Medical Data XTRACT is a data repository, which delivers robust, cost-effective and quick ETL (Extract Transform Load) builds using smart methods and snippets. By means of XTRACT Layer, it enhances the data integration of your organization by reducing the development overheads, quick prototyping and realization, easy administration and thereby eliminating the need of too many ETL developers.
 
The tool allows you to select tables, columns from the source system and create custom SQL views on fly. These SQL views Extract only required tables and columns, Transforms the data based on the configuration and Loads data into the downstream databases.

XTRACT automates the data integration layer, where the entire process follows one standardized method of extraction in your organization thereby creating long term flexibility in administration. In some cases, XTRACT also provides domain specific pre-defined extract data dictionary, which could speed up your data integration process of your organization.
 
 
Product Architecture

The Xtract Repository Engine is a database which holds smart methods, snippets and tables to deliver quick ETL (Extract Transform Load) builds.

The tool allows you to select tables, columns from the source system and create custom SQL views on fly. These SQL views Extract only required tables and columns, Transforms the data based on the configuration and Loads data into the downstream databases. The metadata information of source system is stored in the repository database.
   
 
 

A HLD (high level diagram) showing group of tables, allowing auto generation of views, table scripts and column mappings.

Repository database holding table configuration, environment, batch & log status, error log, delta-load and data-filter. These settings are managed in the extraction manager interface.

 Find out what benefits you could get by
using this tool
?
 
 
 
ETL Dashboard

The ETL environments are monitored using ETL Dashboard.

The daily batch duration, batch trend line, duration per table are some of the user-friendly charts helps you analyze job run statistics and quickly identify specific bottlenecks in the ETL processes.

   
 

Setup and licence cost

  Setup requirements:

  • An ETL Server
  • MS SQL SERVER 2012, 2014, 2016 database engine
  • MS SSIS / BIML
  • Licensing:

    Yearly licence includes:
  • Initial setup
  • Indefinite ETL environments
  • Support
  • 40 hours of development coupons (recurring on yearly bases)
  • Onsite training (2 days)
  • Advise on ETL platforms
  •  
     
     
     Quick Links
     What is MedDataXtract ?
     Where it can be used ?
     How it can be used ?
     What are its benefits ?
    Sub Domain
    BenchMarkData.MedDataXtract.com
    ClinicalTrials.MeddataXtract.com
    DataCollection.MedDataXtract.com
    IOTData.MedDataXtract.com
    ExternDataAanlevering.MedDataXtract.com
    DataRepository.MedDataXtract.com
    Contact
    t: +31-650646089 (also available on WhatsApp)
    e: Info@MedDataXtract.com
    w: MedDataXtract.com