Source Mart Designer
Intelligent Metadata Mapping and Standardization Is the Heart of the Health Catalyst Solution.
Source Mart Designer answers one of the biggest challenges organizations face when implementing an EDW: the time it takes to manually extract data from source systems, bring it into the EDW, and map it to data marts for downstream use in advanced applications.
The Problem with Manual ETL Maintenance
Many enterprise data warehousing ETL models contain no metadata – making it difficult, if not impossible, for a data analyst to know where tables and columns originated in the source system. Worse, when new data sources are added to the data warehouse or analytic use cases mature, source system data must be conformed and mapped again.
Metadata Mapping at Full Speed
Source Mart Designer mobilizes Health Catalyst’s metadata-driven ETL engine to automate that time-consuming, labor-intensive chore.
Metadata in Memory
Metadata – captured for every field – creates mappings from the tables and columns in each source system to tables and columns in their destination Source Marts. Source Mart Designer captures that metadata in a single, comprehensive repository.
Metadata in Movement
Source Mart Designer drives the ETL process entirely by metadata. Based on source system characteristics and supplemented with a few simple Health Catalyst–supplied ETL scripts, a customized, configurable ETL process is created for each source system table.
Making Metadata Meaningful
Once metadata is mapped, Health Catalyst experts use their extensive knowledge of the source system, supplemented by the knowledge base in Source Mart Designer, to change all the cryptic source system names into ones reflecting the way humans think.
All of that data goes in the metadata repository so users can search and browse it in Atlas, Health Catalyst’s metadata management tool.
Rather than relying on a SQL import/export utility or an ETL tool to move data, data architects simply decide how to set up their columns. Data loads during the nightly ETL process.
- Automated upload of common source system fields, schemas, data types, columns, and more
- Modifiable column name suggestions
- Ability to determine if a data load is full or incremental based on both the volume of data and speed requirements
- Consistent naming taxonomy guidelines for review and confirmation
Source Mart Designer’s easy-to-use interface helps data analysts maintain enterprise-wide consistency.
- Standard: Maintain Source Marts purchased from Health Catalyst
- Professional: Design and deploy Source Marts not purchased from Health Catalyst
Success Story: From Data Managers to Data Analysts
One health system tasked its Information Systems (IS) department to increase the value decision-makers get from the health system’s data — and to do it with fewer resources.
Using Source Mart Designer, the IS team automated a rapid integration of source system data into the EDW, empowering them to rapidly design, develop, and deploy Source Marts 75 percent faster.
The days of time-consuming manual ETL maintenance behind them, IS staff spend less time managing data and more time putting their analytical skills to drive clinical quality improvement.