®

erwin by Quest Data Vault
Automation®

®

SERVICE DESCRIPTIONerwin® by Quest® automates the manual processes associated with designing,deploying, documenting and maintaining Data Vaults and provides theprofessional services to help you succeed. erwin Smart Data Connectors
by Quest accelerate project delivery and reduce complexity, time and costassociated with Data Vault implementations by 70%.

KEY FEATURESAPPROACH

KEY BENEFITS/RESULTS• Automatic generation of Data Vault
metadata, DDL and source-totarget mappings

With Data Vault automation backed byerwin Smart Data Connectors, businessanalysts and ETL developers no longer
need to manually perform time-consuming, mundane tasks, and can focus on
business-critical initiatives.

• Centralize the specificationand deployment of Data Vault
architectures for better control andvisibility of the development lifecycle,
resulting in implementations that areon time, on budget and on target.

• Data lineage rendering and analysis
across complex data ecosystems• Auto-generated Data Vault ETL/ELT
code from Data Vault mappings• Solutions for Raw Vault, Business Vault
and Information Marts• Universal code generation for any
ETL/ELT tool with an SDK• ELT-tool optimization parameters, suchas partitioning and parallelization• Custom implementations to adhereto specific use cases• Flexible implementation assessment
and deployment services

Ingestion of underlying metadata andmappings into erwin Data Catalog
enable erwin Smart Data Connectors toautomatically generate massive amountsof ETL/ELT processing that align with Dan
Linstedt’s Data Vault 2.0 methodology.
This saves considerable time anddevelopment effort and ensures
standardization and reuse.
Flexible automation to stage the source
environment for any data source – generating the stage DDL, metadata, mappings,
and ETL in accordance with Data Vault
best practices – is also available.

• Standardize Data Vault architectures
to ensure maximum adaptability
and reuse of Data Vault constructs
for faster time to market andthe seamless adoption of new
and emerging requirements.
• Build and manage Data Vault
deployments in the context of erwin
Data Catalog by Quest, which is
metadata-driven to ensure tightintegration with data governanceand intelligence initiatives.
• Automate data lineage renderingwith traceability from the information
mart back to the operational
data to speed the investigationof issues, analyze the impact ofchanges and ensure regulatorycompliance and ease of auditability.

DATA VAULT AUTOMATION WITH ERWIN DATA INTELLIGENCE

Harness the power of the Data Vault with efficient and cost-effective metadata-driven
automation from erwin by Quest.
DELIVERABLES• Data Vault Hub, Link and Satellite
code generation• Business Vault Point-in-Time andBridge tables• Information Mart tables or views(Dimensions and Facts)• Data Vault model and mapping generation
within erwin Data Intelligence Suite• Forward and reverse lineage• Data Vault test cases

Quest

4 Polaris Way, Aliso Viejo, CA 92656 | www.quest.com
If you are located outside North America, you can findlocal office information on our website.

DURATION AND COST
Contact erwin today for a personalized
demonstration and quote based onyour organization’s unique Data
Vault requirements.
ABOUT QUESTQuest creates software solutions thatmake the benefits of new technology
real in an increasingly complex ITlandscape. From maximizing the value of
their data, to Active Directory and Office
365 management, and cybersecurity
resilience, Quest helps customers solve
their next IT challenge now. Quest
Software. Where next meets now.

© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Quest, Quest Software, the Questlogo, erwin and the erwin logo are trademarks and registered trademarks of Quest Software
Inc. and its affiliates worldwide. For a complete list of Quest marks, visit www.quest.com/legal/trademarkinformation.aspx. All other trademarks are property of their respective owners.
Datasheet-erwinDataVaultAutomation-LP-67174